RC_SECURE_PN_VW (SQL View)	Index Back
Select authorized cases Select cases current user is authorized to view.

RC_SECURE_PN_VW

(SQL View)

Select authorized cases

Select cases current user is authorized to view.

SELECT C.CASE_ID FROM PSOPRALIAS A , PS_RF_GRP_MEMBER B , PS_RC_CASE C WHERE C.SECURE_CASE_FLG = 'Y' AND A.OPRID = 'CVP1' AND A.OPRALIASTYPE = 'PER' AND B.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = C.BUSINESS_UNIT AND D.RECNAME = 'RF_PROVIDER_GRP') AND B.PROVIDER_GRP_ID = C.PROVIDER_GRP_ID AND B.PERSON_ID = A.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.