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 |