FPAHEADCNT01

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Year
2	FP_RANK_CD	Character(6)	VARCHAR2(6) NOT NULL	Grade
3	FP_STATUSEE_CD	Character(1)	VARCHAR2(1) NOT NULL	Employee status
4	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
6	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
7	FP_HDCNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Counting Mode H=Physical Headcount J=Indexical Mass P=Potential FTE R=Paid FTE T=Worked FTE
8	FP_BIRTHYEAR	Character(4)	VARCHAR2(4) NOT NULL	Birthyear
9	BIRTHDATE	Date(10)	DATE	Date of Birth
10	FP_CORPS_CD	Character(6)	VARCHAR2(6) NOT NULL	Corps
11	FP_CATG_FP	Character(2)	VARCHAR2(2) NOT NULL	Civil Service Category A=A B=B C=C D=D X=No Existing Category
12	FP_SETID_RANK	Character(5)	VARCHAR2(5) NOT NULL	SetID
13	FP_HDCNTPCT01	Number(9,2)	DECIMAL(8,2) NOT NULL	% January
14	FP_HDCNTPCT02	Number(9,2)	DECIMAL(8,2) NOT NULL	% February
15	FP_HDCNTPCT03	Number(9,2)	DECIMAL(8,2) NOT NULL	% March
16	FP_HDCNTPCT04	Number(9,2)	DECIMAL(8,2) NOT NULL	% April
17	FP_HDCNTPCT05	Number(9,2)	DECIMAL(8,2) NOT NULL	% May
18	FP_HDCNTPCT06	Number(9,2)	DECIMAL(8,2) NOT NULL	% June
19	FP_HDCNTPCT07	Number(9,2)	DECIMAL(8,2) NOT NULL	% July
20	FP_HDCNTPCT08	Number(9,2)	DECIMAL(8,2) NOT NULL	% August
21	FP_HDCNTPCT09	Number(9,2)	DECIMAL(8,2) NOT NULL	% September
22	FP_HDCNTPCT10	Number(9,2)	DECIMAL(8,2) NOT NULL	% October
23	FP_HDCNTPCT11	Number(9,2)	DECIMAL(8,2) NOT NULL	% November
24	FP_HDCNTPCT12	Number(9,2)	DECIMAL(8,2) NOT NULL	% December
25	FP_FRSTDAY_YEAR	Date(10)	DATE	Fisrt Day of Year