PAEMPCOSTS

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
Element: Company		Numeric 4
Contains the company number.
TR12.1
EMC-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number.
TR12.1
EMC-COURSE
Element: Course Code		Alpha 10
Contains the course code.
TR12.1
EMC-COST-TYPE
Element: Cost Type		Alpha 10
Contains the specific cost classification.
TR12.1
EMC-DATE
Element: Date		Numeric 8 (yyyymmdd)
Contains the date of the cost.
TR12.1
EMC-COST-CAT
Element: Cost Category		Alpha 10
Contains the general cost classification.
TR12.1
EMC-COST
Element: Cost		Signed 11.2
Contains the amount of the cost.
TR12.1
EMC-DIST-COMPANY
Element: Distribution Company		Numeric 4
Contains the distribution company to which a cost could be posted.
TR12.1
EMC-DST-ACCT-UNIT
Distribution
Account Unit		Alpha 15
Contains the general ledger accounting unit to which the amount could be posted.
TR12.1
EMC-DST-ACCOUNT
Element: Distribution Account		Numeric 6
Contains the general ledger account to which the amount could be posted.
TR12.1
EMC-DST-SUB-ACCT
Distribution
Subaccount		Numeric 4
Contains the general ledger subaccount to which the amount could be posted.
TR12.1
EMC-COST-DESIGNATR
Element: Actual or Budget		Alpha 1
Indicates whether the cost is actual or budgeted. A = Actual B = Budget
TR12.1
EMC-CURRENCY-CODE
Element: Currency Code		Alpha 5
Contains the currency in which the cost is recorded.
TR12.1
EMC-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
TR12.1
EMC-BASE-CURRENCY
Element: Base Currency		Alpha 5
Contains the training system's base currency.
TR12.1
EMC-BASE-ND
Element: Base Nd		Numeric 1
Indicates the number of decimal positions defined for the training system's base currency.
TR12.1
EMC-BASE-AMOUNT
Element: Base Amt		Signed 15.2
Contains the cost in the training system's base currency.
TR12.1


PAEMPCOSTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
EMCSET1 COMPANY
EMPLOYEE
COURSE
DATE
COST-TYPE
COST-CAT
HR11.1 PA115
TR12.1 TR210
EMCSET2 COURSE
COMPANY
EMPLOYEE
COST-TYPE
COST-CAT
DATE
TR210


PAEMPCOSTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE Required
EMC-COURSE->CRS-COURSE
  CRS-EFFECTIVE-DATE

File created: Thu Jun 09 02:24:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.