PASCOST

Session Costs

Contains cost and account reference information for each session. TR11.1 (Session Costs) is the primary program that updates this file.
UPDATED BY
TR04.1 TR11.1 TR210

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
COS-COURSE
Element: Course Code
Alpha 10
Contains the course code.
TR11.1
COS-SESSION
Element: Session
Numeric 5
Contains the session number.
TR11.1
COS-START-DATE
Element: Session Start Date
Numeric 8 (yyyymmdd)
Contains the session start date.
TR11.1
COS-COST-TYPE
Element: Cost Type
Alpha 10
Contains the cost type, which is the specific cost classification.
TR11.1
COS-COST-CAT
Element: Cost Category
Alpha 10
Contains the cost category, which is the general cost classification.
TR11.1
COS-COST
Element: Cost
Signed 11.2
Contains the amount of the cost.
TR11.1
COS-DIST-COMPANY
Element: Distribution Company
Numeric 4
Contains the company number to which a transaction could be posted.
TR11.1
COS-DST-ACCT-UNIT
Distribution
Account Unit
Alpha 15
Contains the general ledger accounting unit to which the amount could be posted.
TR11.1
COS-DST-ACCOUNT
Element: Distribution Account
Numeric 6
Contains the general ledger account to which the amount could be posted.
TR11.1
COS-DST-SUB-ACCT
Distribution
Subaccount
Numeric 4
Contains the general ledger subaccount to which the amount could be posted.
TR11.1
COS-COST-DESIGNATR
Element: Actual or Budget
Alpha 1
Indicates whether the cost is actual or budget. A = Actual B = Budget
TR11.1
COS-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which session costs are recorded.
TR11.1
COS-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
TR11.1
COS-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains the base currency for the training system.
TR11.1
COS-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the training system base currency.
TR11.1
COS-BASE-AMOUNT
Element: Base Amt
Signed 15.2
Contains the session costs in the training system's base currency.
TR11.1


PASCOST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
COSSET1 COURSE
SESSION
START-DATE
COST-TYPE
COST-CAT
TR04.1 TR11.1
TR210


PASCOST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accounts GLMASTER Required
When (COS-DIST-COMPANY !=Zeroes )
And(COS-DST-ACCT-UNIT !=Spaces )
And(COS-DST-ACCOUNT !=Zeroes )
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 Required
When COS-COST-CAT !=Spaces
"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
When COS-COST-TYPE !=Spaces
"MT"->PCO-TYPE
COS-COST-TYPE->PCO-CODE


PASCOST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Course PACOURSE Required
COS-COURSE->CRS-COURSE
  CRS-EFFECTIVE-DATE


File created: Wed Jun 08 20:50:26 2016

Home
Contact Us



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