[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_EN_SUA_RULCHK_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_EN_SUA_RULCHK_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 |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value. |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person identifier |
| FULL_NAME | VARCHAR2 | (450) | Full name of the 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 CollectionDocumentation 1997, DETYA. |
| UNIT_CD | VARCHAR2 | (10) | Yes | The code used to identify the unit. |
| VERSION_NUMBER | NUMBER | (3) | Yes | Version number is used to uniquely identify each version of a unit. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | This field is the name of a type of teaching calendar within the university. Examples- SEM-1, YR-LONG. |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | This field uniquely identifies the calendar instance. |
| LOCATION_CD | VARCHAR2 | (10) | Yes | This field is the location name or code. The locationrepresents a geographical location and is used to indicate where units are offered. |
| UNIT_CLASS | VARCHAR2 | (10) | Yes | This field describes the code that uniquely identifies the unit class |
| CI_START_DT | DATE | Yes | This field describes the date from which an instance of a calendar is effective | |
| CI_END_DT | DATE | Yes | This field is the date from which an instance of a calendar is no longer effective example- teaching period Semester 1, 1999 may end on30/06/1999. | |
| UOO_ID | NUMBER | (7) | Yes | The unique identifier for a unit offering option. |
| OWNER_ORG_UNIT_CD | VARCHAR2 | (30) | ||
| ENROLLED_DT | DATE | This field describes the date on which the enrolment in the unit took effect. If this date is not set, the student has notconfirmed their enrolment in the unit attempt. | ||
| UNIT_ATTEMPT_STATUS | VARCHAR2 | (30) | Yes | This field describes the system-defined unit attempt statuses.. |
| ADMINISTRATIVE_UNIT_STATUS | VARCHAR2 | (10) | This field describes institution-defined administrative statuses.Examples- WD-EARLY-Withdrawn Early, WD-LATE -Withdrawn Late. | |
| DISCONTINUED_DT | DATE | This field describes the date on which the discontinuation of the unit attempt took effect. | ||
| RULE_WAIVED_DT | DATE | This field describes the date on which a failed rule applying to the unit attempt was waived. | ||
| RULE_WAIVED_PERSON_ID | NUMBER | (15) | This field describes the person who waived the unit rule applicable to the unit attempt. | |
| NO_ASSESSMENT_IND | VARCHAR2 | (1) | Yes | An indicator which specifies whether or not the student is seekinga formal grade for the student unit attempt. Setting the checkbox ticked signifies that the student is simply auditing the unit andwill not be formally assessed. |
| SUP_UNIT_CD | VARCHAR2 | (10) | This field describes the superior unit code of the unit version being attempted. | |
| SUP_VERSION_NUMBER | NUMBER | (3) | This field describes the superior unit version number of the unit version being attempted. | |
| EXAM_LOCATION_CD | VARCHAR2 | (10) | This field describes the code that uniquely identifies an examination location. | |
| ALTERNATIVE_TITLE | VARCHAR2 | (90) | This field describes the alternative title for the student unitattempt. This alternative title will override the title contained inthe unit table example-it would appear on the student's transcript. | |
| OVERRIDE_ENROLLED_CP | NUMBER | (6) | This field describes the enrolled credit point value which appliesto the student unit attempt. This value will override that contained in the unit entity. | |
| GRADING_SCHEMA_CODE | VARCHAR2 | (10) | ||
| ADMINISTRATIVE_PRIORITY | NUMBER | The priority given by the administration to a waitlist. | ||
| WAITLIST_DT | DATE | The date on which a student is put onto a waitlist. | ||
| WAITLIST_MANUAL_IND | VARCHAR2 | (1) | Indicator column, says whether the waitlist position is modified manually or by system | |
| DCNT_REASON_CD | VARCHAR2 | (10) | The code which describes the reason for discontinuation of a program by the student. | |
| OVERRIDE_EFTSU | NUMBER | (7) | This field 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) | This field describes the achievable credit point value which appliesto 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) | This field describes the reason for overriding the achievable or enrolled credit point values. | |
| FAILED_UNIT_RULE | VARCHAR2 | (30) | ||
| FAILED_UNIT_RULE_MEANING | VARCHAR2 | (80) | ||
| 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) | ||
| DEG_AUD_DETAIL_ID | NUMBER | Degree Audit Detail Id |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PERSON_ID
, PERSON_NUMBER
, FULL_NAME
, COURSE_CD
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, LOCATION_CD
, UNIT_CLASS
, CI_START_DT
, CI_END_DT
, UOO_ID
, OWNER_ORG_UNIT_CD
, ENROLLED_DT
, UNIT_ATTEMPT_STATUS
, ADMINISTRATIVE_UNIT_STATUS
, DISCONTINUED_DT
, RULE_WAIVED_DT
, RULE_WAIVED_PERSON_ID
, NO_ASSESSMENT_IND
, SUP_UNIT_CD
, SUP_VERSION_NUMBER
, EXAM_LOCATION_CD
, ALTERNATIVE_TITLE
, OVERRIDE_ENROLLED_CP
, GRADING_SCHEMA_CODE
, ADMINISTRATIVE_PRIORITY
, WAITLIST_DT
, WAITLIST_MANUAL_IND
, DCNT_REASON_CD
, OVERRIDE_EFTSU
, OVERRIDE_ACHIEVABLE_CP
, OVERRIDE_OUTCOME_DUE_DT
, OVERRIDE_CREDIT_REASON
, FAILED_UNIT_RULE
, FAILED_UNIT_RULE_MEANING
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DEG_AUD_DETAIL_ID
FROM APPS.IGS_EN_SUA_RULCHK_V;
APPS
IGS_EN_SU_ATTEMPT_SV
IGS_LOOKUP_VALUES
IGS_PE_PERSON_BASE_V
IGS_PS_UNIT_OFR_OPT
APPS.IGS_EN_SUA_RULCHK_V is not referenced by any database object
|
|
|
|