[Home] [Help]
[Dependency Information]
[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_AS_SU_SETATMPT
IGS_EN_GEN_008
- show dependent code
IGS_EN_STDNT_PS_ATT
IGS_EN_UNIT_SET
IGS_PS_OF_UNT_SET_RL
APPS.IGS_EN_SUSA_PARENT_V is not referenced by any database object
|
|
|
|