SCC_DISAESP_PVW(SQL View) |
Index Back |
|---|---|
Disability Spain viewDisability Spain staging view |
| SELECT PROCESS_INSTANCE ,SCC_SEQ_ID ,SCC_SEQ_ID3 ,EMPLID ,EFFDT ,DISABLE_TYPE_ESP ,HANDICAP_PCNT_ESP ,DISAB_EVAL_DT_ESP ,DISAB_CARD_NO_ESP ,CARD_ISSUE_DT_ESP ,CARD_EXP_DT_ESP ,DIS_STATUS_OFF_ESP ,CITY ,POSTAL ,HELP_GO_WRK_ESP_SW ,AUDIT_ACTN FROM PS_SCC_DISAESP_STG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SCC_SEQ_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence ID |
| 3 | SCC_SEQ_ID3 |
Number(3,0) | SMALLINT NOT NULL | Sequence Nbr |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EFFDT | Date(10) | DATE | Effective Date |
| 6 | DISABLE_TYPE_ESP | Character(3) | VARCHAR2(3) NOT NULL |
Disability Type
F=Physical Disability N=Non Disability P=Psychological Disability S=Sensorial Disability |
| 7 | HANDICAP_PCNT_ESP | Number(3,0) | SMALLINT NOT NULL | Handicap Percent |
| 8 | DISAB_EVAL_DT_ESP | Date(10) | DATE | Disability Evaluation Dt |
| 9 | DISAB_CARD_NO_ESP | Character(10) | VARCHAR2(10) NOT NULL | Disalbility Card No. |
| 10 | CARD_ISSUE_DT_ESP | Date(10) | DATE | Card Issue Date |
| 11 | CARD_EXP_DT_ESP | Date(10) | DATE | Card Expiration Date |
| 12 | 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 |
| 13 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 14 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 15 | HELP_GO_WRK_ESP_SW | Character(1) | VARCHAR2(1) NOT NULL | Help to Go to Work |
| 16 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |