XML_DEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	XMLFILE_ID	Character(50)	VARCHAR2(50) NOT NULL	XML File ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	XML_SET	Character(5)	VARCHAR2(5) NOT NULL	XML Set Prompt Table: XML_SET_TBL
4	XML_TEMPLATE_ID	Character(3)	VARCHAR2(3) NOT NULL	Template type Prompt Table: XML_TEMPLT_TBL
5	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
6	FILE_PATH	Character(127)	VARCHAR2(127) NOT NULL	Input/Output file path
7	FILE_NAME2	Character(80)	VARCHAR2(80) NOT NULL	File Name
8	FILE_PATH2	Character(127)	VARCHAR2(127) NOT NULL	File Path and Name
9	XMLFILE_RESPONS_ID	Character(20)	VARCHAR2(20) NOT NULL	Communication identification
10	FROM_DATE	Date(10)	DATE	From Date
11	TO_DATE	Date(10)	DATE	Latest Date to be sent to PYR
12	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
13	STATUS_ESP	Character(1)	VARCHAR2(1) NOT NULL	Communication Status C=XML File Created N=XML File No Generated S=XML File Sent and Confirmed Default Value: N
14	PROCESSED_ESP	Number(3,0)	SMALLINT NOT NULL	Processed Records
15	XML_FILTERBY	Character(1)	VARCHAR2(1) NOT NULL	Filter by 0=All Nodes 1=Simple Nodes
16	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
17	YEAR	Character(4)	VARCHAR2(4) NOT NULL	Character field to represent a year
18	INSUR_COMP_CD_ESP	Character(5)	VARCHAR2(5) NOT NULL	Insurance Company Code