# |
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.
|