EONC_USER_LIST_IDEONC_ULST_PR_VW(SQL View) |
Index Back |
|---|---|
Prompt for User List |
| SELECT U.EONC_USER_LIST_ID , U.DESCR100 , X1.XLATSHORTNAME , CASE WHEN EONC_USER_SOURCE = 'C' THEN U.PACKAGEROOT || ' ' ||U.APPCLASS_PATH || ' ' ||U.APP_CLASS || ' ' ||U.METHODNAME WHEN EONC_USER_SOURCE = 'Q' THEN U.QRYNAME WHEN EONC_USER_SOURCE = 'R' THEN U.ROLENAME WHEN EONC_USER_SOURCE = 'S' THEN U.SQLID END FROM PS_EONC_USRLST_HDR U , PSXLATITEM X1 WHERE X1.FIELDNAME= 'EONC_USER_SOURCE' AND X1.FIELDVALUE = U.EONC_USER_SOURCE AND %EffdtCheck(PSXLATITEM X2, X1, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EONC_USER_LIST_ID |
Character(30) | VARCHAR2(30) NOT NULL | Identifies the user list to be used when creating the notification. |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 3 | EONC_ULIST_TYPE | Character(10) | VARCHAR2(10) NOT NULL | User List Type |
| 4 | EONC_OBJ_NAME | Character(100) | VARCHAR2(100) NOT NULL | Role/SQL/Query/App Package |