RF_UTIL_AVHR_VW

(SQL View)
 Index Back

Available Hours - Rate

Input view for Available Hours - Utilization Rate ACE report

SELECT K.PROBINST , D.PROVIDER_GRP_ID , D.SETID , E.PERSON_ID , A.TOTAL_HOURS , 1 FROM PS_RF_UTIL_AVL_TBL A , PS_RF_GRP_MEMBER C , PS_RF_PROVIDER_GRP D , PS_RD_PERSON_NAME E , PS_RF_UTIL_CONFIG J , PS_RF_UTIL_CF_INST K WHERE A.PERSON_ID = C.PERSON_ID AND C.STATUS = 'A' AND A.UUID_RAW = K.UUID_RAW AND C.SETID = D.SETID AND C.PROVIDER_GRP_ID = D.PROVIDER_GRP_ID AND A.PERSON_ID = E.PERSON_ID AND J.OPRID = K.OPRID AND J.RUN_CNTL_ID = K.RUN_CNTL_ID AND ((J.SELECT_FLAG = 'N' AND EXISTS ( SELECT 'X' FROM PS_RF_UTIL_CFG_SEQ Z WHERE Z.OPRID = J.OPRID AND Z.RUN_CNTL_ID = J.RUN_CNTL_ID AND Z.SETID = D.SETID AND Z.PROVIDER_GRP_ID = D.PROVIDER_GRP_ID)) OR J.SELECT_FLAG = 'Y')

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
5 TOTAL_HOURS Signed Number(13,2) DECIMAL(11,2) NOT NULL This field is used to store the Total Hours.
6 DUMMYFIELD Number(3,0) SMALLINT NOT NULL Dummy Filed For ACE Report