COURSEEFFDTCOST_SOURCEF=Facility Cost
I=Instructor Cost
N=Session
P=Vendor Cost
Q=Equipment Cost
S=Salary Cost
T=Total Cost
X=Expense Cost
Prompt Table: CURRENCY_CD_TBL
TRN_CST_ELEMENT(SQL Table) |
Index Back |
|---|---|
Training Course Cost ElementAdminister Training/Budget Training record containing course cost information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | COST_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Cost Source
F=Facility Cost I=Instructor Cost N=Session P=Vendor Cost Q=Equipment Cost S=Salary Cost T=Total Cost X=Expense Cost |
| 4 | VARIABLE_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Variable Cost |
| 5 | FIXED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Fixed Cost |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |