[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_UC_APPLICANTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_UC_APPLICANTS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full View for UCAS Applicant Details
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| APPLICANT_ID | NUMBER | Yes | Unique Record Identifier | |
| PERSONAL_ID | VARCHAR2 | (10) | Unique Personal Identifier | |
| UCAS_APPLICANT_NUMBER | NUMBER | (8) | UCAS Application Number | |
| UCAS_APPLICANT_CHECK_DIGIT | NUMBER | (1) | UCAS Applicant Check Digit | |
| ENQUIRY_NO | NUMBER | Clearing Enquiry number | ||
| OSS_PERSON_ID | NUMBER | (15) | OSS Person ID | |
| APPLICATION_SOURCE | VARCHAR2 | (1) | Yes | UCAS Application Source (U-UCAS, D-Direct) |
| UCAS_NAME_CHANGE_DATE | DATE | UCAS name Change date to synchronize with UCAS view ivStraN | ||
| STUDENT_SUPPORT_ARRANGEMENT | 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 ivstarK | ||
| APPLICATION_SENT_DATE | DATE | Application Sent by UCAS date, to synchronize with UCAS view ivstarK | ||
| APPLICATION_SENT_RUN | NUMBER | Application Sent by UCAS by UCAS run (Batch) number when sent | ||
| FEE_PAYER_CODE | NUMBER | (2) | Fee Payer Code, to synchronize with ivStarK | |
| FEE_TEXT | VARCHAR2 | (30) | Fee Text, to synchronize with UCAS ivStarK | |
| DOMICILE_CODE | NUMBER | (3) | Domicile Code, to synchronize with UCAS ivStarK | |
| CODE_CHANGED_DATE | DATE | Coded Information changed date,to synchronize with UCAS ivStarK | ||
| SCHOOL | NUMBER | (5) | School Code, to synchronize with UCAS ivStarK | |
| WITHDRAWN | VARCHAR2 | (1) | Applicant withdrawn, to synchronize with UCAS ivStarK | |
| WITHDRAWN_DATE | DATE | Applicant withdrawn date, to synchronize with UCAS ivStarK | ||
| RELEASE_TO_CLEARING_REASON | VARCHAR2 | (20) | Reason for UF to clearing by RR transaction | |
| ROUTE_B_FLAG | VARCHAR2 | (1) | Yes | Applicant level Route B indicator, to synchronize with UCAS ivStarK |
| EXAM_CHANGE_DATE | DATE | Examination details change date, to synchronize with UCAS view ivStarK | ||
| QUAL_NUM_WINTER_A_LEVELS | NUMBER | (1) | Number of A levels expected, to synchronize with UCAS view ivStarK | |
| QUAL_NUM_PREVIOUS_QUALS | NUMBER | (1) | Number of previous A/AS/Highers/CSYS, to synchronize with UCAS view ivStarK | |
| QUAL_BTEC_FLAG | VARCHAR2 | (1) | (Y- yes, N- no) to synchronize with UCAS view ivStarK | |
| QUAL_ILC_FLAG | VARCHAR2 | (1) | (Y- yes, N- no) to synchronize with UCAS view ivStarK | |
| QUAL_AILC_FLAG | VARCHAR2 | (1) | (Y- yes, N- no) to synchronize with UCAS view ivStarK | |
| QUAL_IB_FLAG | VARCHAR2 | (1) | (Y- yes, N- no) to synchronize with UCAS view ivStarK | |
| MANUAL_QUAL_CHECK | VARCHAR2 | (1) | Manual investigation of previous results required (Y- yes, N- no), to synchronize with UCAS view ivStarK | |
| BTEC_REGISTRATION_NUMBER | VARCHAR2 | (13) | Registration number, to synchronize with UCAS view ivStarK | |
| OTHER_EXAMINATION_QUAL_FLAG | VARCHAR2 | (1) | Other examination qualifications, to synchronize with UCAS view ivStarK | |
| ELECTRONIC_APPL_SYSTEM_FLAG | VARCHAR2 | (1) | Applied through Electronic Application System (Y- yes, N- no), to synchronize with UCAS view ivStarK | |
| RECORD_OF_ACHEIVEMENT_FLAG | VARCHAR2 | (1) | Record of achievement, to synchronize with UCAS view ivStarK | |
| APPLICANT_STATUS | VARCHAR2 | (3) | Applicant status, to synchronize with UCAS view ivStarK | |
| FIRM_CHOICE_NUMBER | 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 | |
| CONFIRMATION_HIST_FIRM_REPLY | NUMBER | (1) | Confirmation history firm reply, to synchronize with UCAS view ivStarK | |
| CONFIRMATION_HIST_INSU_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_PREVIOUS_FLAG | VARCHAR2 | (1) | Match status (full, part etc), to synchronize with UCAS view ivQualification | |
| MATCH_PREVIOUS_DATE | DATE | Date matched previous changed, to synchronize with UCAS view ivQualification | ||
| MATCH_WINTER_FLAG | VARCHAR2 | (1) | Matched winter results, to synchronize with UCAS view ivQualification | |
| MATCH_SUMMER_FLAG | VARCHAR2 | (1) | Matched summer results, to synchronize with UCAS view ivQualification | |
| IB_MOVED_DATE | DATE | IB moved date, to synchronize with UCAS view ivQualification | ||
| ILC_MOVED_DATE | DATE | ILC moved date, to synchronize with UCAS view ivQualification | ||
| AILC_MOVED_DATE | DATE | AILC moved date, to synchronize with UCAS view ivQualification | ||
| GCSEQA_MOVED_DATE | DATE | GCESQA moved date, to synchronize with UCAS view ivQualification | ||
| UK_ENTRY_DATE | DATE | Available only from UCAS paper application form | ||
| PREVIOUS_SURNAME | VARCHAR2 | (18) | Available only from UCAS paper application form | |
| CRIMINAL_CONVICTIONS_FLAG | VARCHAR2 | (1) | (Y -yes, N- no) Available only from UCAS paper application form | |
| SENT_TO_HESA_FLAG | VARCHAR2 | (1) | Yes | Sent to HESA (Y- yes, N- no) |
| BATCH_IDENTIFIER | NUMBER | Import batch Identifier | ||
| QUAL_NUM_GCE | NUMBER | (1) | Number of GCE | |
| QUAL_NUM_VCE | NUMBER | (1) | Number of VCE Expected | |
| QUAL_NUM_SQA | VARCHAR2 | (1) | SQA Candidate | |
| QUAL_NUM_PREVIOUS_AS | NUMBER | (1) | Number of Previous Summer AS Levels | |
| KEYSKILLS_FLAG | VARCHAR2 | (1) | Taking Key Skills | |
| VOCATIONAL_FLAG | VARCHAR2 | (1) | Taking Vocational Exams | |
| SCOTTISH_CANDIDATE_NUMBER | VARCHAR2 | (9) | Scottish Candidate Number | |
| PREVIOUS_OTHER_EXAM_QUAL_FLAG | VARCHAR2 | (1) | Previous Other Examination Qualifications | |
| CHOICES_TRANSPARENT_IND | VARCHAR2 | (1) | Indicates Whether the Student Applicant choices are visiable to institute or not | |
| EXTRA_STATUS | NUMBER | (1) | Indicates the Applicant's EXTRA Processing status. | |
| EXTRA_PASSPORT_NO | VARCHAR2 | (6) | Holds the applicants extra processing passport ID | |
| REQUEST_APPL_DETAILS_IND | VARCHAR2 | (1) | Request Applicant Details Indicator | |
| REQUEST_COPY_APPL_FORM_IND | VARCHAR2 | (1) | Request Copy Applicant Form Details | |
| CLEARING_ENTRY_FORM_NUMBER | NUMBER | (9) | Applicant Clearing Entry Form Number | |
| UCAS_SYSTEM_CODE | VARCHAR2 | (1) | Yes | UCAS System Code |
| GTTR_GCSE_ENGLISH_FLAG | VARCHAR2 | (1) | GTTR System GCSE English flag | |
| GTTR_GCSE_MATHS_FLAG | VARCHAR2 | (1) | GTTR System GCSH Math flag | |
| GTTR_DEGREE_SUBJECT | VARCHAR2 | (2) | GTTR System Degree Subject | |
| GTTR_DEGREE_STATUS | VARCHAR2 | (1) | GTTR System Degree Status | |
| GTTR_DEGREE_CLASS | VARCHAR2 | (2) | GTTR System Degree class | |
| GTTR_GCSE_SCIENCE_FLAG | VARCHAR2 | (1) | GTTR System GCSH Science flag | |
| SWAS_WELSHSPEAKER | VARCHAR2 | (1) | SWAS welsh Speaker | |
| NMAS_NATIONAL_INSURANCE_NUMBER | VARCHAR2 | (12) | NMAS System UK National Insurance Number | |
| NMAS_EARLIEST_START | VARCHAR2 | (4) | NAMS System Earliest Start date | |
| NMAS_NEAREST_INSTITUTION | VARCHAR2 | (4) | NAMS System Nearest Institution | |
| NMAS_PREFRRED_REGION | NUMBER | (1) | NAMS System Preferred region | |
| NMAS_QUAL_ENGLISH_FLAG | VARCHAR2 | (1) | NAMS System Qualified in English flag | |
| NMAS_QUAL_MATHS_FLAG | VARCHAR2 | (1) | NAMS System Qualified in Maths flag | |
| NMAS_QUAL_SCIENCE_FLAG | VARCHAR2 | (1) | NAMS System Qualified in Science flag | |
| NMAS_MAIN_QUALIFICATION | VARCHAR2 | (1) | NAMS System main Qualification | |
| NMAS_QUAL_5_FLAG | VARCHAR2 | (1) | NAMS System Qualified with 5 points | |
| SWAS_FUTURE_SERVICE | VARCHAR2 | (1) | SWAS System Future Service | |
| SWAS_FUTURE_SETTING | VARCHAR2 | (1) | SWAS System Future Setting | |
| SWAS_PRESENT_SERVICE | VARCHAR2 | (1) | SWAS System present Service | |
| SWAS_PRESENT_SETTING | VARCHAR2 | (1) | SWAS System present setting | |
| SWAS_CURRENT_EMPLOYMENT | VARCHAR2 | (1) | SWAS System Current Employment | |
| SWAS_EDUCATION_QUALIFICATION | VARCHAR2 | (2) | SWAS System Educational Qualifications | |
| OSS_PERSON_NUMBER | VARCHAR2 | (30) | OSS Person number | |
| OSS_PERSON_NAME | VARCHAR2 | (360) | OSS Person name | |
| UCAS_SYSTEM_NAME | VARCHAR2 | (10) | UCAS System name | |
| UCAS_SYSTEM_DESCRIPTION | VARCHAR2 | (240) | UCAS System Description | |
| SCHOOL_NAME | VARCHAR2 | (35) | School Name | |
| DOMICILE_CODE_DESCRIPTION | VARCHAR2 | (40) | Domicile Code description | |
| RESIDENTIAL_CATEGORY_NAME | VARCHAR2 | (300) | Residential Category Name | |
| GTTR_DEGREE_SUBJECT_DESC | VARCHAR2 | (300) | GTTR System degree subject description | |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICANT_ID
, PERSONAL_ID
, UCAS_APPLICANT_NUMBER
, UCAS_APPLICANT_CHECK_DIGIT
, ENQUIRY_NO
, OSS_PERSON_ID
, APPLICATION_SOURCE
, UCAS_NAME_CHANGE_DATE
, STUDENT_SUPPORT_ARRANGEMENT
, ADDRESS_AREA
, APPLICATION_DATE
, APPLICATION_SENT_DATE
, APPLICATION_SENT_RUN
, FEE_PAYER_CODE
, FEE_TEXT
, DOMICILE_CODE
, CODE_CHANGED_DATE
, SCHOOL
, WITHDRAWN
, WITHDRAWN_DATE
, RELEASE_TO_CLEARING_REASON
, ROUTE_B_FLAG
, EXAM_CHANGE_DATE
, QUAL_NUM_WINTER_A_LEVELS
, QUAL_NUM_PREVIOUS_QUALS
, QUAL_BTEC_FLAG
, QUAL_ILC_FLAG
, QUAL_AILC_FLAG
, QUAL_IB_FLAG
, MANUAL_QUAL_CHECK
, BTEC_REGISTRATION_NUMBER
, OTHER_EXAMINATION_QUAL_FLAG
, ELECTRONIC_APPL_SYSTEM_FLAG
, RECORD_OF_ACHEIVEMENT_FLAG
, APPLICANT_STATUS
, FIRM_CHOICE_NUMBER
, FIRM_REPLY
, INSURANCE_REPLY
, CONFIRMATION_HIST_FIRM_REPLY
, CONFIRMATION_HIST_INSU_REPLY
, RESIDENTIAL_CATEGORY
, PERSONAL_STATEMENT
, MATCH_PREVIOUS_FLAG
, MATCH_PREVIOUS_DATE
, MATCH_WINTER_FLAG
, MATCH_SUMMER_FLAG
, IB_MOVED_DATE
, ILC_MOVED_DATE
, AILC_MOVED_DATE
, GCSEQA_MOVED_DATE
, UK_ENTRY_DATE
, PREVIOUS_SURNAME
, CRIMINAL_CONVICTIONS_FLAG
, SENT_TO_HESA_FLAG
, BATCH_IDENTIFIER
, QUAL_NUM_GCE
, QUAL_NUM_VCE
, QUAL_NUM_SQA
, QUAL_NUM_PREVIOUS_AS
, KEYSKILLS_FLAG
, VOCATIONAL_FLAG
, SCOTTISH_CANDIDATE_NUMBER
, PREVIOUS_OTHER_EXAM_QUAL_FLAG
, CHOICES_TRANSPARENT_IND
, EXTRA_STATUS
, EXTRA_PASSPORT_NO
, REQUEST_APPL_DETAILS_IND
, REQUEST_COPY_APPL_FORM_IND
, CLEARING_ENTRY_FORM_NUMBER
, UCAS_SYSTEM_CODE
, GTTR_GCSE_ENGLISH_FLAG
, GTTR_GCSE_MATHS_FLAG
, GTTR_DEGREE_SUBJECT
, GTTR_DEGREE_STATUS
, GTTR_DEGREE_CLASS
, GTTR_GCSE_SCIENCE_FLAG
, SWAS_WELSHSPEAKER
, NMAS_NATIONAL_INSURANCE_NUMBER
, NMAS_EARLIEST_START
, NMAS_NEAREST_INSTITUTION
, NMAS_PREFRRED_REGION
, NMAS_QUAL_ENGLISH_FLAG
, NMAS_QUAL_MATHS_FLAG
, NMAS_QUAL_SCIENCE_FLAG
, NMAS_MAIN_QUALIFICATION
, NMAS_QUAL_5_FLAG
, SWAS_FUTURE_SERVICE
, SWAS_FUTURE_SETTING
, SWAS_PRESENT_SERVICE
, SWAS_PRESENT_SETTING
, SWAS_CURRENT_EMPLOYMENT
, SWAS_EDUCATION_QUALIFICATION
, OSS_PERSON_NUMBER
, OSS_PERSON_NAME
, UCAS_SYSTEM_NAME
, UCAS_SYSTEM_DESCRIPTION
, SCHOOL_NAME
, DOMICILE_CODE_DESCRIPTION
, RESIDENTIAL_CATEGORY_NAME
, GTTR_DEGREE_SUBJECT_DESC
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_UC_APPLICANTS;
APPS
HZ_PARTIES
IGS_UC_APPLICANTS
IGS_UC_COM_SCH
IGS_UC_DEFAULTS
IGS_UC_REF_APR
IGS_UC_REF_CODES
APPS.IGSFV_UC_APPLICANTS is not referenced by any database object
|
|
|
|