HRS_APP_DIS_ESP

(SQL Table)
Index Back

Applicant Disability - Spain

Spain specific App Disabilty information

  • 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 HRS_SUBMITTED_DTTM DateTime(26) TIMESTAMP Submitted Date Time
    5 DISABLE_TYPE_ESP Character(3) VARCHAR2(3) NOT NULL Disability Type
    F=Physical Disability
    N=Non Disability
    P=Psychological Disability
    S=Sensorial Disability
    6 HANDICAP_PCNT_ESP Number(3,0) SMALLINT NOT NULL Handicap Percent
    7 DISAB_EVAL_DT_ESP Date(10) DATE Disability Evaluation Dt
    8 DISAB_CARD_NO_ESP Character(10) VARCHAR2(10) NOT NULL Disalbility Card No.
    9 CARD_ISSUE_DT_ESP Date(10) DATE Card Issue Date
    10 CARD_EXP_DT_ESP Date(10) DATE Card Expiration Date
    11 DIS_STATUS_OFF_ESP Character(4) VARCHAR2(4) NOT NULL Disability Status Office
    FST=Social Security Office
    HFST=Main Social Security Office
    LAA=Regional Employment Office
    LRA=District Admin of a Land
    REGP=Chief Officer - District Admin
    VA=Land War Pension Office
    ZST=Document for support of miners
    12 CITY Character(30) VARCHAR2(30) NOT NULL City
    13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    14 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    15 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    16 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    17 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id