This page (revision-6) 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
6 26-Nov-2021 10:22 3 KB JMyers to previous
5 26-Nov-2021 10:22 3 KB JEscott to previous | to last
4 26-Nov-2021 10:22 3 KB JEscott to previous | to last
3 26-Nov-2021 10:22 3 KB RForbes to previous | to last
2 26-Nov-2021 10:22 3 KB JEscott to previous | to last
1 26-Nov-2021 10:22 3 KB JEscott to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 4 changed 3 lines
|1| 1| PLPL.PERSON_CODE| 1| 11| Char| | LTRIM(~,'0') |This will trim any leading zeros
|1| 2| PLPL.START_DATE| 12| 19| Char| |TO_CHAR(TO_DATE(RTRIM(~), 'MMDDYYYY'),'DD-Mon-YYYY')|This will format the incoming date to the eP standard.
|1| 3| PLPL.TIME_OR_AMOUNT| 28| 35| Char| | TO_NUMBER(~)/100 |This will take the provided value and divide it by 100 since the amt provided does not include any decimal places.
|1| 1| PLPL.PERSON_CODE| 1| 11| Char| |{{{ LTRIM(~,'0')}}} |This will trim any leading zeros
|1| 2| PLPL.START_DATE| 12| 19| Char| |{{{TO_CHAR(TO_DATE(RTRIM(~),'MMDDYYYY'),'DD-Mon-YYYY')}}}|This will format the incoming date to the eP standard.
|1| 3| PLPL.TIME_OR_AMOUNT| 28| 35| Char| | {{{TO_NUMBER(~)/100}}} |This will take the provided value and divide it by 100 since the amt provided does not include any decimal places.
At line 8 changed one line
|1|5| PLPL.TIME_CODE| 40| 42| Char| |decode(:PLPL.F_WORK_IN_PROCESS,'1','OTR1', '2', 'OTR2',p2k_smglx('PL_TIME_CD_KEYED',:PLPL.TIME_CODE))|The value provided is the client's Labor Code. The system will first check if the Work In Process value is a 1 or 2, if it is then it will use OTR1 or OTR2 time code accordingly. If the WIP value is neither a 1 or 2, then the value provided will be translated to an eP time code by comparing the provided value with the displayed value in the client's user defined PL_TIME_CD_KEYED lexicon. The file format is a fixed format.
|1|5| PLPL.TIME_CODE| 40| 42| Char| |{{{decode
(:PLPL.F_WORK_IN_PROCESS,
'1','OTR1','2','OTR2',
p2k_smglx('PL_TIME_CD_KEYED',
:PLPL.TIME_CODE))}}}|The value provided is the client's Labor Code. The system will first check if the Work In Process value is a 1 or 2, if it is then it will use OTR1 or OTR2 time code accordingly. If the WIP value is neither a 1 or 2, then the value provided will be translated to an eP time code by comparing the provided value with the displayed value in the client's user defined PL_TIME_CD_KEYED lexicon. The file format is a fixed format.
At line 24 changed one line
|1 |17| PLPL.F_QUALIFIER| -1| -1| Char |TRUE| CASE WHEN(SUBSTR(:PLPL.TIME_CODE,1,2) = ('VA')) THEN 'FALSE' ELSE 'TRUE' END|This derivation is used to determine if the record qualifies for this type of load. It checks to see if the first 2 characters of the value in the time code field are VA, if they are then the record does not qualify and thus will be bypassed. This is used to Bypass vacation type components which will be loaded directly into IAAL via a different interface. The RECORD TYPE must be QUALIFY RECORD.
|1 |17| PLPL.F_QUALIFIER| -1| -1| Char |TRUE| {{{CASE WHEN
(SUBSTR(:PLPL.TIME_CODE,1,2) = ('VA'))
THEN 'FALSE'
ELSE 'TRUE'
END}}}|This derivation is used to determine if the record qualifies for this type of load. It checks to see if the first 2 characters of the value in the time code field are VA, if they are then the record does not qualify and thus will be bypassed. This is used to Bypass vacation type components which will be loaded directly into IAAL via a different interface. The RECORD TYPE must be QUALIFY RECORD.