D_FISCAL_PERIOD

(SQL Table)
Index Back

Detail Period Dimension

  • Related Language Record: L_FISCAL_PERIOD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    3 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.
    4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    5 ADJUSTMENT_FLG Character(1) VARCHAR2(1) NOT NULL Upward/Downward Adjustment
    6 CALENDAR_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 HIERARCHY_LABEL Character(4) VARCHAR2(4) NOT NULL HIERARCHY_LABEL
    MNTH=Month
    QUTR=Quarter
    SANN=Semi-Annual
    WEEK=Week
    YEAR=Year
    8 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name
    9 PERIOD_ABBRV Character(3) VARCHAR2(3) NOT NULL Abbreviation
    10 BEGIN_DT Date(10) DATE Begin Date
    11 END_DT Date(10) DATE End Date
    12 QTR_NUM Number(1,0) SMALLINT NOT NULL QTR_NUM
    13 PERIOD_KEY Character(30) VARCHAR2(30) NOT NULL PERIOD_KEY
    14 YTD_PERIOD_KEY Character(30) VARCHAR2(30) NOT NULL YTD_PERIOD_KEY
    15 QTR_KEY Character(30) VARCHAR2(30) NOT NULL QTR_KEY
    16 QTD_PERIOD_KEY Character(30) VARCHAR2(30) NOT NULL QTD_PERIOD_KEY
    17 YTD_BEGIN_DT Date(10) DATE YTD_BEGIN_DT
    18 YTD_END_DT Date(10) DATE YTD_END_DT
    19 QTD_BEGIN_DT Date(10) DATE QTD_BEGIN_DT
    20 QTD_END_DT Date(10) DATE QTD_END_DT
    21 QUARTER_DESCR Character(30) VARCHAR2(30) NOT NULL This is the description of the quarter.
    22 FY_QTR Character(50) VARCHAR2(50) NOT NULL FY_QTR
    23 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
    24 QUARTER_END_DT Date(10) DATE QTD_END_DT
    25 MONTH_NUM Number(6,0) INTEGER NOT NULL Month Number
    26 OI_MONTH_KEY Character(20) VARCHAR2(20) NOT NULL Month Key
    27 WEEK_NUM Number(6,0) INTEGER NOT NULL This is the week number
    28 OI_WEEK_KEY Character(20) VARCHAR2(20) NOT NULL Week Key
    29 OI_SEMI_ANNUAL_NBR Character(20) VARCHAR2(20) NOT NULL Semi Annual Number
    30 OI_SEMI_ANNUAL_KEY Character(20) VARCHAR2(20) NOT NULL Semi Annual Key