OI_CAL_DEPFY_VW

(SQL View)
 Index Back

Detail Calendar Fiscal Years

Available fiscal years by setid / calendar id.

SELECT DISTINCT C.SETID , A.CALENDAR_ID , C.FISCAL_YEAR FROM %Table(CAL_DETP_TBL) A , %Table(CAL_DEFN_TBL) B , %Table(CAL_SUMP_TBL) C WHERE A.SETID=B.SETID AND A.CALENDAR_ID = B.DETAIL_CALENDAR AND B.CALENDAR_TYPE IN ('S') AND B.SETID = C.SETID AND B.CALENDAR_ID= C.CALENDAR_ID

# 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 DETAIL_CALENDAR Character(2) VARCHAR2(2) NOT NULL Detail Calendar
3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year