PAEMPCOSTS FILE
Employee Costs
Contains employee cost and account reference information. TR12.1 (Employee
Costs) is the primary program that updates this file.
REFERENCED BY
TR210
UPDATED BY
TR12.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMC-COMPANY Numeric 4 TR12.1
Company Contains the company number.
EMC-EMPLOYEE Numeric 9 TR12.1
Employee Contains the employee number.
EMC-COURSE Alpha 10 TR12.1
Course Code Contains the course code.
EMC-COST-TYPE Alpha 10 TR12.1
Cost Type Contains the specific cost
classification.
EMC-DATE Numeric 8 (yyyymmdd) TR12.1
Date Contains the date of the cost.
EMC-COST-CAT Alpha 10 TR12.1
Cost Category Contains the general cost
classification.
EMC-COST Signed 11.2 TR12.1
Cost Contains the amount of the cost.
EMC-DIST-COMPANY Numeric 4 TR12.1
Distribution Company Contains the distribution company to
which a cost could be posted.
EMC-DST-ACCT-UNIT Alpha 15 TR12.1
Distribution Contains the general ledger accounting
Account Unit unit to which the amount could be
posted.
EMC-DST-ACCOUNT Numeric 6 TR12.1
Distribution Account Contains the general ledger account to
which the amount could be posted.
EMC-DST-SUB-ACCT Numeric 4 TR12.1
Distribution Contains the general ledger subaccount
Subaccount to which the amount could be posted.
EMC-COST-DESIGNATR Alpha 1 TR12.1
Actual or Budget Indicates whether the cost is actual or
budgeted.
A = Actual
B = Budget
EMC-CURRENCY-CODE Alpha 5 TR12.1
Currency Code Contains the currency in which the cost
is recorded.
EMC-CURR-ND Numeric 1 TR12.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
EMC-BASE-CURRENCY Alpha 5 TR12.1
Base Currency Contains the training system's base
currency.
EMC-BASE-ND Numeric 1 TR12.1
Base Number Of Indicates the number of decimal
Decimals positions defined for the training
system's base currency.
EMC-BASE-AMOUNT Signed 15.2 TR12.1
Base Amount Contains the cost in the training
system's base currency.
PAEMPCOSTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMCSET1 COMPANY TR12.1 TR210
EMPLOYEE
COURSE
DATE
COST-TYPE
COST-CAT
EMCSET2 COURSE TR210
COMPANY
EMPLOYEE
COST-TYPE
COST-CAT
DATE
PAEMPCOSTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accounts GLMASTER Not Required
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
"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
Type PCODES Required
"MT" -> PCO-TYPE
EMC-COST-TYPE -> PCO-CODE
PAEMPCOSTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE Required
EMC-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
|
