NATIONAL_IDEFFDTDefault Value: %date
GPES_SSN_EMPLVW(SQL View) |
Index Back |
|---|---|
View SS Number - EmplidThis view links the SSN with the EmplID |
| SELECT N.NATIONAL_ID , A.EMPLID , A.EFFDT , A.EMPL_RCD FROM PS_JOB A , PS_PERS_NID N WHERE N.NATIONAL_ID_TYPE = 'SSN' AND N.COUNTRY = 'ESP' AND A.EMPLID = N.EMPLID AND A.PAY_SYSTEM_FLG = 'GP' AND A.HR_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NATIONAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |