HCR_SMRSLTVWLNG

(SQL View)
 Index Back

Search Match Result Search Rec

Search Match Result Search Record. This view selects Search Match Result Parameters by Role.

SELECT DISTINCT (B.OPRID) ,A.SM_TYPE ,A.SM_RSLT_CD ,C.LANGUAGE_CD ,C.DESCR FROM PS_HCR_SM_RSLT_TBL A , PSROLEUSER_VW B , PS_HCR_SM_RSLT_LNG C WHERE A.SM_TYPE = C.SM_TYPE AND A.SM_RSLT_CD = C.SM_RSLT_CD AND (A.SM_ACCESS_FLG = 'Y' OR A.SM_RSLT_CD IN ( SELECT B1.SM_RSLT_CD FROM PS_HCR_SM_RSEC_TBL B1 WHERE B1.SM_TYPE = A.SM_TYPE AND B1.SM_RSLT_CD = A.SM_RSLT_CD AND B1.ROLENAME IN ( SELECT C1.ROLENAME FROM PSROLEUSER_VW C1 WHERE C1.OPRID = B.OPRID))) AND A.STATUS = 'A'

  • Related Language Record for HCR_SM_RSLT_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 SM_TYPE Character(1) VARCHAR2(1) NOT NULL Search Match Type: This field identifies the domain of core data to be searched.
    A=Applicant
    O=Organization
    P=Person
    3 SM_RSLT_CD Character(15) VARCHAR2(15) NOT NULL Search Match Result Code.
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description