[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_SUSA_INQ_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AS_SUSA_INQ_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | This field describes the ID code that uniquely identifies a person. |
| COURSE_CD | VARCHAR2 | (6) | Yes | A code used to identify the course in which the student is enrolled. -See also Element 307 Higher Education Student Data Collection Documentation 1997, DETYA.- |
| UNIT_SET_CD | VARCHAR2 | (10) | Yes | The unit set code which is being attempted. Unit sets comprise lists of units or rules which constitute a logical set of units. Unit sets are used to represent concepts such as majors, minors, strands, streams and lists. |
| US_VERSION_NUMBER | NUMBER | (3) | Yes | This field describes the unit set version number which is being attempted. |
| UNIT_SET_STATUS | VARCHAR2 | (10) | This field 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. |
| DESCRIPTION | VARCHAR2 | (60) | Yes | This field provides a description of the categories used to classify unit sets. Unit set categories are institution defined and may include for example, Major, Minor, Strand, and Stream. |
| RANK | NUMBER | (3) | Yes | This field describes the relative rank of the unit set category in relation to other categories. For example, a Major may have a higher rank than a Minor. |
| US_START_DT | DATE | Yes | This field records the date on which the unit set version is created. | |
| US_REVIEW_DT | DATE | This field records the date on which 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. | ||
| US_EXPIRY_DT | DATE | This field describes the date on which 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. | ||
| US_END_DT | DATE | This field records the date on which the unit set version is finally closed. All student unit sets must be completed or ended before an end date can be entered. | ||
| SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field describes the internal sequence number. |
| 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. | ||
| STUDENT_CONFIRMED_IND | VARCHAR2 | (1) | Yes | This field indicates whether or not the student has confirmed their attempt at the unit set. |
| END_DT | DATE | The date on which the student unit set attempt was ended. | ||
| PARENT_UNIT_SET_CD | VARCHAR2 | (10) | The parent unit set code. If required it indicates that the unit set in context is a subordinate to another unit set. The parent unit set may be a major that is superior to the unit set in context which may be a minor. The parent unit set must be included as part of the student unit set attempt. It may have an open end date, so it is being completed at the same time as the child unit set or it may already have been completed in which case it would have a completion date. | |
| PARENT_SEQUENCE_NUMBER | NUMBER | (6) | The parent unit set attempt sequence number under which the current attempt is being studied. eg. A minor may be studied within a major. | |
| PRIMARY_SET_IND | VARCHAR2 | (1) | Yes | If the primary set indicator is set -checked- it indicates that the unit set is the primary set. Primary unit sets display on official notification. A unit set cannot be a primary set if it is of a lower rank than another unit set that exists in the student unit set attempt. Administrative unit sets cannot be primary sets. |
| VOLUNTARY_END_IND | VARCHAR2 | (1) | Yes | This field indicates whether the ending of the unit set attempt was voluntary. If not, the student was removed due to a progression breach or other administrative reason. |
| AUTHORISED_PERSON_ID | NUMBER | (15) | The person ID of the staff member who authorised the unit set, for inclusion in the students record -if authorisation was required for selection of the unit set- or authorised the removal of the unit set from the students record -if the unit set was specified as part of an admissions offer-. | |
| AUTHORISED_ON | DATE | The date on which the unit set was authorised. | ||
| SUSA_TITLE | VARCHAR2 | (90) | The override title of the unit set. | |
| RQRMNTS_COMPLETE_IND | VARCHAR2 | (1) | Yes | This field indicates whether the requirements of the unit set have been completed by the student. This may be set by either the system or manually, as indicated by the source type. |
| RQRMNTS_COMPLETE_DT | DATE | The date on which the unit set requirements were complete. | ||
| S_COMPLETED_SOURCE_TYPE | VARCHAR2 | (10) | The source of the completion flag. It can be either system applied or manually applied. | |
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, UNIT_SET_CD
, US_VERSION_NUMBER
, UNIT_SET_STATUS
, UNIT_SET_CAT
, DESCRIPTION
, RANK
, US_START_DT
, US_REVIEW_DT
, US_EXPIRY_DT
, US_END_DT
, SEQUENCE_NUMBER
, SELECTION_DT
, STUDENT_CONFIRMED_IND
, END_DT
, PARENT_UNIT_SET_CD
, PARENT_SEQUENCE_NUMBER
, PRIMARY_SET_IND
, VOLUNTARY_END_IND
, AUTHORISED_PERSON_ID
, AUTHORISED_ON
, SUSA_TITLE
, RQRMNTS_COMPLETE_IND
, RQRMNTS_COMPLETE_DT
, S_COMPLETED_SOURCE_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_AS_SUSA_INQ_V;
APPS
IGS_AS_SU_SETATMPT
IGS_EN_GEN_007
- show dependent code
IGS_EN_UNIT_SET
IGS_EN_UNIT_SET_CAT
APPS.IGS_AS_SUSA_INQ_V is not referenced by any database object
|
|
|
|