PHYM_BRA_VW_LNG

(SQL View)
 Index Back

HS Physician Search

HS Physician Search

SELECT A.NON_EMPLOYEE_ID , C.LANGUAGE_CD , C.NAME_DISPLAY FROM PS_NE_PERSONAL_DTA A , PS_NE_PERSDATA_LNG C , PS_PHYSICIAN_BRA B WHERE A.PHYSICIAN_SW = 'Y' AND A.NON_EMPLOYEE_ID = C.NON_EMPLOYEE_ID AND A.NON_EMPLOYEE_ID = B.NON_EMPLOYEE_ID

  • Related Language Record for PHYS_MED_BRA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PHYSICIAN_ID Character(11) VARCHAR2(11) NOT NULL Physician ID

    Default Value: 0

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country