Lawson Insight Technical Documentation |
|
TAENROLL
TAENROLL FILE
REFERENCED BY
HR00.1 HR01.1 HR02.1 HR06.1 HR506 LP140
LP145 LP188 LP198 LP231 BN150 ET530
ETI2.1 LP130 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 PR529 PR530
PR560 PR80.1 PR82.1 UK102 UK560 TA147
UPDATED BY
BN305 HR11.1 HR11.2 HR511 LP100 LP101
LP103 LP180 LP32.1 LP32.2 LP32.3 LP331
LP80.1 PA02.1 PA100 PA102 PA115 PA13.1
PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8 LP197 LP31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TEN-COMPANY Numeric 4 HR11.1 HR511
Element: Company Hr LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-EMPLOYEE Numeric 9 HR11.1 HR511
Element: Employee Contains the employee number. Each LP100 LP101
person employed by the company is LP180 LP32.1
assigned a unique number. The system LP32.2 LP32.3
uses the employee number to correlate LP80.1 PA100
all of the information related to that PA52.4
person.
TEN-PLAN Alpha 10 HR11.1 HR511
Element: Ta Plan LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-EMPLOYEE-GROUP Alpha 10 HR11.1 HR511
Element: Group Name LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-HM-PROC-LEVEL Alpha 5 BN305 HR11.1
Element: Process Lev Hr HR11.2 HR511
LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
TEN-POSITION Alpha 12 HR11.1 HR511
Element: Position Contains the user-defined code that LP100 LP101
represents a position in the company. LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-JOB-CODE Alpha 9 HR11.1 HR511
Element: Job Code Contains a user-defined code that LP100 LP101
represents a type of job. LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-PROCESS-LEVEL Alpha 5 HR11.1 HR511
Element: Process Lev Hr LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-DEPARTMENT Alpha 5 HR11.1 HR511
Element: Department Contains the department. LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-ENRL-START-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Start Date LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-ENRL-STOP-DT Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Ta Stop Date LP100 LP101
LP103 LP180
LP32.1 LP32.2
LP32.3 LP80.1
PA100 PA52.4
TEN-ENRL-OVERRIDE Numeric 1 HR11.1 HR511
Element: Ta Override 0 = No LP100 LP101
1 = Yes LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-CREATE-DATE Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Date Stamp This field contains the server date LP100 LP101
(month, date, and year) of the last LP180 LP32.1
change to this record. LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-CREATE-TIME Numeric 6 (hhmmss) HR11.1 HR511
Element: Time Stamp Contains the server time (hour, minute, LP100 LP101
and second) when the record was last LP180 LP32.1
changed. LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-CREATE-USER-ID Alpha 10 (Lower Case) HR11.1 HR511
Element: User LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-DATE-STAMP Numeric 8 (yyyymmdd) HR11.1 HR511
Element: Date Stamp This field contains the server date LP100 LP101
(month, date, and year) of the last LP180 LP32.1
change to this record. LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-TIME-STAMP Numeric 6 (hhmmss) HR11.1 HR511
Element: Time Stamp Contains the server time (hour, minute, LP100 LP101
and second) when the record was last LP180 LP32.1
changed. LP32.2 LP32.3
LP80.1 PA100
PA52.4
TEN-USER-ID Alpha 10 (Lower Case) HR11.1 HR511
Element: User LP100 LP101
LP180 LP32.1
LP32.2 LP32.3
LP80.1 PA100
PA52.4
TAENROLL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TENSET1 COMPANY BN305 HR00.1
EMPLOYEE HR01.1 HR02.1
PLAN HR06.1 HR11.1
EMPLOYEE-GROUP HR11.2 HR506
POSITION HR511 LP100
JOB-CODE LP101 LP103
PROCESS-LEVEL LP140 LP145
DEPARTMENT LP180 LP188
LP197 LP198
LP231 LP31.1
LP32.1 LP32.2
LP32.3 LP331
LP80.1 PA02.1
PA100 PA102
PA115 PA13.1
...
TENSET2 COMPANY HR11.1 HR511
EMPLOYEE LP100 LP101
EMPLOYEE-GROUP LP180 LP32.1
PLAN LP32.2 LP32.3
POSITION LP80.1 PA100
JOB-CODE PA52.4
PROCESS-LEVEL
DEPARTMENT
TENSET3 COMPANY KeyChange BN150 ET530
HM-PROC-LEVEL ETI2.1 LP130
EMPLOYEE PR128 PR130
PLAN PR131 PR132
EMPLOYEE-GROUP PR134 PR135
POSITION PR136 PR137
JOB-CODE PR189 PR29.1
PROCESS-LEVEL PR32.1 PR32.2
DEPARTMENT 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
...
TAENROLL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TEN-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Department DEPTCODE Required
When (TEN-DEPARTMENT != Spaces )
TEN-COMPANY -> DPT-COMPANY
TEN-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
TEN-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
TEN-COMPANY -> EMP-COMPANY
TEN-EMPLOYEE -> EMP-EMPLOYEE
Employee Group PERSGROUP Required
TEN-COMPANY -> PRG-COMPANY
TEN-EMPLOYEE-GROUP -> PRG-GROUP-NAME
Hm Proc Level PRSYSTEM Required
When TEN-HM-PROC-LEVEL != Spaces
TEN-COMPANY -> PRS-COMPANY
TEN-HM-PROC-LEVEL -> PRS-PROCESS-LEVEL
Job Code JOBCODE Required
When (TEN-JOB-CODE != Spaces )
TEN-COMPANY -> JBC-COMPANY
TEN-JOB-CODE -> JBC-JOB-CODE
Paemployee PAEMPLOYEE Required
TEN-COMPANY -> PEM-COMPANY
TEN-EMPLOYEE -> PEM-EMPLOYEE
Plan TAPLAN Required
TEN-COMPANY -> TAP-COMPANY
TEN-PLAN -> TAP-PLAN
Process Level PRSYSTEM Required
When (TEN-PROCESS-LEVEL != Spaces )
TEN-COMPANY -> PRS-COMPANY
TEN-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Ta Master TAEEMASTER Required
When TAP-BALANCE-TYPE = 2
TEN-COMPANY -> TEM-COMPANY
TEN-EMPLOYEE -> TEM-EMPLOYEE
TEN-PLAN -> TEM-PLAN
TEN-EMPLOYEE-GROUP -> TEM-EMPLOYEE-GROUP
TEN-POSITION -> TEM-POSITION
Ta Mstr No Pos TAEEMASTER Required
When TAP-BALANCE-TYPE = 1
TEN-COMPANY -> TEM-COMPANY
TEN-EMPLOYEE -> TEM-EMPLOYEE
TEN-PLAN -> TEM-PLAN
TEN-EMPLOYEE-GROUP -> TEM-EMPLOYEE-GROUP
Spaces -> TEM-POSITION
TAENROLL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When (TEN-POSITION != Spaces )
TEN-COMPANY -> POS-COMPANY
TEN-POSITION -> POS-POSITION
POS-EFFECT-DATE
Taemptr No Pos TAEMPTRANS
Valid When TAP-BALANCE-TYPE = 1
TEN-COMPANY -> TTR-COMPANY
TEN-EMPLOYEE -> TTR-EMPLOYEE
TEN-PLAN -> TTR-PLAN
TEN-EMPLOYEE-GROUP -> TTR-EMPLOYEE-GROUP
Spaces -> TTR-POSITION
TTR-DATE
TTR-SEQ-NBR
Taemptr Pos TAEMPTRANS
Valid When TAP-BALANCE-TYPE = 2
TEN-COMPANY -> TTR-COMPANY
TEN-EMPLOYEE -> TTR-EMPLOYEE
TEN-PLAN -> TTR-PLAN
TEN-EMPLOYEE-GROUP -> TTR-EMPLOYEE-GROUP
TEN-POSITION -> TTR-POSITION
TTR-DATE
TTR-SEQ-NBR
Tastructur TASTRUCTUR
TEN-COMPANY -> TST-COMPANY
TEN-EMPLOYEE-GROUP -> TST-EMPLOYEE-GROUP
TEN-PLAN -> TST-PLAN
TST-BEGIN-DATE
Tatrnsum Nopos TATRANSUM
TEN-COMPANY -> TTS-COMPANY
TEN-EMPLOYEE -> TTS-EMPLOYEE
TEN-PLAN -> TTS-PLAN
TEN-EMPLOYEE-GROUP -> TTS-EMPLOYEE-GROUP
Spaces -> TTS-POSITION
TTS-TA-TYPE
TTS-RESET-DATE
Tatrnsum Pos TATRANSUM
Valid When TAP-BALANCE-TYPE = 2
TEN-COMPANY -> TTS-COMPANY
TEN-EMPLOYEE -> TTS-EMPLOYEE
TEN-PLAN -> TTS-PLAN
TEN-EMPLOYEE-GROUP -> TTS-EMPLOYEE-GROUP
TEN-POSITION -> TTS-POSITION
TTS-TA-TYPE
TTS-RESET-DATE
|