COMPANYPrompt Table: COMPANY_TBL
SSN_EMPLOYEREFFDTDefault Value: %date
A=Active
I=Inactive
1=Regular
2=Apprenticeship
3=Training
SOCS_CCC_ESP_VW(SQL View) |
Index Back |
|---|---|
Establishment ER Soc.Sec ViewEstablishment Employer Social Security View - ESP |
| SELECT A.COMPANY , B.SSN_EMPLOYER , A.EFFDT , A.EFF_STATUS , B.SSN_EMPL_TYPE , A.DESCR , B.SCHEME_ID_ESP FROM PS_ESTAB_TBL A , PS_ESTAB_SSEC_ESP B WHERE A.ESTABID = B.ESTABID AND A.EFFDT = B.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | SSN_EMPL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Social Security Number Type
1=Regular 2=Apprenticeship 3=Training |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | SCHEME_ID_ESP | Character(4) | VARCHAR2(4) NOT NULL | Scheme ID - ESP |