[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_STUDENT_UNIT_ATTEMPTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_STUDENT_UNIT_ATTEMPTS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This entity describes a student's attempt at studying a particular unit offered by the university.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| PROGRAM_CODE | VARCHAR2 | (6) | Yes | Code used to identify the program in that the student is enrolled. |
| UNIT_CODE | VARCHAR2 | (10) | Yes | Code used to identify the unit |
| VERSION_NUMBER | NUMBER | (3) | Yes | Version number is used to uniquely identify each version of a unit |
| CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Field is the name of a type of teaching calendar within the university. For example, SEM-1, YR-LONG. |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Uniquely identifies the calendar instance. |
| LOCATION_CODE | VARCHAR2 | (10) | Yes | Location name or code. The location represents a geographical location and is used to indicate if units are offered. |
| UNIT_CLASS | VARCHAR2 | (10) | Yes | Describes the code that uniquely identifies the unit class. |
| CI_START_DATE | DATE | Yes | Describes the date from which an instance of a calendar is effective. | |
| CI_END_DATE | DATE | Yes | Date from that an instance of a calendar is no longer effective. For example, teaching period Semester 1, 1999 may end on30/06/1999. | |
| ENROLLED_DATE | DATE | Describes the date on that the enrollment in the unit took effect. If this date is not set, the student has not confirmed their enrollment in the unit attempt. | ||
| UNIT_ATTEMPT_STATUS | VARCHAR2 | (30) | Yes | Describes the system-defined unit attempt statuses |
| ADMINISTRATIVE_UNIT_STATUS | VARCHAR2 | (10) | Describes institution-defined administrative statuses. For example, WD-EARLY Withdrawn Early , WD-LATE Withdrawn Late . | |
| DISCONTINUED_DATE | DATE | Describes the date on which the discontinuation of the unit attempt took effect. | ||
| RULE_WAIVED_DATE | DATE | Describes the date on which a failed rule applying to the unit attempt was waived. | ||
| NO_ASSESSMENT_INDICATOR | VARCHAR2 | (1) | Yes | Indicator that specifies whether or not the student is seeking a formal grade for the student unit attempt. Setting the checkbox ticked signifies that the student is simply auditing the unit and will not be formally assessed. |
| SUPERIOR_UNIT_CODE | VARCHAR2 | (10) | Describes the superior unit code of the unit version being attempted. | |
| SUPERIOR_VERSION_NUMBER | NUMBER | (3) | Describes the superior unit version number of the unit version being attempted. | |
| EXAM_LOCATION_CODE | VARCHAR2 | (10) | Describes the code that uniquely identifies an examination location. | |
| ALTERNATIVE_TITLE | VARCHAR2 | (90) | Describes the alternative title for the student unit attempt. This alternative title will override the title contained in the unit table. For example, it would appear on the student's transcript. | |
| OVERRIDE_ENROLLED_CP | NUMBER | (6) | Describes the enrolled credit point value that applies to the student unit attempt. This value will override that contained in the unit entity. | |
| OVERRIDE_EFTSU | NUMBER | (7) | Describes the EFTSU figure entered as an override for the particular student unit attempt. This figure will be used by the system as a ''base EFTSU'' whenever calculating EFTSU. | |
| OVERRIDE_ACHIEVABLE_CP | NUMBER | (6) | Describes the achievable credit point value that applies to the student unit attempt. This value will override that contained in the unit entity. | |
| OVERRIDE_OUTCOME_DUE_DATE | DATE | Future functionality. This field describes an override for the due date of the outcome. Normally dates in the teaching period calendar would govern when an outcome is due for a student unit attempt. | ||
| OVERRIDE_CREDIT_REASON | VARCHAR2 | (2000) | Describes the reason for overriding the achievable or enrolled credit point values. | |
| ADMINISTRATIVE_PRIORITY | NUMBER | Priority given to the waitlist by the administration | ||
| WAITLIST_DATE | DATE | Date on which the student is entered into the waitlist | ||
| DISCONTINUATION_REASON_CODE | VARCHAR2 | (10) | Code that describes the reason for discontinuation from the program by the student. | |
| GRADING_SCHEMA_CODE | VARCHAR2 | (10) | Code that describes the grading schema for the program | |
| GRADING_SCH_VERSION_NUMBER | NUMBER | (3) | Holds the Version Number of the Grading Schema | |
| ENROLLMENT_METHOD_TYPE | VARCHAR2 | (10) | Holds the Enrollment Method Type. | |
| FAILED_UNIT_RULE | VARCHAR2 | (30) | Field, which will store the reason for, failed validation for the INVALID unit attempts of the student. | |
| ADDED_TO_CART | VARCHAR2 | (1) | Indicates whether the unit attempt is added to the cart or not. | |
| ORGANIZATION_UNIT_CODE | VARCHAR2 | (30) | Captures the Organization unit code for the student unit attempt. | |
| SUBTITLE | VARCHAR2 | (90) | Sub title | |
| STUDENT_CAREER_TRANSCRIPT | VARCHAR2 | (1) | Indicates whether to include the Unit attempt as part of Career transcript. | |
| STUDENT_CAREER_STATISTICS | VARCHAR2 | (1) | Indicates whether to include the Unit attempt as part of Career Statistics. | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person number |
| PROGRAM_TITLE | VARCHAR2 | (90) | Yes | The title of the program attempted |
| UNIT_TITLE | VARCHAR2 | (90) | Yes | The title of the unit attempted |
| CALENDAR_INSTANCE_DESC | VARCHAR2 | (30) | Description of the Teaching Calendar in which the unit is attempted | |
| LOCATION_DESCRIPTION | VARCHAR2 | (60) | Yes | Description of the Location of the Unit being attempted |
| UNIT_CLASS_DESCRIPTION | VARCHAR2 | (60) | Yes | Description of the Unit class |
| _LA:UNIT_ATTEMPT_STATUS_DESC | CHAR | (73) | Unit Attempt Status Description | |
| ADMIN_UNIT_STATUS_DESC | VARCHAR2 | (60) | Administrative Unit Status description | |
| SUPERIOR_UNIT_TITLE | VARCHAR2 | (90) | Title for the superior unit of the unit version being attempted. | |
| EXAM_LOCATION_DESC | VARCHAR2 | (60) | Exam Location Description | |
| DISCONTINUATION_REASON_DESC | VARCHAR2 | (60) | Discontinuation reason code description | |
| GRADING_SCHEMA_CODE_DESC | VARCHAR2 | (60) | Grading Schema code description | |
| ENR_METHOD_TYPE_DESC | VARCHAR2 | (60) | Enrollment Method Type Description | |
| CORE_INDICATOR_CODE | VARCHAR2 | (30) | The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null. | |
| ORGANIZATION_UNIT_NAME | VARCHAR2 | (360) | Organization Unit name | |
| RULE_WAIVED_PERSON_NUMBER | VARCHAR2 | (30) | Person Number of rule waived | |
| PRIORITY_ID | NUMBER | (15) | Priority ID of Reserve Seating setup | |
| PREFERENCE_ID | NUMBER | (15) | Preference ID of Reserve Seating setup | |
| RESERVE_LEVEL | VARCHAR2 | (10) | The level at which priority and preferences are defined.(USEC, UOPT, ORG) | |
| RULE_WAIVED_PERSON_ID | NUMBER | (15) | Describes the person who waived the unit rule applicable to the unit attempt. | |
| UOO_ID | NUMBER | (7) | Yes | Unique identifier for a unit offering option. |
| DEGREE_AUDIT_DETAIL_ID | NUMBER | Degree Audit Details id | ||
| RESERVE_SEAT_EXT_ID | NUMBER | (15) | Indicates the Reserve Seating Priority and Preference used for Enrollment | |
| SESSION_ID | NUMBER | Session id | ||
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, PROGRAM_CODE
, UNIT_CODE
, VERSION_NUMBER
, CALENDAR_TYPE
, CI_SEQUENCE_NUMBER
, LOCATION_CODE
, UNIT_CLASS
, CI_START_DATE
, CI_END_DATE
, ENROLLED_DATE
, UNIT_ATTEMPT_STATUS
, ADMINISTRATIVE_UNIT_STATUS
, DISCONTINUED_DATE
, RULE_WAIVED_DATE
, NO_ASSESSMENT_INDICATOR
, SUPERIOR_UNIT_CODE
, SUPERIOR_VERSION_NUMBER
, EXAM_LOCATION_CODE
, ALTERNATIVE_TITLE
, OVERRIDE_ENROLLED_CP
, OVERRIDE_EFTSU
, OVERRIDE_ACHIEVABLE_CP
, OVERRIDE_OUTCOME_DUE_DATE
, OVERRIDE_CREDIT_REASON
, ADMINISTRATIVE_PRIORITY
, WAITLIST_DATE
, DISCONTINUATION_REASON_CODE
, GRADING_SCHEMA_CODE
, GRADING_SCH_VERSION_NUMBER
, ENROLLMENT_METHOD_TYPE
, FAILED_UNIT_RULE
, ADDED_TO_CART
, ORGANIZATION_UNIT_CODE
, SUBTITLE
, STUDENT_CAREER_TRANSCRIPT
, STUDENT_CAREER_STATISTICS
, PERSON_NUMBER
, PROGRAM_TITLE
, UNIT_TITLE
, CALENDAR_INSTANCE_DESC
, LOCATION_DESCRIPTION
, UNIT_CLASS_DESCRIPTION
, _LA:UNIT_ATTEMPT_STATUS_DESC
, ADMIN_UNIT_STATUS_DESC
, SUPERIOR_UNIT_TITLE
, EXAM_LOCATION_DESC
, DISCONTINUATION_REASON_DESC
, GRADING_SCHEMA_CODE_DESC
, ENR_METHOD_TYPE_DESC
, CORE_INDICATOR_CODE
, ORGANIZATION_UNIT_NAME
, RULE_WAIVED_PERSON_NUMBER
, PRIORITY_ID
, PREFERENCE_ID
, RESERVE_LEVEL
, RULE_WAIVED_PERSON_ID
, UOO_ID
, DEGREE_AUDIT_DETAIL_ID
, RESERVE_SEAT_EXT_ID
, SESSION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_STUDENT_UNIT_ATTEMPTS;
APPS
HZ_PARTIES
IGS_AD_ADM_UNIT_STAT_ALL
IGS_AD_LOCATION_ALL
IGS_AS_GRD_SCHEMA
IGS_AS_UNIT_CLASS_ALL
IGS_CA_INST_ALL
IGS_EN_DCNT_REASONCD_ALL
IGS_EN_METHOD_TYPE
IGS_EN_STDNT_PS_ATT_ALL
IGS_EN_SU_ATTEMPT_ALL
IGS_PE_HZ_PARTIES
IGS_PS_RSV_EXT
IGS_PS_UNIT_VER_ALL
IGS_PS_VER_ALL
APPS.IGSFV_STUDENT_UNIT_ATTEMPTS is not referenced by any database object
|
|
|
|