SOCS_AUTH_KEY_ESPCOMPANYPrompt Table: COMPANY_TBL
SSN_EMPLOYERLANGUAGE_CDEFFDTDefault Value: %date
GPES_SOCAUT_LNG(SQL View) |
Index Back |
|---|---|
SS AuthorizationSS Authorization Related language record. |
| SELECT CC.SOCS_AUTH_KEY_ESP ,CC.COMPANY ,CC.SSN_EMPLOYER ,SS.LANGUAGE_CD ,CC.EFFDT ,SS.DESCR FROM PS_GPES_AUTH_CCCVW CC , PS_SOCS_ALL_CCCLNG SS WHERE CC.SSN_EMPLOYER = SS.SSN_EMPLOYER AND CC.COMPANY = SS.COMPANY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOCS_AUTH_KEY_ESP |
Character(8) | VARCHAR2(8) NOT NULL | Authorization Key |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |