FPACAHDCNT00_VW (SQL View)	Index Back
Department's First Day of Year This view retrieves the first day of year for each department (used in French Public Sector Commitment Accounting)

FPACAHDCNT00_VW

(SQL View)

Department's First Day of Year

This view retrieves the first day of year for each department (used in French Public Sector Commitment Accounting)

SELECT DISTINCT C.SETID_DEPT , C.DEPTID , C.FP_FRSTDAY_YEAR FROM PS_FPAHEADCNT01 C

# 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

#	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