[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_OFR_OPT_OFROPT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_UNIT_OFR_OPT_OFROPT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Defines the valid unit offering options for a nominated admission program application unit
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_CD | VARCHAR2 | (10) | Yes | The unique identifier of the unit being offered |
VERSION_NUMBER | NUMBER | (3) | Yes | The version number of the unit being offered. Students are normally enrolled in the current version of a unit. Prior versions of the unit are end-dated. |
TEACH_CAL_TYPE | VARCHAR2 | (10) | Yes | The calendar type that the unit is offered. For example, include SEM-1, semester 1 teaching period, TRI-2 (trimester 2 teaching period, and sum summer teaching period. Units can only be offered in instances of calendar types that are categorized as teaching calendars. |
TEACH_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The unique identifier for the calendar instance |
LOCATION_CD | VARCHAR2 | (10) | Yes | The institution-defined location code, typically of a campus, that a unit offering option is offered |
UNIT_CLASS | VARCHAR2 | (10) | Yes | The institution-defined code that identifies a unit class |
ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the calendar type relating to the admission period |
ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the sequence number that uniquely identifies the admission period calendar instance |
ADMISSION_CAT | VARCHAR2 | (10) | Yes | Describes the admission category that applies to this admission period |
S_ADMISSION_PROCESS_TYPE | VARCHAR2 | (30) | Yes | Describes the system admission process type that applies to this admission period |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | The academic calendar type that the program is offered. A calendar type is the institution-defined name of a type of calendar used within the organization. |
ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The unique identifier for the academic calendar instance |
UNIT_STATUS | VARCHAR2 | (10) | Yes | The institution-defined status of a unit that maps to a system unit status. A unit is established with a system equivalent status of planned. For students to be enrolled in the unit it must have a system equivalent status of active. When the unit is no longer to be offered it is given a system equivalent status of inactive. Inactive units may be archived. |
S_UNIT_STATUS | VARCHAR2 | (10) | Yes | A system-defined unit status. Each instiution-defined unit status is mapped to a system status. System values are planned, active, and inactive. |
UNIT_TITLE | VARCHAR2 | (90) | Yes | The title of the unit |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_CD
, VERSION_NUMBER
, TEACH_CAL_TYPE
, TEACH_CI_SEQUENCE_NUMBER
, LOCATION_CD
, UNIT_CLASS
, ADM_CAL_TYPE
, ADM_CI_SEQUENCE_NUMBER
, ADMISSION_CAT
, S_ADMISSION_PROCESS_TYPE
, ACAD_CAL_TYPE
, ACAD_CI_SEQUENCE_NUMBER
, UNIT_STATUS
, S_UNIT_STATUS
, UNIT_TITLE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_UNIT_OFR_OPT_OFROPT_V;
APPS.IGS_PS_UNIT_OFR_OPT_OFROPT_V is not referenced by any database object
|
|
|