[Home] [Help] [Dependency Information]
Object Name: | IGS_EN_SUSA_PARENT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_EN_SUSA_PARENT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view determines the unit sets that are able to be linked as a parent for a student unit set attempt. The exists field is an indicator to show if the parent exists as a student unit set attempt. If not, then it will need to be created before being linked to the unit set.
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 the student is enrolled. See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA. |
UNIT_SET_CD | VARCHAR2 | (10) | Yes | The code of a unit set. Unit sets comprise lists of units or rules which constitute a logical set of units. Unit sets are used torepresent concepts such as majors, minors, strands, streams,and lists. |
SUSA_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the internal sequence number |
US_VERSION_NUMBER | NUMBER | (3) | Yes | Uniquely identifies each version of a unit set |
SUSA_SELECTION_DT | DATE | The date the student selected the unit set. There may be multiple attempts of a unit set by a student over time. | ||
SUSA_END_DT | DATE | Date that the student unit set attempt was ended | ||
COO_ID | NUMBER | (7) | Yes | A unique number that 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 |
UNIT_SET_STATUS | VARCHAR2 | (150) | Yes | Describes the institution-defined unit set status. The unit set status is attributed to each version to define its currency in the system. Unit set status maps to a system unit set status with its associated functionality. |
UNIT_SET_CAT | VARCHAR2 | (10) | Yes | The code of a category of unit set. Unit set categories are institution-defined and may include, for example, Major, Minor, Strand, and Stream. |
TITLE | VARCHAR2 | (90) | The title of a unit set. Unit sets comprise lists of units or rules which constitute a logical set of units. Unit sets are used to represents concepts such as majors, minors, strands, streams,and lists. | |
SUB_UNIT_SET_CD | VARCHAR2 | (10) | Yes | Describes the subordinate unit set code |
SUB_US_VERSION_NUMBER | NUMBER | (3) | Yes | Describes the subordinate unit set code |
SUSA_EXISTS_IND | CHAR | (1) | Inicates if the parent exists as a student_unit_set_attempt record | |
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
, SUSA_SEQUENCE_NUMBER
, US_VERSION_NUMBER
, SUSA_SELECTION_DT
, SUSA_END_DT
, COO_ID
, CAL_TYPE
, CRV_VERSION_NUMBER
, UNIT_SET_STATUS
, UNIT_SET_CAT
, TITLE
, SUB_UNIT_SET_CD
, SUB_US_VERSION_NUMBER
, SUSA_EXISTS_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_EN_SUSA_PARENT_V;
APPS.IGS_EN_SUSA_PARENT_V is not referenced by any database object
|
|
|