My Student System Table Descriptions hand book (I have big hands) Part 11

Student System - IGS_UC_WRONG_APP	Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.
Column Name	Descritpion
WRONG_APP_ID	Unique Record identifier
EXPUNGED	Application marked for expunged (Y - yes , N - no)
JOINT_ADMISSION_IND	Indicator for Joint admissions entity withdrawal.
CREATED_BY	Standard WHO Columns
CREATION_DATE	Standard WHO Columns
LAST_UPDATED_BY	Standard WHO Columns
LAST_UPDATE_DATE	Standard WHO Columns
LAST_UPDATE_LOGIN	Standard WHO Columns
CHOICE1_LOST	Choice Lost
CHOICE2_LOST	Choice Lost
CHOICE3_LOST	Choice Lost
CHOICE4_LOST	Choice Lost
CHOICE5_LOST	Choice Lost
CHOICE6_LOST	Choice Lost
CHOICE7_LOST	Choice Lost
APP_NO	Application number to expunge
DATETIMESTAMP	Timestamp to synchronize with UCAS view ivStarW - Obsolete
MISCODED	Application miscoded ( Y - yes , N - no)
CANCELLED	Application miscoded ( Y - yes , N - no)
CANCEL_DATE	Application cancel date
REMARK	Reasons for action
EXPUNGE	Application marked for expunge(Y - yes , N - no)
BATCH_ID	Batch Id used to import dummy record to OSS for overwriting record to expunge.

Student System - IGS_UC_UCAS_CONTROL	Holds the control information provided by UCAS. It will always contain only one record at any given time. It synchronizes with UCAS view 'cvControl' and will be synchronized every time import is done.
Column Name	Descritpion
TIME_OF_YEAR	Time of Year (null - clearing not started, A - CEF sent to applicants, C - Clearing started)
NO_MORE_LA_TRAN	'Y' indicates it's too late for 'Amended Decision' transactions (Y - yes, N - no)
STAR_X_AVAIL	'Y' indicates that ivStarX data in available (Y - yes, N - no)
EXTRA_START_DATE	Start date of UCAS EXTRA processing.
LAST_PASSPORT_DATE	Last day UCAS will accept applications for EXTRA passports.
LAST_LE_DATE	Last day that UCAS will accept LE transactions
CREATED_BY	Standard WHO column
TIME_OF_DAY	Time of day
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
GTTR_CLEAR_TOY_CODE	GTTR Clearing Time of Year Code
ROUTEB_TIME_OF_YEAR	Route B phase (0 - Route B supplementary forms sent, 1 - Round 1 sent, 2 - Round 2 sent, 3 - Round 3 sent etc.)
TRANSACTION_TOY_CODE	Transaction Time of Year Code
APPNO_FIRST	First application number
SYSTEM_CODE	UCAS System Code
APPNO_MAXIMUM	Maximum application number this year
APPNO_LAST_USED	Last application number in use
APPNO_FIRST_OPF	First Application Number for overseas partnership forms
APPNO_FIRST_RPA_NONEU	First Application Number for record of prior acceptance - nonEU
APPNO_FIRST_RPA_EU	First Application Number for record of prior acceptance - EU
LAST_DAILY_RUN_NO	Last daily run number
LAST_DAILY_RUN_DATE	Last daily run date
UCAS_CYCLE	UCAS Cycle to which this control information belongs to
APPNO_15DEC	Last application number by 15 December (decision deadline)
RUN_DATE_15DEC	Run date of last application number by 15 December
APPNO_24MAR	Last application number by 24 March
RUN_DATE_24MAR	Run date of last application number by 24 March
ENTRY_YEAR	Entry year
APPNO_16MAY	Last application number by 16 May
RUN_DATE_16MAY	Run date of last application number by 16 May
APPNO_DECISION_PROC	Last application number is decision processing
RUN_DATE_DECISION_PROC	Run date of last application number in decision processing
APPNO_FIRST_PRE_NUM	First application number for pre-numbered late application forms
NEWS	News / Announcements

