INEMPLOYEE – No description in the Lawson data dictionary

System: C6 (C6)
Prefix: CEM
Primary key: COMPANY, EMPLOYEE
Fields: 25
Updated by: 36 programs
Referenced by: 10 programs

INEMPLOYEE is a Lawson C6 table (prefix CEM); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE (CEMSET1). It is related 1:1 to EMPLOYEE. It is updated by BN305, HR11.1, HR11.2, HR11.4, HR13.1, HR28.1, HR511, HR513 and 28 more and referenced by BN66.1, PR140, PR160, PR180, PR189, PR195, PR80.1, PR80.4 and 2 more. The table has 25 fields, 1 index and 1 documented relation.

About INEMPLOYEE

No description in the Lawson data dictionary.

Fields (25)

Column = COBOL field name without the CEM- 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
#`CEM-COMPANY` PK COMPANY	Numeric 4	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-EMPLOYEE` PK EMPLOYEE	Numeric 9	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-AADHAAR` AADHAAR	Numeric 10	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-REASON-CDE` REASON_CDE	Alpha 2	— `2` Left Service `3` Retired `5` Expired `8` Suspension of work `10` Retrenchment	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-PF-REG-NBR` PF_REG_NBR	Alpha 20	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-PF-ACCT-NBR` PF_ACCT_NBR	Numeric 7	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-ESIC-REGN-NBR` ESIC_REGN_NBR	Alpha 20	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-ESIC-IP` ESIC_IP	Numeric 10	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-ESIC-REASON` ESIC_REASON	Numeric 2	— `00` Without Reason `01` On Leave `04` Out of Coverage `06` Non Implemented Area `07` Compliance by immediate compny `09` Compliance by immediate compny `11` No Work `12` Doesn't belong to this employr	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +25 more
#`CEM-LWF-REGN-NBR` LWF_REGN_NBR	Alpha 18	—	—
#`CEM-NBR-STD-DEP` NBR_STD_DEP	Numeric 3	—	BN305, HR11.1, HR11.2, HR11.4, HR13.1, HR28.1, HR511, HR513 +27 more
#`CEM-NBR-HOS-DEP` NBR_HOS_DEP	Numeric 3	—	BN305, HR11.1, HR11.2, HR11.4, HR13.1, HR28.1, HR511, HR513 +27 more
#`CEM-FATHER-HUS-NME` FATHER_HUS_NME	Alpha 30	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-MEMBR-RELATION` MEMBR_RELATION	Alpha 1	— `F` Father `H` Husband	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-HOLD-RESUME` HOLD_RESUME	Numeric 1	— `1` Resume `2` Process & Hold `3` Do not process	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-GOVT-EMP` GOVT_EMP	Alpha 1	— `Y` Yes `N` No	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-PF-CONTRIB` PF_CONTRIB	Numeric 1	— `1` Qualifying Amount `2` Actual Earnings	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-DISABILITY-SEV` DISABILITY_SEV	Alpha 1	— `0` 0 to < 40% `1` 40% to < 80% `2` 80% + Above	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-DIRECTOR` DIRECTOR	Alpha 1	— `Y` Yes `N` No	—
#`CEM-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#`CEM-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more

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
`CEMSET1`	`COMPANY` `EMPLOYEE`	Primary		BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR13.1, HR28.1, HR511 +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)

One to one (1) — lookups and parents

Relation Table Rules Condition Field map

Employee

EMPLOYEE

Required

`CEM-COMPANY`	→	`EMP-COMPANY`
`CEM-EMPLOYEE`	→	`EMP-EMPLOYEE`

Programs

Updated by (36)

BN305 Highly Compensated Employees
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR13.1 Dependent
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR513 Dependent Conversion
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA218 Travel Listing
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR197 Payroll Close
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
ZH510 Update PCP from ZPENDPCP

Referenced by (10)

BN66.1 Estimated Pay Calculation
PR140 Earnings and Deductions Calculation
PR160 Payment Print
PR180 Manual Payment Print
PR189 Gross Up Calculation
PR195 Accrual Program
PR80.1 Manual Check
PR80.4 Manual Payment
PR89.1 Payment Modeling
PRAT.1 Alltax connection test

INEMPLOYEE – No description in the Lawson data dictionary

About INEMPLOYEE

Fields (25) Copy as SQL

Indexes (1)

Relations

One to one (1) — lookups and parents

Programs

Updated by (36)

Referenced by (10)

Fields (25)