BUDGET_PERIODPrompt Table: BUDGET_PERIOD
BUSINESS_UNITPrompt Table: BUDGET_BUS_UNIT
DEPTIDPrompt Table: DEPT_TBL
SCENARIODEMAND_NEW_IDTRN_SIMUL_VW(SQL View) |
Index Back |
|---|---|
Training Simulation ViewTraining Simulation View |
| SELECT A.BUDGET_PERIOD , A.BUSINESS_UNIT , A.DEPTID , A.SCENARIO , A.DEMAND_ID , A.DEMAND_APPROVED , %subrec(DMND_APVD_FRA,A) FROM PS_TRN_SIMULATION A |
| # | 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 | SCENARIO |
Character(10) | VARCHAR2(10) NOT NULL | Scenario |
| 5 | DEMAND_NEW_ID |
Character(10) | VARCHAR2(10) NOT NULL | Demand ID |
| 6 | DEMAND_APPROVED | Number(6,0) | INTEGER NOT NULL | Employees Approved |
| 7 | DMND_F_APVD_FRA | Number(6,0) | INTEGER NOT NULL | Approved Department Demand Female Number for France. |
| 8 | DMND_M_APVD_FRA | Number(6,0) | INTEGER NOT NULL | Approved Department Demand Male Number for France. |
| 9 | DMND_ONQ_APVD_FRA | Number(6,0) | INTEGER NOT NULL | Approved Department Demand Non Qualified Worker Number for France. |
| 10 | DMND_OQ_APVD_FRA | Number(6,0) | INTEGER NOT NULL | Approved Department Demand Qualified Worker Number for France. |
| 11 | DMND_E_APVD_FRA | Number(6,0) | INTEGER NOT NULL | Approved Department Demand Office Worker Number for France. |
| 12 | DMND_AM_APVD_FRA | Number(6,0) | INTEGER NOT NULL | Approved Department Demand Manager Number for France. |
| 13 | DMND_IC_APVD_FRA | Number(6,0) | INTEGER NOT NULL | Approved Department Demand Executive Number for France. |