WC_ACTN_RSN_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region Default Value: OPR_DEF_TBL_HR.REG_REGION Prompt Table: REG_STANDARD_VW
2	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
3	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	CHECKLIST_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Code Prompt Table: CHECKLIST_TBL
7	WC_NEW_MGR_SW	Character(1)	VARCHAR2(1) NOT NULL	Used by the functionnality Works Council Notification. Y/N Table Edit Default Value: N
8	WC_SRCH_BIRTHDT_SW	Character(1)	VARCHAR2(1) NOT NULL	Used by the functionnality Works Council Notification. Y/N Table Edit Default Value: N
9	WC_SRCH_DEPTID_SW	Character(1)	VARCHAR2(1) NOT NULL	Used by the functionnality Works Council Notification. Y/N Table Edit Default Value: N
10	WC_SRCH_EMPLID_SW	Character(1)	VARCHAR2(1) NOT NULL	Used by the functionnality Works Council Notification. Y/N Table Edit Default Value: N
11	WC_SRCH_FNAME_SW	Character(1)	VARCHAR2(1) NOT NULL	Used by the functionnality Works Council Notification. Y/N Table Edit Default Value: N
12	WC_SRCH_LNAME_SW	Character(1)	VARCHAR2(1) NOT NULL	Used by the functionnality Works Council Notification. Y/N Table Edit Default Value: N
13	WC_SRCH_PERSTAT_SW	Character(1)	VARCHAR2(1) NOT NULL	Used by the functionnality Works Council Notification. Y/N Table Edit Default Value: N
14	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: N