EMPLIDE_ADDR_TYPEBUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
LANGUAGE_CDHRS_FND_EML_LN(SQL View) |
Index Back |
|---|---|
Related Language RecordRelated Language Record for HRS_FND_EML_VW |
| SELECT A.EMPLID , B.E_ADDR_TYPE , A.LANGUAGE_CD , A.NAME_DISPLAY FROM PS_HRS_PERSON_NM_L A , PS_HRS_PER_EMAIL_I B WHERE A.EMPLID=B.EMPLID AND (EXISTS ( SELECT 'X' FROM PS_HRS_ACTJOB_I WHERE EMPLID = A.EMPLID) OR EXISTS ( SELECT 'X' FROM PS_HRS_ACTPOI_I WHERE EMPLID = A.EMPLID)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | E_ADDR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Email Type
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |