PC_BUD_ROLL_VW(SQL View) |
Index Back |
|---|---|
SQL ViewFROM PS_CAL_BPS_TBL A , PS_CAL_DEFN_TBL B , PS_CAL_BP_TBL C |
| SELECT A.SETID , B.CALENDAR_ID , B.DETAIL_CALENDAR , A.BUDGET_PERIOD , MIN(C.BEGIN_DT) AS BEGIN_DT , MAX(C.END_DT) AS END_DT FROM PS_CAL_BPS_TBL A , PS_CAL_DEFN_TBL B , PS_CAL_BP_TBL C WHERE A.SETID = B.SETID AND B.SETID = C.SETID AND A.CALENDAR_ID = B.CALENDAR_ID AND B.DETAIL_CALENDAR = C.CALENDAR_ID AND C.BUDGET_PERIOD BETWEEN A.BP_FROM AND A.BP_TO GROUP BY A.SETID, B.CALENDAR_ID, B.DETAIL_CALENDAR, A.BUDGET_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 | DETAIL_CALENDAR | Character(2) | VARCHAR2(2) NOT NULL | Detail Calendar |
| 4 | BUDGET_PERIOD | Character(8) | VARCHAR2(8) NOT NULL | Budget Period |
| 5 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | End Date |