PROCESS_INSTANCEEXP=Log Expired Alerts
LOG=Log Alerts
PRG=Purge Alerts
PRX=Purge Expired Alerts
A=Confirmer
C=Compensation Adminstrator
R=Reviewer
S=Submitter
WCS_ALERTS_AET(SQL Table) |
Index Back |
|---|---|
Alert Maintenance Run ControlThis record defines the proccessing of the Alerts table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | WCS_ALERTS_ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Processing action for Alerts Maintenance
EXP=Log Expired Alerts LOG=Log Alerts PRG=Purge Alerts PRX=Purge Expired Alerts |
| 5 | BUDGET_ID | Character(10) | VARCHAR2(10) NOT NULL | Budget ID |
| 6 | BUDGET_START_DT | Date(10) | DATE | Budget Start Date |
| 7 | TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 8 | WCS_SP_ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type/Role
A=Confirmer C=Compensation Adminstrator R=Reviewer S=Submitter |
| 9 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 10 | WCS_ECM_EVENT_CD | Character(3) | VARCHAR2(3) NOT NULL | WCS ECM Event Code |
| 11 | DATE_CREATED | Date(10) | DATE | A Date value used to capture a creation date for a record. |
| 12 | START_DT | Date(10) | DATE | Start Date |
| 13 | END_DT | Date(10) | DATE | end date |
| 14 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 15 | TABLENAME | Character(32) | VARCHAR2(32) NOT NULL | |
| 16 | MSGNUM | Number(5,0) | INTEGER NOT NULL | Message Number |
| 17 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 18 | HR_SSTEXT_TEXT | Long Character(8095) | CLOB | Long Text field for HR Self-Service Text Catalog. This is the text that is displayed on a page from the Text Catalog. |
| 19 | 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. |
| 20 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 21 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 22 | WCS_ALERT_DTTM | DateTime(26) | TIMESTAMP | Date/Time Stamp of Employee Alert Creation |