[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SU_ATMPTOUT_H_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_SU_ATMPTOUT_H_ALL |
Subobject Name: | |
Status: | VALID |
IGS_AS_SU_ATMPTOUT_H_ALL describes history of changes made to student unit attempt outcome.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_SU_ATMPTOUT_H_ALL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
COURSE_CD UOO_ID OUTCOME_DT HIST_START_DT |
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 | Course code |
UNIT_CD | VARCHAR2 | (10) | Yes | Unit code |
CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Calendar instance sequence number |
OUTCOME_DT | DATE | Yes | Outcome date | |
HIST_START_DT | DATE | Yes | The effective start date and time of the history record. | |
HIST_END_DT | DATE | Yes | Effective end date | |
HIST_WHO | NUMBER | (15) | Yes | The Oracle username of the person who created the history record. |
GRADING_SCHEMA_CD | VARCHAR2 | (10) | Grading schema code | |
VERSION_NUMBER | NUMBER | (3) | Grading schema version number | |
GRADE | VARCHAR2 | (5) | The grade which the student attained for this unit attempt. | |
S_GRADE_CREATION_METHOD_TYPE | VARCHAR2 | (10) | System grade creation method type | |
FINALISED_OUTCOME_IND | VARCHAR2 | (1) | Indicates and specifies if or not the outcome for the unit attempt is finalised. Setting the indicator ticked means that the outcome for the unit attempt is finalised. If the indicator is not set and it is the latest outcome, then it is considered recommended and pending finalization. | |
MARK | NUMBER | (6) | A numeric code that indicates the student's level of achievement in the unit attempt. | |
NUMBER_TIMES_KEYED | NUMBER | (2) | Total number of times entered by the user. | |
TRANSLATED_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Translated grading cchema code | |
TRANSLATED_VERSION_NUMBER | NUMBER | (3) | Translated grading schema version number | |
TRANSLATED_GRADE | VARCHAR2 | (5) | Translated grade | |
TRANSLATED_DT | DATE | Date when the translation was done. | ||
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 | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
UOO_ID | NUMBER | (7) | Yes | Unit Section identifier |
MARK_CAPPED_FLAG | VARCHAR2 | (1) | Allows user to indicate whether marks have been capped for a student unit attempt outcome | |
SHOW_ON_ACADEMIC_HISTRY_FLAG | VARCHAR2 | (1) | Allows user to define whether the changed grade be displayed on the Academic History self-service page. | |
RELEASE_DATE | DATE | Date on which the student unit attempt outcome will be released to the student for viewing | ||
MANUAL_OVERRIDE_FLAG | VARCHAR2 | (1) | The user should select this checkbox to keep the system from replacing the manually assigned marks with the system calculated ones. |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, OUTCOME_DT
, HIST_START_DT
, HIST_END_DT
, HIST_WHO
, GRADING_SCHEMA_CD
, VERSION_NUMBER
, GRADE
, S_GRADE_CREATION_METHOD_TYPE
, FINALISED_OUTCOME_IND
, MARK
, NUMBER_TIMES_KEYED
, TRANSLATED_GRADING_SCHEMA_CD
, TRANSLATED_VERSION_NUMBER
, TRANSLATED_GRADE
, TRANSLATED_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, UOO_ID
, MARK_CAPPED_FLAG
, SHOW_ON_ACADEMIC_HISTRY_FLAG
, RELEASE_DATE
, MANUAL_OVERRIDE_FLAG
FROM IGS.IGS_AS_SU_ATMPTOUT_H_ALL;
IGS.IGS_AS_SU_ATMPTOUT_H_ALL does not reference any database object
IGS.IGS_AS_SU_ATMPTOUT_H_ALL is referenced by following:
|
|
|