TAENROLL – No description in the Lawson data dictionary

System
Absence Management (LP)
Prefix
TEN
Primary key
COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, JOB-CODE, PROCESS-LEVEL, DEPARTMENT
Fields
18
Updated by
94 programs
Referenced by
2 programs

TAENROLL is a Lawson Absence Management table (prefix TEN); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, JOB-CODE, PROCESS-LEVEL, DEPARTMENT (TENSET1); alternate indexes: TENSET2 and TENSET3. It is related 1:1 to PRSYSTEM, DEPTCODE, EMPLOYEE, PERSGROUP, JOBCODE, PAEMPLOYEE, TAPLAN and TAEEMASTER and 1:M to PAPOSITION, TAEMPTRANS, TASTRUCTUR and TATRANSUM. It is updated by BN150, BN305, EXI2.1, EXI4.1, HR00.1, HR01.1, HR02.1, HR06.1 and 86 more and referenced by LP188 and LP231. The table has 18 fields, 3 indexes and 17 documented relations.

About TAENROLL

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the TEN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TEN-COMPANY PK
COMPANY		Numeric 4—HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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.HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-PLAN PK
PLAN		Alpha 10—HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-EMPLOYEE-GROUP PK
EMPLOYEE_GROUP		Alpha 10—HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-HM-PROC-LEVEL
HM_PROC_LEVEL		Alpha 5—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LP100, LP101 +31 more
TEN-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-JOB-CODE PK
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-ENRL-START-DT
ENRL_START_DT		Numeric 8 (yyyymmdd)—HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-ENRL-STOP-DT
ENRL_STOP_DT		Numeric 8 (yyyymmdd)—HR11.1, HR511, LP100, LP101, LP103, LP180, LP32.1, LP32.2 +6 more
TEN-ENRL-OVERRIDE
ENRL_OVERRIDE		Numeric 1—
  • 0 No
  • 1 Yes
HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)—HR11.1, HR511, LP100, LP101, LP180, LP32.1, LP32.2, LP32.3 +5 more
TEN-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR11.1, HR511, LP100, LP101, LP103, LP180, LP32.1, LP32.2 +6 more
TEN-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR11.1, HR511, LP100, LP101, LP103, LP180, LP32.1, LP32.2 +6 more
TEN-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR11.1, HR511, LP100, LP101, LP103, LP180, LP32.1, LP32.2 +6 more

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TENSET1COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, JOB-CODE, PROCESS-LEVEL, DEPARTMENTPrimaryBN150, BN305, HR00.1, HR01.1, HR02.1, HR06.1, HR11.1, HR11.2 +22 more (list truncated in source)
TENSET2COMPANY, EMPLOYEE, EMPLOYEE-GROUP, PLAN, POSITION, JOB-CODE, PROCESS-LEVEL, DEPARTMENTHR11.1, HR511, LT101, LT111, LP100, LP101, LP180, LP32.1 +5 more
TENSET3COMPANY, HM-PROC-LEVEL, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, JOB-CODE, PROCESS-LEVEL, DEPARTMENTKeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)

Relations

One to one (11) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTEN-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
DepartmentDEPTCODERequiredWhen (TEN-DEPARTMENT != Spaces)TEN-COMPANY → DPT-COMPANY, TEN-PROCESS-LEVEL → DPT-PROCESS-LEVEL, TEN-DEPARTMENT → DPT-DEPARTMENT
EmployeeEMPLOYEERequiredTEN-COMPANY → EMP-COMPANY, TEN-EMPLOYEE → EMP-EMPLOYEE
Employee GroupPERSGROUPRequiredTEN-COMPANY → PRG-COMPANY, TEN-EMPLOYEE-GROUP → PRG-GROUP-NAME
Hm Proc LevelPRSYSTEMRequiredWhen TEN-HM-PROC-LEVEL != SpacesTEN-COMPANY → PRS-COMPANY, TEN-HM-PROC-LEVEL → PRS-PROCESS-LEVEL
Job CodeJOBCODERequiredWhen (TEN-JOB-CODE != Spaces)TEN-COMPANY → JBC-COMPANY, TEN-JOB-CODE → JBC-JOB-CODE
PaemployeePAEMPLOYEERequiredTEN-COMPANY → PEM-COMPANY, TEN-EMPLOYEE → PEM-EMPLOYEE
PlanTAPLANRequiredTEN-COMPANY → TAP-COMPANY, TEN-PLAN → TAP-PLAN
Process LevelPRSYSTEMRequiredWhen (TEN-PROCESS-LEVEL != Spaces)TEN-COMPANY → PRS-COMPANY, TEN-PROCESS-LEVEL → PRS-PROCESS-LEVEL
Ta MasterTAEEMASTERRequiredWhen TAP-BALANCE-TYPE = 2TEN-COMPANY → TEM-COMPANY, TEN-EMPLOYEE → TEM-EMPLOYEE, TEN-PLAN → TEM-PLAN, TEN-EMPLOYEE-GROUP → TEM-EMPLOYEE-GROUP, TEN-POSITION → TEM-POSITION
Ta Mstr No PosTAEEMASTERRequiredWhen TAP-BALANCE-TYPE = 1TEN-COMPANY → TEM-COMPANY, TEN-EMPLOYEE → TEM-EMPLOYEE, TEN-PLAN → TEM-PLAN, TEN-EMPLOYEE-GROUP → TEM-EMPLOYEE-GROUP, Spaces → TEM-POSITION

One to many (6) — child tables

RelationTableRulesConditionField map
PositionPAPOSITIONValid When (TEN-POSITION != Spaces)TEN-COMPANY → POS-COMPANY, TEN-POSITION → POS-POSITION, → POS-EFFECT-DATE
Taemptr No PosTAEMPTRANSValid When TAP-BALANCE-TYPE = 1TEN-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 PosTAEMPTRANSValid When TAP-BALANCE-TYPE = 2TEN-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
TastructurTASTRUCTURTEN-COMPANY → TST-COMPANY, TEN-EMPLOYEE-GROUP → TST-EMPLOYEE-GROUP, TEN-PLAN → TST-PLAN, → TST-BEGIN-DATE
Tatrnsum NoposTATRANSUMTEN-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 PosTATRANSUMValid When TAP-BALANCE-TYPE = 2TEN-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

Programs

Updated by (94)

Referenced by (2)