INJ_ILLADVW_LNG

(SQL View)
 Index Back

Inj/Ill Physicians

INJ_ILL_DIAG_VW is a view of INJURY_ILL_DIAG that sorts medical diagnosis records by incident number rather than by employee ID or non-employee ID. This functionality is part of the Health and Safety module.

SELECT INCIDENT_NBR ,EMPLID ,EMPL_RCD ,NON_EMPLOYEE_ID ,CARE_TYPE ,LANGUAGE_CD ,PHYSICIAN_NAME ,HOSPITAL FROM PS_INJ_ILLADDR_LNG

  • Related Language Record for INJ_ILL_ADDR_VW

  • Parent record: INJURY_ILL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Prompt Table: PER_ORG_ASGN_VW

    4 NON_EMPLOYEE_ID Character(11) VARCHAR2(11) NOT NULL Non-Employee ID

    Prompt Table: NE_INCIDNT_SRCH

    5 CARE_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Health Care
    A=1st Treatment (Physician)
    B=Company Physician
    E=Emergency Care
    H=Family Physician
    K=Hospital
    L=Further Treatment (Hospital)
    O=Ongoing Health Care
    S=Specialist
    W=Further Treatment (Physician)
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 PHYSICIAN_NAME Character(50) VARCHAR2(50) NOT NULL Physician Name
    8 HOSPITAL Character(30) VARCHAR2(30) NOT NULL Hospital Name