C6EMPADDRT – No description in the Lawson data dictionary

System
C6 (C6)
Prefix
EAR
Primary key
COMPANY, EMPLOYEE, PAY-CODE, POSITION, JOB-CODE, START-DATE, EAR-SEQ-NBR
Fields
17
Updated by
45 programs
Referenced by
0 programs

C6EMPADDRT is a Lawson C6 table (prefix EAR); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PAY-CODE, POSITION, JOB-CODE, START-DATE, EAR-SEQ-NBR (EARSET1); alternate indexes: EARSET2. It is related 1:1 to EMPLOYEE, JOBCODE and PRPAYCODE. It is updated by BN150, BN66.1, EXI2.1, EXI4.1, LP130, PR128, PR131, PR132 and 37 more. The table has 17 fields, 2 indexes and 3 documented relations.

About C6EMPADDRT

No description in the Lawson data dictionary.

Fields (17)

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

Field / columnTypeDescription & valuesUpdated by
EAR-COMPANY PK
COMPANY		Numeric 4——
EAR-EMPLOYEE PK
EMPLOYEE		Numeric 9——
EAR-PAY-CODE PK
PAY_CODE		Alpha 4——
EAR-EAR-SEQ-NBR PK
EAR_SEQ_NBR		Numeric 10——
EAR-RATE
RATE		Signed 13.4——
EAR-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)——
EAR-END-DATE
END_DATE		Numeric 8 (yyyymmdd)——
EAR-JOB-CODE PK
JOB_CODE		Alpha 9——
EAR-POSITION PK
POSITION		Alpha 12——
EAR-NOTIONAL
NOTIONAL		Signed 13.4——
EAR-SALARY-CLASS
SALARY_CLASS		Alpha 1——
EAR-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
EAR-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
EAR-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
EAR-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
EAR-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
EAR-USER-ID
USER_ID		Alpha 10 (Lower Case)——

Indexes (2)

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

IndexKeysFlagsConditionUsed in
EARSET1COMPANY, EMPLOYEE, PAY-CODE, POSITION, JOB-CODE, START-DATE, EAR-SEQ-NBRPrimary—
EARSET2COMPANY, EMPLOYEE, PAY-CODE, POSITION, JOB-CODE, START-DATE*, EAR-SEQ-NBR*BN150, BN66.1, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEENot RequiredEAR-COMPANY → EMP-COMPANY, EAR-EMPLOYEE → EMP-EMPLOYEE
JobcodeJOBCODENot RequiredValid When EAR-JOB-CODE != SpacesEAR-COMPANY → JBC-COMPANY, EAR-JOB-CODE → JBC-JOB-CODE
PrpaycodePRPAYCODENot RequiredEAR-COMPANY → PCD-COMPANY, Spaces → PCD-PROCESS-LEVEL, Spaces → PCD-JOB-CODE, EAR-PAY-CODE → PCD-PAY-CODE

Programs

Updated by (45)