HS_SS_ILL_LVW

(SQL View)
Index Back

Occupational Illness Codes

View of OCC_ILLNESS_LNG used in self service when reporting incidents that resulted in illness.

SELECT SETID , OCC_ILLNESS_CD , LANGUAGE_CD , EFFDT , DESCR50 , DESCRLONG FROM PS_OCC_ILLNESS_LNG

  • Related Language Record for HS_SS_ILL_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_08

    2 OCC_ILLNESS_CD Character(6) VARCHAR2(6) NOT NULL Occupational Illness
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 DESCRLONG Long Character CLOB Long Description