HCSC_RCPNT_VW

(SQL View)
 Index Back

Recipient Look up view

Recipient Look up view. If no role is attached to a recipient type all users can lookup the recipient type. If a role is attached to a recipient type only users with that role will have access to look up the recipient type.

SELECT DISTINCT C.ROLEUSER ,A.HCSC_RECIPIENT_ID , A.HCSC_RECIPIENT_NM FROM PS_HCSC_RECIPIENT A , PS_HCSC_RCPNT_ROLE B , PSROLEUSER C WHERE (A.HCSC_RECIPIENT_ID = B.HCSC_RECIPIENT_ID AND A.STATUS = 'A' AND B.ROLENAME = C.ROLENAME) UNION SELECT DISTINCT C2.ROLEUSER ,A2.HCSC_RECIPIENT_ID , A2.HCSC_RECIPIENT_NM FROM PS_HCSC_RECIPIENT A2 , PS_HCSC_RCPNT_ROLE B2 , PSROLEUSER C2 WHERE (A2.HCSC_RECIPIENT_ID = B2.HCSC_RECIPIENT_ID AND A2.STATUS = 'A' AND B2.ROLENAME = ' ') UNION SELECT DISTINCT C1.ROLEUSER ,A1.HCSC_RECIPIENT_ID , A1.HCSC_RECIPIENT_NM FROM PS_HCSC_RECIPIENT A1 , PSROLEUSER C1 WHERE A1.STATUS = 'A' AND NOT EXISTS( SELECT 'X' FROM PS_HCSC_RCPNT_ROLE B1 WHERE A1.HCSC_RECIPIENT_ID = B1.HCSC_RECIPIENT_ID)

  • Related Language Record: HCSC_RCPNT_L_VW

    • # 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 HCSC_RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Recipient ID for Adhoc Recipient types
    3 HCSC_RECIPIENT_NM Character(30) VARCHAR2(30) NOT NULL Description for Recipient ID of adhoc notification