ACTV_INTERV_ESP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_GBL
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: EMPLOYMENT
3	YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Calendar Year Default Value: ACTV_PERIOD_ESP.YEARCD
4	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 Default Value: ACTV_PERIOD_ESP.MONTHCD
5	ERE_ID_ESP	Character(10)	VARCHAR2(10) NOT NULL	ERE ID Default Value: ACTV_PERIOD_ESP.ERE_ID_ESP
6	BEGIN_DT	Date(10)	DATE	Begin Date Default Value: ACTV_PERIOD_ESP.BEGIN_DT
7	END_DT	Date(10)	DATE	end date Default Value: ACTV_PERIOD_ESP.END_DT
8	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
9	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
10	ACTV_CODE_ESP	Character(2)	VARCHAR2(2) NOT NULL	Report as XML flag 01=No Activity 02=No Activity due Push Back Call 03=Activity 04=Maternity / IT 05=Vacations / Weekends Default Value: 01