CAL_DETP_FY2_VW

(SQL View)
Index Back

Detail Calendar Fiscal Years

Available fiscal years by setid / calendar id.

SELECT DISTINCT setid , calendar_id , fiscal_year FROM PS_CAL_DETP_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
3 FISCAL_YEAR2 Number(4,0) SMALLINT NOT NULL Fiscal Year