WC_USER_NOTIFY(SQL Table) |
Index Back |
|---|---|
WC User notifiedUsed by the functionnality Works Council Notification. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(1) | VARCHAR2(1) NOT NULL |
Job Change Request status.
Used by the functionnality Works Council Notification.
A=Requested by Manager B=Requested by HR C=Approved by Current Manager D=Denied by Current Manager E=Works Cncl Approval Requested F=Denied by HR G=Approved by Works Council H=Denied by Works Council I=Works Council Overridden by HR J=Job Change Complete K=Default Approval by Works Cncl L=CI Failed N=New |
|
| 2 | WC_SUBJECT_SET_NBR | Number(5,0) | INTEGER NOT NULL | Used by the functionnality Works Council Notification. |
| 3 | WC_SUBJECT_MSG_NBR | Number(5,0) | INTEGER NOT NULL | Used by the functionnality Works Council Notification. |
| 4 | WC_EXPLAIN_SET_NBR | Number(5,0) | INTEGER NOT NULL | Used by the functionnality Works Council Notification. |
| 5 | WC_EXPLAIN_MSG_NBR | Number(5,0) | INTEGER NOT NULL | Used by the functionnality Works Council Notification. |
| 6 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data |