FPACAHDCNT02_VW

(SQL View)
 Index Back

FPS Commitment Accounting

This view is used by the French Public Sector Commitment Accounting functionality.

SELECT C.SETID_DEPT , C.DEPTID , C.FP_FRSTDAY_YEAR , A.FP_RANK_GROUP , SUM( C.FP_HDCNTPCT01) , SUM( C.FP_HDCNTPCT02) , SUM( C.FP_HDCNTPCT03) , SUM( C.FP_HDCNTPCT04) , SUM( C.FP_HDCNTPCT05) , SUM( C.FP_HDCNTPCT06) , SUM( C.FP_HDCNTPCT07) , SUM( C.FP_HDCNTPCT08) , SUM( C.FP_HDCNTPCT09) , SUM( C.FP_HDCNTPCT10) , SUM( C.FP_HDCNTPCT11) , SUM( C.FP_HDCNTPCT12) FROM PS_FPAHEADCNT01 C , PS_FPMRANK_TBL A WHERE C.FP_RANK_CD = A.FP_RANK_CD AND A.FP_RANK_GROUP <> ' ' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_FPMRANK_TBL A_ED WHERE A.SETID = A_ED.SETID AND A.FP_RANK_CD = A_ED.FP_RANK_CD AND A_ED.EFFDT <= %CurrentDateIn) AND C.FP_HDCNT_TYPE = 'H' GROUP BY C.SETID_DEPT, C.DEPTID, C.FP_FRSTDAY_YEAR, A.FP_RANK_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
3 EFFDT Date(10) DATE Effective Date
4 FP_RANK_GROUP Character(6) VARCHAR2(6) NOT NULL Grade Group
5 FP_HDCNTPCT01 Number(9,2) DECIMAL(8,2) NOT NULL % January
6 FP_HDCNTPCT02 Number(9,2) DECIMAL(8,2) NOT NULL % February
7 FP_HDCNTPCT03 Number(9,2) DECIMAL(8,2) NOT NULL % March
8 FP_HDCNTPCT04 Number(9,2) DECIMAL(8,2) NOT NULL % April
9 FP_HDCNTPCT05 Number(9,2) DECIMAL(8,2) NOT NULL % May
10 FP_HDCNTPCT06 Number(9,2) DECIMAL(8,2) NOT NULL % June
11 FP_HDCNTPCT07 Number(9,2) DECIMAL(8,2) NOT NULL % July
12 FP_HDCNTPCT08 Number(9,2) DECIMAL(8,2) NOT NULL % August
13 FP_HDCNTPCT09 Number(9,2) DECIMAL(8,2) NOT NULL % September
14 FP_HDCNTPCT10 Number(9,2) DECIMAL(8,2) NOT NULL % October
15 FP_HDCNTPCT11 Number(9,2) DECIMAL(8,2) NOT NULL % November
16 FP_HDCNTPCT12 Number(9,2) DECIMAL(8,2) NOT NULL % December