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 |