AMR_ASUMP_FY_VW

(SQL View)
Index Back

Summary Calendar Fiscal Years

Available summary calendar fiscal years by setid / calendar id.

SELECT DISTINCT setid , calendar_id , fiscal_year FROM PS_CAL_SUMP_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 AMR_CAL_ID_YR Character(2) VARCHAR2(2) NOT NULL Amortization annual summary calendar
3 FISCAL_YEAR_FROM Number(4,0) SMALLINT NOT NULL Fiscal Year