eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_UC_APPLICANTS

Object Details

Object Name:	IGS_UC_APPLICANTS
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_UC_APPLICANTS
Subobject Name:
Status:	VALID

Holds applicant and application details . It synchronizes with UCAS views - 'ivStatement','ivQualification','ivStarC','ivStark','ivStarN'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_UC_APPLICANTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APP_ID
IGS_UC_APPLICANTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	APP_NO
IGS_UC_APPLICANTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENQUIRY_NO
IGS_UC_APPLICANTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AD_BATCH_ID
IGS_UC_APPLICANTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SENT_TO_OSS
IGS_UC_APPLICANTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSONAL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APP_ID	NUMBER		Yes	Unique Record Identifier
APP_NO	NUMBER	(8)		UCAS application number
CHECK_DIGIT	NUMBER	(1)		UCAS application check digit
ENQUIRY_NO	NUMBER			Clearing enquiry number
OSS_PERSON_ID	NUMBER	(15)		Mapped OSS person number
APPLICATION_SOURCE	VARCHAR2	(1)	Yes	(U - UCAS, D - Direct)
NAME_CHANGE_DATE	DATE			Name change date to synchronize with UCAS view ivStarN
STUDENT_SUPPORT	VARCHAR2	(10)		Student support arrangement
ADDRESS_AREA	VARCHAR2	(1)		Address area to synchronize with UCAS view ivStarA
APPLICATION_DATE	DATE			Application date to synchronize with UCAS view ivStarK
APPLICATION_SENT_DATE	DATE			Application sent by UCAS date, to synchronize with UCAS view ivStarK
APPLICATION_SENT_RUN	NUMBER			Application sent by UCAS run (batch) number, to synchronize with UCAS view ivStarK (Batch Id)
LEA_CODE	NUMBER	(3)		Local education authority code, to synchronize with UCAS view ivStarK
FEE_PAYER_CODE	NUMBER	(2)		Fee payer code, to synchronize with UCAS view ivStarK
FEE_TEXT	VARCHAR2	(30)		Fee text, to synchronize with UCAS view ivStarK
DOMICILE_APR	NUMBER	(3)		Domicile code, to synchronize with UCAS view ivStarK
CODE_CHANGED_DATE	DATE			Coded information changed date, to synchronize with UCAS view ivStarK
SCHOOL	NUMBER	(5)		School code, to synchronize with UCAS view ivStarK
WITHDRAWN	VARCHAR2	(1)		x to synchronize with UCAS view ivStarK
WITHDRAWN_DATE	DATE			Withdrawn date, to synchronize with UCAS view ivStarK
REL_TO_CLEAR_REASON	VARCHAR2	(20)		Reason for 'UF' to clearing by 'RR' transaction
ROUTE_B	VARCHAR2	(1)	Yes	Applicant level Route B indicator, to synchronize with UCAS view ivStarK, indicates at applicant level
EXAM_CHANGE_DATE	DATE			Examination details change date, to synchronize with UCAS view ivStarK
A_LEVELS	NUMBER	(1)		Number of A levels expected, to synchronize with UCAS view ivStarK
AS_LEVELS	NUMBER	(1)		Number of AS levels expected, to synchronize with UCAS view ivStarK
HIGHERS	NUMBER	(1)		Number of highers expected, to synchronize with UCAS view ivStarK
CSYS	NUMBER	(1)		Number of CSYS expected, to synchronize with UCAS view ivStarK
WINTER	NUMBER	(1)		Number of winter A-levels expected, to synchronize with UCAS view ivStarK
PREVIOUS	NUMBER	(1)		Number of previous A/AS/Highers/CSYS, to synchronize with UCAS view ivStarK
GNVQ	VARCHAR2	(1)		(Y - yes, N - no) to synchronize with UCAS view ivStarK
BTEC	VARCHAR2	(1)		(Y - yes, N - no) to synchronize with UCAS view ivStarK
ILC	VARCHAR2	(1)		(Y - yes, N - no) to synchronize with UCAS view ivStarK
AILC	VARCHAR2	(1)		(Y - yes, N - no) to synchronize with UCAS view ivStarK
IB	VARCHAR2	(1)		(Y - yes, N - no) to synchronize with UCAS view ivStarK
MANUAL	VARCHAR2	(1)		Manual investigation of previous results required (Y - yes, N - no), to synchronize with UCAS view ivStarK
REG_NUM	VARCHAR2	(13)		Registration number, to synchronize with UCAS view ivStarK
OEQ	VARCHAR2	(1)		Other examination qualifications, to synchronize with UCAS view ivStarK
EAS	VARCHAR2	(1)		Applied through Electronic Application System (Y - yes, N - no), to synchronize with UCAS view ivStarK
ROA	VARCHAR2	(1)		Record of achievement, to synchronize with UCAS view ivStarK
STATUS	VARCHAR2	(3)		Applicant status, to synchronize with UCAS view ivStarK
FIRM_NOW	NUMBER	(1)		Firm choice number, to synchronize with UCAS view ivStarK
FIRM_REPLY	NUMBER	(1)		Firm reply, to synchronize with UCAS view ivStarK
INSURANCE_REPLY	NUMBER	(1)		Insurance reply, to synchronize with UCAS view ivStarK
CONF_HIST_FIRM_REPLY	NUMBER	(1)		Confirmation history firm reply, to synchronize with UCAS view ivStarK
CONF_HIST_INS_REPLY	NUMBER	(1)		Confirmation history insurance reply, to synchronize with UCAS view ivStarK
RESIDENTIAL_CATEGORY	VARCHAR2	(1)		Residential category, to synchronize with UCAS view ivStarK
IVQUAL_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view ivQualification - Obsolete
MATCH_PREV	VARCHAR2	(1)		Match status (full, part etc), to synchronize with UCAS view ivQualification
MATCH_PREV_DATE	DATE			Date matched previous changed, to synchronize with UCAS view ivQualification
MATCH_WINTER	VARCHAR2	(1)		Matched winter results, to synchronize with UCAS view ivQualification
MATCH_SUMMER	VARCHAR2	(1)		Matched summer results, to synchronize with UCAS view ivQualification
GNVQ_DATE	DATE			GNVQ moved date, to synchronize with UCAS view ivQualification
IB_DATE	DATE			IB moved date, to synchronize with UCAS view ivQualification
ILC_DATE	DATE			ILC moved date, to synchronize with UCAS view ivQualification
AILC_DATE	DATE			AILC moved date, to synchronize with UCAS view ivQualification
GCSEQA_DATE	DATE			GCSEQA moved date, to synchronize with UCAS view ivQualification
UK_ENTRY_DATE	DATE			Available only from UCAS paper application form
PREV_SURNAME	VARCHAR2	(18)		Available only from UCAS paper application form
CRIMINAL_CONVICTIONS	VARCHAR2	(1)		(Y - yes, N - no) Available only from UCAS paper application form
IVSTARA_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view ivStarA - Obsolete
IVSTARC_TIMESTAMP	DATE			Applicant level Timestamp for any change in any choice to synchronize with UCAS view ivStarC - Obsolete
IVSTARK_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view ivStarK - Obsolete
IVSTARN_TIMESTAMP	DATE			Timestamp to synchronize with UCAS view ivStarN - Obsolete
SENT_TO_HESA	VARCHAR2	(1)	Yes	Sent to HESA (Y - yes, N - no)
SENT_TO_OSS	VARCHAR2	(1)		Indicates wether this record has been exported to OSS or not
BATCH_IDENTIFIER	NUMBER			Import Batch Identifier
GCE	NUMBER	(1)		Number of GCE
VCE	NUMBER	(1)		Number of VCE expected
SQA	VARCHAR2	(1)		SQA candidate
PREVIOUSAS	NUMBER	(1)		Number of previous summer AS levels
KEYSKILLS	VARCHAR2	(1)		Indicating if applicant is taking key skills
VOCATIONAL	VARCHAR2	(1)		Indicating if applicant is taking Vocational Exams
SCN	VARCHAR2	(9)		Scottish Candidate Number
PREVOEQ	VARCHAR2	(1)		Previous Other Examination Qualifications
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column
CHOICES_TRANSPARENT_IND	VARCHAR2	(1)		Indicates whether the Student Application Choices are visible to institution or not.
EXTRA_STATUS	NUMBER	(1)		Indicates the applicant's EXTRA processing status. This field will be populated when using HERCULES interface only. For Marvin Interface its value will be NULL
EXTRA_PASSPORT_NO	VARCHAR2	(6)		Holds the applicant's extra processing passport ID. This field will be populated when using Hercules interface only. For applicant's who apply on the web will contain 'WEB'
REQUEST_APP_DETS_IND	VARCHAR2	(1)		Request Application Details Indicator. Default 'N'.
REQUEST_COPY_APP_FRM_IND	VARCHAR2	(1)		Request Copy of Application Form Indicator. Default 'N'.
CEF_NO	NUMBER	(9)		The applicant's clearing entry form number
SYSTEM_CODE	VARCHAR2	(1)	Yes	UCAS System Code
GCSE_ENG	VARCHAR2	(1)		GTTR GCSE English
GCSE_MATH	VARCHAR2	(1)		GTTR GCSE Math
DEGREE_SUBJECT	VARCHAR2	(2)		GTTR Degree Subject
DEGREE_STATUS	VARCHAR2	(1)		GTTR Degree Status
DEGREE_CLASS	VARCHAR2	(2)		GTTR Degree Class
GCSE_SCI	VARCHAR2	(1)		GTTR GCSE Science
IVSTARG_TIMESTAMP	DATE			IVSTARG Timestamp - Obsolete
WELSHSPEAKER	VARCHAR2	(1)		SWAS - Welsh Speaker
NI_NUMBER	VARCHAR2	(12)		NMAS - UK National Insurance Number
EARLIEST_START	VARCHAR2	(4)		NMAS - Earliest Start Date
NEAR_INST	VARCHAR2	(4)		NMAS - Nearest Institution
PREF_REG	NUMBER	(1)		NMAS - Preferred Region
QUAL_ENG	VARCHAR2	(1)		NMAS - Qualified in English
QUAL_MATH	VARCHAR2	(1)		NMAS - Qualified in Math's
QUAL_SCI	VARCHAR2	(1)		NMAS - Qualified in Science
MAIN_QUAL	VARCHAR2	(1)		NMAS - Main Qualification
QUAL_5	VARCHAR2	(1)		NMAS - Qualified with 5 Points
IVSTART_TIMESTAMP	DATE			IVSTART Timestamp - Obsolete
FUTURE_SERV	VARCHAR2	(1)		SWAS - Future Service
FUTURE_SET	VARCHAR2	(1)		SWAS - Future Setting
PRESENT_SERV	VARCHAR2	(1)		SWAS - Present Service
PRESENT_SET	VARCHAR2	(1)		SWAS - Present Setting
CURR_EMPLOYMENT	VARCHAR2	(1)		SWAS - Current Employment
EDU_QUALIFICATION	VARCHAR2	(2)		SWAS - Educational Qualification
PERSONAL_STATEMENT	LONG	(0)		Statement of applicant intent, to synchronize with UCAS view ivStatement
AD_BATCH_ID	NUMBER	(15)		Admissions Import Batch ID
AD_INTERFACE_ID	NUMBER	(15)		Admissions Import Interface ID
NATIONALITY	NUMBER	(15)		Applicant Nationality
DUAL_NATIONALITY	NUMBER	(15)		Applicant Dual Nationality
SPECIAL_NEEDS	VARCHAR2	(1)		Applicant Special Needs
COUNTRY_BIRTH	NUMBER	(22)		Applicant Country of Birth
PERSONAL_ID	VARCHAR2	(10)		Unique Personal Identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APP_ID
,      APP_NO
,      CHECK_DIGIT
,      ENQUIRY_NO
,      OSS_PERSON_ID
,      APPLICATION_SOURCE
,      NAME_CHANGE_DATE
,      STUDENT_SUPPORT
,      ADDRESS_AREA
,      APPLICATION_DATE
,      APPLICATION_SENT_DATE
,      APPLICATION_SENT_RUN
,      LEA_CODE
,      FEE_PAYER_CODE
,      FEE_TEXT
,      DOMICILE_APR
,      CODE_CHANGED_DATE
,      SCHOOL
,      WITHDRAWN
,      WITHDRAWN_DATE
,      REL_TO_CLEAR_REASON
,      ROUTE_B
,      EXAM_CHANGE_DATE
,      A_LEVELS
,      AS_LEVELS
,      HIGHERS
,      CSYS
,      WINTER
,      PREVIOUS
,      GNVQ
,      BTEC
,      ILC
,      AILC
,      IB
,      MANUAL
,      REG_NUM
,      OEQ
,      EAS
,      ROA
,      STATUS
,      FIRM_NOW
,      FIRM_REPLY
,      INSURANCE_REPLY
,      CONF_HIST_FIRM_REPLY
,      CONF_HIST_INS_REPLY
,      RESIDENTIAL_CATEGORY
,      IVQUAL_TIMESTAMP
,      MATCH_PREV
,      MATCH_PREV_DATE
,      MATCH_WINTER
,      MATCH_SUMMER
,      GNVQ_DATE
,      IB_DATE
,      ILC_DATE
,      AILC_DATE
,      GCSEQA_DATE
,      UK_ENTRY_DATE
,      PREV_SURNAME
,      CRIMINAL_CONVICTIONS
,      IVSTARA_TIMESTAMP
,      IVSTARC_TIMESTAMP
,      IVSTARK_TIMESTAMP
,      IVSTARN_TIMESTAMP
,      SENT_TO_HESA
,      SENT_TO_OSS
,      BATCH_IDENTIFIER
,      GCE
,      VCE
,      SQA
,      PREVIOUSAS
,      KEYSKILLS
,      VOCATIONAL
,      SCN
,      PREVOEQ
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CHOICES_TRANSPARENT_IND
,      EXTRA_STATUS
,      EXTRA_PASSPORT_NO
,      REQUEST_APP_DETS_IND
,      REQUEST_COPY_APP_FRM_IND
,      CEF_NO
,      SYSTEM_CODE
,      GCSE_ENG
,      GCSE_MATH
,      DEGREE_SUBJECT
,      DEGREE_STATUS
,      DEGREE_CLASS
,      GCSE_SCI
,      IVSTARG_TIMESTAMP
,      WELSHSPEAKER
,      NI_NUMBER
,      EARLIEST_START
,      NEAR_INST
,      PREF_REG
,      QUAL_ENG
,      QUAL_MATH
,      QUAL_SCI
,      MAIN_QUAL
,      QUAL_5
,      IVSTART_TIMESTAMP
,      FUTURE_SERV
,      FUTURE_SET
,      PRESENT_SERV
,      PRESENT_SET
,      CURR_EMPLOYMENT
,      EDU_QUALIFICATION
,      PERSONAL_STATEMENT
,      AD_BATCH_ID
,      AD_INTERFACE_ID
,      NATIONALITY
,      DUAL_NATIONALITY
,      SPECIAL_NEEDS
,      COUNTRY_BIRTH
,      PERSONAL_ID
FROM IGS.IGS_UC_APPLICANTS;

Dependencies

[top of page]

IGS.IGS_UC_APPLICANTS does not reference any database object

IGS.IGS_UC_APPLICANTS is referenced by following:

APPS: IGS_UC_APPLICANTS