SSN_EMPLOYER1=Regular
2=Apprenticeship
3=Training
GPES_SINS_SSNVW(SQL View) |
Index Back |
|---|---|
SSN-Company Self-InsuranceSSN Employer-Company Self-Insurance |
| SELECT A.SSN_EMPLOYER , A.SSN_EMPL_TYPE , B.COMPANY , B.DESCR , C.DESCR FROM PS_ESTAB_SSEC_ESP A , PS_ESTAB_TBL B , PS_COMPANY_TBL C WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ESTAB_SSEC_ESP A_ED WHERE A.ESTABID = A_ED.ESTABID AND A_ED.EFFDT <= %CurrentDateIn) AND A.ESTABID = B.ESTABID AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_ESTAB_TBL B_ED WHERE B.ESTABID = B_ED.ESTABID AND B_ED.EFFDT <= A.EFFDT) AND C.COMPANY = B.COMPANY AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_COMPANY_TBL C_ED WHERE C.COMPANY = C_ED.COMPANY AND C_ED.EFFDT <= B.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 2 | SSN_EMPL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Social Security Number Type
1=Regular 2=Apprenticeship 3=Training |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |