TMP_SIMULATION

(SQL Table)
Index Back

Temp Training Simulation Table

Budget Training table used in HR_TRNCPYSC Application Engine process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
5 SCENARIO Character(10) VARCHAR2(10) NOT NULL Scenario
6 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID
7 DEMAND_APPROVED Number(6,0) INTEGER NOT NULL Employees Approved
8 DMND_F_APVD_FRA Number(6,0) INTEGER NOT NULL Approved Department Demand Female Number for France.
9 DMND_M_APVD_FRA Number(6,0) INTEGER NOT NULL Approved Department Demand Male Number for France.
10 DMND_ONQ_APVD_FRA Number(6,0) INTEGER NOT NULL Approved Department Demand Non Qualified Worker Number for France.
11 DMND_OQ_APVD_FRA Number(6,0) INTEGER NOT NULL Approved Department Demand Qualified Worker Number for France.
12 DMND_E_APVD_FRA Number(6,0) INTEGER NOT NULL Approved Department Demand Office Worker Number for France.
13 DMND_AM_APVD_FRA Number(6,0) INTEGER NOT NULL Approved Department Demand Manager Number for France.
14 DMND_IC_APVD_FRA Number(6,0) INTEGER NOT NULL Approved Department Demand Executive Number for France.