SOCS_AUTH_KEY_ESPCOMPANYAUTH_CMP_ESP_VW(SQL View) |
Index Back |
|---|---|
Social Security Header SetupSocial Security Header Setup. |
| SELECT DISTINCT B.SOCS_AUTH_KEY_ESP , B.COMPANY , C.DESCR FROM PS_SOCS_SETHD_ESP B , PS_COMPANY_TBL C WHERE B.COMPANY = C.COMPANY AND C.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_COMPANY_TBL ED WHERE ED.COMPANY = C.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 |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |