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 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
EMC-COMPANY Numeric 4 TR12.1
Element: Company Contains the company number.
EMC-EMPLOYEE Numeric 9 TR12.1
Element: Employee Contains the employee number.
EMC-COURSE Alpha 10 TR12.1
Element: Course Code Contains the course code.
EMC-COST-TYPE Alpha 10 TR12.1
Element: Cost Type Contains the specific cost
classification.
EMC-DATE Numeric 8 (yyyymmdd) TR12.1
Element: Date Contains the date of the cost.
EMC-COST-CAT Alpha 10 TR12.1
Element: Cost Category Contains the general cost
classification.
EMC-COST Signed 11.2 TR12.1
Element: Cost Contains the amount of the cost.
EMC-DIST-COMPANY Numeric 4 TR12.1
Element: Distribution CContains 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
Element: Distribution AContains 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
Element: Actual or BudgIndicates whether the cost is actual or
budgeted.
A = Actual
B = Budget
EMC-CURRENCY-CODE Alpha 5 TR12.1
Element: Currency Code Contains the currency in which the cost
is recorded.
EMC-CURR-ND Numeric 1 TR12.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
EMC-BASE-CURRENCY Alpha 5 TR12.1
Element: Base Currency Contains the training system's base
currency.
EMC-BASE-ND Numeric 1 TR12.1
Element: Base Nd Indicates the number of decimal
positions defined for the training
system's base currency.
EMC-BASE-AMOUNT Signed 15.2 TR12.1
Element: Base Amt Contains the cost in the training
system's base currency.
PAEMPCOSTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMCSET1 COMPANY HR11.1 PA115
EMPLOYEE TR12.1 TR210
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
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
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
|
