PROBINSTRF_DATE_CNFG_VW(SQL View) |
Index Back |
|---|---|
Service Order Aging Date ConfgUsed in the Service Order Aging ACE report |
| SELECT C.PROBINST , A.DAY_RANGE FROM PS_RF_DATE_CONFIG A , PS_RF_SO_AGE B , PS_RF_SO_AGE_INST C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.OPRID = C.OPRID AND B.RUN_CNTL_ID = C.RUN_CNTL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | DAY_RANGE | Character(15) | VARCHAR2(15) NOT NULL | Range of Days for reporting purposes. |