[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_OFR_PAT_UNITSET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_OFR_PAT_UNITSET_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view describes the offering pattern of a program offering option. This is related to a calendar instance, nominating when each option is available. It describes the relationship between admission periods, admission process types and admission categories. It also describes a unit-set, being a logical sub-grouping of program. For example, major, minor, stream, strand. A unit-set is typically related to the rules which govern its completion via the Rules sub-system.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_SET_CD | VARCHAR2 | (10) | Describes the user-defined code used to identify a set of units. Unit sets contain lists of units or rules that make up a logical set of units. Unit sets are used to represents concepts such as majors, minors, strands, streams, lists and others. | |
US_VERSION_NUMBER | NUMBER | (3) | Used to uniquely identify each version of a unit set | |
COURSE_CD | VARCHAR2 | (6) | Yes | Unique identifier for a program being offered |
CRV_VERSION_NUMBER | NUMBER | (3) | Yes | The version number of the program being offered. There can only be one version of a program with a system status of active and an unset expiry date. |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | The academic calendar type in that the course 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 |
LOCATION_CD | VARCHAR2 | (10) | Yes | A llocation name or code. The location represents a geographical location and can be used to indicate if programs and units can be offered. |
ATTENDANCE_MODE | VARCHAR2 | (2) | Yes | Describes the attendance modes that the program is being offered. These modes are user-defined. For example, on campus, off campus. DEET element reference 329. |
ATTENDANCE_TYPE | VARCHAR2 | (2) | Yes | Describes the attendance types for a program. For example, full-time, part-time. DEET element reference 330. |
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 |
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_SET_CD
, US_VERSION_NUMBER
, COURSE_CD
, CRV_VERSION_NUMBER
, ACAD_CAL_TYPE
, ACAD_CI_SEQUENCE_NUMBER
, LOCATION_CD
, ATTENDANCE_MODE
, ATTENDANCE_TYPE
, ADM_CAL_TYPE
, ADM_CI_SEQUENCE_NUMBER
, ADMISSION_CAT
, S_ADMISSION_PROCESS_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_OFR_PAT_UNITSET_V;
APPS.IGS_PS_OFR_PAT_UNITSET_V is not referenced by any database object
|
|
|