Employee Costs
Contains employee cost and account reference information. TR12.1 (Employee
Costs) is the primary program that updates this file.
UPDATED BY
| TR12.1 | HR11.1 | PA115 | 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.