FPARK_HDCNT_VW (SQL View)	Index Back
Budgeted Year & Counting type This view retrieves the year and the counting type from the headcount per grade table. It is used in the French Public Sector functionalities.

FPARK_HDCNT_VW

(SQL View)

Budgeted Year & Counting type

This view retrieves the year and the counting type from the headcount per grade table. It is used in the French Public Sector functionalities.

SELECT DISTINCT FP_YEAR , FP_CNT_MODE FROM PS_FPARANK_HDCNT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FP_YEAR Character(4) VARCHAR2(4) NOT NULL Year

2 FP_CNT_MODE Character(1) VARCHAR2(1) NOT NULL Counting Mode
B=Budget Headcount
L=Statutory Headcount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FP_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Year
2	FP_CNT_MODE	Character(1)	VARCHAR2(1) NOT NULL	Counting Mode B=Budget Headcount L=Statutory Headcount