FISCAL_YEARWM_QTR_ACCTG_PERWM_QTR_PER_VW(SQL View) |
Index Back |
|---|
| SELECT D.FISCAL_YEAR , D.ACCOUNTING_PERIOD , MIN(B.BEGIN_DT) , MAX(B.END_DT) FROM PS_CAL_DETP_TBL B , PS_CAL_SUMP_TBL D , PS_CAL_DEFN_TBL G , PS_WM_REPORT_SETUP C WHERE B.SETID = C.SETID AND B.CALENDAR_ID = C.WM_MONTH_CALENDAR AND D.SETID = B.SETID AND D.CALENDAR_ID = C.WM_QTR_CALENDAR AND D.FISCAL_YEAR = B.FISCAL_YEAR AND B.ACCOUNTING_PERIOD BETWEEN D.DETL_PERIOD_FROM AND D.DETL_PERIOD_TO AND G.SETID = D.SETID AND G.CALENDAR_ID = D.CALENDAR_ID GROUP BY D.FISCAL_YEAR, D.ACCOUNTING_PERIOD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 2 | WM_QTR_ACCTG_PER |
Number(3,0) | SMALLINT NOT NULL | Quarterly Accounting Period |
| 3 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 4 | END_DT | Date(10) | DATE | End Date |