Student System - IGS_UC_TRANSACTIONS	Holds the admission process transactions that are need to be written to the UCAS view 'TranIn'.
Column Name	Descritpion
UC_TRAN_ID	Unique Record Identifier
CHOICE_NO	Application choice number.
DECISION	Decision
PROGRAM_CODE	UCAS Program code
CAMPUS	UCAS campus code
ENTRY_MONTH	Month of entry
ENTRY_YEAR	Year of entry
ENTRY_POINT	Point of entry
MODULAR	Valid for GTTR only, default value = NULL
PART_TIME	Valid for GTTR only, default value = NULL
SOC	Summary of conditions
TRANSACTION_ID	Generated transaction identifier from UCAS .
COMMENTS_IN_OFFER	Comments in offer
RETURN1	Holds value returned by IGS_UC_TRANSACTIONS.return1
RETURN2	Holds value returned by IGS_UC_TRANSACTIONS.return2
HOLD_FLAG	Do not transmit transaction(Y- yes , N-no)
SENT_TO_UCAS	Update sent to UCAS ('Y' Yes, 'N' No)
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
SYSTEM_CODE	UCAS System Code
TEST_COND_CAT	Condition Category for test transaction type. Not populated for non-test transaction types.
TEST_COND_NAME	Condition Name for test transaction type. Not populated for non-test transaction types.
INST_REFERENCE	For institution use
AUTO_GENERATED_FLAG	To indicate whether the Transaction is created automatically or manually (Y-yes, N - No).
UCAS_CYCLE	UCAS Cycle to which this application choice belongs to
DATETIMESTAMP	Timestamp of record from UCAS
UPDATER	ID of last updater
ERROR_CODE	Error code from UCAS .
TRANSACTION_TYPE	Transaction type('LD',LA' etc.)
APP_NO	Application Number

Student System - IGS_UC_REF_POCC	Holds the list of parental occupation codes and social classes. It synchronizes with UCAS view 'cvRefPOCC'.
Column Name	Descritpion
SOCIAL_CLASS	Social Class code (0 - Unknown, 1 - professional, 2 - managerial / technical, 3 - skilled - non-manual, 4 - skilled - manual, 5 - partly skilled, 6 - unskilled)
OCCUPATION_TEXT	Occupation code description
ALTERNATIVE_TEXT	Occupation code alternative description
ALTERNATIVE_CLASS1	Alternative Social Class
ALTERNATIVE_CLASS2	Alternative Social Class
IMPORTED	Record imported from UCAS? ('Y' Yes, 'N' No)
SOCIO_ECONOMIC	Socio Economic classification
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
POCC	Parental Occupation codes (000-999)
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_UC_REF_OFF_ABRV	Holds the list of UCAS offer abbreviations. It synchronizes with UCAS view 'cvRefOfferAbbrev' and is also used by 'uvOfferAbbrev'.
Column Name	Descritpion
UV_TIMESTAMP	Timestamp to synchronize with UCAS view uvOfferAbbrev - Obsolete
UV_UPDATER	Synchronizes with UCAS value in uvOfferAbbrev.Updater
ABBREV_TEXT	Abbreviation description. Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev
LETTER_FORMAT	No Longer Used
SUMMARY_CHAR	Summary of Conditions character. Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev
UNCOND	Flags validity for unconditional offers (Y-Yes, N-No). Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev.
WITHDRAWAL	Flags validity for withdrawal decisions (Y-Yes, N-No). Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev
RELEASE	Flags validity for release into Clearing (Y-Yes, N-No). Synchronizes with UCAS views uvOfferAbbrev & cvRefOfferAbbrev
ABBREV_CODE	Offer Abbreviation code
IMPORTED	Record imported from UCAS? ('Y' Yes, 'N' No)
SENT_TO_UCAS	Record sent to UCAS? ('Y' Yes, 'N' No)
DELETED	Marked for deletion (Y-Yes, N-No)
TARIFF	Indicates whether valid for use in Tariff Offers
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_UC_REF_KEYWORDS	Holds the list of keywords. It synchronizes with UCAS view 'cvRefKeyword'
Column Name	Descritpion
IMPORTED	Record imported from UCAS? ('Y' Yes, 'N' No)
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
KEYWORD	Keyword value

Student System - IGS_UC_REF_DATETIME	Contains only one record at any given time. - OBSOLETE
Column Name	Descritpion
REF_DIS	Timestamp to synchronize with UCAS view cvRefDis
REF_TARIFF	Timestamp to Synchronize with UCAS view cvRefTariff.
REF_JOINT_ADM	Timestamp to Synchronize with UCAS view cvJointAdmissions.
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
REF_ERROR	Timestamp to synchronize with UCAS view cvRefError
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
REF_ETHNIC	Timestamp to synchronize with UCAS view cvRefEthnic
REF_EXAM	Timestamp to synchronize with UCAS view cvRefExam
REF_FEE	Timestamp to synchronize with UCAS view cvRefFee
REF_KEYWORD	Timestamp to synchronize with UCAS view cvRefKeyword
REF_OEQ	Timestamp to synchronize with UCAS view cvRefOEQ
REF_OFFER_ABBREV	Timestamp to synchronize with UCAS view cvRefOfferAbbrev
REF_APR	Timestamp to synchronize with UCAS view cvRefAPR
REF_OFFER_SUBJ	Timestamp to synchronize with UCAS view cvRefOfferSubj
REF_POCC	Timestamp to synchronize with UCAS view cvRefPOCC
REF_RES_CAT	Timestamp to synchronize with UCAS view cvRefResCat
REF_AWARD_BODY	Timestamp to synchronize with UCAS view cvRefAwardBody
REF_STATUS	Timestamp to synchronize with UCAS view cvRefStatus
REF_UCAS_GROUP	Timestamp to synchronize with UCAS view cvRefUcasGroup
REF_EST_GROUP	Timestamp to synchronize with UCAS view cvRefEstGroup
REF_SCHOOL_TYPE	Timestamp to synchronize with UCAS view cvRefSchoolType
UCAS_SYNC	Timestamp of last data import from UCAS as seen in the 'Data Import' process screen.

Student System - IGS_UC_REF_CODETYPS	Holds the list of reference code types used in IGS_UC_REF_CODES. - OBSOLETE
Column Name	Descritpion
DESCRIPTION	Description of the Reference Code Type
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CODE_TYPE	Reference Code Type

Student System - IGS_UC_MV_CVR_POCC	List of Parental Occupation Codes and Social Class with description. - OBSOLETE
Column Name	Descritpion
POCC	000 - 999
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
SOCIALCLASS	0 - not known, 1- professional, 2 - managerial/technical, 3 - skilled non manual, 4 - skilled - manual, 5- partly skilled and 6 - unskilled
OCCUPATIONTEXT	Occupation Text
ALTERNATIVETEXT	Alternative Text
ALTERNATECLASS1	Alternative Class
ALTERNATECLASS2	Alternative Class
SOCIOECONOMIC	Socio-economic Classification
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_UC_MV_CVR_OEQ	List of other examination qualifications. - OBSOLETE
Column Name	Descritpion
OEQ	Other examination qualification code
OEQTEXT	Other examination qualification description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_KYWD	List of Keywords - OBSOLETE
Column Name	Descritpion
KEYWORD	Keyword
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_FEE	List of examination with level. - OBSOLETE
Column Name	Descritpion
FEEPAYER	Fee Payer code
FEETEXT	Fee description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_EXAM	List of examination with level. - OBSOLETE
Column Name	Descritpion
EXAMLEVEL	Examination level
EXAMTEXT	Exam description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_ERR	List of error codes with descriptions. - OBSOLETE
Column Name	Descritpion
ERRORCODE	Error Code
ERRORDESCRIPTION	Description of the error code
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_DIS	List of disabilities with descriptions. - OBSOLETE
Column Name	Descritpion
DIS	0 to 9
DISTEXT	Disability Description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_APR	List of domiciles with descriptions. - OBSOLETE
Column Name	Descritpion
DOM	3 digit numeric
DOMTEXT	Domicile description
LEAFLAG	Y = LEA in England/Wales N = not an LEA
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_AMD	List of the date and time when the reference common views were last updated. There will only be one row in this table. - OBSOLETE
Column Name	Descritpion
APRDATE	Date and time of last change of cvRefAPR (0)
OFFERSUBJDATE	Date and time of last change of cvRefOfferSubj (0)
POCCDATE	Date and time of last change of cvRefPOCC (0)
RESCATDATE	Date and time of last change of cvRefResCat (0)
AWARDBODYDATE	Date and time of last change of cvRefAwardBody (0)
STATUSDATE	Date and time of last change of cvRefStatus (0)
UCASGROUPDATE	Date and time of last change of cvRefUcasGroup (0)
ESTABGROUP	Date and time of last change of cvRefEstGroup(0)
SCHOOLTYPE	Date and time of last change of cvRefSchoolType(0)
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
DISDATE	Date and time of last change of cvRefDis (0)
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TARIFFDATE	Timestamp for Tariff view
JOINTADMISSIONS	Timestamp for Joint Admissions view
ERRORDATE	Date and time of last change of cvRefError (0)
ETHNICDATE	Date and time of last change of cvRefEthnic (0)
EXAMDATE	Date and time of last change of cvRefExam (0)
FEEDATE	Date and time of last change of cvRefFee (0)
KEYWORDDATE	Date and time of last change of cvRefKeyword (0)
OEQDATE	Date and time of last change of cvRefOEQ (0)
OFFERABBREVDATE	Date and time of last change of cvRefOfferAbbrev (0)

Student System - IGS_UC_MV_TRANIN	This view is inserted into and can be selected from. The table below shows the view structure. - OBSOLETE
Column Name	Descritpion
TRANSACTIONID	Unique transaction number
CAMPUS	Campus Code
ENTRYYEAR	Entry Year
ENTRYMONTH	Entry Month
ENTRYPOINT	Entry Point
SOC	Summary of Conditions
INSTREFERENCE	For institution use
FREEFORMAT	Offer Free Format Area
RETURN1	LA, LD- error position in the free format area, RQ - number of other Form requests recorded.
RETURN2	XA, XD - Semi-expanded form of offer details variable length - consisting of semi-expanded offer letter.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
UPDATER	Identifier of the origin of the transaction
ERRORCODE	000 - success. Any other - Fail
TRANSACTIONTYPE	LA, LD, RA, RD etc
APPNO	Application Number
CHOICENO	Choice Number
DECISION	Decision
COURSE	Course Code

Student System - IGS_UC_MV_IVSTMNT	If an applicant has applied through the EAS system then the institution has access to their personnel statement via this view. The statement is stored in Rich Text Format. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
STATEMENT	Electronic Applicants Statement
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_IVSTARZ2	Applicants clearing round view. This will contain all the clearing round rows for each applicant that you are allowed to see. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
ROUNDNO	Round Number
TIMESTAMP	Time stamp - date and time of last change
INST	Institution Code
COURSE	Course Code
CAMPUS	Campus Code
FACULTY	Faculty Code
ROUNDTYPE	Previously used in Central Clearing, now only contains 'F' (Form Request)
RESULT	Blank = Form request - (copy form printed) , * = New form request (copy form not yet printed) , I = Accepted at this institution , R = Rejected by institution , D = Declined by applicant, C = Cancelled by applicant, X = Form reques

Student System - IGS_UC_MV_IVSTARZ1	Applicant clearing details table. This will contain a row for each applicant that you are allowed to see. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
ENTRYYEAR	Entry Year
ENTRYMONTH	Entry Month
ENTRYPOINT	Point of Entry
RESULT	Result. Previously used in Central Clearing. Now only contains 'A' (Accept) if Inst/Course are not null. Null otherwise
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
DATECEFSENT	Date Clearing Entry Form sent
CEFNO	Clearing Entry Form Number
CENTRALCLEARING	Central Clearing was discontinued in 1999. This field is no longer used, but contains the constant 'N' for backwards compatibility.
INST	Institution Code
COURSE	Course Code
CAMPUS	Campus Code
FACULTY	Faculty Code

Student System - IGS_UC_MV_IVSTARX	Extra statistical data view. This will be available when the column StarXAvail has a value of 'Y'. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
ETHNIC	Ethnic origin
POCCEDUCHANGEDATE	Date of change of Parental Occupation details
SOCIALCLASS	Social class - pre 2000
POCC	Parental Occupation Code
POCCTEXT	EAS Parental Occupation Text
SOCIOECONOMIC	Socio-economic classification
OCCBACKGROUND	Occupation background

Student System - IGS_UC_MV_IVSTARW	Extra statistical data table. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
MISCODED	Y - Miscoded
CANCELLED	Y - Cancelled
CANCELDATE	Date cancelled
REMARK	Why they were cancelled
JOINTADMISSION	Indicator for Joint admissions entity withdrawal.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_UC_MV_IVSTARPQR	This is a view of qualification results. There is a single row for each qualification. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
SUBJECTID	Subject identification number see 0 cvEBLsubject
EBLRESULT	Contents depends on board: A-grade and S-grade. Range mark and Percentage etc
EBLAMENDED	Grade amend by board:As EBLresult
CLAIMEDRESULT	Grade claimed by candidate:As EBLresult
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_UC_MV_IVSTARN	Applicant name table. This will contain a row for each applicant that you are allowed to see. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
CHECKDIGIT	Application number check digit
NAMECHANGEDATE	Date the Name Changed
TITLE	Mr, Miss, Ms, Mrs, Lord etc
FORENAMES	Forenames
SURNAME	Surnames
BIRTHDATE	Date of birth
SEX	M - Male F - Female

Student System - IGS_UC_MV_IVSTARK	Coded information TABLE. This will contain a row for each applicant that you are allowed to see. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
FEEPAYER	Fee Payer Code see 0 cvRefFee
FEETEXT	EAS fee payer name
APR	Refers to 0cvrefAPR - all values
COUNTRYBIRTH	Refers to 0cvrefAPR - Countries
NATIONALITY	Refers to 0cvrefAPR - Countries
DUALNATIONALITY	EAS - same format as Nationality, but contains other nationality
WITHDRAWN	Null - not withdrawn, C - candidate withdrew, R - reinstated, W- UF withdrawal
WITHDRAWNDATE	Date candidate withdrew or was reinstated
ROUTEB	Y - route B is required
TIMESTAMP	Time stamp - date and time of last change
EXAMCHANGEDATE	Exam details changed date
WINTER	Number of Winter A Levels
PREVIOUSA	Number of previous A/AS/Higher/CSYS
BTEC	Y - BTEC
ILC	Y - ILC
APPLICATIONDATE	Application Date
AICE	Y - AICE
IB	Y - International Baccalaureate
MANUAL	Y - manual investigation of previous results required
REGNO	TEC registration number
OEQ	Other Examination Qualifications
EAS	Y - Applied through EAS
ROA	Y - record of achievement
SPECIALNEEDS	0 - No disability, 1 - Dyslexia, 2 - Blind/partial sight, 3 - Deaf/partial hearing, 4 - Wheelchair/mobility, 5 - Personal care, 6 - Mental health, 7 - Unseen disability, 8 - Multiple disabilities, 9 - Other disability
STATUS	Status
FIRMNOW	Firm choice number
SENTDATE	Date sent out
FIRMREPLY	Firm Reply
INSURANCEREPLY	insurance Reply
CONFHISTFIRMREPLY	Confirmation history firm reply
CONFHISTINSURANCEREPLY	Confirmation history insurance reply
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
SCN	Scottish Candidate Number
PREVOEQ	Previous Other Examination Qualifications
GCE	Number of GCE (A + AS) expected
RUNSENT	Run/Batch number when sent
VCE	Number of VCE (A + AS + Double) expected
SQA	Y - SQA Candidate
PREVIOUSAS	Number of previous Summer AS levels
KEYSKILLS	Key Skills
VOCATIONAL	Null - not taking vocational exams1 - taking Higher BTEC (HNC/HND)2 - taking Lower BTEC (NC/ND)3 - taking Foundation Art & Design course
CRIMINALCONV	Criminal Convictions - Y, N, NULL
UKENTRYDATE	Date of first entry to UK
CHOICESALLTRANSPARENT	Indicates whether the Student Applications Choices are visible to institution or not.
EXTRASTATUS	Indicates whether the applicant is in extra processing.
EXTRAPASSPORTNO	Passport ID used in UCAS Extra. For applicants applying on web will contain 'WEB'.
CODEDCHANGEDATE	Coded information changed date
SCHOOL	School code
RESCAT	Residential Category
FEELEVEL	F - full fee, S - single entry fee (UCAS fee level received from applicant)

Student System - IGS_UC_MV_UVCRS_KYW	This table allows an institution to see its own course keywords. It also allows the institution to activate or deactivate any row. - OBSOLETE
Column Name	Descritpion
COURSE	Course Code
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CAMPUS	Campus Code
OPTIONCODE	Option Code
KEYNO	Keyword number (1 - 6)
KEYWORD	Keyword
TIMESTAMP	Time stamp - date and time of last change
UPDATER	ID of last updater
ACTIVE	Y - Active N - Not Active
CREATED_BY	Standard WHO Column

Student System - IGS_UC_MV_CVR_UCS_G	List of the groups plus the description used for institution contacts. - OBSOLETE
Column Name	Descritpion
GROUPNO	Group Number
GROUPNAME	Group description text
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_STAT	List of possible application statuses. - OBSOLETE
Column Name	Descritpion
STATUS	Status number
STATUSTEXT	Status description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_SCHTY	List of possible school types. - OBSOLETE
Column Name	Descritpion
SCHOOLTYPE	School Type
SCHOOLTEXT	School description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_RESCA	List of residential categories. - OBSOLETE
Column Name	Descritpion
RESCAT	Residential category code
RESCATTEXT	Residential category description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_OF_SU	List of subject codes with description. - OBSOLETE
Column Name	Descritpion
SUBJCODE	Hercules Subject Code
SUBJTEXT	Subject Text
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_OF_AB	List of UCAS abbreviations available. - OBSOLETE
Column Name	Descritpion
ABBREVCODE	Abbreviation code
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
ABBREVTEXT	Abbreviation description
LETTERFORMAT	A - G
SUMMARYCHAR	Summary of conditions character
UNCOND	Valid for unconditional offers or not
WITHDRAWAL	Valid for withdrawal decisions or not
RELEASE	Valid for release to clearing or not
TARIFF	Valid for use in Tariff offers or not
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column

Student System - IGS_UC_MV_CVR_ETHNC	List of ethnic codes with descriptions - OBSOLETE
Column Name	Descritpion
ETHNIC	Ethnic Code
ETHNICTEXT	Ethnic Description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVR_EST_G	List of Establishment Group Code with descriptions - OBSOLETE
Column Name	Descritpion
ESTABGRP	Establishment Group Code
ESTABTEXT	Establishment Description
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_LOAD_MV_T	This table used to store the Marvin data which need to be imported into Hercules Dummy table
Column Name	Descritpion
MARVIN_ID	Identifier for the temporary table
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CONTD_FLAG	Indicates whether the logical data spans more than one record (1-9)
TRANS_TYPE	Indicates the transaction type of the data stored
ERROR_CODE	Error Code for the acknowledgement transactions
RECORD_DATA	Holds the exact Marvin data which needs to be imported
FILE_TYPE	Holds the Marvin file type( G, N, S, U)
RECORD_STATUS	Indicates the record status R- Ready to move, N - Not ready to move, P - Already moved.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column

Student System - IGS_UC_MV_UVCRS_VOP	This view is for institutions that use option codes within clearing. It is used to open and close options - OBSOLETE
Column Name	Descritpion
COURSE	Course Code
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CAMPUS	Campus Code
OPTIONCODE	Option Code
TIMESTAMP	Time stamp - date and time of last change
UPDATER	ID of last updater
CLUPDATED	Y - Updated not yet notified
CLDATE	Vacancies updated date
VACSTATUS	Y-Open to all applicants, N-Closed, O-Overseas only (not applicable to an option)
CREATED_BY	Standard WHO column

Student System - IGS_UC_MV_CVR_AWD_B	List of GCE examining boards and other awarding bodies by year, sitting and awarding body. - OBSOLETE
Column Name	Descritpion
YEAR	1950 - 2049
LAST_UPDATE_LOGIN	Standard WHO Column
SITTING	S - summer W - winter
AWARDINGBODY	Board code
BODYNAME	Board Name
BODYABBREV	Board Abbreviation
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column

Student System - IGS_UC_MV_UVOFR_ABV	This view allows an institution to maintain its own abbreviations - OBSOLETE
Column Name	Descritpion
ABBREVID	00 to 99
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
TIMESTAMP	Time stamp - date and time of last change
UPDATER	ID of last updater
ABBREVTEXT	Abbreviation Text
LETTERFORMAT	A - G
SUMMARYCHAR	Summary of conditions character (see Summary of conditions column)
ABBREVUSE	U - Unconditional, W - Withdrawals , Null - abbreviation invalid on unconditional offers or withdrawal.
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Student System - IGS_UC_MV_UVINST	This view allows the institution to maintain some of its own institution details kept by UCAS - OBSOLETE
Column Name	Descritpion
TIMESTAMP	Time stamp - date and time of last change
LABELS	Space - No new applicant labels, 1 - 1 label , l2 - 2 labels
WEEKLYMOVLISTSEQ	Space - no list, A - alpha, B - course/alpha, D - faculty/alpha , E - faculty/course/alpha, N - appno, P - course/appno, R - faculty/appno , T - faculty/course/appno
WEEKLYMOVPAGING	Space - no list, N - no paging major key change, Y - paging at major key change
FORMSEQ	A, B, D, E, N, P, R or T
EBLREQUIRED	Space - No EBL required, A - EBL1, EBL2, EBL3 required , N - No EBL required, P - EBL2, EBL3 only , R - EBL3 only
EBLMEDIA1OR2	Space - No EBL1/2, L - EBL printed, T - EBL on magnetic tape
EBLMEDIA3	Space - No EBL3, L - EBL printed, O - EBL Online (MARVIN *R records), T - EBL on magnetic tape (Obsolete value)
EBL1OR2MERGED	Space - No EBL1/2, N - EBL1 and EBL2 separate, Y - EBL1 and EBL2 merged
EBL1OR2BOARDGROUP	Space - No EBL1/2, F - EBL1/2 fully combined, S - EBL1/2 separate boards
EBL3BOARDGROUP	Space - No EBL3, C - EBL3 combined boards, F - EBL3 fully combined boards, S - EBL3 separate boards
UPDATER	ID of last updater
EBLNCAPP	Space - no EBL required, N - None Committed applicants excluded, Y -None Committed applicants required
EBLMAJORKEY1	Space - major key not required, C - Course, F - Faculty, G - Grouped June category, J - June category, S - Sex Y - Year of entry
EBLMAJORKEY2	Space - not required , C, F, G, J, S, Y as EBLMajorKey1
EBLMAJORKEY3	As EBLMajorKey2
EBLMINORKEY1	Space - minor key not required , C, F, G, J, S, Y as EBLMajorKey1
EBLMINORKEY2	Space - not required , C, F, G, J, S, Y as EBLMajorKey1
EBLMINORKEY3	As EBLMinorKey2
EBLFINALKEY	Space - no EBL required, A - Alpha, B - Board ref(centre), N - Application reference number
ODL1	Space - no ODL1, A - alpha, B - course/alpha, D - faculty/alpha, E - faculty/course/alpha, N - appno, P - course/appno, R - faculty/appno, T - faculty/course/appno
ODL1A	Space - no ODL1A , A, B, D, E, N, P, R, T as ODL1
INSTTYPE	A - Route A only institution , B - Route B only institution, C - Route A and B institution
ODL2	Space - no ODL2 , A, B, D, E, N, P, R, T as ODL1
ODL3	Space - no ODL3 , A, B, D, E, N, P, R, T as ODL1
ODLSUMMER	Space - no Summer ODL , A, B, D, E, N, P, R, T as ODL1
ODLROUTEB	Space - no Route B ODL , A, B, D, E, N, P, R, T as ODL1
MONTHLYSEQ	Space - no monthly info/movement , A, B, D, E, N, P, R, T as ODL1
MONTHLYPAPER	Space - no monthly info/movement , 1 - 1-part paper , 2 - 2-part paper
MONTHLYPAGE	Space - no monthly info/movement , N - No paging at major key change , Y - Paging at major key change
MONTHLYTYPE	Space - no monthly info/movement, I - information list, M - movement list
JUNELISTSEQ	Space - no June lists , A - alpha, B - course/alpha, D - faculty/alpha, E - faculty/course/alpha, N - appno, P - course/appno, R - faculty/appno, T - faculty/course/appno, X - faculty/course/cat/appno
JUNELABELS	Space - no June labels, A - alpha, B - course/alpha, D - faculty/alpha, E - faculty/course/alpha, N - appno, P - course/appno, R - faculty/appno, T - faculty/course/appno
INSTSHORTNAME	e.g. ABRDN
JUNENUMLABELS	Space - no labels, 1 - 1 set label , s2 - 2 sets labels
COURSEANALYSIS	Space - No D3 decision docs , 1 - Monthly in course order , 2 - Fortnightly in course order , 3 - Monthly in faculty order , 4 - Fortnightly in faculty order
CAMPUSUSED	Space - Campus codes not used , C - Campus codes used
D3DOCSREQUIRED	Space - No D3 decision docs , N - No D3 decision docs , Y - D3 decision docs required
CLEARINGACCEPTCOPYFORM	Space - No Application form copy , Y - Application form for Clearing Accept
ONLINEMESSAGE	Message for this user
ETHNICLISTSEQ	Space - no June labels, A - alpha, B - course/alpha , D - faculty/alpha, E - faculty/course/alpha, N - appnoP - course/appno, R - faculty/appno, T - faculty/course/appno
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
INSTNAME	e.g. Aberdeen
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
INSTFULLNAME	Full Name
SWITCHBOARDTELNO	0-9 and hyphen
DECISIONCARDS	Space - No decision docs , A - Online decision cards, B - D1 documents (D4 Clearing)
RECORDCARDS	Space - No record cards, 1 - 1 record card, 2 - 2 record cards

Student System - IGS_UC_MV_UVCRS_VAC	This table allows an institution to see its own course keywords. It also allows the institution to activate or deactivate any row. - OBSOLETE
Column Name	Descritpion
COURSE	Course Code
RBFULL	Null - Open, F - Full
SCOTVAC	Up to 6 grades of A,B or C
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CAMPUS	Campus Code
TIMESTAMP	Time stamp - date and time of last change
UPDATER	ID of last updater
CLUPDATED	Y - Updated not yet notified
CLDATE	Vacancies updated date
VACSTATUS	Y - Open to all applicants, N - Closed, O - Overseas only (not applicable to an option)
NOVAC	Number of vacancies or GI for group intake
SCORE	00 - 30

Student System - IGS_UC_MV_UVCOURSE	This table is used to update institutions course details. - OBSOLETE
Column Name	Descritpion
COURSE	Course Code
TERM1START	First term start date
TERM1END	First term end date
TERM2START	Second term start date
TERM2END	Second term end date
TERM3START	Third term start date
TERM3END	Third term end date
TERM4START	Fourth term start date
TERM4END	Fourth term end date
JOINTADMISSION	Indicates Joint Admissions Entity course.
OPENEXTRA	Open Extra Indicator.
CAMPUS	Campus Code
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
UPDATER	ID of last updater
FACULTY	Faculty Code
SHORTTITLE	Short Title
LONGTITLE	Long Title
VALIDCURR	D - Discontinued R - Running Null - Invalid
VALIDDEFER	D - Discontinued R - Running Null - Invalid

Student System - IGS_UC_MV_UVCONTGRP	This table allows an institution to direct UCAS output to the correct person(s). - OBSOLETE
Column Name	Descritpion
CONTACTCODE	A - Z
UCASGROUP	List of the groups plus the description used for institution contacts.
UPDATER	ID of last updater
TIMESTAMP	Time stamp - date and time of last change
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_UVCONTACT	This table allows the institution to maintain its own contacts. - OBSOLETE
Column Name	Descritpion
CONTACTCODE	A - Z
TELEPHONE	Telephone Number
EMAIL	E-mail address
FAX	Fax Number
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
UPDATER	ID of last updater
NAME	Name
POST	Post Held
ADDRESS1	Contact address line 1
ADDRESS2	Contact address line 2
ADDRESS3	Contact address line 3
ADDRESS4	Contact address line 4

Student System - IGS_UC_MV_IVSTARH	This view is HESA data for each applicant accepted by your institution. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
LEA	Y = LEA in England/Wales N = not an LEA
SOCIALECONOMIC	Socio-economic classification
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
ETHNIC	Ethnic code
SOCIALCLASS	Social Class
POCCEDUCHANGEDATE	Date of change of Parental Occupation/Education details
POCC	Parental Occupation Code
POCCTEXT	EAS Parental Occupation Text
LASTEDUCATION	Last educational establishment: Last school attended (DFE number) Last HE inst attended (HESA code) Zero if no details of leaving
EDUCATIONLEAVEDATE	Year of leaving

Student System - IGS_UC_MV_IVSTARC	This table stores the applicant choices. You can see all the choices for all the applicants you are allowed to see. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
DECISION	C,U,R,W or Blank
DECISIONDATE	Date when the decision was made
DECISIONNUMBER	Pre SOD reply: 0 - no decision 1 - 1st decision (LD) 2-9 - 2nd etc decision (LA). Post SOD reply: 0 - SOD reply in 1 - Confirmation decision in 2 - UF amendment
REPLY	F, I, D or Blank
SUMMARYCONDITIONS	Summary of conditions column
ENTRYMONTH	Month course starts
ENTRYYEAR	Year the course starts
ENTRYPOINT	Null = year 1 entry 1-4 = Year of entry 0 = Foundation Year entry
CHOICECANCELLED	Y - Choice cancelled
ACTION	D - DBD (Decline by Default), R - RBD (Reject by Default), U - up rated (UI-UF, CI-CF), X - assumed decline (no answer on AS6C, AS6F, AS6R, AS6W, AS7)
CHOICENO	Choice number
SUBSTITUTION	Space - no substitution 1 - substitution up to 15th Dec 2 - substitution/applied after 15th Dec 3 - substitution/applied after 16th May C - substitution in confirmation (UF only)
DATESUBSTITUTED	Date a substitution was made or applied post 15th Dec
PREVIOUSINST	Previous institution
PREVIOUSCOURSE	Previous course
PREVIOUSCAMPUS	Previous campus
UCASAMENDMENT	Null - No UCAS amendment A - latest amendment P - previous amendment
ROUTEBPREF	Route B preference, Rounds Priority 1,2 or3
ROUTEBROUND	Route B Actual Round
EXTRAROUND	Extra round choice number.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change to any choice for this applicant
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
LASTCHANGE	Date and time of last change to this choice.
INST	Institution Code
COURSE	Course Code
CAMPUS	Campus Code
FACULTY	Faculty Code
HOME	H - Live at home

Student System - IGS_UC_MV_IVSTARA	This table stores the Applicant address. This will contain a row for each applicant that you are allowed to see. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
TELEPHONE	Telephone number
EMAIL	EAS Email address
HOMEADDRESS1	EAS Address line 1
HOMEADDRESS2	EAS Address line 2
HOMEADDRESS3	EAS Address line 3
HOMEADDRESS4	EAS Address line 4
HOMEPOSTCODE	EAS Postcode
HOMEPHONE	EAS Home Phone number
TIMESTAMP	Time stamp - date and time of last change
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
ADDRESSAREA	H = England/Wales/N. Ireland. O = Overseas. S = Scotland
ADDRESS1	Address line 1
ADDRESS2	Address line 2
ADDRESS3	Address line 3
ADDRESS4	Address line 4
POSTCODE	UK addresses only
MAILSORT	UK addresses only

Student System - IGS_UC_MV_IVQUAL	This is a table of an applicant's results matching status. There is a single row for each applicant. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
AICEDATE	AICE moved date
GCESQADATE	GCESQA moved date
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
MATCHPREVIOUS	C - Cease matching, N - Not taking these exams, F - Full match, P - Part match and Null means Not set
MATCHPREVIOUSDATE	Date match previous changed
MATCHWINTER	Matched Winter Results
MATCHSUMMER	Matched Summer Results
GNVQDATE	GNVQ moved date -Obsoleted
IBDATE	IB moved date
ILCDATE	ILC moved date

Student System - IGS_UC_MV_IVOFFER	Contains details of offers made to your institution's applicants via LD and LA transactions. Other institution offers are not available. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
OFFERTEXT	Semi-expanded offer letter.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CHOICENO	Choice Number
TIMESTAMP	Time stamp - date and time of last change
OFFERCOURSE	Change Course
OFFERCAMPUS	Change Campus
OFFERCOURSELENGTH	Change Duration
OFFERENTRYMONTH	Change Entry Month
OFFERENTRYYEAR	Change Entry Year
OFFERENTRYPOINT	Change entry point

Student System - IGS_UC_MV_CVSCHOOL	List of school details and addresses - OBSOLETE
Column Name	Descritpion
SCHOOL	UCAS school code
COUNTRY	Use APR codes for meaning
LEA	APR codes which are also LEA
UCASSTATUS	L,M,N,C (Live, Merged, Not Live, Closed)
ESTABGRP	cvRefEstGroup
SCHOOLTYPE	cvRefSchoolType
STATSDATE	Date when Statistics collected - no on roll through No going to HE
NOROLL	No on Roll
NO5TH	Number in 5th form
NO6TH	Number in 6th form
NOHE	Number going to higher education
SITECODE	For future use - when one organization has several site addresses
ADDRESS1	School address line 1
ADDRESS2	School address line 2
ADDRESS3	School address line 3
ADDRESS4	School address line 4
POSTCODE	UK addresses only
MAILSORT	UK only - 5 digit mail sort code for bulk mailing
TOWNKEY	Town key
COUNTYKEY	County Key
COUNTRYCODE	E,N,S,W,O for England, Northern .Ireland etc
CREATED_BY	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
SCHOOLNAME	School Name
NAMECHANGEDATE	Date when school name last changed
FORMERNAME	Schools former name
NCN	Cambridge NCN for exam matching purposes
EDEXCELNCN	Formally BTEC National Center Number
DFEECODE	7 digit DfEE code (DfEE schools only)

Student System - IGS_UC_MV_CVSCHL_CT	List of School Contacts. - OBSOLETE
Column Name	Descritpion
SCHOOL	School Code
PRINCIPAL	Y = This post is the head of the organization
LISTS	Y = This post orders/receives lists
ORDERS	Y = This post deals with material orders (handbooks, forms etc)
FORMS	Y = This post returns/co-ordinates transmission of forms to UCAS (incl. Payment)
REFEREE	Y = This post acts as a referee on some or all UCAS forms
CAREERS	Y = This is the careers material contact
EASCONTACT	Y = This is the EAS installer/administrator
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
SITECODE	For future use - when one organization has several site addresses
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CONTACTCODE	Set to 1 for primary contact and 2 for any existing secondary contacts
TIMESTAMP	Time stamp - date and time of last change
CONTACTPOST	Name of Post e.g. Headmaster, Head of Sixth, Director of Education etc (Title1)
CONTACTNAME	Post holders name e.g. Mr J Smith Dr A Waters etc (Name1)
TELEPHONE	Includes STD code e.g. 01242 123456
FAX	Fax Number
EMAIL	Email address

Student System - IGS_UC_MV_CVR_SUB	List of subject codes with descriptions, abbreviations as used on Clearing Entry Forms and the EBL codes used on results. - OBSOLETE
Column Name	Descritpion
SUBJCODE	Hercules Subject Code
SUBJTEXT	Subject text
SUBJABBREV	Used on Clearing Entry Forms
EBL_SUBJ	ANN format if subject is an A/AS level, SQA Higher or ILC subject. Spaces otherwise.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_MV_CVNAME	List of all UCAS applicants with name and status. - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
WITHDRAWN	Y - Withdrawn
STATUS	Status
BIRTHDATE	Date of Birth
SEX	M - Male , F - Female
CHOICEALLTRANSPARENT	-Obsolete
EXTRASTATUS	Indicates whether the applicant is in extra processing.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
TIMESTAMP	Date and time of last change
LAST_UPDATE_LOGIN	Standard WHO Column
CHOICESALLTRANSPARENT	Indicates whether the Student Application Choices are visible to institution or not.
CHECKDIGIT	Application number check digit
NAMECHANGEDATE	Date and time of last change
TITLE	Mr, Miss,Ms,Mrs, Lord etc
FORENAMES	First Names
SURNAME	Surname
INDEXSURN	Surname in upper case
CANCELLED	Y - Cancelled

Student System - IGS_UC_MV_CVINST	Lists all institutions. - OBSOLETE
Column Name	Descritpion
INST	Institution Code
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
INSTCODE	Abbreviated Institution Name
INSTNAME	Institution Name
UCAS	Y
GTTR	For use later
SWAS	For use later
NMAS	For use later
CREATED_BY	Standard WHO Column

Student System - IGS_UC_MV_CVEBL_SUB	Lists all the subjects for an examining board subject, year and sitting. - OBSOLETE
Column Name	Descritpion
SUBJECTID	Subject ID
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	Time stamp - date and time of last change
YEAR	1950 - 2049
SITTING	S - summer, W - winter
AWARDINGBODY	Board
EXTERNALREF	Awarding body code for this exam/paper/module etc
EXAMLEVEL	If this column is having value as A- means Advanced level, AS - means Advanced Supplementary , CS - means Certificate of six year studies, H - means SQA Higher , GN - means GNVQ, S - means Special paper
TITLE	Subject Title
SUBJCODE	UCAS subject abbreviation

Student System - IGS_UC_MV_CVCOURSE	Lists all the courses that are running for each institution. - OBSOLETE
Column Name	Descritpion
INST	Institution Code
JOINTADMISSION	Joint Admissions Entity flag.
OPENEXTRA	Indicates the availability for UCAS Extra.
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
COURSE	Course Code
CAMPUS	Campus Code
TIMESTAMP	Time stamp - date and time of last change
FACULTY	Faculty Code
SHORTNAME	Short Course Name
LONGNAME	Long Course Name
VALIDCURRENT	Null - not valid this year , D - discontinued , R - running
VALIDDEFER	Null - not valid for deferred year , D - discontinued, R - running

Student System - IGS_UC_MV_CVCONTROL	This view contains one row of control data. - OBSOLETE
Column Name	Descritpion
ENTRYYEAR	Entry Year
RUNDATE15JAN	Run date of last application number by 15th December
APPNO24MAR	Last application number by 24th March
RUNDATE24MAR	Run date of last application number by 24th March
APPNODECISIONPROC	Last application number in decision processing
RUNDATEDECISIONPROC	Run date of last application number in decision processing
NEWS	News
NOMORELATRAN	Y - too late for LA transactions.
TIMEOFYEAR	Space- Clearing not started , A Clearing Entry Form's sent to applicants (UCAS MU06 run) , C - Clearing started
STARXAVAIL	Y - Star X data is available
TIMEOFDAY	Time
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
APPNOFIRSTOPF	First application number for Overseas Partnership forms
APPNOFIRSTRPANONEU	First application number for Record of Prior Acceptance - non EU
APPNOFIRSTRPAEU	First application number for Record of Prior Acceptance - EU
EXTRASTART	Start of UCAS Extra Processing date.
LASTPASSPORT	Last day for Extra Passports.
ROUTEBTIMEOFYEAR	Space - Route B choices on GA0 - Route B supplementary forms sent 1 - Round 1 sent 2 - Round 2 sent3 - Round 3 sent5 - No more supplementary forms6 - No more send-offs
LASTLE	Last day for LE transactions.
APPNOFIRST	First application number
APPNOMAXIMUM	Maximum application number this year
APPNOLASTUSED	Last application number in use
LASTDAILYRUNNO	Last daily run number
LASTDAILYRUNDATE	Last daily run date
APPNO15JAN	Last application number by 15th December

Student System - IGS_UC_REF_SUBJ	Stores the UCAS Subject reference codes
Column Name	Descritpion
SUBJ_TEXT	Subject text
SUBJ_ABBREV	Used on Clearing Entry Forms
EBL_SUBJ	Examination Board Listing subject - stored in ANN format if subject is an A or AS level , SQA Higher or ILC subject
IMPORTED	Indicates if the record has been imported from the UCAS
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
SUBJ_CODE	Hercules Subject code
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_UC_QUAL_DETS	The qualification details table will hold the qualifications awarded to an applicant.
Column Name	Descritpion
QUAL_DETS_ID	Qualification details identifier
PREDICTED_RESULT	Predicted Result
APPROVED_RESULT	Approved Result
CLAIMED_RESULT	Claimed Result
UCAS_TARIFF	UCAS Tariff
IMPORTED_FLAG	Record imported from UCAS? 'Y' for YES or 'N' for No
IMPORTED_DATE	Date when Record is imported.
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
PERSON_ID	Person Identifier
LAST_UPDATE_LOGIN	Standard Who Column
EXAM_LEVEL	Qualification
SUBJECT_CODE	Subject Code
YEAR	Year (1950-2049)
SITTING	S - summer, W - winter
AWARDING_BODY	Awarding Board code
GRADING_SCHEMA_CD	Grading Schema Code
VERSION_NUMBER	Grading Schema Version Number

Student System - IGS_UC_REF_CODES	Holds the list of reference codes used in other tables and their descriptions for the purpose of display in forms
Column Name	Descritpion
CODE	Reference Code
CODE_TEXT	Description of the Reference Code
IMPORTED	Record imported from UCAS? ('Y' Yes, 'N' No)
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CODE_TYPE	Reference Code Type

Student System - IGS_UC_REF_AWRDBDY	Holds the list of examining boards that are associated with subjects. It is used to link exam boards to results. It synchronizes with UCAS view 'cvRefAwardBody'.
Column Name	Descritpion
SITTING	S - summer, W - winter
AWARDING_BODY	Awarding Board code
BODY_NAME	Awarding Board name
BODY_ABBREV	Awarding Board abbreviation
IMPORTED	Record imported from UCAS? ('Y' Yes, 'N' No)
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
YEAR	Year (1950-2049)
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_UC_REF_APR	Holds the list of valid domicile codes. It synchronizes with UCAS view 'cvRefAPR'.
Column Name	Descritpion
DOM_TEXT	Domicile code description
LEA_FLAG	Local Education Authority flag (Y-Yes, N-No)
IMPORTED	Record imported from UCAS? ('Y' Yes, 'N' No)
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
DOM	Domicile code

Student System - IGS_UC_PROSPECTIVE	Synchronizes with UCAS view 'cvName'.
Column Name	Descritpion
APP_NO	Application Number
DATETIMESTAMP	Date Time Stamp
CHECK_DIGIT	Check Digit
NAME_CHANGE_DATE	Name Change Date
TITLE	Title
FORENAMES	Forenames
SURNAME	Surname
INDEX_SURNAME	Index Surname
PROSPECTIVE_ID	Prospective ID
CANCELLED	Cancelled
WITHDRAWN	Withdrawn
STATUS	Status
BIRTH_DATE	Date Of Birth
SEX	Sex
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Student System - IGS_UC_OFFER_CONDS	This is the master table in the generic condition library . It holds the condition category and condition code , which is used to uniquely identify the offer condition and its attributes
Column Name	Descritpion
CONDITION_CATEGORY	Condition Category Name
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
CONDITION_NAME	User friendly offer name
EFFECTIVE_FROM	Start date for condition
EFFECTIVE_TO	End date for condition
STATUS	Condition status (N - not tested , P- pending , A - passed , F- failed)
MARVIN_CODE	Marvin coded offer
SUMM_OF_COND	Summary of Conditions
LETTER_TEXT	Text format of the letter generated by this offer
DECISION	UCAS Decision
CREATED_BY	Standard WHO columns

Student System - IGS_UC_INST_CONTS	Holds the institution contact codes. It synchronizes with UCAS view 'uvContact'.
Column Name	Descritpion
DATETIMESTAMP	Timestamp to synchronize with UCAS view uvContact - Obsolete
UPDATER	ID of last updater
NAME	Contact name
POST	Post held by contact
ADDRESS1	Contact address line 1
ADDRESS2	Contact address line 2
ADDRESS3	Contact address line 3
ADDRESS4	Contact address line 4
CONTACT_CODE	'A' to 'Z'
TELEPHONE	Telephone number
FAX	FAX number
EMAIL	Email address
SENT_TO_UCAS	Update sent to UCAS ('Y' - yes, 'N' - no)
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_UC_INST_CONTROL	Holds the control information for the institution using UCAS sub-system. It synchronizes with UCAS view 'uvInstitution'
Column Name	Descritpion
UPDATER	No longer used
EBL_NC_APP	Indicate if non-committed applicants are excluded or required in EBL
EBL_MAJOR_KEY1	Major key 1 for EBL
EBL_MAJOR_KEY2	Major key 2 for EBL
EBL_MAJOR_KEY3	Major key 3 for EBL
EBL_MINOR_KEY1	Minor Key 1 for EBL
EBL_MINOR_KEY2	Minor Key 2 for EBL
EBL_MINOR_KEY3	Minor Key 3 for EBL
EBL_FINAL_KEY	Final key for EBL
ODL1	Updateable coded order for Outstanding Decision List 1
ODL1A	Updateable coded order for ODL1A
INST_TYPE	No longer used
ODL2	Updateable coded order for ODL2
ODL3	Updateable coded order for ODL3
ODL_SUMMER	Updateable order for summer ODL
ODL_ROUTE_B	Updateable coded order for route B ODL
MONTHLY_SEQ	Order for monthly information
MONTHLY_PAPER	Number of parts for monthly information
MONTHLY_PAGE	Pagination for monthly information
MONTHLY_TYPE	Type of monthly information (null - none, I - information list, M - movement list)
JUNE_LIST_SEQ	Order for June list
JUNE_LABELS	Order for June labels
INST_SHORT_NAME	Abbreviated institute name
JUNE_NUM_LABELS	Number of June labels
COURSE_ANALYSIS	Frequency of decision documents
CAMPUS_USED	Indicates whether campus codes are used
D3_DOC_REQUIRED	Indicates if D3 decision documents required
CLEARING_ACCEPT_COPY_FORM	Updateable Accept copy of application form for clearing
ONLINE_MESSAGE	Message for the user
ETHNIC_LIST_SEQ	Updateable coded order for ethnic lists
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
INST_NAME	Institute name
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
STARX	Indicates whether starx transaction is required or not
INST_FULL_NAME	Institute full name
SWITCHBOARD_TEL_NO	Updateable with '0'-'9' and '-'
DECISION_CARDS	Coded number of Decision Cards
RECORD_CARDS	Coded number of Record Cards
DATETIMESTAMP	Timestamp for synchronizing with UCAS - Obsolete
LABELS	Coded number of new applicant labels
WEEKLY_MOV_LIST_SEQ	Order of weekly move lists
WEEKLY_MOV_PAGING	Pagination for weekly move lists
FORM_SEQ	Updateable coded order of forms
EBL_REQUIRED	Indicates Examination Board Listing requirement (EBL1,2,3 required, no EBL required etc.)
EBL_MEDIA_1OR2	Media for EBL 1 / 2
EBL_MEDIA_3	Media for EBL 3
EBL_1OR2_MERGED	Indicates if EBL1 & 2 are separate or merged
EBL_1OR2_BOARD_GROUP	Indicates if EBL 1 & 2 have separate boards
EBL_3_BOARD_GROUP	Indicates if EBL3 has a combined board

Student System - IGS_UC_INST_CNT_GRP	Holds the institution contact membership to UCAS contact groups.It synchronizes with UCAS view uvContGrp
Column Name	Descritpion
CONTACT_CODE	'A' to 'Z'
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
DATETIMESTAMP	Timestamp to synchronize with UCAS view cvContGrp - Obsolete
UPDATER	ID of last updater
UCAS_GROUP	UCAS Group code
SENT_TO_UCAS	Update sent to UCAS ('Y' Yes, 'N' No)
DELETED	Record marked for deletion(Y-yes,N-no)
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns

Student System - IGS_UC_MAP_OFF_RESP	Stores the mappings between UCAS decision,reply code combinations and admission offer response status codes
Column Name	Descritpion
SYSTEM_CODE	Identifies the UCAS admissions system
LAST_UPDATE_LOGIN	Standard WHO Column
DECISION_CODE	UCAS Decision Code
REPLY_CODE	UCAS Reply Code
ADM_OFFER_RESP_STATUS	Admissions User Offer response code
CLOSED_IND	Default Value N,indicates this record is valid to be used
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column

Student System - IGS_UC_MAP_OUT_STAT	Stores the mappings between the UCAS decision codes and the admission outcome status codes
Column Name	Descritpion
SYSTEM_CODE	Identifies the UCAS admissions system
LAST_UPDATE_LOGIN	Standard WHO column
DECISION_CODE	UCAS Decision code
ADM_OUTCOME_STATUS	Admissions user outcome status code
DEFAULT_IND	Flag to identify the default mapping for each UCAS system decision
CLOSED_IND	Default Value N,indicates this record is valid to be used
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column

Student System - IGS_UC_OLD_OUSTAT
Column Name	Descritpion
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CHOICE_NO	UCAS application choice number
OLD_OUTCOME_STATUS	Old admission outcome status captured
DECISION_DATE	Old outcome's decision date
APP_NO	UCAS application number
DECISION_REASON_ID	Old outcome's Decision Reason
DECISION_MAKE_ID	Old outcome's decision maker
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column

Student System - IGS_UC_SYS_DECISION	Seeded Table containing the system decision codes
Column Name	Descritpion
SYSTEM_CODE	Identifies the UCAS admissions system
DECISION_CODE	UCAS Decision Code
S_ADM_OUTCOME_STATUS	The default Admission System outcome status code
CLOSED_IND	Default Value N,indicates this record is valid to be used
DECISION_TYPE	Defines which Decision Type a UCAS decision applies to

Student System - IGS_UC_JNT_ADM_INST	Holds the details of institutions, which are recorded as Joint Admissions Entities.
Column Name	Descritpion
CHILD_INST	Institution code of main (or child institution)
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
PARENT_INST1	Institution code of first parent institution
PARENT_INST2	Institution code of second parent institution
PARENT_INST3	Institution code of third parent institution
PARENT_INST4	Institution code of fourth parent institution
PARENT_INST5	Institution code of fifth parent institution
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Student System - IGS_UC_MV_CVR_P2KPC	Holds list of Pre-2000 Parental Occupation Codes and Social Class with description. - OBSOLETE
Column Name	Descritpion
POCC	Occupational group (in the range 000 to 999)
SOCIALCLASS	Pre-2000 Social Class
OCCUPATIONTEXT	Occupation Text
ALTERNATIVETEXT	Alternative Text
ALTERNATECLASS1	First Alternative Class
ALTERNATECLASS2	Second Alternative Class

Student System - IGS_UC_MV_CVR_SOCCL	Holds list of Pre-2000 Social Class values. - OBSOLETE
Column Name	Descritpion
SOCIALCLASS	Pre-2000 Social Class
SOCIALCLASSTEXT	Social Class description

Student System - IGS_UC_MV_CVR_SOCEC	Holds list of Socio-economic classifications. - OBSOLETE
Column Name	Descritpion
SOCIOECON	Socio-economic classification
SOCIOECONTEXT	Socio-economic description

Student System - IGS_UC_MV_CVR_TARIF	Holds list of Tariff scores and the equivalent exam levels and scores. - OBSOLETE
Column Name	Descritpion
EXAMLEVEL	Exam level - A,A1,V,V2 etc.
EXAMGRADE	Grade achieved - A,B,C etc.
TARIFFSCORE	Points awarded - 10,120,48 etc.

Student System - IGS_UC_MV_JOINT_ADM	Holds the details of institutions, which are recorded as joint admissions Entities. - OBSOLETE
Column Name	Descritpion
CHILDINST	Institution Code (of main or Child institution)
PARENTINST1	Institution Code (of first Parent institution)
PARENTINST2	Institution Code (of second Parent institution)
PARENTINST3	Institution Code (of third Parent institution)
PARENTINST4	Institution Code (of fourth Parent institution)
PARENTINST5	Institution Code (of fifth Parent institution)

Student System - IGS_UC_REF_PRE2KPOC	Holds list of Pre-200 parental Occupation Codes and Social Class with description.
Column Name	Descritpion
POCC	Occupational group (in the range 000 to 999)
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
SOCIAL_CLASS	Pre-2000 Social Class
OCCUPATION_TEXT	Occupation Text
ALTERNATIVE_TEXT	Alternative Text
ALTERNATE_CLASS1	First Alternative Class
ALTERNATE_CLASS2	Second Alternative Class
IMPORTED	Imported from UCAS ? ('Y' Yes, 'N' No)
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Student System - IGS_UC_REF_TARIFF	Holds the list of EBL exam level, grade and associated UCAS tariff score.
Column Name	Descritpion
EXAM_LEVEL	Exam Level e.g. A, A1, V etc
EXAM_GRADE	Grade achieved
TARIFF_SCORE	UCAS tariff points awarded
IMPORTED	Record Imported from UCAS? ('Y Y'es, 'N' No)
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_UC_MV_DEGSB_INT	Holds temporary data while uploading Degree Subjects for Small Systems
Column Name	Descritpion
DEG_SUBJ_CODE	Degree Subject for Small Systems
CODE_TEXT	Degree Subject Description for Small Systems

Student System - IGS_UC_MV_ERRCD_INT	Temporary table used while uploading Error codes for Small Systems
Column Name	Descritpion
ERROR_CODE	Error Code for Small Systems
CODE_TEXT	Error Code Description for Small Systems

Student System - IGS_UC_MV_INST_INT	Holds temporary data while uploading Institution codes for Small Systems
Column Name	Descritpion
INST	Three character Institution Code for Small Systems
INST_CODE	Institution Code for Small Systems
INST_NAME	Institution Name for Small Systems
SYSTEM_CODE	UCAS System Code

Student System - IGS_UC_MV_IVSTARG	Holds Applicant Choice records for GTTR System - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
REPLY	GTTR Reply
ENTRYYEAR	Entry Year
ENTRYMONTH	Entry Month
ACTION	Action Flag
INTERVIEW	Interview Date
LATEAPPLICATION	Late Application
MODULAR	Modular
CONFIRMED	Confirmed
GCSEENG	GTTR GCSE English
GCSEMATH	GTTR GCSE Math
ROUNDNO	Round Number mapped to Choice Number of UCAS application choices table
DEGREESUBJECT	GTTR Degree Subject
DEGREESTATUS	GTTR Degree Status
DEGREECLASS	GTTR Degree Class
GCSESCI	GTTR GCSE Science
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	IVSTARG Time Stamp
LASTCHANGE	Last Change
INST	Institute Code
COURSE	GTTR Course Code
CAMPUS	GTTR Campus
PARTTIME	Part Time
DECISION	GTTR Decision

Student System - IGS_UC_MV_IVSTART	Holds General Social Care Council Data - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
TIMESTAMP	IVSTART Timestamp
LASTCHANGE	Last Change
FUTURESERV	SWAS - Future Service
FUTURESET	SWAS - Future Setting
PRESENTSERV	SWAS - Present Service
PRESENTSET	SWAS - Present Setting
CURREMP	SWAS - Current Employment
EDUQUAL	SWAS - Educational Qualification

Student System - IGS_UC_SS_IVSTARC	Holds Application Choice extension columns for Small Systems - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
CHOICENO	Choice Number
RESIDENTIAL	NMAS - Residential Accommodation Required

Student System - IGS_UC_SS_IVSTARH	Holds extension columns for HESA Statistics information about applicants for Small Systems - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
DEPENDANTS	NMAS - Number of Dependants
MARRIED	NMAS - Marital Status

Student System - IGS_UC_SS_IVSTARK	Holds Applicant details extension columns for Small Systems - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
MAINQUAL	NMAS - Main Qualification
QUAL5	NMAS - Qualified With 5 Points
WELSHSPEAKER	SWAS - Welsh Speaker
NINUMBER	NMAS - NI Number
EARLIESTSTART	NMAS - Earliest Start Date
NEARINST	NMAS - Nearest Institution
PREFREG	NMAS - Preferred Region
QUALENG	NMAS - Qualified In English
QUALMATH	NMAS - Qualified In Math's
QUALSCI	NMAS - Qualified In Science

Student System - IGS_UC_SS_IVSTARX	Holds extension columns for Extra Statistics information about applicants for Small Systems - OBSOLETE
Column Name	Descritpion
APPNO	Application Number
RELIGION	SWAS - Religion1 - Protestant 2 - Catholic 3 - Other
DEPENDANTS	NMAS - Number of Dependants
MARRIED	NMAS - Marital Status S - Single, M - Married, D - Divorced ,W - Widowed, Blank - Not Known

Student System - IGS_UC_TRANS_TYPES	Holds seeded information about Transaction Types valid for each of the UCAS Systems
Column Name	Descritpion
SYSTEM_CODE	UCAS System Code
TRANSACTION_TYPE	Transaction Type
DESCRIPTION	Transaction Type Description
ENABLED	Enabled Flag
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_UC_MAP_EBL_QUAL	Holds seeded information about mapping information between Exam Board details, Exam Level and Qualification details.
Column Name	Descritpion
EBL_FORMAT	EBL format of the Subject
EXAM_LEVEL	Examination Level code
AWARDING_BODY	Awarding Body code
CONV_EBL_FORMAT	Converted EBL format of the Subject
CLOSED_IND	Closed Indicator , takes values Y or N
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
EXAM_BOARD_CODE	Exam Board Code
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Student System - IGS_UC_QUAL_INTS	This interface table holds the Qualification details that need to get imported for a person
Column Name	Descritpion
INTERFACE_ID	Interface identifier
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
REQUEST_ID	Standard WHO Column for concurrent programs
PROGRAM_ID	Standard WHO Column for concurrent programs
PROGRAM_APPLICATION_ID	Standard WHO Column for concurrent programs
PROGRAM_UPDATE_DATE	Standard WHO Column for concurrent programs
INTERFACE_RUN_ID	Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
PERSON_ID	Person Identifier. This column will be populated by the import process
ERROR_TEXT	Error Text
EXAM_LEVEL	Qualification
SUBJECT_CODE	Subject Code
YEAR	Year, If the value is there then it should be greater than 1900 and less than 2200
SITTING	Sitting
AWARDING_BODY	Awarding Body
GRADING_SCHEMA_CD	Grading Schema Code
VERSION_NUMBER	Grading Schema Version Number
INTERFACE_QUAL_ID	A unique identifier to identify each row in this table
PREDICTED_RESULT	Predicted Result
APPROVED_RESULT	Approved Result
CLAIMED_RESULT	Claimed Result
UCAS_TARIFF	UCAS tariff
IMPORTED_FLAG	Imported Flag
IMPORTED_DATE	Imported Date
STATUS	Status of the interface record
ERROR_CODE	Error Code
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column

Student System - IGS_UC_FORM_QUALS	Holds individual Form Qualifications imported from UCAS
Column Name	Descritpion
APP_NO	Applicant Number
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
QUAL_ID	No Longer Used
QUAL_TYPE	Qualification type
AWARD_BODY	Awarding body
TITLE	Title
GRADE	Grade obtained
QUAL_DATE	Qualification date
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Student System - IGS_UC_HRC_TIMSTMPS	Holds individual timestamps for each Hercules View , in a UCAS Cycle
Column Name	Descritpion
VIEW_NAME	Hercules view name
UCAS_CYCLE	UCAS Cycle to which this timestamp belongs to
TIMESTAMP	Timestamp of this view
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Student System - IGS_UC_IFRMQUL_INTS	Holds form qualification information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
QUALID	Qualification identifier
QUALTYPE	Qualification type
AWARDBODY	Awarding body code
TITLE	Award title
GRADE	Grade obtained
QUALDATE	Qualification date
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data

Student System - IGS_UC_IOFFER_INTS	Holds offer information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
OFFERTEXT	Semi-expanded offer letter
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
CHOICENO	Choice Number
UCAS_CYCLE	UCAS Cycle to which this interface record belongs to
OFFERCOURSE	Change Course
OFFERCAMPUS	Change Campus
OFFERCOURSELENGTH	Change Duration
OFFERENTRYMONTH	Change Entry Month
OFFERENTRYYEAR	Change Entry Year
OFFERENTRYPOINT	Change entry point

Student System - IGS_UC_IQUAL_INTS	Holds Qualification information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
GCESQADATE	GCESQA moved date
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
MATCHPREVIOUS	C - Cease matching, N - Not taking these exams, F - Full match, P - Part matchNull - Not set
MATCHPREVIOUSDATE	Date match previous changed
MATCHWINTER	Matched Winter Results
MATCHSUMMER	Matched Summer Results
GNVQDATE	GNVQ moved date
IBDATE	IB moved date
ILCDATE	ILC moved date
AICEDATE	AICE moved date

Student System - IGS_UC_IREFRNC_INTS	Holds applicant reference information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
FAX	Fax number
EMAIL	Email address
STATEMENT	Electronic application Statement
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
PREDICTEDGRADES	Predicted Grades
REFEREENAME	Referee name
REFEREEPOST	Referee post
ESTABNAME	Establishment name
ADDRESS1	Address line 1
ADDRESS2	Address line 2
ADDRESS3	Address line 3
ADDRESS4	Address line 4
TELEPHONE	Telephone

Student System - IGS_UC_ISTARA_INTS	Holds applicant address information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
FAX	Facsimile
EMAIL	EAS Email address
HOMEADDRESS1	Home Address line 1
HOMEADDRESS2	Home Address line 2
HOMEADDRESS3	Home Address line 3
HOMEADDRESS4	Home Address line 4
HOMEPOSTCODE	Home Postcode
HOMEPHONE	Home Phone number
HOMEFAX	Home Facsimile
HOMEEMAIL	Home Email address
ADDRESSAREA	H = England or Wales or N. Ireland, O = Overseas, S = Scotland
MOBILE	Mobile phone number
COUNTRYCODE	Correspondence Country Code
HOMECOUNTRYCODE	Home Address Country Code
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
ADDRESS1	Correspondence Address line 1
ADDRESS2	Correspondence Address line 2
ADDRESS3	Correspondence Address line 3
ADDRESS4	Correspondence Address line 4
POSTCODE	UK addresses only
MAILSORT	UK addresses only
TELEPHONE	Telephone number

Student System - IGS_UC_ISTARC_INTS	Holds application choice information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
DECISION	UCAS Decision. Values are C,U,R,W or Blank
DECISIONDATE	Date when the decision was made
DECISIONNUMBER	Pre SOD reply: 0 - no decision ,1 - 1st decision (LD), 2-9 - 2nd etc decision (LA). Post SOD reply: 0 - SOD reply , 1 - Confirmation decision , 2 - UF amendment
REPLY	UCAS Reply. Values can be, F, I, D or Blank
SUMMARYCONDITIONS	Summary of conditions column
ENTRYMONTH	Month course starts
ENTRYYEAR	Year the course starts
ENTRYPOINT	Null = year 1 entry, 1-4 = Year of entry, 0 = Foundation Year entry
CHOICECANCELLED	Y means Choice cancelled
ACTION	D - DBD (Decline by Default), R - RBD (Reject by Default), U - up rated (UI-UF, CI-CF), X - assumed decline (no answer on AS6C, AS6F, AS6R, AS6W, AS7)
CHOICENO	Choice Number
SUBSTITUTION	Space - no substitution, 1 - substitution up to 15th Dec, 2 - substitution or applied after 15th Dec, 3 - substitution or applied after 16th May C - substitution in confirmation (UF only)
DATESUBSTITUTED	Date a substitution was made or applied post 15th Dec
PREVIOUSINST	Previous institution
PREVIOUSCOURSE	Previous course
PREVIOUSCAMPUS	Previous campus
UCASAMENDMENT	Null - No UCAS amendment, A - latest amendment, P - previous amendment
ROUTEBPREF	Route B preference, Rounds Priority 1,2 or3
ROUTEBROUND	Route B Actual Round
DETAIL	Detail
EXTRAROUND	Extra round choice number
UCAS_CYCLE	UCAS Cycle to which this interface record belongs to
RESIDENTIAL	NMAS- Residential Accommodation Required
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
LASTCHANGE	Date and time of last change to this choice
INST	Institution Code
COURSE	Course Code
CAMPUS	Campus Code
FACULTY	Faculty Code
HOME	H - Live at home

Student System - IGS_UC_ISTARG_INTS	Holds Applicant Choice Records for GTTR System
Column Name	Descritpion
APPNO	Application Number
REPLY	GTTR Reply
ENTRYYEAR	Entry Year
ENTRYMONTH	Entry Month
ACTION	Action Flag
INTERVIEW	Interview Date
LATEAPPLICATION	Late Application
MODULAR	Modular
CONFIRMED	Confirmed
GCSEENG	GTTR GCSE English
GCSEMATH	GTTR GCSE Math
ROUNDNO	Round Number
DEGREESUBJECT	GTTR Degree Subject
DEGREESTATUS	GTTR Degree Status
DEGREECLASS	GTTR Degree Class
GCSESCI	GTTR GCSE Science
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
UCAS_CYCLE	UCAS Cycle to which this interface record belongs to
LASTCHANGE	Last Change
INST	Institute Code
COURSE	GTTR Course Code
CAMPUS	GTTR Campus
PARTTIME	Part Time
DECISION	GTTR Decision

Student System - IGS_UC_ISTARH_INTS	Holds columns for HESA statistics information about Applicants for small systems.
Column Name	Descritpion
APPNO	Application Number
SOCIALECONOMIC	Socio-economic classification
DEPENDANTS	NMAS - Number of Dependants
MARRIED	NMAS - Marital Status
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
ETHNIC	Ethnic code
SOCIALCLASS	Social Class - pre 2000
POCCEDUCHANGEDATE	Date of change of Parental Occupation or Education details
POCC	Parental Occupation Group
POCCTEXT	EAS Parental Occupation Text
LASTEDUCATION	Last educational establishment: Last school attended (DFE number), Last HE inst attended (HESA code) , Zero if no details of leaving
EDUCATIONLEAVEDATE	Year of leaving
LEA	** NO LONGER USED **

Student System - IGS_UC_ISTARJ_INTS	Holds HESA data information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
ETHNIC	Ethnic code
DISABLE	Disability code
YRLLINST	Year Last left institution
OCCCODE	Occupation code
QUALENT2	Highest Qualification on entry code
SBJQA1	Subject of qualification Aim 1
SBJQA2	Subject of qualification Aim 2
SBJQA3	Subject of qualification Aim 3
SBJBID	Qualification Aim proportion code
FEEELIG	Fee eligibility
HUSID	Student HESA Identifier
POSTCODE	Post code
UCASNUM	UCAS applicant number
SEC	Socio economic Code
SOC2000	Social Class indicator code
PREVINST	Previous Institution
GCEASN	Number of GCE AS levels
GCEASTS	GCE AS Levels Tariff Score
VCEASN	No of VCE AS Levels
VCEASTS	VCE AS Levels Tariff Score
GCEAN	No of GCE A Levels
SCOTVEC	Scottish candidate number
GCEATS	GCE A Levels Tariff Score
VCEAN	No of VCE A Levels
VCEATS	VCE A Levels Tariff Score
KSQN	No of Key Skills
KSQTS	Key Skills Tariff Score
UKSAN	No of 1 unit key skills
UKSATS	1 unit key skills Tariff Score
SAHN	No of Advanced Highers
SAHTS	Advanced Highers Tariff Score
SHN	No of Highers
SURNAME	Surname
SHTS	No of Highers Tariff Score
SI2N	No of Intermediates
SI2TS	Intermediates Tariff Score
SSGCN	No of standard grade
SSGCTS	Standard grade Tariff Score
SCSN	No of Scottish core skills
SCSTS	Scottish core skills Tariff Score
AEAN	No of Advanced Extension Awards
AEATS	Advanced Extension Awards Tariff Score
TOTALTS	Total UCAS Tariff score
FNAMES	First name
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
BIRTHDTE	Date of Birth
GENDER	Gender
DOMICILE	Domicile code
NATION	Nationality

Student System - IGS_UC_ISTARK_INTS	Holds Applicant details columns for small systems
Column Name	Descritpion
APPNO	Application Number
FEETEXT	EAS fee payer name
APR	Refers to Error. Reference source not found.cvrefAPR - all values
LEA	**FIELD NO LONGER USED (2002)**
COUNTRYBIRTH	Refers to Error.Reference source not found.cvrefAPR - Countries
NATIONALITY	Refers to Error. Reference source not found.cvrefAPR - Countries
DUALNATIONALITY	EAS - same format as Nationality, but contains other nationality
WITHDRAWN	Null - not withdrawn, C - candidate withdrew, R - reinstatedW - UF withdrawal
WITHDRAWNDATE	Date candidate withdrew or was reinstated
ROUTEB	Y - route B is required
EXAMCHANGEDATE	Exam details changed date
APPLICATIONDATE	Application Date
ALEVELS	** FIELD NO LONGER USED (2002)**
ASLEVELS	** FIELD NO LONGER USED (2002)**
HIGHERS	** FIELD NO LONGER USED (2002)**
CSYS	** FIELD NO LONGER USED (2002)**
GCE	Number of GCE (A + AS) expected
VCE	Number of VCE (A + AS + Double) expected
SQA	Y - SQA Candidate
WINTER	Number of Winter A Levels
PREVIOUSA	Number of previous Summer A levels
PREVIOUSAS	Number of previous Summer AS levels
SENTDATE	Date sent out
KEYSKILLS	Y - taking Key Skills, N - not taking Key Skills
VOCATIONAL	Null - not taking vocational exams, 1 - taking Higher BTEC (HNC or HND), 2 - taking Lower BTEC (NC or ND), 3 - taking Foundation Art and Design course
GNVQ	** FIELD NO LONGER USED (2002)**
BTEC	Y - BTEC
ILC	Y - ILC
AICE	Y - AICE
IB	Y - International Baccalaureate
MANUAL	Y - manual investigation of previous results required
REGNO	BTEC registration number
SCN	Scottish Candidate Number
RUNSENT	Run or Batch number when sent
OEQ	Other Examination Qualifications
PREVOEQ	Previous Other Examination Qualifications
EAS	Y - Applied through EAS
ROA	Y - record of achievement (EAS applicants only)
SPECIALNEEDS	0 - No disability, 1 - Dyslexia, 2 - Blind or partial sight, 3 - Deaf or partial hearing, 4 - Wheelchair or mobility, 5 - Personal care, 6 - Mental health, 7 - Unseen disability, 8 - Multiple disabilities, 9 - Other disability
CRIMINALCONV	Criminal Conviction. Null - not known, Y - Yes, N - No
UKENTRYDATE	Date of first entry to UK
STATUS	Status code from cvRefStatus
FIRMNOW	Firm choice number
FIRMREPLY	Firm Reply
CODEDCHANGEDATE	Coded information changed date
INSURANCEREPLY	Insurance Reply
CONFHISTFIRMREPLY	Confirmation history firm reply
CONFHISTINSURANCEREPLY	Confirmation history insurance reply
CHOICESALLTRANSPARENT	Indicates whether the Student Applications Choices are visible to institution or not
EXTRASTATUS	Indicates whether the applicant is in extra processing
EXTRAPASSPORTNO	Passport ID used in UCAS Extra. For applicants applying on web will contain WEB
WELSHSPEAKER	SWAS - Welsh Speaker
NINUMBER	NMAS - NI Number
EARLIESTSTART	NMAS - Earliest Start Date
NEARINST	NMAS - Nearest Institution
SCHOOL	School code
PREFREG	NMAS - Preferred Region
QUALENG	NMAS - Qualified In English
QUALMATH	NMAS - Qualified In Maths
QUALSCI	NMAS - Qualified In Science
MAINQUAL	NMAS - Main Qualification
QUAL5	NMAS - Qualified With 5 Points
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
RESCAT	Residential Category
FEELEVEL	F - full fee, S - single entry fee(UCAS fee level received from applicant)
FEEPAYER	Fee Payer Code see Error! Reference source not found. cvRefFee

Student System - IGS_UC_ISTARN_INTS	Holds applicant name information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
AD_BATCH_ID	Admissions Import Batch ID
AD_INTERFACE_ID	Admissions Interface Import ID
AD_API_ID	Admissions Import API ID
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
CHECKDIGIT	Application number check digit
PERSONALID	Unique Personal Identifier
NAMECHANGEDATE	Date the Name Changed
TITLE	Title, Mr, Miss, Ms, Mrs, Lord etc ..
FORENAMES	Forenames
SURNAME	Surnames
BIRTHDATE	Date of birth
SEX	M - Male, F - Female

Student System - IGS_UC_ISTART_INTS	Holds General Social Care Council Data
Column Name	Descritpion
APPNO	Application Number
ERROR_CODE	Code for the error encountered during processing of this interface record data
LASTCHANGE	Last Change
FUTURESERV	SWAS- Future Service
FUTURESET	SWAS - Future Setting
PRESENTSERV	SWAS - Present Service
PRESENTSET	SWAS - Present Setting
CURREMP	SWAS - Current Employment
EDUQUAL	SWAS - Educational Qualification
RECORD_STATUS	Status of the interface record , takes values N, O, D etc

Student System - IGS_UC_ISTARW_INTS	Holds Wrong application information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
CHOICE6LOST	Substitute choice 6
CHOICE7LOST	Substitute choice 7
CANCELDATE	Date cancelled
REMARK	Why they were cancelled
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
MISCODED	Y - Miscoded
CANCELLED	Y - Cancelled
JOINTADMISSION	Joint admission
CHOICE1LOST	Substitute choice 1
CHOICE2LOST	Substitute choice 2
CHOICE3LOST	Substitute choice 3
CHOICE4LOST	Substitute choice 4
CHOICE5LOST	Substitute choice 5

Student System - IGS_UC_ISTARX_INTS	Holds Extra Statistics information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
DEPENDANTS	NMAS - Number of Dependants
MARRIED	NMAS - Marital Status. S - Single, M - Married, D - Divorced, W - Widowed, Blank - Not Known
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
ETHNIC	Ethnic origin
POCCEDUCHANGEDATE	Date of change of Parental Occupation details
SOCIALCLASS	Social Class - pre 2000
POCC	Parental Occupation Group
POCCTEXT	EAS Parental Occupation Text
SOCIOECONOMIC	Socio-economic classification
OCCBACKGROUND	Occupation background
RELIGION	SWAS - Religion. 1 - Protestant, 2 - Catholic, 3 - Other

Student System - IGS_UC_ISTARZ1_INTS	Holds Application Clearing information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
ENTRYMONTH	Entry Month
ENTRYPOINT	Point of Entry
RESULT	Result. Previously used in Central Clearing. Now only contains A (Accept) if Inst or Course are not null. Null otherwise
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
DATECEFSENT	Date Clearing Entry Form sent
CEFNO	Clearing Entry Form Number
CENTRALCLEARING	Central Clearing was discontinued in 1999. This field is no longer used, but contains the constant N for backward compatibility.
INST	Institution Code
COURSE	Course Code
CAMPUS	Campus Code
FACULTY	Faculty Code
ENTRYYEAR	Entry Year

Student System - IGS_UC_ISTARZ2_INTS	Holds Application Clearing round information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
ERROR_CODE	Code for the error encountered during processing of this interface record data
ROUNDNO	Round Number - previously used in Central Clearing - should be null
INST	Institution Code
COURSE	Course Code
CAMPUS	Campus Code
FACULTY	Faculty Code
ROUNDTYPE	Previously used in Central Clearing, now only contains F (Form Request)
RESULT	blank = Form request , star = New form request , I = Accepted at this institution, R = Rejected by institution, D = Declined by applicant C = Cancelled by applicant,X = Form request cancelled by UCAS
RECORD_STATUS	Status of the interface record , takes values N, O, D etc

Student System - IGS_UC_ISTMNT_INTS	Holds Application Statement information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
STATEMENT	Electronic Applicants Statement
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data

Student System - IGS_UC_ISTRPQR_INTS	Holds Previous qualification information loaded from UCAS
Column Name	Descritpion
APPNO	Application Number
GRADE	Grade from Marvin flat file
GRADE1	Grade 1 from Marvin flat file
GRADE2	Grade 2 from Marvin flat file
LENDINGBOARD	Lending Board code from Marvin flat file
MATCHIND	Match indicator from Marvin flat file
MARVIN_TYPE	Indicates if this is a Marvin *P or *R transaction
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
SUBJECTID	Subject identification number from cvEBLsubject
EBLRESULT	Contents depends on board:A-grade, A-grade and S-grade, Range mark,Percentage etc
EBLAMENDED	Grade amend by board:As EBLresult
CLAIMEDRESULT	Grade claimed by candidate:As EBLresult
YEAROFEXAM	Year of Exam from Marvin flat file
SITTING	Exam Sitting from Marvin flat file
EXAMBOARD	Exam Board code from Marvin flat file
EBLSUBJECT	EBL Subject code format from Marvin flat file

Student System - IGS_UC_TRANIN_INTS	Holds application choice transaction information loaded from UCAS
Column Name	Descritpion
TRANSACTIONID	Unique identifier , UCAS Applicant Number
CAMPUS	Campus code
ENTRYYEAR	Entry year
ENTRYMONTH	Entry month
ENTRYPOINT	Entry point
SOC	Summary of condition
FREEFORMAT	Free format
RETURN1	Return 1 value, returned from Hercules
RETURN2	Return 2 value, returned from Hercules
SYSCODE	System code
ROUNDNO	Round number
INSTREFERENCE	Institution reference
MODULAR	Modular indicator
PARTTIME	Part time indicator
UPDATER	Record updater in Hercules
ERRORCODE	Error code when transaction fails in Hercules
TRANSACTIONTYPE	Transaction type
APPNO	Application Number
CHOICENO	Choice Number
DECISION	Decision code
COURSE	Course code

Student System - IGS_UC_UCNTACT_INTS	Holds institution contact information loaded from UCAS
Column Name	Descritpion
CONTACTCODE	Contact code, takes values from A - Z
EMAIL	Email address
FAX	Fax number
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
UPDATER	ID of last updater
NAME	Name
POST	Post Held
ADDRESS1	Contact address line 1
ADDRESS2	Contact address line 2
ADDRESS3	Contact address line 3
ADDRESS4	Contact address line 4
TELEPHONE	Telephone Number

Student System - IGS_UC_UCNTGRP_INTS	Holds institution contact groups information loaded from UCAS
Column Name	Descritpion
CONTACTCODE	Contact code, takes values from A - Z
UCASGROUP	Contact Group code, taken from cvRefUCASgroup
UPDATER	ID of last updater
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data

Student System - IGS_UC_UCRSE_INTS	Holds update course information loaded from UCAS
Column Name	Descritpion
COURSE	Course Code
TERM1END	First term end date
TERM2START	Second term start date
TERM2END	Second term end date
TERM3START	Third term start date
TERM3END	Third term end date
TERM4START	Fourth term start date
TERM4END	Fourth term end date
JOINTADMISSION	Joint admission indicator
OPENEXTRA	Extra processing indicator
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
CAMPUS	Campus Code
ERROR_CODE	Code for the error encountered during processing of this interface record data
UPDATER	ID of last updater
FACULTY	Faculty Code
SHORTTITLE	Short Title
LONGTITLE	Long Title
VALIDCURR	D - Discontinued, R - Running, Null - Invalid
VALIDDEFER	D - Discontinued, R - Running, Null - Invalid
TERM1START	First term start date

Student System - IGS_UC_UCRSKWD_INTS	Holds course keywords information loaded from UCAS
Column Name	Descritpion
COURSE	Course Code
CAMPUS	Campus Code
OPTIONCODE	Option Code
KEYNO	Keyword number (1 - 6)
KEYWORD	Keyword
UPDATER	ID of last updater
ACTIVE	Y - Active,N - Not Active
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data

Student System - IGS_UC_UCRSVAC_INTS	Holds course vacancy information loaded from UCAS
Column Name	Descritpion
COURSE	Course Code
SCOTVAC	Up to 6 grades of A,B or C
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
CAMPUS	Campus Code
UPDATER	ID of last updater
CLUPDATED	Y - Updated not yet notified
CLDATE	Vacancies updated date
VACSTATUS	Y - Open to all applicants, N - Closed, O - Overseas only (not applicable to an option)
NOVAC	Number of vacancies or GI for group intake
SCORE	Score, takes values 000- 999
RBFULL	Null - Open, F - Full

Student System - IGS_UC_UCRSVOP_INTS	Holds course vacancy option information loaded from UCAS
Column Name	Descritpion
COURSE	Course Code
CAMPUS	Campus Code
OPTIONCODE	Option Code
UPDATER	ID of last updater
CLUPDATED	Y - Updated not yet notified
CLDATE	Vacancies updated date
VACSTATUS	Y - Open to all applicants, N - Closed, O - Overseas only (not applicable to an option)
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data

Student System - IGS_UC_UINST_INTS	Holds update institution information loaded from UCAS
Column Name	Descritpion
UPDATER	ID of last updater
WEEKLYMOVLISTSEQ	Space - no list, A - alpha, B - course or alpha, D - faculty or alpha, E - faculty or course or alpha, N - appno, P - course or appno, R - faculty or appno, T - faculty or course or appno
WEEKLYMOVPAGING	Space - no list, N - no paging major key change, Y - paging at major key change
FORMSEQ	A, B, D, E, N, P, R or T
EBLREQUIRED	Space - No EBL required, A - EBL1 and EBL2 and EBL3 required, N - No EBL required, P - EBL2 and EBL3 only, R - EBL3 only
EBLMEDIA1OR2	Space - No EBL1 or 2, L - EBL printed, T - EBL on mag tape
EBLMEDIA3	Space - No EBL3, L - EBL printed, O - EBL Online (MARVIN *R records), T - EBL on mag tape (Obsolete value)
EBL1OR2MERGED	Space - No EBL1 or 2, N - EBL1 and EBL2 separate, Y - EBL1 and EBL2 merged
EBL1OR2BOARDGROUP	Space - No EBL1 or 2, F - EBL1 or 2 fully combined, S - EBL1 or 2 separate boards
EBL3BOARDGROUP	Space - No EBL3C - EBL3 combined boards, F - EBL3 fully combined boards, S - EBL3 separate boards
EBLNCAPP	Space - no EBL required, N - None Committed applicants excluded, Y -None Committed applicants required
INSTTYPE	A - Route A only inst, B - Route B only inst, C - Route A and B inst.
EBLMAJORKEY1	Space - major key not required, C - Course, F - Faculty, G - Grouped June category, J - June category, S - Sex Y - Year of entry
EBLMAJORKEY2	Space - not requiredC, F, G, J, S, Y as EBLMajorKey1
EBLMAJORKEY3	As EBLMajorKey2
EBLMINORKEY1	Space - minor key not requiredC, F, G, J, S, Y as EBLMajorKey1
EBLMINORKEY2	Space - not requiredC, F, G, J, S, Y as EBLMajorKey1
EBLMINORKEY3	As EBLMinorKey2
EBLFINALKEY	Space - no EBL required, A - Alpha, B - Board ref(center or cand), N - App-reference number
ODL1	Space - no ODL1, A - alpha, B - course or alpha, D - faculty or alpha, E - faculty or course or alpha, N - appno, P - course or appno, R - faculty or appno, T - faculty or course or appno
ODL1A	Space - no ODL1A, B, D, E, N, P, R, T as ODL1
ODL2	Space - no ODL2A, B, D, E, N, P, R, T as ODL1
INSTSHORTNAME	e.g. ABRDN
ODL3	Space - no ODL3A, B, D, E, N, P, R, T as ODL1
ODLSUMMER	Space - no Summer ODLA, B, D, E, N, P, R, T as ODL1
ODLROUTEB	Space - no Route B ODLA, B, D, E, N, P, R, T as ODL1
MONTHLYSEQ	Space - no monthly info or movementA, B, D, E, N, P, R, T as ODL1
MONTHLYPAPER	Space - no monthly info or movement, 1 - 1-part paper, 2 - 2-part paper
MONTHLYPAGE	Space - no monthly info or movement, N - No paging at major key change, Y - Paging at major key change
MONTHLYTYPE	Space - no monthly info or movement, I - information list, M - movement list
JUNELISTSEQ	Space - no June lists ,A - alpha, B - course or alpha,D - faculty or alpha,E - faculty or course or alpha,N - appno,P - course or appno etc
JUNELABELS	Space - no June labels,A - alpha ,B - course or alpha,D - faculty or alpha,E - faculty or course or alpha,N - appno,P - course or appno,R - faculty or appno,T - faculty or course or appno
JUNENUMLABELS	Space - no labels, 1 - 1 set labels, 2 - 2 sets labels
INSTNAME	e.g. Aberdeen
COURSEANALYSIS	Space - No D3 decision docs, 1 - Monthly in course order, 2 - Fortnightly in course order, 3 - Monthly in faculty order4 - Fortnightly in faculty order
CAMPUSUSED	Space - Campus codes not used, C - Campus codes used
D3DOCSREQUIRED	Space - No D3 decision docs, N - No D3 decision docs, Y - D3 decision docs required
CLEARINGACCEPTCOPYFORM	Space - No Application form copy, Y - Application form for Clearing Accept
ONLINEMESSAGE	Message for this user
ETHNICLISTSEQ	Space - no June labels, A - alpha, B - course or alpha, D - faculty or alpha, E - faculty or course or alpha, N - appno, P - course or appno, R - faculty or appno, T - faculty orcourse or appno
STARX	Indicates if Starx transaction is necessary or not
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data
INSTFULLNAME	Full Name
SWITCHBOARDTELNO	0-9 and hyphen
DECISIONCARDS	Space - No decision docs, A - Online decision cards, B - D1 documents (D4 Clring)
RECORDCARDS	Space - No records cards, 1 - 1 record card, 2 - 2 record cards
LABELS	Space - No new applicant labels, 1 - 1 label, 2 - 2 labels

Student System - IGS_UC_UOFABRV_INTS	Holds update offer abbreviation information loaded from UCAS
Column Name	Descritpion
ABBREVID	Abbreviation identifier, takes values 00 to 99
UPDATER	ID of last updater
ABBREVTEXT	Abbreviation Text
LETTERFORMAT	Letter format, takes values A - G
SUMMARYCHAR	Summary of conditions character (see Error. Reference source not found.)
ABBREVUSE	U - Unconditional, W - Withdrawals, Null - abbreviation invalid on unconditional offers or withdrawal.
RECORD_STATUS	Status of the interface record , takes values N, O, D etc
ERROR_CODE	Code for the error encountered during processing of this interface record data

Student System - IGS_UC_SYS_CALNDRS	Holds Calendar details for UCAS Systems
Column Name	Descritpion
ENTRY_YEAR	UCAS Entry Year
ENTRY_MONTH	UCAS Entry Month
ACA_CAL_TYPE	Academic calendar type from OSS
ACA_CAL_SEQ_NO	Academic calendar sequence number
ADM_CAL_TYPE	Admission calendar type from OSS
ADM_CAL_SEQ_NO	Admission calendar sequence number
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
SYSTEM_CODE	UCAS System code
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Student System - IGS_UC_REF_COUNTRY	Base table for related view cvRefCountry
Column Name	Descritpion
COUNTRY_CODE	Country Code
DESCRIPTION	Country Description
TYPE	H = Home, E = EU, O = Overseas
IMPORTED	Flag to indicate whether the record was imported from UCAS
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns