Below are two sample interfaces that were created for a specific client to load in time exceptions. The first interface loads time exceptions for employees who are 'Away From Post', the second interface loads time exceptions for employees who are filling those now vacant positions.
Load Away From Post Exceptions#
| Rec # | Field # | Name | Beg Pos | End Pos | Field Type | Constant Value | Derivation Expression | Notes |
|---|---|---|---|---|---|---|---|---|
| 0 | 1 | HEADER RECORD* | -1 | -1 | Char | Record Type must be Header Record | ||
| 1 | 1 | TTX.EAS_ID.EEM_ID.EID_ID.PERSON_CODE | -1 | -1 | Char | |||
| 1 | 2 | TTX.TIME_EXCEPTION_TYPE | -1 | -1 | Char | |||
| 1 | 3 | TTX.START_DATE | -1 | -1 | Char | TO_CHAR(TO_DATE(RTRIM(~), 'MM/DD/YYYY'),'DDMon-YYYY') | Formats date to match Personality standards | |
| 1 | 4 | TTX.START_TIME | -1 | -1 | Char | concat(substr(~,1,2),substr(~,4,5))] | The time in the file includes the :, the derivation is used to strip out the semi colon | |
| 1 | 5 | TTX.END_TIME | -1 | -1 | Char | concat(substr(~,1,2),substr(~,4,5)) | The time in the file includes the :, the derivation is used to strip out the semi colon | |
| 1 | 6 | TTX.DTC_ID.TIME_CODE | -1 | -1 | Char | P2K_SMGLX('AESOP ABSENCE TRNSLT',UPPER(~)) | The derivation translates the value in the file to a time code using a user defined lexicon called AESOP ABSENCE | |
| 1 | 7 | TTX.TSH_ID.EAS_ID.EEM_ID.TERMINATION_DATE | 0 | 0 | Char | ' ' | ||
| 1 | 8 | TTX.EAS_ID.EEM_ID.TERMINATION_DATE | 0 | 0 | Char | ' ' | ||
| 1 | 9 | TTX.TSH_ID.EAS_ID.EEM_ID.EID_ID.PERSON_CODE | 0 | 0 | Char | (:TTX.EAS_ID.EEM_ID.EID_ID.PERSON_CODE) | This is required for LMTD to know which scheduled shift to update. | |
| 1 | 10 | TTX.TSH_ID.EAS_ID.PRIME_ASSIGNMENT | 0 | 0 | Char | 1 | This is required for LMTD to know which scheduled shift to update | |
| 1 | 11 | TTX.TSH_ID.SHIFT_DATE | 0 | 0 | Char | TO_CHAR(TO_DATE(RTRIM((:TTX.START_DATE)), 'MM/DD/YYYY'),'DDMon-YYYY') | Formats date to match Personality standards | |
| 1 | 12 | TTX.EAS_ID.PRIME_ASSIGNMENT | 0 | 0 | Char | 1 | Defaults to the prime assignment | |
| 1 | 13 | TTX.ACT_DIF_POST_UPDATE_BUILD_SCHED | 0 | 0 | Char | Required so that the scheduled day is rebuilt. | ||
| 1 | 14 | TTX.ACT_DIF_POST_INSERT_BUILD_SCHED | 0 | 0 | Char | Required so that the scheduled day is rebuilt. |
Load Replacement Exceptions#
| Rec # | Field # | Name | Beg Pos | End Pos | Field Type | Constant Value | Derivation Expression | Notes |
|---|---|---|---|---|---|---|---|---|
| 0 | 1 | HEADER RECORD* | -1 | -1 | Char | Must have Record Type of Header Record | ||
| 1 | 1 | TTX.EAS_ID.EEM_ID.EID_ID.PERSON_CODE | -1 | -1 | Char | |||
| 1 | 2 | TTX.EAS_ID.ASSIGNMENT_CODE | -1 | -1 | Char | P2K_SMGLX('AESOP PAY POSITION TRNSLT', UPPER(~)) | The file includes a field which indicates which assignment to use, the derivation translates this using the specified user defined lexicon. | |
| 1 | 3 | TTX.TSH_ID.EAS_ID.EEM_ID.EID_ID.PERSON_CODE** | -1 | -1 | Char | The file includes the person code of the employee who is away from post, so the LMTD will use this to locate which scheduled shift to update. | ||
| 1 | 4 | TTX.F_OVERRIDE_ASSIGNMENT | -1 | -1 | Char | The file included an overridden assignment code which is to be ignored. Since the file is character delimited, a foreign field was used to map its position within the file. | ||
| 1 | 5 | TTX.TIME_EXCEPTION_TYPE | -1 | -1 | Char | |||
| 1 | 6 | TTX.START_DATE | -1 | -1 | Char | TO_CHAR(TO_DATE(RTRIM(~),MM/DD/YYYY'), 'DDMon-YYYY') | Formats date to match Personality standards | |
| 1 | 7 | TTX.START_TIME | -1 | -1 | Char | concat(substr(~,1,2),substr(~,4,5)) | The time in the file includes the :, the derivation is used to strip out the semi colon | |
| 1 | 8 | TTX.END_TIME | -1 | -1 | Char | concat(substr(~,1,2),substr(~,4,5)) | The time in the file includes the :, the derivation is used to strip out the semi colon | |
| 1 | 9 | TTX.DTC_ID.TIME_CODE | -1 | -1 | Char | P2K_SMGLX('AESOP PAY TIMECODE TRNSLT', UPPER(~)) | ||
| 1 | 10 | TTX.TSH_ID.EAS_ID.EEM_ID.TERMINATION_DATE | 0 | 0 | Char | ' ' | ||
| 1 | 11 | TTX.EAS_ID.EEM_ID.TERMINATION_DATE | 0 | 0 | Char | ' ' | ||
| 1 | 12 | TTX.TSH_ID.SHIFT_DATE | 0 | 0 | Char | TO_CHAR(TO_DATE(RTRIM((:TTX.START_DATE)), 'MM/DD/YYYY'),'DDMon-YYYY') | Required to help the LMTD locate the correct scheduled shift to update. The derivation uses the TTX.START_DATE original value and formats it to match Personality standards. | |
| 1 | 13 | TTX.TSH_ID.EAS_ID.PRIME_ASSIGNMENT*** | 0 | 0 | Char | 1 | Used to help locate the correct scheduled shift to update. | |
| 1 | 14 | TTX.ACT_DIF_POST_UPDATE_BUILD_SCHED | 0 | 0 | Char | Required so that the scheduled day is rebuilt. | ||
| 1 | 15 | TTX.ACT_DIF_POST_INSERT_BUILD_SCHED | 0 | 0 | Char | Required so that the scheduled day is rebuilt. |
- *Record 0, Field 1 must have a Record Type of Header Record
- **Record 1, Field 3 must have the Add to UK Set toggled ON
- ***Record 1, Field 12 must have the Add to UK Set toggled ON
