TAEMPSERV

REFERENCED BY
LP262 LP62.1 LP62.2 LP102 LP188 LP145
LP198


UPDATED BY
BN134 BN150 BN305 BN66.1 HR11.1 HR11.2
HR511 PR521 EXI2.1 EXI4.1 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 PR13.9 PR130 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
PR37.1 PR38.1 PR39.1 PR45.1 PR529 PR530
PR560 PR582 PR80.1 PR80.4 PR82.1 PR85.1
PR89.1 UK102 UK330 UK560 TA147 LP251
LP260 LP60.1 LP60.2 LP61.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TES-COMPANY
Element: Company Hr		Numeric 4
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
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
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-TES-OBJ-ID
Element: Tes Obj Id		Numeric 12
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102 UK560
TES-SERVICE-CODE
Element: Ta Service Cd		Alpha 10
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-EVENT-FLAG
Element: Event Flag		Numeric 1

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

1 = Absence
2 = Non Absence
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-PLAN-BALANCE
Element: Lp Plan Bal		Numeric 1

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

0 = Created
2 = Processed
9 = Closed
BN150 EXI2.1
EXI4.1 LP130
LP140 LP197
LP53.1 LP553
LP554 PR128
PR130 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 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
TA147 UK102
UK560
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
LP53.1 LP553
LP554 PR128
PR130 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 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
TA147 UK102
UK560
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 LP140
LP53.1 LP553
LP554 PR128
PR130 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 PR37.1
PR38.1 PR39.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 TA147
UK102 UK330
UK560
TES-TIME-SEQ
Element: Time Seq		Numeric 12
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP54.1 LP553
LP554 PR128
PR130 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 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
TES-EXT-TIME-SEQ
Element: Ext Time Seq		Numeric 12
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-TR-DATE
Element: Tr Date		Numeric 8 (yyyymmdd)
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
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
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-HM-PROC-LEVEL
Element: Process Lev Hr		Alpha 5
 ...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR511 LP130
LP140 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
PR13.9 PR130
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
PR37.1 PR45.1
PR521 PR529
TES-DEPARTMENT
Element: Department		Alpha 5
Contains the department. 		...
BN150 BN305
EXI2.1 EXI4.1
HR11.1 HR11.2
HR511 LP130
LP140 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
PR13.9 PR130
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
PR37.1 PR45.1
PR521 PR529
TES-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
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
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-HOURS
Element: Hours		Signed 7.2
Contains the hours.
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
PR85.1 TA147
UK102 UK560
TES-WAGE-AMOUNT
Element: Ta Wage Amount		Signed 18.2
BN150 BN66.1
EXI2.1 EXI4.1
LP130 LP140
LP53.1 LP553
LP554 PR128
PR130 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 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 PR85.1
PR89.1 TA147
UK102 UK560
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
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
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
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-PCD-SEQ-NBR
Element: Pcd Seq Nbr		Numeric 4
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-POINTS
Element: Points		Signed 7.2
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP54.1 LP553
LP554 PR128
PR130 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 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
TES-OCCURRENCE
Element: Occurrence		Alpha 1

1 = No
2 = Yes
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP54.1 LP553
LP554 PR128
PR130 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 PR37.1
PR45.1 PR521
PR529 PR530
PR560 PR582
PR80.1 PR80.4
PR82.1 TA147
UK102 UK560
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
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
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
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
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
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
TES-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560
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 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 PR13.9
PR130 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
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 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 PR13.9
PR130 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
TES-USER-ID
Element: User		Alpha 10 (Lower Case)
 ...
BN150 BN305
BN66.1 EXI2.1
EXI4.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 PR13.9
PR130 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
TES-CREATED-NG-BAL
Element: Time Acc Flag		Alpha 1

A = Created by LP Neg Bal Options
BN150 EXI2.1
EXI4.1 LP130
LP140 LP53.1
LP553 LP554
PR128 PR130
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
PR37.1 PR45.1
PR521 PR529
PR530 PR560
PR582 PR80.1
PR80.4 PR82.1
TA147 UK102
UK560


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 LP197
LP251 LP260
LP262 LP353
LP53.1 LP54.1
LP553 LP554
LP60.3 LP60.4
PA115 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR139
TESSET10 COMPANY
EMPLOYEE
TR-DATE
TES-OBJ-ID
KeyChange
LP251 LP62.1
LP62.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
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 HR511
PR521 EXI2.1
EXI4.1 LP130
LP140 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
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: Wed Jun 08 20:50:01 2016

Home
Contact Us



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