SAD_UC_I_POCC

(SQL Table)
Index Back

cvRefPOCC

Staging table for storing UCAS view cvRefPOCC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SAD_UC_POCC Character(4) VARCHAR2(4) NOT NULL Parental Occupation
3 SAD_UC_SOCIALCLASS Character(1) VARCHAR2(1) NOT NULL Social Class
4 SAD_UC_OCCTEXT Character(110) VARCHAR2(110) NOT NULL Occupation Text
5 SAD_UC_ALTTEXT Character(40) VARCHAR2(40) NOT NULL Alternative Text
6 SAD_UC_ALTCLASS1 Character(1) VARCHAR2(1) NOT NULL Alternative Class 1
7 SAD_UC_ALTCLASS2 Character(1) VARCHAR2(1) NOT NULL Alternative Class 2
8 SAD_UC_SOCIOECON Character(1) VARCHAR2(1) NOT NULL Socio-Economic Classification