[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSBV_UC_APPLICANT_CHOICES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSBV_UC_APPLICANT_CHOICES
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Base View for Applicant Choices
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| APPLICANT_CHOICE_ID | NUMBER | Yes | Unique Record Identifier | |
| APPLICANT_ID | NUMBER | Yes | Unique applicant identifier | |
| APPLICANT_UCAS_NUMBER | NUMBER | (8) | Yes | UCAS application number |
| APPLICANT_CHOICE_NUMBER | NUMBER | (2) | Yes | UCAS application choice number |
| UCAS_CYCLE | NUMBER | (15) | Yes | UCAS cycle to which this application choice belongs to |
| DATE_OF_LAST_CHANGE | DATE | Yes | Choice level time stamp to synchronize with UCAS view ivStarC | |
| UCAS_INSTITUTE_CODE | VARCHAR2 | (5) | Yes | Institution code to synchronize with UCAS view ivStarC |
| UCAS_PROGRAM_CODE | VARCHAR2 | (6) | Yes | 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 | |
| UCAS_CAMPUS | VARCHAR2 | (1) | Yes | UCAS campus code to synchronize with UCAS view ivStarC |
| OSS_LOCATION | VARCHAR2 | (10) | OSS location code | |
| UCAS_FACULTY | VARCHAR2 | (1) | UCAS faculty code to synchronize with UCAS view ivStarC | |
| ENTRY_YEAR | NUMBER | (2) | Yes | Year of entry to synchronize with UCAS view ivStarC |
| ENTRY_MONTH | NUMBER | (2) | Yes | Month of entry to synchronize with UCAS view ivStarC |
| POINT_OF_ENTRY | NUMBER | (1) | Point of entry to synchronize with UCAS view ivStarC | |
| HOME_FLAG | VARCHAR2 | (1) | Yes | Applicant will live at home (Y- yes, N- no) to synchronize with UCAS view ivStarC |
| DEFERRED_FLAG | VARCHAR2 | (1) | Yes | Applied for deferred entry (Y- yes, N- no). Default is No. |
| ROUTE_B_PREFERENCE_ROUND_FLAG | NUMBER | Route B preference round number (1,2,3) to synchronize with UCAS view ivStarC | ||
| ROUTE_B_ACTUAL_ROUND_FLAG | NUMBER | Route B actual round number (1,2,3) to synchronize with UCAS view ivStarC | ||
| CONDITION_CATEGORY | VARCHAR2 | (10) | ||
| 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_CONDITIONS | VARCHAR2 | (6) | Summary of conditions, to synchronize with UCAS view ivStarC | |
| CHOICE_CANCELLED_FLAG | 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 | |
| SUBSTITUTED_DATE | DATE | Date a substitution was applied or made, post-15thDec, to synchronize with UCAS view ivStarC | ||
| PREVIOUS_INSTITUTION | VARCHAR2 | (3) | ||
| PREVIOUS_COURSE | VARCHAR2 | (6) | Previous UCAS course code, to synchronize with UCAS view ivStarC | |
| PREVIOUS_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' | |
| OFFERED_COURSE | VARCHAR2 | (6) | UCAS Course code in offer, to synchronize with UCAS view ivOffer | |
| OFFERED_CAMPUS | VARCHAR2 | (1) | UCAS campus in offer, to synchronize with UCAS view ivOffer | |
| OFFERED_COURSE_LENGTH | NUMBER | (1) | Duration of course in offer, to synchronize with UCAS view ivOffer | |
| OFFERED_ENTRY_MONTH | VARCHAR2 | (2) | Month of entry in offer, to synchronize with UCAS view ivOffer | |
| OFFERED_ENTRY_YEAR | VARCHAR2 | (2) | Year of entry in offer, to synchronize with UCAS view ivOffer | |
| OFFERED_ENTRY_POINT | VARCHAR2 | (1) | Point of entry in offer, to synchronize with UCAS view ivOffer | |
| OFFERED_TEXT | VARCHAR2 | (2000) | Text version of offer letter to synchronize with UCAS view ivOffer | |
| EXPORT_TO_OSS_STATUS | VARCHAR2 | (10) | Identifies the status of exporting the application choices, Default value is NEW | |
| EXPORT_PROCESS_ERROR_CODE | VARCHAR2 | (10) | Identifies the Error encountered while exporting the application choice to OSS | |
| ADM_IMPORT_PROCESS_BATCH_ID | NUMBER | (15) | Admission Import Process batch in which the last error was encountered | |
| EXTRA_ROUND_NUMBER | NUMBER | (3) | Holds the UCAS EXTRA Processing round number | |
| UCAS_SYSTEM_CODE | VARCHAR2 | (1) | Yes | UCAS System Code |
| GTTR_PART_TIME | VARCHAR2 | (1) | GTTR System Part Time | |
| GTTR_INTERVIEW_DATE | DATE | GTTR System Interview Date | ||
| GTTR_LATE_APPLICATION_FLAG | VARCHAR2 | (1) | GTTR late Application flag | |
| GTTR_MODULAR_FLAG | VARCHAR2 | (1) | GTTR System Modular flag | |
| NMAS_RESIDENTIAL_FLAG | VARCHAR2 | (1) | NMAS residential flag | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO columns |
| CREATION_DATE | DATE | Yes | Standard WHO columns | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO columns |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO columns |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICANT_CHOICE_ID
, APPLICANT_ID
, APPLICANT_UCAS_NUMBER
, APPLICANT_CHOICE_NUMBER
, UCAS_CYCLE
, DATE_OF_LAST_CHANGE
, UCAS_INSTITUTE_CODE
, UCAS_PROGRAM_CODE
, OSS_PROGRAM_CODE
, OSS_PROGRAM_VERSION
, OSS_ATTENDANCE_TYPE
, OSS_ATTENDANCE_MODE
, UCAS_CAMPUS
, OSS_LOCATION
, UCAS_FACULTY
, ENTRY_YEAR
, ENTRY_MONTH
, POINT_OF_ENTRY
, HOME_FLAG
, DEFERRED_FLAG
, ROUTE_B_PREFERENCE_ROUND_FLAG
, ROUTE_B_ACTUAL_ROUND_FLAG
, CONDITION_CATEGORY
, CONDITION_CODE
, DECISION
, DECISION_DATE
, DECISION_NUMBER
, REPLY
, SUMMARY_OF_CONDITIONS
, CHOICE_CANCELLED_FLAG
, ACTION
, SUBSTITUTION
, SUBSTITUTED_DATE
, PREVIOUS_INSTITUTION
, PREVIOUS_COURSE
, PREVIOUS_CAMPUS
, UCAS_AMENDMENT
, WITHDRAWAL_REASON
, OFFERED_COURSE
, OFFERED_CAMPUS
, OFFERED_COURSE_LENGTH
, OFFERED_ENTRY_MONTH
, OFFERED_ENTRY_YEAR
, OFFERED_ENTRY_POINT
, OFFERED_TEXT
, EXPORT_TO_OSS_STATUS
, EXPORT_PROCESS_ERROR_CODE
, ADM_IMPORT_PROCESS_BATCH_ID
, EXTRA_ROUND_NUMBER
, UCAS_SYSTEM_CODE
, GTTR_PART_TIME
, GTTR_INTERVIEW_DATE
, GTTR_LATE_APPLICATION_FLAG
, GTTR_MODULAR_FLAG
, NMAS_RESIDENTIAL_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_UC_APPLICANT_CHOICES;
APPS
IGS_UC_APP_CHOICES
APPS.IGSBV_UC_APPLICANT_CHOICES is not referenced by any database object
|
|
|
|