This page (revision-8) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
8 26-Nov-2021 10:22 4 KB JMyers to previous
7 26-Nov-2021 10:22 4 KB JEscott to previous | to last
6 26-Nov-2021 10:22 4 KB JEscott to previous | to last
5 26-Nov-2021 10:22 4 KB JEscott to previous | to last
4 26-Nov-2021 10:22 4 KB JEscott to previous | to last
3 26-Nov-2021 10:22 4 KB JEscott to previous | to last
2 26-Nov-2021 10:22 4 KB JEscott to previous | to last
1 26-Nov-2021 10:22 4 KB JEscott to last

Page References

Incoming links Outgoing links
LMTD LOADING TIME EXCEPTIONS
LMTD LOADING TIME EXCEPTIONS

Version management

Difference between version and

At line 4 changed one line
!Load Away From Post exceptions
!Load Away From Post Exceptions
At line 9 changed 4 lines
|1| 3| TTX.START_DATE| -1| -1| Char| | TO_CHAR(TO_DATE(RTRIM(~), 'MM/DD/YYYY'),'DDMon-YYYY')|Formats date to match eP 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| 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
At line 15 changed 3 lines
|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 eP standards
|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
At line 22 changed 2 lines
!Load Replacement exceptions
\\
!Load Replacement Exceptions
At line 27 changed one line
|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| 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.
At line 31 changed 4 lines
|1| 6| TTX.START_DATE |-1| -1| Char| |TO_CHAR(TO_DATE(RTRIM(~),MM/DD/YYYY'),'DDMon-YYYY')|Formats date to match eP 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| 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(~))}}}|
At line 37 changed one line
|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 eP standards.
|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.
At line 51 added 5 lines
----
![Notes|Edit:Internal.LMTD+LOADING+TIME+EXCEPTIONS]
[{InsertPage page='Internal.LMTD+LOADING+TIME+EXCEPTIONS' default='Click to create a new notes page'}]
This page (revision-8) was last changed on 26-Nov-2021 10:22 by JMyersTop