CAL_BLDR_LNG_VW

(SQL View)
Index Back

Detail Calendar Periods


SELECT SETID , CALENDAR_ID , FISCAL_YEAR , ACCOUNTING_PERIOD , LANGUAGE_CD , PERIOD_NAME , PERIOD_ABBRV FROM PS_CAL_DETP_LANG

  • Related Language Record for CAL_BLDR_VW
  • # 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_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    4 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name
    7 PERIOD_ABBRV Character(3) VARCHAR2(3) NOT NULL Abbreviation