ZHLINRATES – No description in the Lawson data dictionary
- System
- Human Resources (HR)
- Prefix
ZHL- Primary key
COMPANY,PLAN-CODE,COV-OPTION,EMP-STATUS- Fields
- 7
- Updated by
- 1 program
- Referenced by
- 0 programs
ZHLINRATES is a Lawson Human Resources table (prefix ZHL); no description in the lawson data dictionary. It is indexed by COMPANY, PLAN-CODE, COV-OPTION, EMP-STATUS (ZHLSET1). It is updated by ZH602. The table has 7 fields, 1 index and 0 documented relations.
About ZHLINRATES
No description in the Lawson data dictionary.
Fields (7)
Column = COBOL field name without the ZHL- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#ZHL-COMPANY PKCOMPANY | Numeric 4 | — | ZH602 |
#ZHL-PLAN-CODE PKPLAN_CODE | Alpha 4 | — | ZH602 |
#ZHL-COV-OPTION PKCOV_OPTION | Numeric 2 | — | ZH602 |
#ZHL-EMP-STATUS PKEMP_STATUS | Alpha 2 | — | ZH602 |
#ZHL-POS-STATUSPOS_STATUS | Alpha 10 | — | ZH602 |
#ZHL-EMP-CONTEMP_CONT | Signed 7.2 | — | ZH602 |
#ZHL-EMR-CONTEMR_CONT | Signed 7.2 | — | ZH602 |
Indexes (1)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ZHLSET1 |
| Primary | ZH602 |
Programs
Updated by (1)
- ZH602 ACA files to Vendor HealthFx