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

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 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
EARSET1
  1. COMPANY
  2. EMPLOYEE
  3. PAY-CODE
  4. POSITION
  5. JOB-CODE
  6. START-DATE
  7. EAR-SEQ-NBR
Primary—
EARSET2
  1. COMPANY
  2. EMPLOYEE
  3. PAY-CODE
  4. POSITION
  5. JOB-CODE
  6. START-DATE ↓
  7. EAR-SEQ-NBR ↓
BN150, BN66.1, PR521, EXI2.1, EXI4.1, LP130, PR128, PR131 +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)
EMPLOYEEJOBCODEPRPAYCODEC6EMPADDRT

One to one (3) — lookups and parents

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

Programs

Updated by (45)