SAD_UC_REFERENC(SQL Table) |
Index Back |
|---|---|
IvReference/IvgReference BaseIvReference/IvgReference Base Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INST_CAR_SCTY |
| 2 | SAD_UC_APPCODE |
Character(10) | VARCHAR2(10) NOT NULL | Application Code |
| 3 | SAD_UC_PERS_ID |
Character(10) | VARCHAR2(10) NOT NULL | Personalid - Unique personal identifier |
| 4 | SAD_UC_REFEREETYPE |
Character(30) | VARCHAR2(30) NOT NULL |
Referee Type
P=Principal Referee S=Second Referee Default Value: P |
| 5 | SAD_UC_REFERENC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Reference ID |
| 6 | SAD_UC_TIMESTAMP |
DateTime(26) | TIMESTAMP | Timestamp |
| 7 | SAD_UC_REFEREENAME | Character(200) | VARCHAR2(200) NOT NULL | Referee's Name |
| 8 | SAD_UC_REFEREEPOST | Character(40) | VARCHAR2(40) NOT NULL | Post held by Referee |
| 9 | SAD_UC_ESTABNAME | Character(70) | VARCHAR2(70) NOT NULL | Referee's School or Other Establishment |
| 10 | SAD_UC_FTIMECOUNT | Character(5) | VARCHAR2(5) NOT NULL | Full Time Count |
| 11 | SAD_UC_PTIMECOUNT | Character(5) | VARCHAR2(5) NOT NULL | Part Time Count |
| 12 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: SCC_CNT_ADFMTVW |
| 13 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 14 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 15 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 16 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 17 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 18 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 19 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 20 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference WW=House Trailer Reference |
| 21 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 22 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 23 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 24 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 25 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 26 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 27 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 28 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 29 | SAD_UC_TELEPHONE | Character(35) | VARCHAR2(35) NOT NULL | Telephone |
| 30 | SAD_UC_FAX | Character(35) | VARCHAR2(35) NOT NULL | Fax |
| 31 | SAD_UC_EMAIL | Character(100) | VARCHAR2(100) NOT NULL | |
| 32 | SAD_UC_QUALSCHECKD | Character(1) | VARCHAR2(1) NOT NULL |
Quals Checked
Y/N Table Edit |
| 33 | SAD_UC_STATEMENT | Long Character(10240) | CLOB | Referee's Statement |
| 34 | SAD_UC_PREDICTDGRD | Character(250) | VARCHAR2(250) NOT NULL | Predicted Grades |
| 35 | SAD_UC_PREDICTGRD1 | Character(250) | VARCHAR2(250) NOT NULL | Predicted Grades |
| 36 | SAD_UC_PREDICTGRD2 | Character(250) | VARCHAR2(250) NOT NULL | Predicted Grades |
| 37 | SAD_UC_PREDICTGRD3 | Character(250) | VARCHAR2(250) NOT NULL | Predicted Grades |
| 38 | SAD_UC_SYSTEM | Character(4) | VARCHAR2(4) NOT NULL |
UCAS System
APPL=Apply GTTR=UTT GTTR=UTT UCAS=UCAS |
| 39 | SAD_UC_PREPRACGRDS | Long Character(300) | VARCHAR2(300) | Predicted Grades |
| 40 | SAD_UC_RELATION | Long Character(1330) | VARCHAR2(1330) | Field for DFE API |
| 41 | SAD_UC_SAFEG_CON | Character(1) | VARCHAR2(1) NOT NULL | Safeguarding concerns |
| 42 | SAD_UC_DEF_NBR | Character(7) | VARCHAR2(7) NOT NULL | DfE Number |
| 43 | SAD_UC_HE_COUNT | Number(4,0) | SMALLINT NOT NULL | HE Count |
| 44 | SAD_UC_SCHOOLTEXT | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 45 | SAD_UC_ROLL_COUNT | Number(5,0) | INTEGER NOT NULL | Roll Count |