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 |