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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET3
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TENSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. JOB-CODE
  7. PROCESS-LEVEL
  8. DEPARTMENT
PrimaryBN150, BN305, HR00.1, HR01.1, HR02.1, HR06.1, HR11.1, HR11.2 +22 more (list truncated in source)
TENSET2
  1. COMPANY
  2. EMPLOYEE
  3. EMPLOYEE-GROUP
  4. PLAN
  5. POSITION
  6. JOB-CODE
  7. PROCESS-LEVEL
  8. DEPARTMENT
HR11.1, HR511, LT101, LT111, LP100, LP101, LP180, LP32.1 +5 more
TENSET3
  1. COMPANY
  2. HM-PROC-LEVEL
  3. EMPLOYEE
  4. PLAN
  5. EMPLOYEE-GROUP
  6. POSITION
  7. JOB-CODE
  8. PROCESS-LEVEL
  9. DEPARTMENT
KeyChangeBN150, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMDEPTCODEEMPLOYEEPERSGROUPJOBCODEPAEMPLOYEETAPLANTAEEMASTERPAPOSITIONTAEMPTRANSTASTRUCTURTATRANSUMTAENROLL

One to one (11) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TEN-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
EmployeeEMPLOYEERequired
TEN-COMPANY→EMP-COMPANY
TEN-EMPLOYEE→EMP-EMPLOYEE
Employee GroupPERSGROUPRequired
TEN-COMPANY→PRG-COMPANY
TEN-EMPLOYEE-GROUP→PRG-GROUP-NAME
Hm Proc LevelPRSYSTEMRequiredWhen TEN-HM-PROC-LEVEL != Spaces
TEN-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
PaemployeePAEMPLOYEERequired
TEN-COMPANY→PEM-COMPANY
TEN-EMPLOYEE→PEM-EMPLOYEE
PlanTAPLANRequired
TEN-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 = 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 PosTAEEMASTERRequiredWhen 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

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 = 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 PosTAEMPTRANSValid 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
TastructurTASTRUCTUR
TEN-COMPANY→TST-COMPANY
TEN-EMPLOYEE-GROUP→TST-EMPLOYEE-GROUP
TEN-PLAN→TST-PLAN
—→TST-BEGIN-DATE
Tatrnsum NoposTATRANSUM
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 PosTATRANSUMValid 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

Programs

Updated by (94)

Referenced by (2)