SAD_UC_IMPRFXML

(SQL Table)
Index Back

UCAS XML Sync Import Applicant

# 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_LASTTIMESTP DateTime(26) TIMESTAMP Last Run Timestamp
10 SAD_UC_APPYEAR Character(4) VARCHAR2(4) NOT NULL UCAS Admissions Cycle
11 SAD_UC_ROWPOSREP Number(10,0) DECIMAL(10) NOT NULL Row Position
12 SAD_UC_UCMOREROWS Character(10) VARCHAR2(10) NOT NULL More rows available
13 SAD_UC_UCXMLSTAT Character(10) VARCHAR2(10) NOT NULL XML Sync Status
14 SAD_UC_UCERRCODE Character(10) VARCHAR2(10) NOT NULL Error code
15 SAD_UC_UCFAULT Character(10) VARCHAR2(10) NOT NULL Fault
16 SAD_UC_ERROR_MSG Long Character CLOB Field for DFE Apply