PAEMPCOSTS – Employee Costs

System: Personnel (PA)
Prefix: EMC
Primary key: COMPANY, EMPLOYEE, COURSE, DATE, COST-TYPE, COST-CAT
Fields: 17
Updated by: 3 programs
Referenced by: 1 program

PAEMPCOSTS is the Employee Costs table in Lawson Personnel (prefix EMC). It is indexed by COMPANY, EMPLOYEE, COURSE, DATE, COST-TYPE, COST-CAT (EMCSET1); alternate indexes: EMCSET2. It is related 1:1 to GLMASTER, CUCODES, PCODES, PRSYSTEM, EMPLOYEE and PAEMPLOYEE and 1:M to PACOURSE. It is updated by HR11.1, PA115 and TR12.1 and referenced by TR210. The table has 17 fields, 2 indexes and 9 documented relations.

About PAEMPCOSTS

Contains employee cost and account reference information. TR12.1 (Employee Costs) is the primary program that updates this file.

Fields (17)

Column = COBOL field name without the EMC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`EMC-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	TR12.1
`EMC-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	TR12.1
`EMC-COURSE` PK COURSE	Alpha 10	Contains the course code.	TR12.1
`EMC-COST-TYPE` PK COST_TYPE	Alpha 10	Contains the specific cost classification.	TR12.1
`EMC-DATE` PK DATE	Numeric 8 (yyyymmdd)	Contains the date of the cost.	TR12.1
`EMC-COST-CAT` PK COST_CAT	Alpha 10	Contains the general cost classification.	TR12.1
`EMC-COST` COST	Signed 11.2	Contains the amount of the cost.	TR12.1
`EMC-DIST-COMPANY` DIST_COMPANY	Numeric 4	Contains the distribution company to which a cost could be posted.	TR12.1
`EMC-DST-ACCT-UNIT` DST_ACCT_UNIT	Alpha 15	Contains the general ledger accounting unit to which the amount could be posted.	TR12.1
`EMC-DST-ACCOUNT` DST_ACCOUNT	Numeric 6	Contains the general ledger account to which the amount could be posted.	TR12.1
`EMC-DST-SUB-ACCT` DST_SUB_ACCT	Numeric 4	Contains the general ledger subaccount to which the amount could be posted.	TR12.1
`EMC-COST-DESIGNATR` COST_DESIGNATR	Alpha 1	Indicates whether the cost is actual or budgeted. `A` Actual `B` Budget	TR12.1
`EMC-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency in which the cost is recorded.	TR12.1
`EMC-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	TR12.1
`EMC-BASE-CURRENCY` BASE_CURRENCY	Alpha 5	Contains the training system's base currency.	TR12.1
`EMC-BASE-ND` BASE_ND	Numeric 1	Indicates the number of decimal positions defined for the training system's base currency.	TR12.1
`EMC-BASE-AMOUNT` BASE_AMOUNT	Signed 15.2	Contains the cost in the training system's base currency.	TR12.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`EMCSET1`	`COMPANY`, `EMPLOYEE`, `COURSE`, `DATE`, `COST-TYPE`, `COST-CAT`	Primary		HR11.1, PA115, TR12.1, TR210
`EMCSET2`	`COURSE`, `COMPANY`, `EMPLOYEE`, `COST-TYPE`, `COST-CAT`, `DATE`			TR210

Relations

One to one (8) — lookups and parents

Relation	Table	Rules	Condition	Field map
Accounts	GLMASTER	Not Required	Valid When (EMC-DIST-COMPANY != Zeroes) And (EMC-DST-ACCT-UNIT != Spaces) And (EMC-DST-ACCOUNT != Zeroes)	`EMC-DIST-COMPANY` → `GLM-COMPANY`, `EMC-DST-ACCT-UNIT` → `GLM-ACCT-UNIT`, `EMC-DST-ACCOUNT` → `GLM-ACCOUNT`, `EMC-DST-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Base Currency	CUCODES	Required	When EMC-CURRENCY-CODE != Spaces	`EMC-BASE-CURRENCY` → `CUC-CURRENCY-CODE`
Category	PCODES	Not Required	Valid When EMC-COST-CAT != Spaces	`"MC"` → `PCO-TYPE`, `EMC-COST-CAT` → `PCO-CODE`
Company	PRSYSTEM	Required		`EMC-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Currency	CUCODES	Required	When EMC-CURRENCY-CODE != Spaces	`EMC-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Employee	EMPLOYEE	Required		`EMC-COMPANY` → `EMP-COMPANY`, `EMC-EMPLOYEE` → `EMP-EMPLOYEE`
Paemployee	PAEMPLOYEE	Required		`EMC-COMPANY` → `PEM-COMPANY`, `EMC-EMPLOYEE` → `PEM-EMPLOYEE`
Type	PCODES	Required	When EMC-COST-TYPE != Spaces	`"MT"` → `PCO-TYPE`, `EMC-COST-TYPE` → `PCO-CODE`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Course	PACOURSE	Required		`EMC-COURSE` → `CRS-COURSE`, → `CRS-EFFECTIVE-DATE`

PAEMPCOSTS – Employee Costs

About PAEMPCOSTS

Fields (17)

Indexes (2)

Relations

One to one (8) — lookups and parents

One to many (1) — child tables

Programs

Updated by (3)

Referenced by (1)