CRSE_SESSN_COST(SQL Table) |
Index Back |
|---|---|
Training Course ExpensesCRSE_SESSN_COST is one of a group of records used to record data about specific sessions of a training course for the Training Administration application. Use CRSE_SESSN_COST to record expenses associated with a specific course session. For example, you could track expenses such as student transportation to the course, student meals, student hotel costs, the cost of books and materials, and the cost of renting a training facility. You can create multiple CRSE_SESSN_COST records per course session, each with a unique expense code. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL |
Course Session Nbr
Default Value: 0 Prompt Table: CRSE_SESSN_TBL |
| 3 | EXPENSE_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Expense Type
Prompt Table: TRN_TUIT_EXP_VW |
| 4 | PER_UNIT_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Per Unit Cost |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 6 | COST_UNIT_CD | Character(10) | VARCHAR2(10) NOT NULL |
Cost Unit
Default Value: H Prompt Table: XP_COST_UNIT_VW |
| 7 | QUANTITY | Number(3,0) | SMALLINT NOT NULL |
Quantity
Default Value: 1 |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 9 | FINANCED_COST_FRA | Number(19,3) | DECIMAL(18,3) NOT NULL | Financed Cost |
| 10 | FINANCING_DEPT_FRA | Character(10) | VARCHAR2(10) NOT NULL |
Financing Department
Prompt Table: DEPT_TBL |
| 11 | FINANCING_FUND_FRA | Character(6) | VARCHAR2(6) NOT NULL |
Financing Fund
Prompt Table: TRN_VENDOR_TBL |
| 12 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_HR |