INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SAD_UC_APPCODESAD_UC_PERS_IDE=Error (E)
I=Imported (I)
N=New (N)
P=Pending (P)
R=Pending (R)
T=Error (T)
SAD_UC_I_IVSTJ(SQL Table) |
Index Back |
|---|---|
IVSTARJ Staging record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 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_TIMESTAMP | DateTime(26) | TIMESTAMP | Timestamp |
| 5 | SAD_UC_SCN | Character(9) | VARCHAR2(9) NOT NULL | Scottish Candidate Number |
| 6 | SAD_UC_SURNAME | Character(60) | VARCHAR2(60) NOT NULL | Surname |
| 7 | SAD_UC_FORENAMES | Character(60) | VARCHAR2(60) NOT NULL | Forenames |
| 8 | SAD_UC_BIRTHDT | Date(10) | DATE | Date of Birth |
| 9 | SAD_UC_GENDER | Character(1) | VARCHAR2(1) NOT NULL | Gender |
| 10 | SAD_UC_APR | Character(4) | VARCHAR2(4) NOT NULL | Area Of Permanent Residency |
| 11 | SAD_UC_NATIONALITY | Character(4) | VARCHAR2(4) NOT NULL | Nationality |
| 12 | SAD_UC_ETHNIC | Character(3) | VARCHAR2(3) NOT NULL | Ethnic Code |
| 13 | SAD_UC_DISABLE | Character(2) | VARCHAR2(2) NOT NULL | Disability Code |
| 14 | SAD_UC_YRLLINST | Number(4,0) | SMALLINT NOT NULL | School Leaving Year |
| 15 | SAD_UC_QUALENT2 | Character(3) | VARCHAR2(3) NOT NULL | Highest Qualification |
| 16 | SAD_UC_POSTCODE | Character(8) | VARCHAR2(8) NOT NULL | Postcode |
| 17 | SAD_UC_SOCIOECON | Character(1) | VARCHAR2(1) NOT NULL | Socio-Economic Classification |
| 18 | SAD_UC_POCC | Character(4) | VARCHAR2(4) NOT NULL | Parental Occupation |
| 19 | SAD_UC_PREVINST | Character(8) | VARCHAR2(8) NOT NULL | Previous Institution |
| 20 | SAD_UC_PGCECLSS | Character(2) | VARCHAR2(2) NOT NULL | PGCE Degree Class |
| 21 | SAD_UC_WELBACC | Character(2) | VARCHAR2(2) NOT NULL | Welsh Bacc Adv Dip |
| 22 | SAD_UC_NATIOND | Character(2) | VARCHAR2(2) NOT NULL | Primary National Identity |
| 23 | SAD_UC_QUALGRADE1 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 1 |
| 24 | SAD_UC_QUALGRADE2 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 2 |
| 25 | SAD_UC_QUALGRADE3 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 3 |
| 26 | SAD_UC_QUALGRADE4 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 4 |
| 27 | SAD_UC_QUALGRADE5 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 5 |
| 28 | SAD_UC_QUALGRADE6 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 6 |
| 29 | SAD_UC_QUALGRADE7 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 7 |
| 30 | SAD_UC_QUALGRADE8 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 8 |
| 31 | SAD_UC_QUALGRADE9 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 9 |
| 32 | SAD_UC_QUALGRADE10 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 10 |
| 33 | SAD_UC_QUALGRADE11 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 11 |
| 34 | SAD_UC_QUALGRADE12 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 12 |
| 35 | SAD_UC_QUALGRADE13 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 13 |
| 36 | SAD_UC_QUALGRADE14 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 14 |
| 37 | SAD_UC_QUALGRADE15 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 15 |
| 38 | SAD_UC_QUALGRADE16 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 16 |
| 39 | SAD_UC_QUALGRADE17 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 17 |
| 40 | SAD_UC_QUALGRADE18 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 18 |
| 41 | SAD_UC_QUALGRADE19 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 19 |
| 42 | SAD_UC_QUALGRADE20 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 20 |
| 43 | SAD_UC_QUALGRADE21 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 21 |
| 44 | SAD_UC_QUALGRADE22 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 22 |
| 45 | SAD_UC_QUALGRADE23 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 23 |
| 46 | SAD_UC_QUALGRADE24 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 24 |
| 47 | SAD_UC_QUALGRADE25 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 25 |
| 48 | SAD_UC_QUALGRADE26 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 26 |
| 49 | SAD_UC_QUALGRADE27 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 27 |
| 50 | SAD_UC_QUALGRADE28 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 28 |
| 51 | SAD_UC_QUALGRADE29 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 29 |
| 52 | SAD_UC_QUALGRADE30 | Character(11) | VARCHAR2(11) NOT NULL | Final grade for Qual 30 |
| 53 | SAD_UC_QUALSIT1 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 1 |
| 54 | SAD_UC_QUALSIT2 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 2 |
| 55 | SAD_UC_QUALSIT3 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 3 |
| 56 | SAD_UC_QUALSIT4 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 4 |
| 57 | SAD_UC_QUALSIT5 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 5 |
| 58 | SAD_UC_QUALSIT6 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 6 |
| 59 | SAD_UC_QUALSIT7 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 7 |
| 60 | SAD_UC_QUALSIT8 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 8 |
| 61 | SAD_UC_QUALSIT9 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 9 |
| 62 | SAD_UC_QUALSIT10 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 10 |
| 63 | SAD_UC_QUALSIT11 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 11 |
| 64 | SAD_UC_QUALSIT12 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 12 |
| 65 | SAD_UC_QUALSIT13 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 13 |
| 66 | SAD_UC_QUALSIT14 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 14 |
| 67 | SAD_UC_QUALSIT15 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 15 |
| 68 | SAD_UC_QUALSIT16 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 16 |
| 69 | SAD_UC_QUALSIT17 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 17 |
| 70 | SAD_UC_QUALSIT18 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 18 |
| 71 | SAD_UC_QUALSIT19 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 19 |
| 72 | SAD_UC_QUALSIT20 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 20 |
| 73 | SAD_UC_QUALSIT21 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 21 |
| 74 | SAD_UC_QUALSIT22 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 22 |
| 75 | SAD_UC_QUALSIT23 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 23 |
| 76 | SAD_UC_QUALSIT24 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 24 |
| 77 | SAD_UC_QUALSIT25 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 25 |
| 78 | SAD_UC_QUALSIT26 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 26 |
| 79 | SAD_UC_QUALSIT27 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 27 |
| 80 | SAD_UC_QUALSIT28 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 28 |
| 81 | SAD_UC_QUALSIT29 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 29 |
| 82 | SAD_UC_QUALSIT30 | Character(2) | VARCHAR2(2) NOT NULL | Exam Sitting 30 |
| 83 | SAD_UC_QUALSBJ1 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 1 |
| 84 | SAD_UC_QUALSBJ2 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 2 |
| 85 | SAD_UC_QUALSBJ3 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 3 |
| 86 | SAD_UC_QUALSBJ4 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 4 |
| 87 | SAD_UC_QUALSBJ5 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 5 |
| 88 | SAD_UC_QUALSBJ6 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 6 |
| 89 | SAD_UC_QUALSBJ7 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 7 |
| 90 | SAD_UC_QUALSBJ8 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 8 |
| 91 | SAD_UC_QUALSBJ9 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 9 |
| 92 | SAD_UC_QUALSBJ10 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 10 |
| 93 | SAD_UC_QUALSBJ11 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 11 |
| 94 | SAD_UC_QUALSBJ12 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 12 |
| 95 | SAD_UC_QUALSBJ13 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 13 |
| 96 | SAD_UC_QUALSBJ14 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 14 |
| 97 | SAD_UC_QUALSBJ15 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 15 |
| 98 | SAD_UC_QUALSBJ16 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 16 |
| 99 | SAD_UC_QUALSBJ17 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 17 |
| 100 | SAD_UC_QUALSBJ18 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 18 |
| 101 | SAD_UC_QUALSBJ19 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 19 |
| 102 | SAD_UC_QUALSBJ20 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 20 |
| 103 | SAD_UC_QUALSBJ21 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 21 |
| 104 | SAD_UC_QUALSBJ22 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 22 |
| 105 | SAD_UC_QUALSBJ23 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 23 |
| 106 | SAD_UC_QUALSBJ24 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 24 |
| 107 | SAD_UC_QUALSBJ25 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 25 |
| 108 | SAD_UC_QUALSBJ26 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 26 |
| 109 | SAD_UC_QUALSBJ27 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 27 |
| 110 | SAD_UC_QUALSBJ28 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 28 |
| 111 | SAD_UC_QUALSBJ29 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 29 |
| 112 | SAD_UC_QUALSBJ30 | Character(6) | VARCHAR2(6) NOT NULL | ABL Subject Code 30 |
| 113 | SAD_UC_QUALTYPE1 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 1 |
| 114 | SAD_UC_QUALTYPE2 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 2 |
| 115 | SAD_UC_QUALTYPE3 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 3 |
| 116 | SAD_UC_QUALTYPE4 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 4 |
| 117 | SAD_UC_QUALTYPE5 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 5 |
| 118 | SAD_UC_QUALTYPE6 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 6 |
| 119 | SAD_UC_QUALTYPE7 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 7 |
| 120 | SAD_UC_QUALTYPE8 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 8 |
| 121 | SAD_UC_QUALTYPE9 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 9 |
| 122 | SAD_UC_QUALTYPE10 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 10 |
| 123 | SAD_UC_QUALTYPE11 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 11 |
| 124 | SAD_UC_QUALTYPE12 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 12 |
| 125 | SAD_UC_QUALTYPE13 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 13 |
| 126 | SAD_UC_QUALTYPE14 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 14 |
| 127 | SAD_UC_QUALTYPE15 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 15 |
| 128 | SAD_UC_QUALTYPE16 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 16 |
| 129 | SAD_UC_QUALTYPE17 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 17 |
| 130 | SAD_UC_QUALTYPE18 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 18 |
| 131 | SAD_UC_QUALTYPE19 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 19 |
| 132 | SAD_UC_QUALTYPE20 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 20 |
| 133 | SAD_UC_QUALTYPE21 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 21 |
| 134 | SAD_UC_QUALTYPE22 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 22 |
| 135 | SAD_UC_QUALTYPE23 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 23 |
| 136 | SAD_UC_QUALTYPE24 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 24 |
| 137 | SAD_UC_QUALTYPE25 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 25 |
| 138 | SAD_UC_QUALTYPE26 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 26 |
| 139 | SAD_UC_QUALTYPE27 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 27 |
| 140 | SAD_UC_QUALTYPE28 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 28 |
| 141 | SAD_UC_QUALTYPE29 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 29 |
| 142 | SAD_UC_QUALTYPE30 | Character(6) | VARCHAR2(6) NOT NULL | Qualification Type 30 |
| 143 | SAD_UC_QUALYEAR1 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 1 was taken |
| 144 | SAD_UC_QUALYEAR2 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 2 was taken |
| 145 | SAD_UC_QUALYEAR3 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 3 was taken |
| 146 | SAD_UC_QUALYEAR4 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 4 was taken |
| 147 | SAD_UC_QUALYEAR5 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 5 was taken |
| 148 | SAD_UC_QUALYEAR6 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 6 was taken |
| 149 | SAD_UC_QUALYEAR7 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 7 was taken |
| 150 | SAD_UC_QUALYEAR8 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 8 was taken |
| 151 | SAD_UC_QUALYEAR9 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 9 was taken |
| 152 | SAD_UC_QUALYEAR10 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 10 was taken |
| 153 | SAD_UC_QUALYEAR11 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 11 was taken |
| 154 | SAD_UC_QUALYEAR12 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 12 was taken |
| 155 | SAD_UC_QUALYEAR13 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 13 was taken |
| 156 | SAD_UC_QUALYEAR14 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 14 was taken |
| 157 | SAD_UC_QUALYEAR15 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 15 was taken |
| 158 | SAD_UC_QUALYEAR16 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 16 was taken |
| 159 | SAD_UC_QUALYEAR17 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 17 was taken |
| 160 | SAD_UC_QUALYEAR18 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 18 was taken |
| 161 | SAD_UC_QUALYEAR19 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 19 was taken |
| 162 | SAD_UC_QUALYEAR20 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 20 was taken |
| 163 | SAD_UC_QUALYEAR21 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 21 was taken |
| 164 | SAD_UC_QUALYEAR22 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 22 was taken |
| 165 | SAD_UC_QUALYEAR23 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 23 was taken |
| 166 | SAD_UC_QUALYEAR24 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 24 was taken |
| 167 | SAD_UC_QUALYEAR25 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 25 was taken |
| 168 | SAD_UC_QUALYEAR26 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 26 was taken |
| 169 | SAD_UC_QUALYEAR27 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 27 was taken |
| 170 | SAD_UC_QUALYEAR28 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 28 was taken |
| 171 | SAD_UC_QUALYEAR29 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 29 was taken |
| 172 | SAD_UC_QUALYEAR30 | Character(4) | VARCHAR2(4) NOT NULL | Year Qual 30 was taken |
| 173 | SAD_UC_ULN | Character(10) | VARCHAR2(10) NOT NULL | Unique Learner Number |
| 174 | SAD_UC_PARED | Character(1) | VARCHAR2(1) NOT NULL | Parental Education |
| 175 | SAD_UC_IMP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Import Status
E=Error (E) I=Imported (I) N=New (N) P=Pending (P) R=Pending (R) T=Error (T) |
| 176 | SAD_UC_CARELEAVER | Character(2) | VARCHAR2(2) NOT NULL | Care Leaver |
| 177 | SAD_UC_SOCECO2010 | Character(1) | VARCHAR2(1) NOT NULL | Social Economic 2010 |
| 178 | SAD_UC_POCC2010 | Character(4) | VARCHAR2(4) NOT NULL | Parental occupation |
| 179 | SAD_UC_SEXORT | Character(2) | VARCHAR2(2) NOT NULL | Sexual Orientation |
| 180 | SAD_UC_RELBLF | Character(2) | VARCHAR2(2) NOT NULL | Religion/Belief |
| 181 | SAD_UC_SOCECO2020 | Character(1) | VARCHAR2(1) NOT NULL | Socio-Economic 2020 |
| 182 | SAD_UC_POCC2020 | Character(4) | VARCHAR2(4) NOT NULL | Parental Occupation 2020 |
| 183 | SAD_UC_CARER | Character(2) | VARCHAR2(2) NOT NULL | Caring Responsibilities |
| 184 | SAD_UC_ESTRANGED | Character(2) | VARCHAR2(2) NOT NULL | Estranged |