OI_CAL_QED_VW(SQL View) |
Index Back |
|---|---|
OTBI Quarter viewOTBI Quarter view to find Quarter_End_Date |
| SELECT SETID ,CALENDAR_ID ,QTD_BEGIN_DT ,MAX(QTD_END_DT) QTD_END_DT FROM PS_D_FISCAL_PERIOD B WHERE B.ADJUSTMENT_FLG='N' GROUP BY QTD_BEGIN_DT,SETID,CALENDAR_ID |
| # | 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 | QTD_BEGIN_DT | Date(10) | DATE | QTD_BEGIN_DT |
| 4 | QTD_END_DT | Date(10) | DATE | QTD_END_DT |