EMPLIDE_ADDR_TYPEBUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
WEB=WebAddress
Default Value: WEB
A=Add
C=Change
D=Delete
SAE_LIS_WEB_RC(SQL Table) |
Index Back |
|---|
| # | 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 | ADDR_USAGE | Character(10) | VARCHAR2(10) NOT NULL | Address Usage |
| 4 | SAE_TARGET_ID | Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID |
| 5 | SAE_LIS_WEB_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
LIS Contact Info Type
WEB=WebAddress Default Value: WEB |
| 6 | SAE_LIS_WEB_LNAME | Character(30) | VARCHAR2(30) NOT NULL | LIS Web |
| 7 | URL_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | URL Address |
| 8 | SAE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Operation Mode
A=Add C=Change D=Delete |