HRS_APP_DISGR_I

(SQL View)
 Index Back

Applicant Disability - Germany

Germany specific App Disabilty information

SELECT HRS_PERSON_ID ,EFFDT ,END_EFFDT ,DISABLED_TYPE ,HANDICAP_PERCENT ,DISABLED_PERM_GER ,DISABILITY_EVAL_DT ,DIS_STATUS_OFFICE ,CITY ,POSTAL ,DISABLED_POSN_CNT ,DISABILITY_CARD_NO ,CARD_ISSUE_DT ,CARD_EXP_DT ,%subrec(HRS_AUDIT_SBR,A) FROM PS_HRS_APP_DIS_GER A

  • Parent record: HRS_APP_DIS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 END_EFFDT Date(10) DATE End Effdt
    4 DISABLED_TYPE Character(1) VARCHAR2(1) NOT NULL Disabled Type
    1=GT 50% Disabled. Not blind.
    2=Blind
    3=LT 50%, But GT 20% Disabled
    4=Equalized Disability
    5=25 - 49% Disabled (Saarland)
    6=Widow/Wife
    7=Miner Pension
    N=Not Disabled

    Default Value: N

    5 HANDICAP_PERCENT Number(3,0) SMALLINT NOT NULL Handicap Percent
    6 DISABLED_PERM_GER Character(1) VARCHAR2(1) NOT NULL Permanent Disability

    Y/N Table Edit

    7 DISABILITY_EVAL_DT Date(10) DATE Disability Evaluation Dt
    8 DIS_STATUS_OFFICE Character(4) VARCHAR2(4) NOT NULL Disability Status Office Type
    AA=Employment Office
    AFS=Social (and family) office
    BG=Other or par. 69 pas. 2 SGB IX
    BG=Employer's Liability Ins Assoc
    EIN=Office par. 35 SGB IX
    FST=Social Security Office
    FST=Social Security Office
    HFST=Main Social Security Office
    IA=Integration Office
    IA=Integration Office
    LAA=Regional Employment Office
    LAA=Regional Employment Office
    LRA=District Admin of a Land
    REGP=Chief Officer - District Admin
    REGP=Chief Officer - District Admin
    VA=Pension Office
    WFBM=Sheltered Workshop
    ZST=Document for Support of Mners
    9 CITY Character(30) VARCHAR2(30) NOT NULL City
    10 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    11 DISABLED_POSN_CNT Number(1,0) SMALLINT NOT NULL Disabled Position Count
    12 DISABILITY_CARD_NO Character(25) VARCHAR2(25) NOT NULL Disability Card Number
    13 CARD_ISSUE_DT Date(10) DATE Card Issue Date
    14 CARD_EXP_DT Date(10) DATE Card Expiration Date
    15 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    16 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    17 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    18 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id