BUSINESS_UNITBUDGET_PERIODPC_SUMCAL_BP_VW(SQL View) |
Index Back |
|---|---|
Detail Calendar Periods |
| SELECT C.BUSINESS_UNIT , A.BUDGET_PERIOD , A.BEGIN_DT , A.END_DT , A.PERIOD_NAME FROM PS_CAL_BP_TBL A , PS_INSTALLATION_PC B , PS_BUS_UNIT_TBL_PC C , PS_SET_CNTRL_REC D WHERE A.CALENDAR_ID = B.PC_SUM_CAL_ID AND A.SETID = D.SETID AND D.SETCNTRLVALUE = C.BUSINESS_UNIT AND D.RECNAME = 'CAL_BP_TBL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BUDGET_PERIOD |
Character(8) | VARCHAR2(8) NOT NULL | Budget Period |
| 3 | BEGIN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 4 | END_DT | Date(10) | DATE NOT NULL | End Date |
| 5 | PERIOD_NAME | Character(30) | VARCHAR2(30) NOT NULL | Period Name |