[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_UNIT_SET_VALID_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_UNIT_SET_VALID_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view provides valid unit sets for student, and or an option to reselect unit set that student had previously
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (15) | Yes | Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
COURSE_CD | VARCHAR2 | (6) | Yes | Identifies the program that student is enrolled. See also Element 307 Higher Education Student Data Collection Documentation 1997, DEETYA. |
UNIT_SET_CD | VARCHAR2 | (10) | Yes | 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 etc. |
US_VERSION_NUMBER | NUMBER | (3) | Yes | Uniquely identifies each version of a unit set |
COO_ID | NUMBER | (7) | Yes | References the particular program offering option |
CAL_TYPE | VARCHAR2 | (10) | Yes | The name of the calendar type that the program is offered. It is usual for award programs to be offered in the standard academic calendar. |
CRV_VERSION_NUMBER | NUMBER | (3) | Yes | Describes the program version number that the related unit sets are linked to |
START_DT | DATE | Yes | Describes the date that the unit set version is created. This would default to the day after the previous version expired. | |
REVIEW_DT | DATE | Describes the date that the unit set version is to be reviewed. No automated action will result from this date, rather it is expected to trigger notification of the need for review. | ||
EXPIRY_DT | DATE | Describes the date that the unit set version expires. This date would be entered as part of the process of expiring one version and creating a new one. Students may still exist in expired unit set versions until the time when the version is finally ended. | ||
END_DT | DATE | Describes the date that the unit set version is finally closed | ||
UNIT_SET_STATUS | VARCHAR2 | (150) | Yes | Describes the user-defined unit set statuses. The unit set status is attributed to each version to define its currency in the system. Unit set status will map back onto the 'system unitset statuses' which will define the attached functionality. For example, urrent, suspended. |
UNIT_SET_CAT | VARCHAR2 | (10) | Yes | Describes the categories that define the type of the unit set. It would be expected that these categories would vary between institutions due to the large range of terminology used in this area. For example, major, minor, strand, stream, list. |
TITLE | VARCHAR2 | (90) | Provides an explanation of the set of units | |
SHORT_TITLE | VARCHAR2 | (40) | Yes | Describes the unit set short title |
ABBREVIATION | VARCHAR2 | (20) | Yes | Describes the unit set abbreviation |
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 PERSON_ID
, COURSE_CD
, UNIT_SET_CD
, US_VERSION_NUMBER
, COO_ID
, CAL_TYPE
, CRV_VERSION_NUMBER
, START_DT
, REVIEW_DT
, EXPIRY_DT
, END_DT
, UNIT_SET_STATUS
, UNIT_SET_CAT
, TITLE
, SHORT_TITLE
, ABBREVIATION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_UNIT_SET_VALID_V;
APPS.IGS_EN_UNIT_SET_VALID_V is not referenced by any database object
|
|
|