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]

VIEW: APPS.IGS_UC_APPL_DTLS_V

Object Details

Object Name:	IGS_UC_APPL_DTLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_UC_APPL_DTLS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROWID of Application Choice Table
UCAP_ROW_ID	ROWID	(10)		ROWID of Application Table
UCCLR_ROW_ID	ROWID	(10)		ROWID of Application Clearing Table
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)		Withdrawn 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
PERSONAL_STATEMENT	LONG	(0)		Statement of applicant intent to synchronize with UCAS view ivStatement
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			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
SENT_TO_HESA	VARCHAR2	(1)	Yes	Sent to HESA (Y - yes N - no)
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
CHOICES_TRANSPARENT_IND	VARCHAR2	(1)		Indicates whether the Student Application Choices are visible to institution or not.
EXTRA_STATUS	NUMBER	(1)		Indicates the applicants 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 applicants extra processing passport ID. This field will be populated when using Hercules interface only. For applicants 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 applicants 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
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 Maths
QUAL_SCI	VARCHAR2	(1)		NMAS - Qualified In Science
MAIN_QUAL	VARCHAR2	(1)		NMAS - Main Qualification
QUAL_5	VARCHAR2	(1)		NMAS - Qualified With 5 Points
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
APP_CHOICE_ID	NUMBER			Unique Record Identifier
CHOICE_NO	NUMBER	(2)		UCAS application choice number
LAST_CHANGE	DATE			Choice level time stamp to synchronize with UCAS view ivStarC
INSTITUTE_CODE	VARCHAR2	(5)		Institution code to synchronize with UCAS view ivStarC
UCAS_PROGRAM_CODE	VARCHAR2	(6)		UCAS course code to synchronize with UCAS view ivStarC
OSS_PROGRAM_CODE	VARCHAR2	(6)		Mapped OSS program code
OSS_PROGRAM_VERSION	NUMBER	(3)		Mapped OSS program version
OSS_ATTENDANCE_TYPE	VARCHAR2	(2)		OSS attendance type
OSS_ATTENDANCE_MODE	VARCHAR2	(2)		OSS attendance mode
CAMPUS	VARCHAR2	(1)		UCAS campus code to synchronize with UCAS view ivStarC
OSS_LOCATION	VARCHAR2	(10)		OSS location code
FACULTY	VARCHAR2	(1)		UCAS faculty code to synchronize with UCAS view ivStarC
ENTRY_YEAR	NUMBER	(2)		Year of entry to synchronize with UCAS view ivStarC
ENTRY_MONTH	NUMBER	(2)		Month of entry to synchronize with UCAS view ivStarC
POINT_OF_ENTRY	NUMBER	(1)		Point of entry to synchronize with UCAS view ivStarC
HOME	VARCHAR2	(1)		Applicant will live at home (Y - yes, N - no) to synchronize with UCAS view ivStarC
DEFERRED	VARCHAR2	(1)		Applied for deferred entry (Y - yes, N - no). Default is No
ROUTE_B_PREF_ROUND	NUMBER			Route B preference round number (1,2,3) to synchronize with UCAS view ivStarC
ROUTE_B_ACTUAL_ROUND	NUMBER			Route B actual round number (1,2,3) to synchronize with UCAS view ivStarC
CONDITION_CATEGORY	VARCHAR2	(10)		Attached offer condition category. Links an offer to a choice
CONDITION_CODE	VARCHAR2	(20)		Attached offer condition name. Links an offer to a choice
DECISION	VARCHAR2	(1)		Decision, to synchronize with UCAS view ivStarC
DECISION_DATE	DATE			Decision date, to synchronize with UCAS view ivStarC
DECISION_NUMBER	NUMBER			Decision number, to synchronize with UCAS view ivStarC
REPLY	VARCHAR2	(1)		Applicant reply, to synchronize with UCAS view ivStarC
SUMMARY_OF_COND	VARCHAR2	(6)		Summary of conditions, to synchronize with UCAS view ivStarC
CHOICE_CANCELLED	VARCHAR2	(1)		Choice cancelled (Y - yes, N - no), to synchronize with UCAS view ivStarC
ACTION	VARCHAR2	(1)		Action by default, to synchronize with UCAS view ivStarC
SUBSTITUTION	VARCHAR2	(1)		Indicates substitution made, to synchronize with UCAS view ivStarC
DATE_SUBSTITUTED	DATE			Date a substitution was applied or made, post-15thDec, to synchronize with UCAS view ivStarC
PREV_INSTITUTION	VARCHAR2	(3)		Previous institution code, to synchronize with UCAS view ivStarC
PREV_COURSE	VARCHAR2	(6)		Previous UCAS course code, to synchronize with UCAS view ivStarC
PREV_CAMPUS	VARCHAR2	(1)		Previous UCAS campus code to synchronize with UCAS view ivStarC
UCAS_AMENDMENT	VARCHAR2	(1)		UCAS Amendment to synchronize with UCAS view ivStarC
WITHDRAWAL_REASON	VARCHAR2	(20)		Reason for W in LD, LA
OFFER_COURSE	VARCHAR2	(6)		UCAS Course code in offer, to synchronize with UCAS view ivOffer
OFFER_CAMPUS	VARCHAR2	(1)		UCAS campus in offer, to synchronize with UCAS view ivOffer
OFFER_CRSE_LENGTH	NUMBER	(1)		Duration of course in offer, to synchronize with UCAS view ivOffer
OFFER_ENTRY_MONTH	VARCHAR2	(2)		Month of entry in offer, to synchronize with UCAS view ivOffer
OFFER_ENTRY_YEAR	VARCHAR2	(2)		Year of entry in offer, to synchronize with UCAS view ivOffer
OFFER_ENTRY_POINT	VARCHAR2	(1)		Point of entry in offer, to synchronize with UCAS view ivOffer
OFFER_TEXT	VARCHAR2	(2000)		Text version of offer letter to synchronize with UCAS view ivOffer
EXPORT_TO_OSS_STATUS	VARCHAR2	(10)		Default Value NEW,identifies the status of exporting this application choice
ERROR_CODE	VARCHAR2	(10)		Identifies the error encountered while exporting the application choice to OSS ,meaningless when export_to_oss_status = NEW
REQUEST_ID	NUMBER	(15)		Request Id of the run of export applications to oss process
BATCH_ID	NUMBER	(15)		Admissions import process batch in which the last error was encountered
EXTRA_ROUND_NBR	NUMBER	(3)		Holds the UCAS EXTRA processing round number.
PART_TIME	VARCHAR2	(1)		GTTR Part Time
INTERVIEW	DATE			GTTR Interview Date
LATE_APPLICATION	VARCHAR2	(1)		GTTR Late Application Flag
MODULAR	VARCHAR2	(1)		GTTR Modular Flag
RESIDENTIAL	VARCHAR2	(1)		NMAS - Residential Accommodation Required
CEF_RECEIVED	VARCHAR2	(1)		Clearing Entry Form Received or not
RESULT	VARCHAR2	(11)		Clearing Entry Result
CLEARING_APP_SOURCE	VARCHAR2	(1)		Clearing Application Source
DATE_CEF_SENT	DATE			Date at which Clearing entry form sent
CLEARING_APP_ID	NUMBER			Sequence generated primary key of Clearing Table
CREATED_BY	NUMBER	(15)		Standard WHO column
CREATION_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column

