Employee Costs
Contains employee cost and account reference information. TR12.1 (Employee
Costs) is the primary program that updates this file.
UPDATED BY
HR11.1 | PA115 | TR12.1 | TR210 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
EMC-COMPANY Element: Company | Numeric 4 Contains the company number. |
|
||
EMC-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. |
|
||
EMC-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||
EMC-COST-TYPE Element: Cost Type | Alpha 10 Contains the specific cost classification. |
|
||
EMC-DATE Element: Date | Numeric 8 (yyyymmdd) Contains the date of the cost. |
|
||
EMC-COST-CAT Element: Cost Category | Alpha 10 Contains the general cost classification. |
|
||
EMC-COST Element: Cost | Signed 11.2 Contains the amount of the cost. |
|
||
EMC-DIST-COMPANY Element: Distribution Company | Numeric 4 Contains the distribution company to which a cost could be posted. |
|
||
EMC-DST-ACCT-UNIT Distribution Account Unit | Alpha 15 Contains the general ledger accounting unit to which the amount could be posted. |
|
||
EMC-DST-ACCOUNT Element: Distribution Account | Numeric 6 Contains the general ledger account to which the amount could be posted. |
|
||
EMC-DST-SUB-ACCT Distribution Subaccount | Numeric 4 Contains the general ledger subaccount to which the amount could be posted. |
|
||
EMC-COST-DESIGNATR Element: Actual or Budget | Alpha 1 Indicates whether the cost is actual or budgeted. A = Actual B = Budget |
|
||
EMC-CURRENCY-CODE Element: Currency Code | Alpha 5 Contains the currency in which the cost is recorded. |
|
||
EMC-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
EMC-BASE-CURRENCY Element: Base Currency | Alpha 5 Contains the training system's base currency. |
|
||
EMC-BASE-ND Element: Base Nd | Numeric 1 Indicates the number of decimal positions defined for the training system's base currency. |
|
||
EMC-BASE-AMOUNT Element: Base Amt | Signed 15.2 Contains the cost in the training system's base currency. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EMCSET1 |
COMPANY EMPLOYEE COURSE DATE COST-TYPE COST-CAT |
|
| ||||||||||
EMCSET2 |
COURSE COMPANY EMPLOYEE COST-TYPE COST-CAT DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Accounts | GLMASTER |
Not Required
| ||||||||||||||||||||||||||||||
Base Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Category | PCODES |
Not Required
| ||||||||||||||||||||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||||||||||||||
Paemployee | PAEMPLOYEE |
Required
| ||||||||||||||||||||||||||||||
Type | PCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Course | PACOURSE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.