EMPLIDE_ADDR_TYPEBUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
LANGUAGE_CDEFFDTLSEMALTYPEVW_LN(SQL View) |
Index Back |
|---|---|
Rel Lang Translate View for SAUsed as a prompt table for SA. It has special list box characteristics which make it useful as a prompt table for all fields prompting against the translate table. |
| SELECT DISTINCT C.EMPLID , A.FIELDVALUE , A.LANGUAGE_CD , A.EFFDT , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A , PS_HCR_PERSON_I C WHERE A.FIELDNAME = 'E_ADDR_TYPE' AND %EffdtCheck(PSXLATITEMLANG XL, A, %CurrentDateIn) AND A.FIELDVALUE NOT IN ( SELECT E_ADDR_TYPE FROM PS_TYPE_CNTL_EMAIL WHERE TYPE_CONTROL = 'N') |
| # | 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 Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 6 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |