SOCS_AUTH_KEY_ESPSSN_EMPLOYEREMPLIDGPES_FIE_EE_VW(SQL View) |
Index Back |
|---|---|
FIE Employee VWThis view shows the employees by SSN Employer. It is used as edit table for DERIVED_GPES.EMPLID field |
| SELECT DISTINCT A.SOCS_AUTH_KEY_ESP , A.SSN_EMPLOYER , A.EMPLID , B.NAME FROM PS_GPES_FIE_EE A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOCS_AUTH_KEY_ESP |
Character(8) | VARCHAR2(8) NOT NULL | Authorization Key |
| 2 | SSN_EMPLOYER |
Character(13) | VARCHAR2(13) NOT NULL | Employer Social Security number |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |