TAEMPSERV

Employee LP Service Record

REFERENCED BY
LP260 HR00.1 HR01.1 LP61.1


UPDATED BY
BN134 BN150 BN305 BN66.1 HR11.1 HR11.2
HR11.4 HR28.1 HR511 LT101 LT111 PR521
ZH510 EXI2.1 EXI4.1 LP130 LP140 LP151
LP197 LP199 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 PR12.6 PR120 PR128
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR131
PR132 PR134 PR135 PR136 PR137 PR139
PR140 PR189 PR195 PR197 PR29.1 PR30.2
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 PR36.4 PR37.1 PR38.1 PR39.1
PR45.1 PR512 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 PR85.1 PR89.1 PRAT.1
UK102 TA147 LP251 LP262 LP60.3 LP60.4
LP62.1 LP62.2 HR02.1 HR06.1 HR506 LP08.2
LP09.2 LP102 LP188 LP145 LP198

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TES-COMPANY
Element: Company Hr		Numeric 4
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-TES-OBJ-ID
Element: Tes Obj Id		Numeric 12
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
TA147 UK102
TES-SERVICE-CODE
Element: Ta Service Cd		Alpha 10
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-EVENT-FLAG
Element: Event Flag		Numeric 1

0 = No
1 = Yes
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-REASON-CODE
Element: Ta Reason Cd		Alpha 4
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP54.1
LP553 LP554
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
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 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TES-EVENT-TYPE
Element: Event Type		Numeric 1

1 = Absence
2 = Non Absence
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-PLAN-BALANCE
Element: Lp Plan Bal		Numeric 1

0 = None
1 = Available
2 = Reserve
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-SERVICE-STATUS
Element: Service Status		Numeric 1

0 = Created
2 = Processed
9 = Closed
BN150 EXI2.1
EXI4.1 LP130
LP140 LP197
LP199 LP53.1
LP553 LP554
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
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 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102
TES-EVENT-STATUS
Element: Event Status		Numeric 1

0 = Created
1 = Not Processed
2 = Processed
9 = Closed
BN150 EXI2.1
EXI4.1 LP130
LP140 LP197
LP199 LP53.1
LP553 LP554
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
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 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102
TES-STATUS
Element: Status		Numeric 1
This field displays the status of the transaction.
0 = Batch
1 = Future
2 = Current
3 = Error
4 = Processed
5 = Manual
9 = Closed
BN150 BN66.1
EXI2.1 EXI4.1
LP130 LP53.1
LP553 LP554
PR128 PR131
PR132 PR134
PR135 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 PR36.4
PR37.1 PR38.1
PR39.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 PR89.1
PRAT.1 TA147
UK102
TES-TIME-SEQ
Element: Time Seq		Numeric 12
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP54.1
LP553 LP554
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
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 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TES-EXT-TIME-SEQ
Element: Ext Time Seq		Numeric 12
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-TR-DATE
Element: Tr Date		Numeric 8 (yyyymmdd)
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-PER-END-DATE
Element: Per End Date		Numeric 8 (yyyymmdd)
Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE).
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-HM-PROC-LEVEL
Element: Process Lev Hr		Alpha 5
 ...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LP130
LP53.1 LP553
LP554 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR30.2
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
TES-DEPARTMENT
Element: Department		Alpha 5
Contains the department. 		...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LP130
LP53.1 LP553
LP554 LT101
LT111 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR131
PR132 PR134
PR135 PR136
PR137 PR189
PR29.1 PR30.2
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
TES-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-JOB-CODE
Element: Job Code		Alpha 9
Contains a user-defined code that represents a type of job.
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-HOURS
Element: Hours		Signed 7.2
Contains the hours.
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
TA147 UK102
TES-WAGE-AMOUNT
Element: Ta Wage Amount		Signed 18.2
BN150 BN66.1
EXI2.1 EXI4.1
LP130 LP53.1
LP553 LP554
PR128 PR131
PR132 PR134
PR135 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 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 PR89.1
PRAT.1 TA147
UK102
TES-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-PCD-SEQ-NBR
Element: Pcd Seq Nbr		Numeric 8
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-POINTS
Element: Points		Signed 7.2
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP54.1
LP553 LP554
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
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 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TES-OCCURRENCE
Element: Occurrence		Alpha 1

1 = No
2 = Yes
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP54.1
LP553 LP554
PR128 PR131
PR132 PR134
PR135 PR136
PR137 PR189
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 PR36.4
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
TES-DAYS-IND
Element: Days Ind		Numeric 1

1 = Sunday
2 = Monday
3 = Tuesday
4 = Wednesday
5 = Thursday
6 = Friday
7 = Saturday
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record. 		...
BN150 BN305
BN66.1 EXI2.1
EXI4.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LP130 LP140
LP197 LP199
LP53.1 LP54.1
LP553 LP554
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR131 PR132
PR134 PR135
PR136 PR137
PR139 PR140
PR189 PR195
PR197 PR29.1
PR30.2 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
TES-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed. 		...
BN150 BN305
BN66.1 EXI2.1
EXI4.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LP130 LP140
LP197 LP199
LP53.1 LP54.1
LP553 LP554
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR131 PR132
PR134 PR135
PR136 PR137
PR139 PR140
PR189 PR195
PR197 PR29.1
PR30.2 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
TES-USER-ID
Element: User		Alpha 10 (Lower Case)
 ...
BN150 BN305
BN66.1 EXI2.1
EXI4.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LP130 LP140
LP197 LP199
LP53.1 LP54.1
LP553 LP554
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR131 PR132
PR134 PR135
PR136 PR137
PR139 PR140
PR189 PR195
PR197 PR29.1
PR30.2 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
TES-CREATED-NG-BAL
Element: Time Acc Flag		Alpha 1

A = Created by LP Neg Bal Options
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102
TES-REQ-OBJ-ID
Element: Req Obj Id		Numeric 12
TES-RESTORE-DATE
Element: Date		Numeric 8 (yyyymmdd)
LP151
TES-ABN-OBJ-ID
Element: Abn Obj Id		Numeric 12
BN150 EXI2.1
EXI4.1 LP130
LP53.1 LP553
LP554 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
PR36.4 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102


TAEMPSERV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TESSET1 COMPANY
EMPLOYEE
TES-OBJ-ID
...
BN134 BN150
BN66.1 HR11.1
PR521 EXI2.1
EXI4.1 LP130
LP140 LP151
LP197 LP199
LP251 LP260
LP262 LP353
LP53.1 LP54.1
LP553 LP554
LP60.3 LP60.4
PA115 PR128
PR131 PR132
PR134 PR135
PR136 PR137
TESSET10 COMPANY
EMPLOYEE
TR-DATE
TES-OBJ-ID
KeyChange
LP151 LP251
LP62.1 LP62.2
TESSET11 COMPANY
PROCESS-LEVEL
DEPARTMENT
SERVICE-STATUS
EVENT-STATUS
JOB-CODE
EMPLOYEE
TES-OBJ-ID
SERVICE-CODE
REASON-CODE
KeyChange
HR00.1 HR01.1
HR02.1 HR06.1
HR506 LT101
LT111 LP08.2
LP09.2
TESSET2 COMPANY
EMPLOYEE
TR-DATE
TES-OBJ-ID
KeyChange, Subset
Where((STATUS =2)
Or(STATUS =3)
Or(STATUS =4)
Or(STATUS =5)
Or(STATUS =9))
And(SERVICE-CODE !=Spaces)
LP102 LP140
TESSET3 COMPANY
EMPLOYEE
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
TR-DATE
TES-OBJ-ID
KeyChange, Subset
Where(SERVICE-CODE !=Spaces)
LP188
TESSET4 COMPANY
EMPLOYEE
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
PER-END-DATE
TES-OBJ-ID
KeyChange, Subset
Where((STATUS =2)
Or(STATUS =3)
Or(STATUS =4)
Or(STATUS =5)
Or(STATUS =9))
And(SERVICE-CODE !=Spaces)
LP140 LP145
LP198
TESSET5 COMPANY
EMPLOYEE
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
TR-DATE
TES-OBJ-ID
KeyChange, Subset
Where(SERVICE-CODE !=Spaces)
And(PLAN-BALANCE !=Zeroes)
And(EVENT-STATUS !=9)
And((STATUS =2)
Or(STATUS =3)
Or(STATUS =4)
Or(STATUS =5)
Or(STATUS =9))
LP140
TESSET6 COMPANY
EMPLOYEE
PER-END-DATE
TES-OBJ-ID
KeyChange, Subset
Where((STATUS =2)
Or(STATUS =3)
Or(STATUS =4)
Or(STATUS =5)
Or(STATUS =9))
And(SERVICE-CODE !=Spaces)
LP140
TESSET7 COMPANY
HM-PROC-LEVEL
EMPLOYEE
TES-OBJ-ID
KeyChange
HR00.1 HR01.1
LP197
TESSET8 COMPANY
EMPLOYEE
TR-DATE
TES-OBJ-ID
KeyChange, Subset
Where(SERVICE-STATUS !=9)
And(EVENT-STATUS !=9)
...
BN150 BN305
BN66.1 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PR521 ZH510
EXI2.1 EXI4.1
LP08.2 LP130
LP199 LP53.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
TESSET9 COMPANY
EMPLOYEE
TR-DATE*
TES-OBJ-ID*
SERVICE-STATUS
EVENT-STATUS
KeyChange
LP140 LP260
LP262 LP54.1
LP60.1 LP60.2
LP61.1


TAEMPSERV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When (TES-POSITION !=Spaces )
TES-COMPANY->POS-COMPANY
TES-POSITION->POS-POSITION
  POS-EFFECT-DATE

File created: Thu Jun 09 02:22:07 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.