CWB_CAL_CUR_VW

(SQL View)
Index Back

Current FY & Period


SELECT A.BUSINESS_UNIT , c.calendar_id , c.fiscal_year , c.accounting_period , d.number_of_periods , c.begin_dt , c.end_dt FROM PS_BU_CRNCY_VW_AR A , ps_cal_defn_tbl d , PS_CAL_DETP_TBL c WHERE c.setid = d.setid AND c.calendar_id = d.calendar_id AND d.calendar_type = 'D' AND %CurrentDateIn BETWEEN c.begin_dt AND c.end_dt AND c.setid = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = A.business_unit AND RECNAME = 'CAL_DEFN_TBL') AND c.calendar_id = A.calendar_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

Prompt Table: CAL_DETL_VW

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 NUMBER_OF_PERIODS Number(3,0) SMALLINT NOT NULL Periods in a Year
6 BEGIN_DT Date(10) DATE Begin Date
7 END_DT Date(10) DATE End Date