TRN_DEMAND_DEPT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUDGET_PERIOD	Character(10)	VARCHAR2(10) NOT NULL	Budget Period
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUDGET_BUS_UNIT
3	DEMAND_ID	Character(10)	VARCHAR2(10) NOT NULL	Demand ID
4	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: TRN_DEPTEFFD_VW
5	DEPT_DEMAND	Number(6,0)	INTEGER NOT NULL	Department Demand
6	UPDATE_DEPTID_SW	Character(1)	VARCHAR2(1) NOT NULL	User Updated Department Y/N Table Edit Default Value: N
7	DEPT_DMND_F_FRA	Number(6,0)	INTEGER NOT NULL	Department Demand Female Number for France.
8	DEPT_DMND_M_FRA	Number(6,0)	INTEGER NOT NULL	Department Demand Male Number for France.
9	DEPT_DMND_ONQ_FRA	Number(6,0)	INTEGER NOT NULL	Department Demand Non Qualified Worker Number for France.
10	DEPT_DMND_OQ_FRA	Number(6,0)	INTEGER NOT NULL	Department Demand Qualified Worker Number for France.
11	DEPT_DMND_E_FRA	Number(6,0)	INTEGER NOT NULL	Department Demand Office Worker Number for France.
12	DEPT_DMND_AM_FRA	Number(6,0)	INTEGER NOT NULL	Department Demand Manager Number for France.
13	DEPT_DMND_IC_FRA	Number(6,0)	INTEGER NOT NULL	Department Demand Executive Number for France.