OM_PWC_PRI_CAL1(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , C1.BEGIN_DT , C1.END_DT FROM PS_CAL_TD_TBL C , PS_BUS_UNIT_TBL_OM BU , PS_SET_CNTRL_REC X , PS_CAL_TD_TBL C1 WHERE BU.CALENDAR_ID = C.CALENDAR_ID AND C.SETID = X.SETID AND X.SETCNTRLVALUE = BU.BUSINESS_UNIT AND X.RECNAME = 'CAL_TD_TBL' AND %CurrentDateIn BETWEEN C.BEGIN_DT AND C.END_DT AND BU.CALENDAR_ID = C1.CALENDAR_ID AND C1.SETID = X.SETID AND %DateAdd(C.BEGIN_DT,-1) BETWEEN C1.BEGIN_DT AND C1.END_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 3 | END_DT | Date(10) | DATE | End Date |