[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_SUAAI_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AS_SUAAI_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 | A unique identification number, incorporating a check digit, used to identify a particular student. |
| 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_CD | VARCHAR2 | (10) | Yes | The code of a unit in which the student is enrolled. A list of values is available. -See also Element 354 of the Higher Education Student Data Collection Documentation 1997, DETYA. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | Units are offered in teaching calendars. For example SEM - 1 -semester 1-, SEM - 2 -semester 2- and YR-LONG -a year long teaching period-. |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The system generated sequence number of the calendar instance. |
| ASS_ID | NUMBER | (10) | Yes | The assessment item ID of an assessment item which has been linked to the student unit attempt. An assessment item ID is a system generated number which is used to uniquely identify an assessment item. An assessment item must first be assigned to one or more unit offering patterns before it can be assigned to student unit attempts. |
| CREATION_DT | DATE | Yes | The date on which the assessment item was assigned to the student unit attempt. | |
| ATTEMPT_NUMBER | NUMBER | (2) | Yes | The attempt number of the assessment item. Assists in identifying the item when multiple attempts of it exist within a single student unit attempt. For example, a student may be required to resubmit an assignment. If assignments are being tracked, the assessment item may be assigned to the student's unit a second time, with an attempt number of 2. |
| OUTCOME_DT | DATE | The date on which the outcome was recorded for the student unit assessment item. | ||
| OVERRIDE_DUE_DT | DATE | The assessment item extension date. Overrides the due date recorded for the assessment item. Typically used to record assignment due date extensions. For tracked assignments, the override due date is copied to the 'received from student' step action date | ||
| DSP_ASSESSMENT_TYPE | VARCHAR2 | (10) | Yes | Assessment type. |
| DSP_DESCRIPTION | VARCHAR2 | (180) | Description for the assessment type. | |
| MARK | NUMBER | (6) | The mark for the assessment item for the student. | |
| GRADE | VARCHAR2 | (5) | The grade for the assessment item for the student. | |
| GRADING_SCHEMA_CD | VARCHAR2 | (10) | The grading schema for the assessment item associated with student assessment item | |
| GS_VERSION_NUMBER | NUMBER | (3) | The version of grading schema for the assessment item associated with student assessment item. | |
| OUTCOME_COMMENT_CODE | VARCHAR2 | (30) | The reason for changing the grade or marks. This would be a required column whenever the marks or grade are changed | |
| OUTCOME_COMMENT_MEANING | VARCHAR2 | (4000) | Meaning of outcome. | |
| PERFORMANCE | VARCHAR2 | (10) | The outcome of the student unit attempt assessment item. Assessment item outcomes are not restricted in any way - characters or numbers may be used. There is no associated system functionality. --'Obsolete' | |
| TRACKING_ID | NUMBER | (9) | The ID of the assignment tracking item. A tracking ID is a system- generated identification number used to uniquely identify a tracking item. | |
| LOGICAL_DELETE_DT | DATE | The date on which the assessment item was deleted from the student's unit attempt. Logical deletion is used here as a method of retaining a history of a student's assessment items. | ||
| S_DEFAULT_IND | VARCHAR2 | (1) | Yes | An indicator which specifies if the assessment item was manually assigned to the student unit attempt or assigned by the system. If set -ticked-, the assessment item was assigned by a system process -ASSJ3212 or ASSJ3213-. |
| UAI_DUE_DT | DATE | The Due Date of the student unit attempt assessment item. This date is sourced from the unit assessment item Due Date. | ||
| UAI_REFERENCE | VARCHAR2 | (4000) | The assessment item reference. For example, assignment number, examination paper number. | |
| ASS_PATTERN_ID | NUMBER | (10) | - OBSOLETE | |
| APPORTIONMENT_PERCENTAGE | VARCHAR2 | (0) | - OBSOLETE | |
| INVALID_ITEM | VARCHAR2 | (7) | Field indicates item is invalid by containing INVALID or null. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column. | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Attribute for Descriptive Flexfield. | |
| 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) | ||
| UOO_ID | NUMBER | (7) | Yes | Unit Section identifier |
| UNIT_SECTION_ASS_ITEM_ID | NUMBER | (15) | Unique identifier of the Assessment Item attached at the unit section level. | |
| UNIT_ASS_ITEM_ID | NUMBER | (15) | Unique identifier of the Assessment Item attached at the unit level. | |
| SUA_ASS_ITEM_GROUP_ID | NUMBER | (15) | Yes | Unique identifier for a group to which the unit assessment item is attached. |
| MIDTERM_MANDATORY_TYPE_CODE | VARCHAR2 | (30) | For Midterm Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default) | |
| MIDTERM_WEIGHT_QTY | NUMBER | (6) | Allows user to define the weight of the assessment item relative to other assessment items for �Midterm� grading period. | |
| FINAL_MANDATORY_TYPE_CODE | VARCHAR2 | (30) | For Final Grading Period, allows user to define whether a certain assessment item is:- Optional- Mandatory - Mandatory pass- Null (Default) | |
| FINAL_WEIGHT_QTY | NUMBER | (6) | Allows user to define the weight of the assessment item relative to other assessment items for �Final� grading period. | |
| SUBMITTED_DATE | DATE | Date on which the student submitted the assessment item for grading | ||
| WAIVED_FLAG | VARCHAR2 | (1) | Allows the user to indicate that the assessment item is being waived for a particular student. | |
| PENALTY_APPLIED_FLAG | VARCHAR2 | (1) | Allows the user to indicate that the captured mark/grade have been subjected to a penalty. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, ASS_ID
, CREATION_DT
, ATTEMPT_NUMBER
, OUTCOME_DT
, OVERRIDE_DUE_DT
, DSP_ASSESSMENT_TYPE
, DSP_DESCRIPTION
, MARK
, GRADE
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, OUTCOME_COMMENT_CODE
, OUTCOME_COMMENT_MEANING
, PERFORMANCE
, TRACKING_ID
, LOGICAL_DELETE_DT
, S_DEFAULT_IND
, UAI_DUE_DT
, UAI_REFERENCE
, ASS_PATTERN_ID
, APPORTIONMENT_PERCENTAGE
, INVALID_ITEM
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, UOO_ID
, UNIT_SECTION_ASS_ITEM_ID
, UNIT_ASS_ITEM_ID
, SUA_ASS_ITEM_GROUP_ID
, MIDTERM_MANDATORY_TYPE_CODE
, MIDTERM_WEIGHT_QTY
, FINAL_MANDATORY_TYPE_CODE
, FINAL_WEIGHT_QTY
, SUBMITTED_DATE
, WAIVED_FLAG
, PENALTY_APPLIED_FLAG
FROM APPS.IGS_AS_SUAAI_V;
APPS
IGS_AS_ASSESSMNT_ITM_ALL
IGS_AS_GEN_001
- show dependent code
IGS_AS_GEN_003
- show dependent code
IGS_AS_SU_ATMPT_ITM
IGS_AS_UNITASS_ITEM_ALL
IGS_GE_GEN_004
- show dependent code
IGS_PS_UNITASS_ITEM
APPS
IGS_HE_EXTRACT_FIELDS_PKG
- show dependent code
|
|
|
|