EMPLIDWCS_ECM_EVENT_CDBUDGET_IDBUDGET_START_DTWCS_ALERT_DTTMDefault Value: %DateTime
A=Confirmer
C=Compensation Adminstrator
R=Reviewer
S=Submitter
Y/N Table Edit
Default Value: N
WCS_EE_ALERTS(SQL Table) |
Index Back |
|---|---|
WCS Employee Alert MessagesThis table cotains the Employee's Alert Messages. |
| # | 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 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | DATE_CREATED | Date(10) | DATE | A Date value used to capture a creation date for a record. |
| 9 | TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 10 | WCS_SP_ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type/Role
A=Confirmer C=Compensation Adminstrator R=Reviewer S=Submitter |
| 11 | ALLOW_DELETE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Delete
Y/N Table Edit Default Value: N |