SAD_UC_IMPAPXML

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SAD_UC_UCMETHOD	Character(30)	VARCHAR2(30) NOT NULL	UCAS XML Sync method
2	SAD_UC_APPDATE	Date(10)	DATE	Application Date
3	PROCESSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
5	SAD_UC_UCIDXML	Character(100)	VARCHAR2(100) NOT NULL	XML-Link User ID
6	SAD_UC_UCPWXML	Character(50)	VARCHAR2(50) NOT NULL	XML-Link Password
7	SAD_UC_ROWPOS	Number(10,0)	DECIMAL(10) NOT NULL	Row Position
8	SAD_UC_INST	Character(3)	VARCHAR2(3) NOT NULL	UCAS Institution Code
9	SAD_UC_APPCODE	Character(10)	VARCHAR2(10) NOT NULL	Application Code
10	SAD_UC_PERS_ID	Character(10)	VARCHAR2(10) NOT NULL	Personalid - Unique personal identifier
11	SAD_UC_LASTTIMESTP	DateTime(26)	TIMESTAMP	Last Run Timestamp
12	SAD_UC_SCHOOL	Character(10)	VARCHAR2(10) NOT NULL	UCAS School
13	SAD_UC_APPYEAR	Character(4)	VARCHAR2(4) NOT NULL	UCAS Admissions Cycle
14	SAD_UC_ROWPOSREP	Number(10,0)	DECIMAL(10) NOT NULL	Row Position
15	SAD_UC_UCMOREROWS	Character(10)	VARCHAR2(10) NOT NULL	More rows available
16	SAD_UC_UCXMLSTAT	Character(10)	VARCHAR2(10) NOT NULL	XML Sync Status
17	SAD_UC_UCERRCODE	Character(10)	VARCHAR2(10) NOT NULL	Error code
18	SAD_UC_UCFAULT	Character(10)	VARCHAR2(10) NOT NULL	Fault
19	SAD_UC_ERROR_MSG	Long Character	CLOB	Field for DFE Apply