EMPLIDSAE_TARGET_IDSAE_LIS_WEB_TYPEWEB=WebAddress
Default Value: WEB
E_ADDR_TYPEBUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
A=Add
C=Change
D=Delete
SAE_LIS_WEB_VW(SQL View) |
Index Back |
|---|
| SELECT URL.EMPLID , WEBMAP.SAE_TARGET_ID ,WEBMAP.SAE_LIS_WEB_TYPE , URL.E_ADDR_TYPE , XLAT.XLATLONGNAME SAE_LIS_WEB_LNAME , URL.URL_ADDRESS , 'A' SAE_MODE FROM %Table(URL_ADDRESSES) URL , %Table(SAE_LIS_WEBMAP) WEBMAP , PSXLATITEM XLAT WHERE URL.E_ADDR_TYPE = WEBMAP.E_ADDR_TYPE AND XLAT.FIELDNAME = 'SAE_LIS_WEB_TYPE' AND XLAT.FIELDVALUE = WEBMAP.SAE_LIS_WEB_TYPE AND %EffdtCheck(PSXLATITEM XL, XLAT, %CurrentDateIn) AND XLAT.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SAE_TARGET_ID |
Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID |
| 3 | SAE_LIS_WEB_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
LIS Contact Info Type
WEB=WebAddress Default Value: WEB |
| 4 | 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 |
| 5 | SAE_LIS_WEB_LNAME | Character(30) | VARCHAR2(30) NOT NULL | LIS Web |
| 6 | URL_ADDRESS | Character(254) | VARCHAR2(254) NOT NULL | URL Address |
| 7 | SAE_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Operation Mode
A=Add C=Change D=Delete |