05: Time Accounting and HRM Base |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 910 | F06936 | JA | 19 | 7 | Retro Pay Types Rate | Constants Files | 07: Payroll | Business Data |
Number | Description |
---|
1 | Union Code Job Category +A (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | UN | Union Code | Ascending | 2 | JBCD | Job Type (Craft) Code | Ascending | 3 | JBST | Job Step | Ascending | 4 | EFTB | Date - Beginning Effective | Ascending | 5 | PDBA | DBA Code | Ascending |
|
4 | Union Code +A |
| Element | Alias | Description | Sequence |
---|
1 | UN | Union Code | Ascending | 2 | EFTB | Date - Beginning Effective | Ascending | 3 | JBCD | Job Type (Craft) Code | Ascending | 4 | JBST | Job Step | Ascending |
|
5 | Union Code Job Category +B |
| Element | Alias | Description | Sequence |
---|
1 | UN | Union Code | Ascending | 2 | JBCD | Job Type (Craft) Code | Ascending | 3 | JBST | Job Step | Ascending | 4 | EFTB | Date - Beginning Effective | Ascending | 5 | AN8 | Address Number | Ascending |
|
6 | Union Code Job Category +C |
| Element | Alias | Description | Sequence |
---|
1 | UN | Union Code | Ascending | 2 | JBCD | Job Type (Craft) Code | Ascending | 3 | JBST | Job Step | Ascending | 4 | EFTE | Date - Ending Effective | Ascending |
|
7 | Union Code Address Number + |
| Element | Alias | Description | Sequence |
---|
1 | UN | Union Code | Ascending | 2 | AN8 | Address Number | Ascending | 3 | JBCD | Job Type (Craft) Code | Ascending | 4 | JBST | Job Step | Ascending | 5 | EFTE | Date - Ending Effective | Ascending |
|
8 | Union Code +B |
| Element | Alias | Description | Sequence |
---|
1 | UN | Union Code | Ascending | 2 | PDBA | DBA Code | Ascending | 3 | JBCD | Job Type (Craft) Code | Ascending | 4 | JBST | Job Step | Ascending | 5 | EFTE | Date - Ending Effective | Ascending |
|
9 | Union Code Cost Center + |
| Element | Alias | Description | Sequence |
---|
1 | UN | Union Code | Ascending | 2 | MCU | Business Unit | Ascending | 3 | SHFT | Shift Code | Ascending | 4 | EFTB | Date - Beginning Effective | Ascending | 5 | JBCD | Job Type (Craft) Code | Ascending | 6 | JBST | Job Step | Ascending |
|