COMPANYPrompt Table: COMPANY_TBL
GPNL_SOC_NUMESTABIDPrompt Table: ESTAB_TBL
EFFDTDefault Value: %date
GPNL_ESTB_VW(SQL View) |
Index Back |
|---|---|
Establishment ER Soc.Sec ViewEstablishment Employer Social Security View - NLD |
| SELECT C.COMPANY , B.GPNL_SOC_NUM , A.ESTABID , A.EFFDT , A.DESCR FROM PS_ESTAB_TBL A ,PS_GPNL_ESTAB_TBL B ,PS_COMPANY_TBL C WHERE A.ESTABID = B.ESTABID AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_GPNL_ESTAB_TBL D WHERE D.ESTABID = B.ESTABID) AND A.COMPANY = C.COMPANY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | GPNL_SOC_NUM |
Character(20) | VARCHAR2(20) NOT NULL | Social Security Number |
| 3 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |