WC_USER_NOTIFY

(SQL Table)
Index Back

WC User notified

Used by the functionnality Works Council Notification.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WC_JCR_STATUS 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 Code
N=Customer Data
S=Sample Data
Y=System Data