HRS_APP_DIS_ESP(SQL Table) |
Index Back |
---|---|
Applicant Disability - SpainSpain specific App Disabilty information |
# | 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 |