WC_JCR_SRCH (SQL View)	Index Back
WC notification Works Council notification, Used to search employees whose job has been changed . Action And Reason can also be used as the criteria.

WC_JCR_SRCH

(SQL View)

WC notification

Works Council notification, Used to search employees whose job has been changed . Action And Reason can also be used as the criteria.

SELECT EMPLID ,EMPL_RCD ,REG_REGION , ACTION_REASON , EFFDT ,ACTION FROM PS_WC_JOB_CHG_REQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

4 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

6 WC_ACTION Character(3) VARCHAR2(3) NOT NULL Action

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
4	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	WC_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action