[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_SU_ATTEMPT_H |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_EN_SU_ATTEMPT_H
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
IGS_EN_SU_ATTEMPT_H implements the student unit attempt
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row identifier | |
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| PERSON_ID | NUMBER | (15) | Yes | Person identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| COURSE_CD | VARCHAR2 | (6) | Yes | Describes the program code. DEET element reference 307. |
| UNIT_CD | VARCHAR2 | (10) | Yes | Identifies the unit |
| VERSION_NUMBER | NUMBER | (3) | Uniquely identifies each version of a unit | |
| CAL_TYPE | VARCHAR2 | (10) | Yes | 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 |
| HIST_START_DT | DATE | Yes | The effective start date and time of the history record | |
| HIST_END_DT | DATE | Yes | The effective end date and time of the history record | |
| HIST_WHO | NUMBER | (15) | Yes | The Oracle username of the person who created the history record. |
| LOCATION_CD | VARCHAR2 | (10) | Location name or code. The location represents a geographical location and is used to indicate where units are offered. | |
| UNIT_CLASS | VARCHAR2 | (10) | Describes the code that uniquely identifies the unit class | |
| ENROLLED_DT | DATE | Describes the date that the enrollment in the unit took effect. If this date is not selected, the student has not confirmed their enrollment in the unit attempt. | ||
| UNIT_ATTEMPT_STATUS | VARCHAR2 | (10) | Describes the unit attempt status for the duration of the student unit attempt history | |
| ADMINISTRATIVE_UNIT_STATUS | VARCHAR2 | (10) | Describes the administrative unit status for the duration of the student unit attempt history | |
| AUS_DESCRIPTION | VARCHAR2 | (60) | Gives the description for the administrative unit status | |
| DISCONTINUED_DT | DATE | Describes the date discontinuation date for the duration of the student unit attempt history | ||
| RULE_WAIVED_DT | DATE | Describes the date that a failed rule applying to the unit attempt was waived | ||
| RULE_WAIVED_PERSON_ID | NUMBER | (15) | Describes the person who waived the unit rule applicable to the unit attempt | |
| NO_ASSESSMENT_IND | VARCHAR2 | (1) | Specifies whether or not the student is seeking a formal grade for the student unit attempt. Selecting the checkbox ticked signifies that the student is simply auditing the unit and will not be formally assessed. | |
| EXAM_LOCATION_CD | VARCHAR2 | (10) | Describes the code that uniquely identifies an examination location | |
| ELO_DESCRIPTION | VARCHAR2 | (60) | Description of the location where the exam was conducted | |
| SUP_UNIT_CD | VARCHAR2 | (10) | Describes the superior unit code of the unit version being attempted | |
| SUP_VERSION_NUMBER | NUMBER | (3) | Describes the superior unit version number of the unit version being attempted | |
| ALTERNATIVE_TITLE | VARCHAR2 | (90) | Describes the alternative title for the student unit attempt. This alternative title will override the title contained inthe 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_DT | DATE | *** Future functionality | ||
| OVERRIDE_CREDIT_REASON | VARCHAR2 | (2000) | Describes the reason for overriding the achievable or enrolled credit point values | |
| 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 | |
| DCNT_REASON_CD | VARCHAR2 | (10) | The code for the reason of discontinuation of a program by the student. | |
| GRADING_SCHEMA_CODE | VARCHAR2 | (10) | Grading Schema Code | |
| ENR_METHOD_TYPE | VARCHAR2 | (10) | Enrollment method type | |
| DEG_AUD_DETAIL_ID | NUMBER | Degree Audit Detail ID | ||
| UOO_ID | NUMBER | (7) | Yes | The unique identifier for a unit offering option. |
| CORE_INDICATOR_CODE | VARCHAR2 | (30) | The core indicator indicates whether a student unit attempt is Core, Optional, Elective or null. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORG_ID
, PERSON_ID
, COURSE_CD
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, LOCATION_CD
, UNIT_CLASS
, ENROLLED_DT
, UNIT_ATTEMPT_STATUS
, ADMINISTRATIVE_UNIT_STATUS
, AUS_DESCRIPTION
, DISCONTINUED_DT
, RULE_WAIVED_DT
, RULE_WAIVED_PERSON_ID
, NO_ASSESSMENT_IND
, EXAM_LOCATION_CD
, ELO_DESCRIPTION
, SUP_UNIT_CD
, SUP_VERSION_NUMBER
, ALTERNATIVE_TITLE
, OVERRIDE_ENROLLED_CP
, OVERRIDE_EFTSU
, OVERRIDE_ACHIEVABLE_CP
, OVERRIDE_OUTCOME_DUE_DT
, OVERRIDE_CREDIT_REASON
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DCNT_REASON_CD
, GRADING_SCHEMA_CODE
, ENR_METHOD_TYPE
, DEG_AUD_DETAIL_ID
, UOO_ID
, CORE_INDICATOR_CODE
FROM APPS.IGS_EN_SU_ATTEMPT_H;
APPS
IGS_EN_SU_ATTEMPT_H_ALL
APPS
IGS_AD_GEN_001
- show dependent code
IGS_AS_SUA_H_V
IGS_AU_GEN_003
- show dependent code
IGS_EN_GEN_007
- show dependent code
IGS_EN_GEN_010
- show dependent code
IGS_EN_GET_SUAEH_DTL
- show dependent code
IGS_EN_NSC_PKG
- show dependent code
IGS_EN_SU_ATTEMPT_PKG
- show dependent code
IGS_FI_GET_SUAEH
- show dependent code
IGS_ST_GEN_004
- show dependent code
|
|
|
|