[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SUA_AI_GROUP |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_SUA_AI_GROUP |
Subobject Name: | |
Status: | VALID |
Student Unit Attempt Assessment Item Group
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_SUA_AI_GROUP_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | SUA_ASS_ITEM_GROUP_ID |
IGS_AS_SUA_AI_GROUP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
COURSE_CD UOO_ID GROUP_NAME |
IGS_AS_SUA_AI_GROUP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UNIT_ASS_ITEM_GROUP_ID |
IGS_AS_SUA_AI_GROUP_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | US_ASS_ITEM_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUA_ASS_ITEM_GROUP_ID | NUMBER | (15) | Yes | System generated number is used to uniquely identify group of assessment items attached to a student unit attempt. Student unit attempt assessment item group is a group of assessment items that would have certain amount of weight in the unit grade. Formula can be applied to all the assessment items in a group such as Best 3, Atleast 2. |
PERSON_ID | NUMBER | (15) | Yes | Describes the person ID of the student to whom the assessment item group is linked. |
COURSE_CD | VARCHAR2 | (6) | Yes | Describes the students course code |
UOO_ID | NUMBER | (7) | Yes | Unique identifier for a unit section. |
GROUP_NAME | VARCHAR2 | (30) | Yes | Describes the name of a group of assessment items attached to a student unit attempt. For example, Quizzes, Homework. |
MIDTERM_FORMULA_CODE | VARCHAR2 | (30) | For Midterm Grading Period, allows user to define the derivation formula based on which the student unit attempt outcome marks will be calculated:- Weighted Average- Best N- At least N- Null | |
MIDTERM_FORMULA_QTY | NUMBER | (3) | In case the Formula is 'Best N' or 'At least N', the user is required to define the corresponding number of assessment item to be used to derive student unit attempt outcome marks. | |
MIDTERM_WEIGHT_QTY | NUMBER | (6) | Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Midterm' grading period. | |
FINAL_FORMULA_CODE | VARCHAR2 | (30) | For Final Grading Period, allows user to define the derivation formula based on which the student unit attempt outcome marks will be calculated:- Weighted Average- Best N- At least N- Null | |
FINAL_FORMULA_QTY | NUMBER | (3) | In case the Formula is 'Best N' or 'At least N', the user is required to define the corresponding number of assessment item that will be used to derive student unit attempt outcome marks. | |
FINAL_WEIGHT_QTY | NUMBER | (6) | Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Final' grading period. | |
UNIT_ASS_ITEM_GROUP_ID | NUMBER | (15) | Reference to the original source from where the student unit attempt assessment items were inherited - Unit Level | |
US_ASS_ITEM_GROUP_ID | NUMBER | (15) | Reference to the original source from where the student unit attempt assessment items were inherited - Unit Section Level | |
LOGICAL_DELETE_DATE | DATE | Logical Delete Date for the Group | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SUA_ASS_ITEM_GROUP_ID
, PERSON_ID
, COURSE_CD
, UOO_ID
, GROUP_NAME
, MIDTERM_FORMULA_CODE
, MIDTERM_FORMULA_QTY
, MIDTERM_WEIGHT_QTY
, FINAL_FORMULA_CODE
, FINAL_FORMULA_QTY
, FINAL_WEIGHT_QTY
, UNIT_ASS_ITEM_GROUP_ID
, US_ASS_ITEM_GROUP_ID
, LOGICAL_DELETE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_AS_SUA_AI_GROUP;
IGS.IGS_AS_SUA_AI_GROUP does not reference any database object
IGS.IGS_AS_SUA_AI_GROUP is referenced by following:
|
|
|