CAL_DETP_PR2_VW

(SQL View)
 Index Back

Detail Calendar Periods

Available fiscal years by setid / calendar id.

SELECT DISTINCT setid , calendar_id , fiscal_year , accounting_period , period_name FROM PS_CAL_DETP_TBL

  • Related Language Record: CAL_DETPP2_LVW

    • # 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
    4 ACCOUNTING_PERIOD2 Number(3,0) SMALLINT NOT NULL Accounting Period
    5 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name