Query Text

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


SELECT ROW_ID
,      UCAP_ROW_ID
,      UCCLR_ROW_ID
,      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
,      PERSONAL_STATEMENT
,      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
,      SENT_TO_HESA
,      BATCH_IDENTIFIER
,      GCE
,      VCE
,      SQA
,      PREVIOUSAS
,      KEYSKILLS
,      VOCATIONAL
,      SCN
,      PREVOEQ
,      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
,      WELSHSPEAKER
,      NI_NUMBER
,      EARLIEST_START
,      NEAR_INST
,      PREF_REG
,      QUAL_ENG
,      QUAL_MATH
,      QUAL_SCI
,      MAIN_QUAL
,      QUAL_5
,      FUTURE_SERV
,      FUTURE_SET
,      PRESENT_SERV
,      PRESENT_SET
,      CURR_EMPLOYMENT
,      EDU_QUALIFICATION
,      APP_CHOICE_ID
,      CHOICE_NO
,      LAST_CHANGE
,      INSTITUTE_CODE
,      UCAS_PROGRAM_CODE
,      OSS_PROGRAM_CODE
,      OSS_PROGRAM_VERSION
,      OSS_ATTENDANCE_TYPE
,      OSS_ATTENDANCE_MODE
,      CAMPUS
,      OSS_LOCATION
,      FACULTY
,      ENTRY_YEAR
,      ENTRY_MONTH
,      POINT_OF_ENTRY
,      HOME
,      DEFERRED
,      ROUTE_B_PREF_ROUND
,      ROUTE_B_ACTUAL_ROUND
,      CONDITION_CATEGORY
,      CONDITION_CODE
,      DECISION
,      DECISION_DATE
,      DECISION_NUMBER
,      REPLY
,      SUMMARY_OF_COND
,      CHOICE_CANCELLED
,      ACTION
,      SUBSTITUTION
,      DATE_SUBSTITUTED
,      PREV_INSTITUTION
,      PREV_COURSE
,      PREV_CAMPUS
,      UCAS_AMENDMENT
,      WITHDRAWAL_REASON
,      OFFER_COURSE
,      OFFER_CAMPUS
,      OFFER_CRSE_LENGTH
,      OFFER_ENTRY_MONTH
,      OFFER_ENTRY_YEAR
,      OFFER_ENTRY_POINT
,      OFFER_TEXT
,      EXPORT_TO_OSS_STATUS
,      ERROR_CODE
,      REQUEST_ID
,      BATCH_ID
,      EXTRA_ROUND_NBR
,      PART_TIME
,      INTERVIEW
,      LATE_APPLICATION
,      MODULAR
,      RESIDENTIAL
,      CEF_RECEIVED
,      RESULT
,      CLEARING_APP_SOURCE
,      DATE_CEF_SENT
,      CLEARING_APP_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_UC_APPL_DTLS_V;

Dependencies

[top of page]

APPS.IGS_UC_APPL_DTLS_V references the following:

APPS: IGS_UC_APPLICANTS; IGS_UC_APP_CHOICES; IGS_UC_APP_CLEARING

APPS.IGS_UC_APPL_DTLS_V is not referenced by any database object