HR_WC_APPR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID
5	APP_DT	Date(10)	DATE	Date an application was submitted
6	JOB_REQ_NBR	Character(6)	VARCHAR2(6) NOT NULL	Job requisition number
7	STATUS_DT	Date(10)	DATE	Status Date
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
10	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
11	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
12	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
13	WC_JCR_STATUS_DTTM	DateTime(26)	TIMESTAMP	Used by the functionnality Works Council Notification.
14	WC_COUNCIL_ID	Character(9)	VARCHAR2(9) NOT NULL	Works Council ID
15	APPROVAL_WEEK	Number(2,0)	SMALLINT NOT NULL	Works Council Setup Table
16	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
17	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag
18	ASOFDATE	Date(10)	DATE	As of Date
19	WC_DECISION_DTTM	DateTime(26)	TIMESTAMP	Works Council decision date/time
20	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)