ERE_PRCS_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	ERE_ID_ESP	Character(10)	VARCHAR2(10) NOT NULL	ERE ID
5	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
6	YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Calendar Year
7	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
8	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
9	ERE_TYP_PERM_ESP	Character(1)	VARCHAR2(1) NOT NULL	Permanent ERE type Y/N Table Edit Default Value: N
10	ERE_TYP_SUSP_ESP	Character(1)	VARCHAR2(1) NOT NULL	Suspension ERE type Y/N Table Edit Default Value: N
11	ERE_TYP_WSRD_ESP	Character(1)	VARCHAR2(1) NOT NULL	Work schedule reduction ERE type Y/N Table Edit Default Value: N
12	ERE_JD_UPD_FLG	Character(1)	VARCHAR2(1) NOT NULL	"ERE Data update" Job Data update flag. Y/N Table Edit
13	ERE_CN_UPD_FLG	Character(1)	VARCHAR2(1) NOT NULL	"ERE Data Update" Contract data update flag Y/N Table Edit
14	ERE_AB_UPD_FLG	Character(1)	VARCHAR2(1) NOT NULL	"ERE Data Update" Absence event update flag. Y/N Table Edit
15	ERE_TE_UPD_FLG	Character(1)	VARCHAR2(1) NOT NULL	"ERE Data Update" Manage termination update flag. Y/N Table Edit
16	ERE_BR_UPD_FLG	Character(1)	VARCHAR2(1) NOT NULL	BRD update flag Y/N Table Edit