BUDGET_PERIODPrompt Table: BUDGET_PERIOD
BUSINESS_UNITPrompt Table: BUDGET_BUS_UNIT
DEPTIDPrompt Table: DEPT_TBL
TRN_DEPT_SUMMRY(SQL Table) |
Index Back |
|---|---|
Summary Cost by Dept TableBudget Training record containing summary cost information by Department. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUDGET_PERIOD |
Character(10) | VARCHAR2(10) NOT NULL |
Budget Period
Prompt Table: BUDGET_PERIOD |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUDGET_BUS_UNIT |
| 3 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 4 | BUDGETED_DEMAND | Number(6,0) | INTEGER NOT NULL | Budgeted Demand |
| 5 | BUDGETED_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Budgeted Duration |
| 6 | BUDGETED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Budgeted Cost |
| 7 | LISTED_DEMAND | Number(6,0) | INTEGER NOT NULL | Projected Demand |
| 8 | LISTED_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Projected Duration |
| 9 | LISTED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Projected Cost |
| 10 | ACTUAL_DEMAND | Number(6,0) | INTEGER NOT NULL | Actual Demand |
| 11 | ACTUAL_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Actual Duration |
| 12 | ACTUAL_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Actual Cost |
| 13 | NBGT_LISTED_DEMAND | Number(6,0) | INTEGER NOT NULL | Unbudgeted Projected Demand |
| 14 | NBGT_LISTED_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Unbudgeted Projected Duration |
| 15 | NBGT_LISTED_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Unbudgeted Projected Cost |
| 16 | NBGT_ACTUAL_DEMAND | Number(6,0) | INTEGER NOT NULL | Unbudgeted Actual Demand |
| 17 | NBGT_ACTUAL_DURTN | Number(10,1) | DECIMAL(9,1) NOT NULL | Unbudgeted Actual Duration |
| 18 | NBGT_ACTUAL_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Unbudgeted Actual Cost |