PACOST FILE
Course Cost
Contains cost and account reference information for each course.
TR10.1 (Course Costs) is the primary program that updates this file.
REFERENCED BY
TR201 TR210
UPDATED BY
TR01.1 TR10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CST-COURSE Alpha 10 TR10.1
Element: Course Code Contains the course code.
CST-COST-TYPE Alpha 10 TR10.1
Element: Cost Type Contains the specific cost
classification.
CST-COST-CAT Alpha 10 TR10.1
Element: Cost Category Contains the general cost
classification.
CST-EFFECTIVE-DATE Numeric 8 (yyyymmdd) TR10.1
Element: Start Date Contains the date the cost becomes
effective. The course start date
defaults.
CST-END-DATE Numeric 8 (yyyymmdd) TR10.1
Element: End Date Contains the date the cost ends.
CST-COST Signed 11.2 TR10.1
Element: Cost Contains the amount of the cost.
CST-DIST-COMPANY Numeric 4 TR10.1
Element: Distribution CContains the distribution company for
the cost.
CST-DST-ACCT-UNIT Alpha 15 TR10.1
Distribution Contains the general ledger accounting
Account Unit unit to which the amount could be
posted.
CST-DST-ACCOUNT Numeric 6 TR10.1
Element: Distribution AContains the general ledger account to
which the amount could be posted.
CST-DST-SUB-ACCT Numeric 4 TR10.1
Distribution Contains the general ledger subaccount
Subaccount to which the amount could be posted.
CST-COST-DESIGNATR Alpha 1 TR10.1
Element: Actual or BudgIndicates whether the cost is actual or
budgeted.
A = Actual
B = Budget
CST-CURRENCY-CODE Alpha 5 TR10.1
Element: Currency Code Contains the currency in which the cost
is recorded.
CST-CURR-ND Numeric 1 TR10.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
CST-BASE-CURRENCY Alpha 5 TR10.1
Element: Base Currency Contains the training system's base
currency.
CST-BASE-ND Numeric 1 TR10.1
Element: Base Nd The number of decimal positions defined
for the training system's base currency.
CST-BASE-AMOUNT Signed 15.2 TR10.1
Element: Base Amt Contains the cost in the training
system's base currency.
PACOST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSTSET1 COURSE TR01.1 TR10.1
COST-TYPE TR201 TR210
COST-CAT
EFFECTIVE-DATE
PACOST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accounts GLMASTER Required
When (CST-DIST-COMPANY != Zeroes )
And (CST-DST-ACCT-UNIT != Spaces )
And (CST-DST-ACCOUNT != Zeroes )
CST-DIST-COMPANY -> GLM-COMPANY
CST-DST-ACCT-UNIT -> GLM-ACCT-UNIT
CST-DST-ACCOUNT -> GLM-ACCOUNT
CST-DST-SUB-ACCT -> GLM-SUB-ACCOUNT
Base Currency CUCODES Required
When CST-CURRENCY-CODE != Spaces
CST-BASE-CURRENCY -> CUC-CURRENCY-CODE
Category PCODES Required
When CST-COST-CAT != Spaces
"MC" -> PCO-TYPE
CST-COST-CAT -> PCO-CODE
Currency CUCODES Required
When CST-CURRENCY-CODE != Spaces
CST-CURRENCY-CODE -> CUC-CURRENCY-CODE
Type PCODES Required
When CST-COST-TYPE != Spaces
"MT" -> PCO-TYPE
CST-COST-TYPE -> PCO-CODE
PACOST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE Required
CST-COURSE -> CRS-COURSE
CRS-EFFECTIVE-DATE
|
