Below are sample interfaces that show how to insert effective date records on to date effective tables. All samples show the required fields only to insert a new record. Additional fields to be updated may be added to these interfaces provided they are found on the subject table being updated. The first line of these interfaces will make the assumption that the file will contain a header row identifying the column names. As the position of the data in the file will be established in the IDIF interface, the header row will not be required. Establishing a header row in the interface will instruct the interface to skip the first row of data found on the file. If the inbound file does not contain a header row, this part of the set up is not required. Inserts a change in position to the P2K_HR_ASSIGNMENT_DETAILS table.

Load Away From Post Exceptions#

Rec
#
Field
#
NameBeg
Pos
End
Pos
Field
Type
Constant
Value
Add to
UK set
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.
114 TTX.ACT_DIF_POST_INSERT_BUILD_SCHED 0 0 Char Required so that the scheduled day is rebuilt.


Load Replacement Exceptions#

Rec
#
Field
#
NameBeg
Pos
End
Pos
Field
Type
Constant
Value
Derivation
Expression
Notes
01HEADER RECORD*-1-1Char Must have Record Type of Header Record
11TTX.EAS_ID.EEM_ID.EID_ID.PERSON_CODE-1-1Char
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


Notes #

Click to create a new notes page