SOCS_CCC_ESPLNG(SQL View) |
Index Back |
---|---|
Establishment ER Soc.Sec ViewEstablishment Employer Social Security View - ESP |
SELECT A.COMPANY , B.SSN_EMPLOYER , A.EFFDT , A1.LANGUAGE_CD , A1.DESCR FROM PS_ESTAB_TBL A , PS_ESTAB_SSEC_ESP B , PS_ESTAB_TBL_LANG A1 WHERE A.ESTABID = B.ESTABID AND A.EFFDT = B.EFFDT AND A.ESTABID = A1.ESTABID AND A.EFFDT = A1.EFFDT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
|
2 | Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number | |
3 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
4 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |