RC_ER_UNAUTH_VW

(SQL View)
 Index Back

ER Active Assignees

View for active assignees for a case.

SELECT B.OPRID , A.CASE_ID , A.BUSINESS_UNIT , B.PERSON_ID FROM PS_RC_CASE_ASSIGN A , PSOPRALIAS B WHERE B.OPRALIASTYPE ='PER' AND (( B.PERSON_ID !=( SELECT C.RC_ER_MANAGER FROM PS_BUS_UNIT_TBL_RC C WHERE C.BUSINESS_UNIT= A.BUSINESS_UNIT )) AND (A.RC_ASSIGNMENT_TYPE='I' AND (A.RC_ER_ASSIGNED_TO != B.PERSON_ID OR (A.START_DATE > %CurrentDateIn OR (A.END_DATE IS NOT NULL AND A.END_DATE <%CurrentDateIn) ))) OR (A.RC_PROVIDER_GRP_ID != ( SELECT P.PROVIDER_GRP_ID FROM PS_RF_GRP_MEMBER P , PS_SET_CNTRL_REC S WHERE (S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.RECNAME = 'RF_PROVIDER_GRP' AND P.SETID = S.SETID AND P.PROVIDER_GRP_ID = A.RC_PROVIDER_GRP_ID) AND P.PERSON_ID = B.PERSON_ID AND P.STATUS = 'A') OR ((A.START_DATE > %CurrentDateIn OR (A.END_DATE IS NOT NULL AND A.END_DATE <%CurrentDateIn) ) )))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

Default Value: RC_CASE.CASE_ID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: RC_CASE.BUSINESS_UNIT

4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID