CWDISTRIB – No description in the Lawson data dictionary

System
CW (CW)
Prefix
CWD
Primary key
COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, PAY-CODE, GL-EFFECT-DATE, GL-SEQ-NBR
Fields
23
Updated by
0 programs
Referenced by
0 programs

CWDISTRIB is a Lawson CW table (prefix CWD); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CONTRACT-YEAR, POSITION, CONT-SEQ-NBR, PAY-CODE, GL-EFFECT-DATE, GL-SEQ-NBR (CWDSET1); alternate indexes: CWDSET2 and CWDSET3. It is related 1:1 to ACACCTCAT, ACACTIVITY, PRSYSTEM, GLMASTER, EMPLOYEE and PAEMPLOYEE and 1:M to CWASSIGN, CWCONTRACT, PAEMPPOS and PRPAYCODE. The table has 23 fields, 3 indexes and 10 documented relations.

About CWDISTRIB

No description in the Lawson data dictionary.

Fields (23)

Column = COBOL field name without the CWD- 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
#CWD-COMPANY PK
COMPANY		Numeric 4——
#CWD-EMPLOYEE PK
EMPLOYEE		Numeric 9——
#CWD-CONTRACT-YEAR PK
CONTRACT_YEAR		Numeric 4——
#CWD-POSITION PK
POSITION		Alpha 12——
#CWD-CONT-SEQ-NBR PK
CONT_SEQ_NBR		Numeric 12——
#CWD-PAY-CODE PK
PAY_CODE		Alpha 4——
#CWD-GL-EFFECT-DATE PK
GL_EFFECT_DATE		Numeric 8 (yyyymmdd)——
#CWD-GL-SEQ-NBR PK
GL_SEQ_NBR		Numeric 4——
#CWD-PCD-SEQ-NBR
PCD_SEQ_NBR		Numeric 8——
#CWD-DIST-COMPANY
DIST_COMPANY		Numeric 4——
#CWD-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15——
#CWD-DST-ACCOUNT
DST_ACCOUNT		Numeric 6——
#CWD-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4——
#CWD-ACTIVITY
ACTIVITY		Alpha 15——
#CWD-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5——
#CWD-PERCENT
PERCENT		Signed 7.3——
#CWD-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)——
#CWD-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)——
#CWD-USER-ID
USER_ID		Alpha 10 (Lower Case)——
#CWD-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)——
#CWD-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)——
#CWD-CREATE-USER-ID
CREATE_USER_ID		Alpha 10 (Lower Case)——
#CWD-FTE
FTE		Signed 11.6——

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
CWDSET1
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR ↓
  4. POSITION
  5. CONT-SEQ-NBR ↓
  6. PAY-CODE
  7. GL-EFFECT-DATE ↓
  8. GL-SEQ-NBR ↓
PrimaryBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
CWDSET2
  1. COMPANY
  2. EMPLOYEE
  3. CONTRACT-YEAR
  4. POSITION
  5. CONT-SEQ-NBR
  6. PAY-CODE
  7. GL-EFFECT-DATE
  8. GL-SEQ-NBR
—
CWDSET3
  1. COMPANY
  2. CONTRACT-YEAR ↓
  3. EMPLOYEE
  4. POSITION
  5. CONT-SEQ-NBR ↓
  6. PAY-CODE
  7. GL-EFFECT-DATE ↓
  8. GL-SEQ-NBR ↓
—

Relations

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

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Acct CategoryACACCTCATRequiredWhen (CWD-ACCT-CATEGORY != Spaces)
CWD-ACCT-CATEGORY→AAX-ACCT-CATEGORY
ActivityACACTIVITYRequiredWhen (CWD-ACTIVITY != Spaces)
CWD-ACTIVITY→ACV-ACTIVITY
CompanyPRSYSTEMRequired
CWD-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Dist AccountGLMASTERRequired
CWD-COMPANY→GLM-COMPANY
CWD-DST-ACCT-UNIT→GLM-ACCT-UNIT
CWD-DST-ACCOUNT→GLM-ACCOUNT
CWD-DST-SUB-ACCT→GLM-SUB-ACCOUNT
EmployeeEMPLOYEERequired
CWD-COMPANY→EMP-COMPANY
CWD-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
CWD-COMPANY→PEM-COMPANY
CWD-EMPLOYEE→PEM-EMPLOYEE

One to many (4) — child tables

RelationTableRulesConditionField map
AssignmentCWASSIGN
CWD-COMPANY→CWA-COMPANY
CWD-CONTRACT-YEAR→CWA-CONTRACT-YEAR
CWD-EMPLOYEE→CWA-EMPLOYEE
CWD-POSITION→CWA-POSITION
—→CWA-ASG-EFFECT-DTE
—→CWA-PCD-SEQ-NBR
Emp ContractCWCONTRACT
CWD-COMPANY→CCT-COMPANY
CWD-EMPLOYEE→CCT-EMPLOYEE
CWD-CONTRACT-YEAR→CCT-CONTRACT-YEAR
CWD-POSITION→CCT-POSITION
—→CCT-CONT-SEQ-NBR
Emp PositionPAEMPPOS
CWD-COMPANY→PEP-COMPANY
CWD-EMPLOYEE→PEP-EMPLOYEE
CWD-POSITION→PEP-POSITION
—→PEP-EFFECT-DATE
—→PEP-POS-LEVEL
Pay CodePRPAYCODE
CWD-COMPANY→PCD-COMPANY
CWD-PAY-CODE→PCD-PAY-CODE
—→PCD-PROCESS-LEVEL
—→PCD-JOB-CODE

Programs

No Lawson programs are documented as updating or referencing this table.