Number | Description |
---|
1 | Home BU Position A+ (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | HMCU | Business Unit - Home | Ascending | 2 | POS | Position ID | Ascending | 3 | AN8 | Address Number | Ascending | 4 | EFTS | Date - Effective From | Descending | 5 | TMDY | Time of Day | Descending |
|
2 | Address Number Date Eff A+ |
| Element | Alias | Description | Sequence |
---|
1 | AN8 | Address Number | Ascending | 2 | EFTS | Date - Effective From | Descending | 3 | TMDY | Time of Day | Descending |
|
3 | Position Effective Date A+ |
| Element | Alias | Description | Sequence |
---|
1 | POS | Position ID | Ascending | 2 | EFTS | Date - Effective From | Descending | 3 | TMDY | Time of Day | Descending |
|
6 | Home BU Position B+ |
| Element | Alias | Description | Sequence |
---|
1 | HMCU | Business Unit - Home | Ascending | 2 | POS | Position ID | Ascending | 3 | ACTT | Employee Action | Ascending | 4 | EFTS | Date - Effective From | Ascending | 5 | TMDY | Time of Day | Ascending |
|
7 | Position Home BU A+ |
| Element | Alias | Description | Sequence |
---|
1 | POS | Position ID | Ascending | 2 | HMCU | Business Unit - Home | Ascending | 3 | AN8 | Address Number | Ascending |
|
8 | Home BU Position C+ |
| Element | Alias | Description | Sequence |
---|
1 | HMCU | Business Unit - Home | Ascending | 2 | POS | Position ID | Ascending | 3 | EFTS | Date - Effective From | Ascending |
|
9 | Home BU Position D+ |
| Element | Alias | Description | Sequence |
---|
1 | HMCU | Business Unit - Home | Ascending | 2 | POS | Position ID | Ascending | 3 | AN8 | Address Number | Ascending | 4 | ACTT | Employee Action | Ascending |
|
10 | Address Number Date Eff B+ |
| Element | Alias | Description | Sequence |
---|
1 | AN8 | Address Number | Ascending | 2 | EFTS | Date - Effective From | Ascending | 3 | ACTT | Employee Action | Ascending |
|
11 | Employee Action Employ Num A+ |
| Element | Alias | Description | Sequence |
---|
1 | ACTT | Employee Action | Ascending | 2 | AN8 | Address Number | Ascending | 3 | EFTS | Date - Effective From | Descending |
|