PROBINSTPROVIDER_GRP_IDSETIDRF_UTIL_COST_VW(SQL View) |
Index Back |
|---|---|
Cost - Utilization Rate ViewInput view for Cost - Utilization Rate ACE report |
| SELECT K.PROBINST , C.PROVIDER_GRP_ID , C.SETID , B.CURRENCY_CD , B.HOURLY_RT FROM PS_RF_COST_CAT_GRP B , PS_RF_PROVIDER_GRP C , PS_RF_UTIL_COST A , PS_RF_UTIL_CONFIG J , PS_RF_UTIL_CF_INST K WHERE B.SETID = C.SETID AND B.PROVIDER_GRP_ID = C.PROVIDER_GRP_ID AND B.SETID = A.SETID AND B.COST_CAT_CD = A.COST_CAT_CD AND J.OPRID = K.OPRID AND J.RUN_CNTL_ID = K.RUN_CNTL_ID AND EXISTS ( SELECT 'X' FROM PS_RF_UTIL_AVHR_VW V WHERE V.SETID = C.SETID AND V.PROVIDER_GRP_ID = C.PROVIDER_GRP_ID AND V.PROBINST = K.PROBINST) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 2 | PROVIDER_GRP_ID |
Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 5 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | HOURLY RATE |