[Home] [Help] [Dependency Information]
Object Name: | IGSBV_UC_COURSE_VAC_OPTIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_UC_COURSE_VAC_OPTIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Base View for Course Vacancy Options
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UCAS_PROGRAM_CODE | VARCHAR2 | (6) | Yes | UCAS course code |
UCAS_INSTITUTE_CODE | VARCHAR2 | (3) | Yes | UCAS Institute code |
UCAS_CAMPUS_CODE | VARCHAR2 | (1) | Yes | UCAS campus code |
UCAS_SYSTEM_CODE | VARCHAR2 | (1) | Yes | UCAS System Code |
OPTION_CODE | VARCHAR2 | (2) | Yes | Option code |
CLEARING_UPDATED | VARCHAR2 | (1) | Vacancies updated not notified (Y - yes) | |
CLEARING_UPDATED_DATE | DATE | Vacancies updated date | ||
VACANCY_STATUS | VARCHAR2 | (1) | Vacancy Status | |
_LA:VACANCY_STATUS_DESC | CHAR | (65) | ||
SENT_TO_UCAS | VARCHAR2 | (1) | Yes | Update sent to UCAS (Y - Yes, N - No) |
UCAS_COURSE_SHORT_TITLE | VARCHAR2 | (20) | Course short title | |
UCAS_COURSE_LONG_TITLE | VARCHAR2 | (100) | Course long title | |
OSS_PROGRAM_CODE | VARCHAR2 | (6) | Mapped OSS Program Code | |
OSS_PROGRAM_VERSION | NUMBER | (3) | Mapped OSS Program version | |
OSS_LOCATION_CODE | VARCHAR2 | (10) | Mapped OSS location code | |
OSS_ATTENDANCE_TYPE | VARCHAR2 | (2) | Mapped OSS Attendance Type | |
OSS_ATTENDANCE_MODE | VARCHAR2 | (2) | Mapped OSS Attendance Mode | |
CLEARING_OPTIONS_FLAG | VARCHAR2 | (1) | Indicates whether to use Clearing Option Codes for this course | |
UPDATER_IDENTIFIER | VARCHAR2 | (20) | Yes | Identifier of the last updater |
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 UCAS_PROGRAM_CODE
, UCAS_INSTITUTE_CODE
, UCAS_CAMPUS_CODE
, UCAS_SYSTEM_CODE
, OPTION_CODE
, CLEARING_UPDATED
, CLEARING_UPDATED_DATE
, VACANCY_STATUS
, _LA:VACANCY_STATUS_DESC
, SENT_TO_UCAS
, UCAS_COURSE_SHORT_TITLE
, UCAS_COURSE_LONG_TITLE
, OSS_PROGRAM_CODE
, OSS_PROGRAM_VERSION
, OSS_LOCATION_CODE
, OSS_ATTENDANCE_TYPE
, OSS_ATTENDANCE_MODE
, CLEARING_OPTIONS_FLAG
, UPDATER_IDENTIFIER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_UC_COURSE_VAC_OPTIONS;
APPS.IGSBV_UC_COURSE_VAC_OPTIONS is not referenced by any database object
|
|
|