DISABILITY

(SQL Table)
 Index Back

Disability

Information on Employee's disability

  • Parent record: PERSONAL_DATA

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

    Prompt Table: PERSONAL_DATA

    2 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    3 DISABLED_VET Character(1) VARCHAR2(1) NOT NULL Disabled Veteran

    Y/N Table Edit

    4 REG_DISABLED_NBR Character(10) VARCHAR2(10) NOT NULL Registered Disabled Number
    5 DISABILITY_CD_UK Character(3) VARCHAR2(3) NOT NULL Disability
    DXT=Manual Dexterity
    HRN=Hearing
    LRN=Learning
    MBL=Mobility
    MNH=Mental Handicap
    MNI=Mental Illness
    OTH=Other
    RSP=Respiratory
    SPC=Speech
    UNS=Unspecified
    VSN=Vision
    6 HANDICAP_PCENT_NLD Number(6,2) DECIMAL(5,2) NOT NULL Handicap Percent
    7 DISABILITY_ITA Character(3) VARCHAR2(3) NOT NULL Disability
    8 DISABILITY_PERCTG Number(3,0) SMALLINT NOT NULL Disability Percentage
    9 DISABILITY_CD_JPN Character(3) VARCHAR2(3) NOT NULL Disability Code
    10 COMMENTS Long Character CLOB Comment