Lawson Insight Technical Documentation |
|
TAEMPSERV
TAEMPSERV FILE
UPDATED BY
BN134 BN150 HR11.2 HR511 PA02.1 PA100
PA102 PA13.1 PA13.2 PA502 PA513 PA52.5
PR110 PR128 PR130 PR131 PR132 PR134
PR136 PR137 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 PR82.1 PR85.1 PRSA.1 UK102 UK330
TA147 TP135
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TES-COMPANY Numeric 4 BN150 PR128
Element: Company Hr Identifies the AP company if the PR130 PR131
resource type = V. Identifies the HR PR132 PR134
company if the resource type = E. It is PR136 PR29.1
blank for type A, P or Q resources. 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
PR82.1 TA147
TP135 UK102
TES-EMPLOYEE Numeric 9 BN150 PR128
Element: Employee Contains the employee number. Each PR130 PR131
person employed by the company is PR132 PR134
assigned a unique number. The system PR136 PR29.1
uses the employee number to correlate PR32.2 PR33.2
all of the information related to that PR33.3 PR35.1
person. PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TES-TES-OBJ-ID Numeric 12 BN150 PR128
Element: Tes Obj Id PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-SERVICE-CODE Alpha 4 BN150 PR128
Element: Ta Service Cd PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-EVENT-FLAG Numeric 1 BN150 PR128
Element: Event Flag 0 = No PR130 PR131
1 = Yes PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-REASON-CODE Alpha 4 BN150 PR128
Element: Ta Reason Cd This field contains the reason code, PR130 PR131
which indicates the cause for credit PR132 PR134
memos. PR136 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
PR82.1 TA147
TP135 UK102
TES-EVENT-TYPE Numeric 1 BN150 PR128
Element: Event Type 1 = Absence PR130 PR131
2 = Non Absence PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-PLAN-BALANCE Numeric 1 BN150 PR128
Element: Lp Plan Bal 0 = None PR130 PR131
1 = Available PR132 PR134
2 = Reserve PR136 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
PR82.1 TA147
TP135 UK102
TES-SERVICE-STATUS Numeric 1 BN150 PR128
Element: Service Status0 = Created PR130 PR131
2 = Processed PR132 PR134
9 = Closed PR136 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
PR82.1 TA147
TP135 UK102
TES-EVENT-STATUS Numeric 1 BN150 PR128
Element: Event Status 0 = Created PR130 PR131
1 = Not Processed PR132 PR134
2 = Processed PR136 PR29.1
9 = Closed 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
PR82.1 TA147
TP135 UK102
TES-STATUS Numeric 1 BN150 PR128
Element: Status This field displays the status of the PR130 PR131
transaction. PR132 PR134
0 = Batch PR136 PR137
1 = Future PR197 PR29.1
2 = Current PR32.1 PR32.2
3 = Error PR33.1 PR33.2
4 = Processed PR33.3 PR35.1
5 = Manual PR35.2 PR35.3
9 = Closed PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR37.1 PR38.1
PR39.1 PR45.1
PR529 PR530
PR560 PR82.1
PR85.1 TA147
TP135 UK102
UK330
TES-TIME-SEQ Numeric 12 BN150 PR128
Element: Sequence Number PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-EXT-TIME-SEQ Numeric 12 BN150 PR128
Element: Ext Time Seq PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-TR-DATE Numeric 8 (yyyymmdd) BN150 PR128
Element: Time Record Date PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-PER-END-DATE Numeric 8 (yyyymmdd) BN150 PR128
Element: Period End DatIdentifies period end date in PR130 PR131
distribution record; used during PR198 PR132 PR134
to relieve salary encumbrance PR136 PR29.1
commitments for pay period (updated from PR32.2 PR33.2
TIMERECORD.PER-END-DATE). 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
PR82.1 TA147
TP135 UK102
TES-PROCESS-LEVEL Alpha 5 BN150 PR128
Element: Process Lev HrThis field contains the process level, PR130 PR131
which is the reporting hierarchy below PR132 PR134
company. PR136 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
PR82.1 TA147
TP135 UK102
TES-HM-PROC-LEVEL Alpha 5 BN150 HR11.2
Element: Process Lev HrContains the employee's home process HR511 PA02.1
level. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.5 PR110
PR128 PR130
PR131 PR132
PR134 PR136
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 PR82.1
TA147 TP135
UK102
TES-DEPARTMENT Alpha 5 BN150 HR11.2
Element: Department Contains the department. HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.5 PR110
PR128 PR130
PR131 PR132
PR134 PR136
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 PR82.1
TA147 TP135
UK102
TES-POSITION Alpha 12 BN150 PR128
Element: Position Contains the user-defined code that PR130 PR131
represents a position in the company. PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-JOB-CODE Alpha 9 BN150 PR128
Element: Job Code Contains a user-defined code that PR130 PR131
represents a type of job. PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-HOURS Signed 7.2 BN150 PR128
Element: Hours Contains the hours. PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-WAGE-AMOUNT Signed 18.2 BN150 PR128
Element: Ta Wage AmountContains the sum of all wage amounts PR130 PR131
from the time records for pay codes tied PR132 PR134
to this pay summary group. PR136 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
PR82.1 PRSA.1
TA147 TP135
UK102
TES-CURRENCY-CODE Alpha 5 BN150 PR128
Element: Currency Code This field contains the company base PR130 PR131
currency code established in Company PR132 PR134
(GL10.1 ). PR136 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
PR82.1 TA147
TP135 UK102
TES-CURR-ND Numeric 1 BN150 PR128
Account Currency Represents the number of decimals PR130 PR131
Code defined for the currency of the object. PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-PCD-SEQ-NBR Numeric 4
Element: Pcd Seq Nbr
TES-POINTS Signed 7.2 BN150 PR128
Element: Points PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-OCCURRENCE Alpha 1 BN150 PR128
Element: Occurrence 1 = No PR130 PR131
2 = Yes PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-DAYS-IND Numeric 1 BN150 PR128
Element: Days Indicator1 = Sunday PR130 PR131
2 = Monday PR132 PR134
3 = Tuesday PR136 PR29.1
4 = Wednesday PR32.2 PR33.2
5 = Thursday PR33.3 PR35.1
6 = Friday PR35.2 PR35.3
7 = Saturday PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TES-CREATE-DATE Numeric 8 (yyyymmdd) BN150 PR128
Element: Date Stamp The creation date. PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-CREATE-TIME Numeric 6 (hhmmss) BN150 PR128
Element: Time Stamp PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-CREATE-USER-ID Alpha 10 (Lower Case) BN150 PR128
Element: User PR130 PR131
PR132 PR134
PR136 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
PR82.1 TA147
TP135 UK102
TES-DATE-STAMP Numeric 8 (yyyymmdd) BN150 HR11.2
Element: Date Stamp This field contains the server date HR511 PA02.1
(month, date, and year) of the last PA100 PA102
change to this record. PA13.1 PA13.2
PA502 PA513
PA52.5 PR110
PR128 PR130
PR131 PR132
PR134 PR136
PR137 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
PR82.1 PR85.1
PRSA.1 TA147
TP135 UK102
UK330
TES-TIME-STAMP Numeric 6 (hhmmss) BN150 HR11.2
Element: Time Stamp Contains the server time (hour, minute, HR511 PA02.1
and second) when the record was last PA100 PA102
changed. PA13.1 PA13.2
PA502 PA513
PA52.5 PR110
PR128 PR130
PR131 PR132
PR134 PR136
PR137 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
PR82.1 PR85.1
PRSA.1 TA147
TP135 UK102
UK330
TES-USER-ID Alpha 10 (Lower Case) BN150 HR11.2
Element: User Contains the user ID of the person who HR511 PA02.1
last changed this record. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.5 PR110
PR128 PR130
PR131 PR132
PR134 PR136
PR137 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
PR82.1 PR85.1
PRSA.1 TA147
TP135 UK102
UK330
TAEMPSERV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TESSET1 COMPANY BN134 BN150
EMPLOYEE PR128 PR130
TES-OBJ-ID PR131 PR132
PR134 PR136
PR137 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
...
TESSET2 COMPANY KeyChange, Subset
EMPLOYEE Where((STATUS = 2 )
TR-DATE Or (STATUS = 3 )
TES-OBJ-ID Or (STATUS = 4 )
Or (STATUS = 5 ))
And (SERVICE-CODE != Spaces )
TESSET3 COMPANY KeyChange, Subset
EMPLOYEE Where (SERVICE-CODE != Spaces )
POSITION
JOB-CODE
PROCESS-LEVEL
DEPARTMENT
TR-DATE
TES-OBJ-ID
TESSET4 COMPANY KeyChange, Subset
EMPLOYEE Where((STATUS = 2 )
POSITION Or (STATUS = 3 )
JOB-CODE Or (STATUS = 4 )
PROCESS-LEVEL Or (STATUS = 5 ))
DEPARTMENT And (SERVICE-CODE != Spaces )
PER-END-DATE
TES-OBJ-ID
TESSET5 COMPANY KeyChange, Subset
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
EMPLOYEE Where((STATUS = 2 )
PER-END-DATE Or (STATUS = 3 )
TES-OBJ-ID Or (STATUS = 4 )
Or (STATUS = 5 ))
And (SERVICE-CODE != Spaces )
TESSET7 COMPANY KeyChange
HM-PROC-LEVEL
EMPLOYEE
TES-OBJ-ID
TESSET8 COMPANY KeyChange, Subset HR11.2 HR511
EMPLOYEE Where (SERVICE-STATUS != 9 ) PA02.1 PA100
TR-DATE And (EVENT-STATUS != 9 ) PA102 PA13.1
TES-OBJ-ID PA13.2 PA502
PA513 PA52.5
PR110 PR132
PRSA.1
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
Job Code JOBCODE Required
When (TES-JOB-CODE != Spaces )
TES-COMPANY -> JBC-COMPANY
TES-JOB-CODE -> JBC-JOB-CODE
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
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
|