SAE_LIS_EMLMAP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SAE_TARGET_ID |
Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID |
| 2 | SAE_PRSN_DEF_FLAG |
Character(4) | VARCHAR2(4) NOT NULL |
Default Flag
D=Default U=User Defined Default Value: U |
| 3 | SAE_LIS_EMAIL_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
LIS Contact Info Type
EMHP=EmailHomePrimary EMHS=EmailHomeSecondary EMLP=EmailPrimary EMLS=EmailSecondary EMPP=EmailPersonalPrimary EMPS=EmailPersonalSecondary EMSP=EmailSchoolPrimary EMSS=EmailSchoolSecondary EMWP=EmailWorkPrimary EMWS=EmailWorkSecondary IMSG=InstantMessage |
| 4 | SAE_CS_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 PRF=Preferred |