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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#EMC-COMPANY PK
COMPANY		Numeric 4Contains the company number.TR12.1
#EMC-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number.TR12.1
#EMC-COURSE PK
COURSE		Alpha 10Contains the course code.TR12.1
#EMC-COST-TYPE PK
COST_TYPE		Alpha 10Contains 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 10Contains the general cost classification.TR12.1
#EMC-COST
COST		Signed 11.2Contains the amount of the cost.TR12.1
#EMC-DIST-COMPANY
DIST_COMPANY		Numeric 4Contains the distribution company to which a cost could be posted.TR12.1
#EMC-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15Contains the general ledger accounting unit to which the amount could be posted.TR12.1
#EMC-DST-ACCOUNT
DST_ACCOUNT		Numeric 6Contains the general ledger account to which the amount could be posted.TR12.1
#EMC-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4Contains the general ledger subaccount to which the amount could be posted.TR12.1
#EMC-COST-DESIGNATR
COST_DESIGNATR		Alpha 1Indicates whether the cost is actual or budgeted.
  • A Actual
  • B Budget
TR12.1
#EMC-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the cost is recorded.TR12.1
#EMC-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.TR12.1
#EMC-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the training system's base currency.TR12.1
#EMC-BASE-ND
BASE_ND		Numeric 1Indicates the number of decimal positions defined for the training system's base currency.TR12.1
#EMC-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the cost in the training system's base currency.TR12.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
EMCSET1
  1. COMPANY
  2. EMPLOYEE
  3. COURSE
  4. DATE
  5. COST-TYPE
  6. COST-CAT
PrimaryHR11.1, PA115, TR12.1, TR210
EMCSET2
  1. COURSE
  2. COMPANY
  3. EMPLOYEE
  4. COST-TYPE
  5. COST-CAT
  6. DATE
TR210

Relations

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

One to one (8) — lookups and parents

RelationTableRulesConditionField map
AccountsGLMASTERNot RequiredValid 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 CurrencyCUCODESRequiredWhen EMC-CURRENCY-CODE != Spaces
EMC-BASE-CURRENCY→CUC-CURRENCY-CODE
CategoryPCODESNot RequiredValid When EMC-COST-CAT != Spaces
"MC"→PCO-TYPE
EMC-COST-CAT→PCO-CODE
CompanyPRSYSTEMRequired
EMC-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen EMC-CURRENCY-CODE != Spaces
EMC-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequired
EMC-COMPANY→EMP-COMPANY
EMC-EMPLOYEE→EMP-EMPLOYEE
PaemployeePAEMPLOYEERequired
EMC-COMPANY→PEM-COMPANY
EMC-EMPLOYEE→PEM-EMPLOYEE
TypePCODESRequiredWhen EMC-COST-TYPE != Spaces
"MT"→PCO-TYPE
EMC-COST-TYPE→PCO-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
CoursePACOURSERequired
EMC-COURSE→CRS-COURSE
—→CRS-EFFECTIVE-DATE

Programs

Updated by (3)

Referenced by (1)