CAL_DETP_TO_VW

(SQL View)
Index Back

View of Dtl Cal Periods To


select setid ,calendar_id ,fiscal_year ,accounting_period ,period_name from PS_CAL_DETP_TBL

  • Related Language Record: CAL_DETP2_LG_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DETAIL_CALENDAR Character(2) VARCHAR2(2) NOT NULL Detail Calendar
    3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    4 DETL_PERIOD_TO Number(3,0) SMALLINT NOT NULL Detail Calendar To Period
    5 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name