COURSEBUDGET_PERIODDEMAND_IDTRN_SAL_COST_VW(SQL View) |
Index Back |
|---|---|
Salary Cost ViewSalary Cost View |
| SELECT COURSE, BUDGET_PERIOD, DEMAND_ID, SALARY_COST_BUDGET, CURRENCY_CD, COST_UNIT_CD, VARIABLE_COST FROM PS_TRN_DEMAND |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 2 | BUDGET_PERIOD |
Character(10) | VARCHAR2(10) NOT NULL | Budget Period |
| 3 | DEMAND_ID |
Character(10) | VARCHAR2(10) NOT NULL | Demand ID |
| 4 | SALARY_COST_BUDGET | Number(19,3) | DECIMAL(18,3) NOT NULL | Empl Training Budgeted Cost |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | COST_UNIT_CD | Character(10) | VARCHAR2(10) NOT NULL | Cost Unit |
| 7 | VARIABLE_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Variable Cost |