RE_EMP_PHN_W(SQL View) |
Index Back |
---|---|
employees' work phone |
SELECT A.EMPLID , B.RS_PHONE FROM %Table(RE_CAFM_EMP_STG) A , %Table(RS_WRKR_PHONE) B WHERE A.EMPLID = B.EMPLID (+) AND RS_PHONE_TYPE = 'WORK' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
2 | RS_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Phone number. |