FPABUDG_HDCNT

(SQL Table)
Index Back

Hdcnt/ Budget Hdcnt

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FP_HYP_NBR Number(3,0) SMALLINT NOT NULL Assumption Nber
2 FP_YEAR Character(4) VARCHAR2(4) NOT NULL Year
3 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL SetID
4 FP_RANK_CD Character(6) VARCHAR2(6) NOT NULL Grade
5 FP_CNT_MODE Character(1) VARCHAR2(1) NOT NULL Counting Mode
B=Budget Headcount
L=Statutory Headcount
6 FP_SEX_HDCNT Character(1) VARCHAR2(1) NOT NULL Headcount - Male/Female
F=Female
M=Male
T=Total
7 FP_HDCNT_BUDG Number(7,0) INTEGER NOT NULL Budget Headcount
8 FP_HDCNT01 Number(6,0) INTEGER NOT NULL January
9 FP_HDCNT02 Number(6,0) INTEGER NOT NULL February
10 FP_HDCNT03 Number(6,0) INTEGER NOT NULL March
11 FP_HDCNT04 Number(6,0) INTEGER NOT NULL April
12 FP_HDCNT05 Number(6,0) INTEGER NOT NULL May
13 FP_HDCNT06 Number(6,0) INTEGER NOT NULL June
14 FP_HDCNT07 Number(6,0) INTEGER NOT NULL July
15 FP_HDCNT08 Number(6,0) INTEGER NOT NULL August
16 FP_HDCNT09 Number(6,0) INTEGER NOT NULL September
17 FP_HDCNT10 Number(6,0) INTEGER NOT NULL October
18 FP_HDCNT11 Number(6,0) INTEGER NOT NULL November
19 FP_HDCNT12 Number(6,0) INTEGER NOT NULL December
20 FP_HDCNTPCT01 Number(9,2) DECIMAL(8,2) NOT NULL % January
21 FP_HDCNTPCT02 Number(9,2) DECIMAL(8,2) NOT NULL % February
22 FP_HDCNTPCT03 Number(9,2) DECIMAL(8,2) NOT NULL % March
23 FP_HDCNTPCT04 Number(9,2) DECIMAL(8,2) NOT NULL % April
24 FP_HDCNTPCT05 Number(9,2) DECIMAL(8,2) NOT NULL % May
25 FP_HDCNTPCT06 Number(9,2) DECIMAL(8,2) NOT NULL % June
26 FP_HDCNTPCT07 Number(9,2) DECIMAL(8,2) NOT NULL % July
27 FP_HDCNTPCT08 Number(9,2) DECIMAL(8,2) NOT NULL % August
28 FP_HDCNTPCT09 Number(9,2) DECIMAL(8,2) NOT NULL % September
29 FP_HDCNTPCT10 Number(9,2) DECIMAL(8,2) NOT NULL % October
30 FP_HDCNTPCT11 Number(9,2) DECIMAL(8,2) NOT NULL % November
31 FP_HDCNTPCT12 Number(9,2) DECIMAL(8,2) NOT NULL % December
32 FP_FRSTDAY_YEAR Date(10) DATE Fisrt Day of Year