ILL_CARE_LNG

(SQL Table)
 Index Back

RellangInjury/Illness Dr Addrs

INJ_ILLADDR_LNG is the language record related to INJURY_ILL_ADDR. A related language record enables text fields on a table to be translated into various languages for use in other countries.

  • Related Language Record for ILL_CARE_GER

  • Parent record: INJURY_ILL

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

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

    Prompt Table: PER_ORG_ASGN_VW

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

    Prompt Table: NE_INCIDNT_SRCH

    4 ILLNESS_NBR_GER Character(8) VARCHAR2(8) NOT NULL Illness Number
    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 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: ILLNESS_GER.REG_REGION

    Prompt Table: REG_HANDS_VW

    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 PHYSICIAN_NAME Character(50) VARCHAR2(50) NOT NULL Physician Name
    9 HOSPITAL Character(30) VARCHAR2(30) NOT NULL Hospital Name