FPACAHDCNT01_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.SETID , A.FP_CA_CATG_ID , 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_FPM_CA_CTG_MBR A WHERE C.FP_HDCNT_TYPE = 'H' AND C.FP_RANK_CD = A.FP_RANK_CD AND A.SETID = C.FP_SETID_RANK AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_FPM_CA_CTG_MBR A_ED WHERE A.SETID = A_ED.SETID AND A.FP_CA_CATG_ID = A_ED.FP_CA_CATG_ID AND A_ED.EFFDT <= %CurrentDateIn) GROUP BY C.SETID_DEPT, C.DEPTID, C.FP_FRSTDAY_YEAR, A.SETID, A.FP_CA_CATG_ID

# 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_SETID_RANK Character(5) VARCHAR2(5) NOT NULL SetID
5 FP_CA_CATG_ID Character(6) VARCHAR2(6) NOT NULL CAE Category
6 FP_HDCNTPCT01 Number(9,2) DECIMAL(8,2) NOT NULL % January
7 FP_HDCNTPCT02 Number(9,2) DECIMAL(8,2) NOT NULL % February
8 FP_HDCNTPCT03 Number(9,2) DECIMAL(8,2) NOT NULL % March
9 FP_HDCNTPCT04 Number(9,2) DECIMAL(8,2) NOT NULL % April
10 FP_HDCNTPCT05 Number(9,2) DECIMAL(8,2) NOT NULL % May
11 FP_HDCNTPCT06 Number(9,2) DECIMAL(8,2) NOT NULL % June
12 FP_HDCNTPCT07 Number(9,2) DECIMAL(8,2) NOT NULL % July
13 FP_HDCNTPCT08 Number(9,2) DECIMAL(8,2) NOT NULL % August
14 FP_HDCNTPCT09 Number(9,2) DECIMAL(8,2) NOT NULL % September
15 FP_HDCNTPCT10 Number(9,2) DECIMAL(8,2) NOT NULL % October
16 FP_HDCNTPCT11 Number(9,2) DECIMAL(8,2) NOT NULL % November
17 FP_HDCNTPCT12 Number(9,2) DECIMAL(8,2) NOT NULL % December