|
|
PASCOST FILE
Session Costs
Contains cost and account reference information for each session.
TR11.1 (Session Costs) is the primary program that updates this file.
REFERENCED BY
TR210
UPDATED BY
HR700 TR04.1 TR11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COS-COURSE Alpha 10 TR11.1
Course Code Contains the course code.
COS-SESSION Numeric 5 TR11.1
Session Contains the session number.
COS-START-DATE Numeric 8 (yyyymmdd) TR11.1
Session Start Date Contains the session start date.
COS-COST-TYPE Alpha 10 TR11.1
Cost Type Contains the cost type, which is the
specific cost classification.
COS-COST-CAT Alpha 10 TR11.1
Cost Category Contains the cost category, which is
the general cost classification.
COS-COST Signed 11.2 TR11.1
Cost Contains the amount of the cost.
COS-DIST-COMPANY Numeric 4 TR11.1
Distribution Company Contains the company number to which a
transaction could be posted.
COS-DST-ACCT-UNIT Alpha 15 TR11.1
Distribution Contains the general ledger accounting
Account Unit unit to which the amount could be
posted.
COS-DST-ACCOUNT Numeric 6 TR11.1
Distribution Account Contains the general ledger account to
which the amount could be posted.
COS-DST-SUB-ACCT Numeric 4 TR11.1
Distribution Contains the general ledger subaccount
Subaccount to which the amount could be posted.
COS-COST-DESIGNATR Alpha 1 TR11.1
Actual or Budget Indicates whether the cost is actual or
budget.
A = Actual
B = Budget
COS-CURRENCY-CODE Alpha 5 HR700 TR11.1
Currency Code Contains the currency in which session
costs are recorded.
COS-CURR-ND Numeric 1 HR700 TR11.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
COS-BASE-CURRENCY Alpha 5 HR700 TR11.1
Base Currency Contains the base currency for the
training system.
COS-BASE-ND Numeric 1 HR700 TR11.1
Base Number Of The number of decimal positions defined
Decimals for the training system base currency.
COS-BASE-AMOUNT Signed 15.2 TR11.1
Base Amount Contains the session costs in the
training system's base currency.
PASCOST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COSSET1 COURSE HR700 TR04.1
SESSION TR11.1 TR210
START-DATE
COST-TYPE
COST-CAT
PASCOST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accounts GLMASTER Not Required
COS-DIST-COMPANY -> GLM-COMPANY
COS-DST-ACCT-UNIT -> GLM-ACCT-UNIT
COS-DST-ACCOUNT -> GLM-ACCOUNT
COS-DST-SUB-ACCT -> GLM-SUB-ACCOUNT
Base Currency CUCODES Required
When COS-CURRENCY-CODE != Spaces
COS-BASE-CURRENCY -> CUC-CURRENCY-CODE
Category PCODES Not Required
"MC" -> PCO-TYPE
COS-COST-CAT -> PCO-CODE
Currency CUCODES Required
When COS-CURRENCY-CODE != Spaces
COS-CURRENCY-CODE -> CUC-CURRENCY-CODE
Session PASESSION Required
COS-COURSE -> SES-COURSE
COS-SESSION -> SES-SESSION
COS-START-DATE -> SES-START-DATE
Type PCODES Required
"MT" -> PCO-TYPE
COS-COST-TYPE -> PCO-CODE
PASCOST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE Required
COS-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
|