Lawson Insight Technical Documentation |
|
TAEMPSERV
TAEMPSERV FILE
REFERENCED BY
HR00.1 HR01.1 HR02.1 HR06.1 HR506 LP08.2
LP09.2 LP251 LP260 LP262 LP60.3 LP60.4
LP60.1 LP60.2 LP62.1 LP62.2 LP188 LP145
LP198 LP61.1
UPDATED BY
BN134 BN150 BN305 BN66.1 ET530 ETI2.1
HR11.1 HR11.2 HR511 LP130 LP140 LP197
LP353 LP53.1 LP54.1 LP553 LP554 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR120 PR128 PR13.1 PR13.5 PR13.6
PR13.8 PR130 PR131 PR132 PR134 PR136
PR137 PR139 PR140 PR189 PR195 PR197
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR37.1 PR38.1 PR39.1
PR45.1 PR529 PR530 PR560 PR80.1 PR82.1
PR85.1 PR89.1 UK102 UK330 UK560 TA147
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TES-COMPANY Numeric 4 BN150 ET530
Element: Company Hr ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-EMPLOYEE Numeric 9 BN150 ET530
Element: Employee Contains the employee number. Each ETI2.1 LP130
person employed by the company is LP53.1 LP553
assigned a unique number. The system LP554 PR128
uses the employee number to correlate PR130 PR131
all of the information related to that PR132 PR134
person. PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-TES-OBJ-ID Numeric 12 BN150 ET530
Element: Tes Obj Id ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR85.1
TA147 UK102
UK560
TES-SERVICE-CODE Alpha 4 BN150 ET530
Element: Ta Service Cd ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-EVENT-FLAG Numeric 1 BN150 ET530
Element: Event Flag 0 = No ETI2.1 LP130
1 = Yes LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-REASON-CODE Alpha 4 BN150 ET530
Element: Ta Reason Cd ETI2.1 LP130
LP53.1 LP54.1
LP553 LP554
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TES-EVENT-TYPE Numeric 1 BN150 ET530
Element: Event Type 1 = Absence ETI2.1 LP130
2 = Non Absence LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-PLAN-BALANCE Numeric 1 BN150 ET530
Element: Lp Plan Bal 0 = None ETI2.1 LP130
1 = Available LP53.1 LP553
2 = Reserve LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-SERVICE-STATUS Numeric 1 BN150 ET530
Element: Service Status0 = Created ETI2.1 LP130
2 = Processed LP140 LP197
9 = Closed LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR85.1
TA147 UK102
UK560
TES-EVENT-STATUS Numeric 1 BN150 ET530
Element: Event Status 0 = Created ETI2.1 LP130
1 = Not Processed LP140 LP197
2 = Processed LP53.1 LP553
9 = Closed LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR85.1
TA147 UK102
UK560
TES-STATUS Numeric 1 BN150 BN66.1
Element: Status This field displays the status of the ET530 ETI2.1
transaction. LP130 LP53.1
0 = Batch LP553 LP554
1 = Future PR128 PR130
2 = Current PR131 PR132
3 = Error PR134 PR136
4 = Processed PR137 PR139
5 = Manual PR140 PR189
9 = Closed PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR37.1
PR38.1 PR39.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK330 UK560
TES-TIME-SEQ Numeric 12 BN150 ET530
Element: Time Seq ETI2.1 LP130
LP53.1 LP54.1
LP553 LP554
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TES-EXT-TIME-SEQ Numeric 12 BN150 ET530
Element: Ext Time Seq ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-TR-DATE Numeric 8 (yyyymmdd) BN150 ET530
Element: Tr Date ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-PER-END-DATE Numeric 8 (yyyymmdd) BN150 ET530
Element: Per End Date Identifies period end date in ETI2.1 LP130
distribution record; used during PR198 LP53.1 LP553
to relieve salary encumbrance LP554 PR128
commitments for pay period (updated from PR130 PR131
TIMERECORD.PER-END-DATE). PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-PROCESS-LEVEL Alpha 5 BN150 ET530
Element: Process Lev Hr ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-HM-PROC-LEVEL Alpha 5 BN150 BN305
Element: Process Lev Hr ET530 ETI2.1
HR11.1 HR11.2
HR511 LP130
LP53.1 LP553
LP554 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TES-DEPARTMENT Alpha 5 BN150 BN305
Element: Department Contains the department. ET530 ETI2.1
HR11.1 HR11.2
HR511 LP130
LP53.1 LP553
LP554 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TES-POSITION Alpha 12 BN150 ET530
Element: Position Contains the user-defined code that ETI2.1 LP130
represents a position in the company. LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-JOB-CODE Alpha 9 BN150 ET530
Element: Job Code Contains a user-defined code that ETI2.1 LP130
represents a type of job. LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-HOURS Signed 7.2 BN150 ET530
Element: Hours Contains the hours. ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 PR85.1
TA147 UK102
UK560
TES-WAGE-AMOUNT Signed 18.2 BN150 BN66.1
Element: Ta Wage Amount ET530 ETI2.1
LP130 LP53.1
LP553 LP554
PR128 PR130
PR131 PR132
PR134 PR136
PR137 PR140
PR189 PR195
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR37.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
PR85.1 PR89.1
TA147 UK102
UK560
TES-CURRENCY-CODE Alpha 5 BN150 ET530
Element: Currency Code This field contains the company base ETI2.1 LP130
currency code established in Company LP53.1 LP553
(GL10.1 ). LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-CURR-ND Numeric 1 BN150 ET530
Element: Acct Nd The number of decimals assigned to a ETI2.1 LP130
particular account as determined by the LP53.1 LP553
account currency. LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-PCD-SEQ-NBR Numeric 4 BN150 ET530
Element: Pcd Seq Nbr ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-POINTS Signed 7.2 BN150 ET530
Element: Points ETI2.1 LP130
LP53.1 LP54.1
LP553 LP554
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TES-OCCURRENCE Alpha 1 BN150 ET530
Element: Occurrence 1 = No ETI2.1 LP130
2 = Yes LP53.1 LP54.1
LP553 LP554
PR128 PR130
PR131 PR132
PR134 PR136
PR189 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK560
TES-DAYS-IND Numeric 1 BN150 ET530
Element: Days Ind 1 = Sunday ETI2.1 LP130
2 = Monday LP53.1 LP553
3 = Tuesday LP554 PR128
4 = Wednesday PR130 PR131
5 = Thursday PR132 PR134
6 = Friday PR136 PR189
7 = Saturday PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-CREATE-DATE Numeric 8 (yyyymmdd) BN150 ET530
Element: Date Stamp This field contains the server date ETI2.1 LP130
(month, date, and year) of the last LP53.1 LP553
change to this record. LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-CREATE-TIME Numeric 6 (hhmmss) BN150 ET530
Element: Time Stamp Contains the server time (hour, minute, ETI2.1 LP130
and second) when the record was last LP53.1 LP553
changed. LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-CREATE-USER-ID Alpha 10 (Lower Case) BN150 ET530
Element: User ETI2.1 LP130
LP53.1 LP553
LP554 PR128
PR130 PR131
PR132 PR134
PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR45.1
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK560
TES-DATE-STAMP Numeric 8 (yyyymmdd) BN150 BN305
Element: Date Stamp This field contains the server date BN66.1 ET530
(month, date, and year) of the last ETI2.1 HR11.1
change to this record. HR11.2 HR511
LP130 LP140
LP197 LP53.1
LP54.1 LP553
LP554 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR137 PR139
PR140 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
...
TES-TIME-STAMP Numeric 6 (hhmmss) BN150 BN305
Element: Time Stamp Contains the server time (hour, minute, BN66.1 ET530
and second) when the record was last ETI2.1 HR11.1
changed. HR11.2 HR511
LP130 LP140
LP197 LP53.1
LP54.1 LP553
LP554 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR137 PR139
PR140 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
...
TES-USER-ID Alpha 10 (Lower Case) BN150 BN305
Element: User BN66.1 ET530
ETI2.1 HR11.1
HR11.2 HR511
LP130 LP140
LP197 LP53.1
LP54.1 LP553
LP554 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR137 PR139
PR140 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
...
TES-CREATED-NG-BAL Alpha 1
Element: Time Acc Flag A = Created by LP Neg Bal Options
TAEMPSERV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TESSET1 COMPANY BN134 BN150
EMPLOYEE BN66.1 ET530
TES-OBJ-ID ETI2.1 HR00.1
HR01.1 HR02.1
HR06.1 HR11.1
HR506 LP08.2
LP09.2 LP130
LP140 LP197
LP251 LP260
LP262 LP353
LP53.1 LP54.1
LP553 LP554
LP60.3 LP60.4
PA115 PR128
PR130 PR131
...
TESSET10 COMPANY KeyChange LP251 LP62.1
EMPLOYEE LP62.2
TR-DATE
TES-OBJ-ID
TESSET2 COMPANY KeyChange, Subset LP140
EMPLOYEE Where((STATUS = 2 )
TR-DATE Or (STATUS = 3 )
TES-OBJ-ID Or (STATUS = 4 )
Or (STATUS = 5 )
Or (STATUS = 9 ))
And (SERVICE-CODE != Spaces )
TESSET3 COMPANY KeyChange, Subset LP188
EMPLOYEE Where (SERVICE-CODE != Spaces )
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
TR-DATE
TES-OBJ-ID
TESSET4 COMPANY KeyChange, Subset LP140 LP145
EMPLOYEE Where((STATUS = 2 ) LP198
POSITION Or (STATUS = 3 )
JOB-CODE Or (STATUS = 4 )
PROCESS-LEVEL Or (STATUS = 5 )
DEPARTMENT Or (STATUS = 9 ))
PER-END-DATE And (SERVICE-CODE != Spaces )
TES-OBJ-ID
TESSET5 COMPANY KeyChange, Subset LP140
EMPLOYEE Where (SERVICE-CODE != Spaces )
POSITION And (PLAN-BALANCE != Zeroes )
JOB-CODE And (EVENT-STATUS != 9 )
PROCESS-LEVEL And ((STATUS = 2 )
DEPARTMENT Or (STATUS = 3 )
TR-DATE Or (STATUS = 4 )
TES-OBJ-ID Or (STATUS = 5 )
Or (STATUS = 9 ))
TESSET6 COMPANY KeyChange, Subset LP140
EMPLOYEE Where((STATUS = 2 )
PER-END-DATE Or (STATUS = 3 )
TES-OBJ-ID Or (STATUS = 4 )
Or (STATUS = 5 )
Or (STATUS = 9 ))
And (SERVICE-CODE != Spaces )
TESSET7 COMPANY KeyChange LP140 LP197
HM-PROC-LEVEL
EMPLOYEE
TES-OBJ-ID
TESSET8 COMPANY KeyChange, Subset BN305 BN66.1
EMPLOYEE Where (SERVICE-STATUS != 9 ) ET530 HR06.1
TR-DATE And (EVENT-STATUS != 9 ) HR11.1 HR11.2
TES-OBJ-ID HR506 HR511
LP197 LP53.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
...
TESSET9 COMPANY KeyChange LP260 LP262
EMPLOYEE LP54.1 LP60.1
TR-DATE* LP60.2 LP61.1
TES-OBJ-ID*
SERVICE-STATUS
EVENT-STATUS
TAEMPSERV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TES-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When (TES-CURRENCY-CODE != Spaces )
TES-CURRENCY-CODE -> CUC-CURRENCY-CODE
Department DEPTCODE Required
When (TES-DEPARTMENT != Spaces )
TES-COMPANY -> DPT-COMPANY
TES-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
TES-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
TES-COMPANY -> EMP-COMPANY
TES-EMPLOYEE -> EMP-EMPLOYEE
Hm Proc Level PRSYSTEM Required
When TES-HM-PROC-LEVEL != Spaces
TES-COMPANY -> PRS-COMPANY
TES-HM-PROC-LEVEL -> PRS-PROCESS-LEVEL
Job Code JOBCODE Required
When (TES-JOB-CODE != Spaces )
TES-COMPANY -> JBC-COMPANY
TES-JOB-CODE -> JBC-JOB-CODE
Paemployee PAEMPLOYEE Required
TES-COMPANY -> PEM-COMPANY
TES-EMPLOYEE -> PEM-EMPLOYEE
Pay Code PRPAYCODE Required
When TES-PCD-SEQ-NBR != Zeroes
TES-COMPANY -> PCD-COMPANY
TES-PCD-SEQ-NBR -> PCD-SEQ-NBR
Process Level PRSYSTEM Required
When (TES-PROCESS-LEVEL != Spaces )
TES-COMPANY -> PRS-COMPANY
TES-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Reason Code TAREASCODE Required
When (TES-REASON-CODE != Spaces )
TES-COMPANY -> TRE-COMPANY
TES-REASON-CODE -> TRE-REASON-CODE
Service Code TASERVCODE Required
When (TES-SERVICE-CODE != Spaces )
TES-COMPANY -> TSC-COMPANY
TES-SERVICE-CODE -> TSC-SERVICE-CODE
Timerecord TIMERECORD Not Required
TES-COMPANY -> TRD-COMPANY
TES-EMPLOYEE -> TRD-EMPLOYEE
TES-TIME-SEQ -> TRD-TIME-SEQ
TAEMPSERV FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When (TES-POSITION != Spaces )
TES-COMPANY -> POS-COMPANY
TES-POSITION -> POS-POSITION
POS-EFFECT-DATE
|