WCS_MSS_ALRT_VW(SQL View) |
Index Back |
|---|---|
WCS MSS Alert MessagesView of an Employee's Manager Self Service Alert Messages with use be the WCS features. |
| SELECT EE.EMPLID , EE.WCS_ECM_EVENT_CD , EE.BUDGET_ID , EE.BUDGET_START_DT , EE.WCS_ALERT_DTTM , AL.OBJECTOWNERID , AL.HR_SSTEXT_SUB_ID , AL.TEXT_ID , AL.WCS_SS_TARGET_CD , EE.DATE_CREATED , EE.ALLOW_DELETE , EE.TREE_NODE_NUM , EE.WCS_SP_ACCESS_TYPE , AL.WCS_PREF_DISP_CD FROM PS_WCS_EE_ALERTS EE , PS_WCS_ALERT_TBL AL WHERE EE.WCS_ECM_EVENT_CD = AL.WCS_ECM_EVENT_CD AND EE.WCS_SP_ACCESS_TYPE <> 'C' AND (EE.START_DT <= %CurrentDateIn AND EE.END_DT >= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | WCS_ECM_EVENT_CD |
Character(3) | VARCHAR2(3) NOT NULL | WCS ECM Event Code |
| 3 | BUDGET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 4 | BUDGET_START_DT |
Date(10) | DATE | Budget Start Date |
| 5 | WCS_ALERT_DTTM |
DateTime(26) | TIMESTAMP NOT NULL |
Date/Time Stamp of Employee Alert Creation
Default Value: %DateTime |
| 6 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 7 | HR_SSTEXT_SUB_ID | Character(4) | VARCHAR2(4) NOT NULL | The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID. For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId. |
| 8 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL | Text ID |
| 9 | WCS_SS_TARGET_CD | Character(3) | VARCHAR2(3) NOT NULL |
Defines the target of a navigational link or launch selection made on the Application Alerts page by the User.
AT=Attachment Only GS=Group Summary Page NA=Not Applicable Default Value: GS |
| 10 | DATE_CREATED | Date(10) | DATE | A Date value used to capture a creation date for a record. |
| 11 | ALLOW_DELETE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Delete
Y/N Table Edit Default Value: N |
| 12 | TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 13 | WCS_SP_ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type/Role
A=Confirmer C=Compensation Adminstrator R=Reviewer S=Submitter |
| 14 | WCS_PREF_DISP_CD | Character(4) | VARCHAR2(4) NOT NULL |
Preferred Date Range Display Code.
Although this has a slightly different usage, it shares the same set of translates as the WCS_EVT_DISP_CD field definition.
COMM=Notification Period DFLT=Default OPNR=Review Period OPNU=Update Period |