FPM_CA_HDCT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_STFBDG_LVL1	Character(2)	VARCHAR2(2) NOT NULL	Section EM=Labor LG=Housing S1=Sector 1 S2=Sector 2 SL=Solidarity TO=Tourism TR=Transportation
2	FP_FINANC_LAW_ID	Character(12)	VARCHAR2(12) NOT NULL	Finance Act
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
6	FP_CA_CATG_ID	Character(6)	VARCHAR2(6) NOT NULL	CAE Category Prompt Table: FPM_CA_CTG_TBL
7	FP_FL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Finance Act Status A=Adjourned E=To Be Stamped V=Stamped Default Value: FPM_CA_FINLAW.FP_FL_STATUS
8	FP_BUDG_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Budgetized Headcount
9	FP_ALLWD_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Budget Headcount Authorized
10	FP_MNDGD_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Authorized Headcount Managmt
11	FP_CARRYOVER_1	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Moves BH/BHA Carry Over
12	FP_CARRYOVER_2	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Total Mvts Lev 2 Carryover
13	FP_TRS1_SUM	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Moves between BH and BHA
14	FP_TRS2_SUM	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Moves between BHA and AHM
15	FP_FROZ_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Transactional Freeze
16	FP_MASS_FRZ_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Mass Freeze
17	FP_USED_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Allocated CAE
18	FP_BK_UNST_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	CAE Booked not Stamped
19	FP_BK_STMP_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	CAE Booked and Stamped
20	FP_DSCH_UNST_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	CAE Deallocated not Stamped
21	FP_DSCH_STMP_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	CAE Deallocated and Stamped
22	FP_POT_DSCH_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	CAE to be Deallocated
23	FP_LOCK_OVFL_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Overstaff Authorized
24	FP_LOCKED_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	CAE Locked in
25	FP_LOCK_RQS	Number(9,2)	DECIMAL(8,2) NOT NULL	Nbr of Locking ins Requested
26	FP_LCKD_DSCH_RQS	Number(9,2)	DECIMAL(8,2) NOT NULL	Nbr of CAE to Unlock
27	FP_COMM_PHYSIC	Number(6,0)	INTEGER NOT NULL	Physical Headcount
28	FP_WARN1_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Booked Overdue not Stamped
29	FP_WARN2_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Dealloctd Overdue not Stamped
30	FP_FREE_ENT1_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Counter 1 Free of Use
31	FP_FREE_ENT2_HDCNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Counter 2 Free of Use
32	LAST_UPDATE_DATE	Date(10)	DATE	Date of last update