ZFNDATION – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
ZFN
Primary key
COMPANY, EMPLOYEE, CHOICE, EFFECT-DATE, SEQ-NBR
Fields
15
Updated by
2 programs
Referenced by
0 programs

ZFNDATION is a Lawson Payroll table (prefix ZFN); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, CHOICE, EFFECT-DATE, SEQ-NBR (ZFNSET1); alternate indexes: ZFNSET2. It is updated by ZP10.1 and ZP580. The table has 15 fields, 2 indexes and 0 documented relations.

About ZFNDATION

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the ZFN- 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
#ZFN-COMPANY PK
COMPANY		Numeric 4—ZP10.1
#ZFN-EMPLOYEE PK
EMPLOYEE		Numeric 9—ZP10.1
#ZFN-CHOICE PK
CHOICE		Numeric 1—ZP10.1
#ZFN-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)—ZP10.1, ZP580
#ZFN-SEQ-NBR PK
SEQ_NBR		Numeric 4—ZP10.1
#ZFN-END-DATE
END_DATE		Numeric 8 (yyyymmdd)—ZP10.1
#ZFN-AMOUNT
AMOUNT		Currency 15.2—ZP10.1
#ZFN-NBR-YEARS
NBR_YEARS		Numeric 1—ZP10.1
#ZFN-NBR-PAY-PERIOD
NBR_PAY_PERIOD		Numeric 2—ZP10.1
#ZFN-DONOR-WALL-FLG
DONOR_WALL_FLG		Alpha 1—ZP10.1
#ZFN-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1—ZP10.1, ZP580
#ZFN-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)—ZP10.1
#ZFN-USER-ID
USER_ID		Alpha 10 (Lower Case)—ZP10.1
#ZFN-ENTRY-SOURCE
ENTRY_SOURCE		Alpha 1—ZP10.1
#ZFN-INITIATIVE
INITIATIVE		Alpha 30 (Lower Case)—ZP10.1

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
ZFNSET1
  1. COMPANY
  2. EMPLOYEE
  3. CHOICE
  4. EFFECT-DATE
  5. SEQ-NBR
PrimaryZP10.1, ZP580
ZFNSET2
  1. COMPANY
  2. EMPLOYEE
  3. CHOICE
  4. EFFECT-DATE
  5. SEQ-NBR
SubsetWhere (ACTIVE-FLAG = "A")ZP580

Programs

Updated by (2)