[Home] [Help]
[Dependency Information]
[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_AD_PRD_AD_PRC_CA
IGS_CA_INST_REL
IGS_EN_GEN_008
- show dependent code
IGS_EN_UNIT_SET_STAT
IGS_PS_COO_AD_UNIT_S
IGS_PS_OFR_OPT_UNIT_SET_V
IGS_PS_OFR_PAT
IGS_PS_OFR_UNIT_SET
IGS_PS_OF_UNT_SET_RL
APPS.IGS_PS_OFR_PAT_UNITSET_V is not referenced by any database object
|
|
|
|