PASCOST – Session Costs

System
Personnel (PA)
Prefix
COS
Primary key
COURSE, SESSION, START-DATE, COST-TYPE, COST-CAT
Fields
16
Updated by
2 programs
Referenced by
1 program

PASCOST is the Session Costs table in Lawson Personnel (prefix COS). It is indexed by COURSE, SESSION, START-DATE, COST-TYPE, COST-CAT (COSSET1). It is related 1:1 to GLMASTER, CUCODES, PCODES and PASESSION and 1:M to PACOURSE. It is updated by TR04.1 and TR11.1 and referenced by TR210. The table has 16 fields, 1 index and 7 documented relations.

About PASCOST

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

Fields (16)

Column = COBOL field name without the COS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#COS-COURSE PK
COURSE		Alpha 10Contains the course code.TR11.1
#COS-SESSION PK
SESSION		Numeric 5Contains the session number.TR11.1
#COS-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the session start date.TR11.1
#COS-COST-TYPE PK
COST_TYPE		Alpha 10Contains the cost type, which is the specific cost classification.TR11.1
#COS-COST-CAT PK
COST_CAT		Alpha 10Contains the cost category, which is the general cost classification.TR11.1
#COS-COST
COST		Signed 11.2Contains the amount of the cost.TR11.1
#COS-DIST-COMPANY
DIST_COMPANY		Numeric 4Contains the company number to which a transaction could be posted.TR11.1
#COS-DST-ACCT-UNIT
DST_ACCT_UNIT		Alpha 15Contains the general ledger accounting unit to which the amount could be posted.TR11.1
#COS-DST-ACCOUNT
DST_ACCOUNT		Numeric 6Contains the general ledger account to which the amount could be posted.TR11.1
#COS-DST-SUB-ACCT
DST_SUB_ACCT		Numeric 4Contains the general ledger subaccount to which the amount could be posted.TR11.1
#COS-COST-DESIGNATR
COST_DESIGNATR		Alpha 1Indicates whether the cost is actual or budget.
  • A Actual
  • B Budget
TR11.1
#COS-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which session costs are recorded.TR11.1
#COS-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.TR11.1
#COS-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the base currency for the training system.TR11.1
#COS-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the training system base currency.TR11.1
#COS-BASE-AMOUNT
BASE_AMOUNT		Signed 15.2Contains the session costs in the training system's base currency.TR11.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
COSSET1
  1. COURSE
  2. SESSION
  3. START-DATE
  4. COST-TYPE
  5. COST-CAT
PrimaryTR04.1, TR11.1, TR210

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERCUCODESPCODESPASESSIONPACOURSEPASCOST

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccountsGLMASTERRequiredWhen (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 CurrencyCUCODESRequiredWhen COS-CURRENCY-CODE != Spaces
COS-BASE-CURRENCY→CUC-CURRENCY-CODE
CategoryPCODESRequiredWhen COS-COST-CAT != Spaces
"MC"→PCO-TYPE
COS-COST-CAT→PCO-CODE
CurrencyCUCODESRequiredWhen COS-CURRENCY-CODE != Spaces
COS-CURRENCY-CODE→CUC-CURRENCY-CODE
SessionPASESSIONRequired
COS-COURSE→SES-COURSE
COS-SESSION→SES-SESSION
COS-START-DATE→SES-START-DATE
TypePCODESRequiredWhen COS-COST-TYPE != Spaces
"MT"→PCO-TYPE
COS-COST-TYPE→PCO-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
CoursePACOURSERequired
COS-COURSE→CRS-COURSE
—→CRS-EFFECTIVE-DATE

Programs

Updated by (2)

Referenced by (1)