DBA Data[Home] [Help] [Dependency Information]

TABLE: IGS.IGS_AS_UNIT_AI_GRP

Object Details
Object Name: IGS_AS_UNIT_AI_GRP
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_AS_UNIT_AI_GRP
Subobject Name:
Status: VALID


Unit Assessment Item Group


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AS_UNIT_AI_GRP_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_ASS_ITEM_GROUP_ID
IGS_AS_UNIT_AI_GRP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_CD
ColumnVERSION_NUMBER
ColumnCAL_TYPE
ColumnCI_SEQUENCE_NUMBER
ColumnGROUP_NAME
Columns
Name Datatype Length Mandatory Comments
UNIT_ASS_ITEM_GROUP_ID NUMBER (15) Yes System generated number is used to uniquely identify group of unit assessment items. Unit 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.
UNIT_CD VARCHAR2 (10) Yes Unit code to which assessment item groups are linked. Unit code is an institution-defined unique identifier of a unit of study.
VERSION_NUMBER NUMBER (3) Yes Version of the unit the unit assessment item group is linked to. Students are normally enrolled in the current version. Prior versions of the unit are end-dated.
CAL_TYPE VARCHAR2 (10) Yes Calendar type of the unit offerings to which the unit assessment item group is linked. A calendar type is an institution-defined code for a calendar, such as ACAD-YR for a standard academic year.
CI_SEQUENCE_NUMBER NUMBER (3) Yes Calendar instance sequence number for the unit assessment item group. Sequence number is the unique identifier for the calendar instance.
GROUP_NAME VARCHAR2 (30) Yes Describes the name of a group of Unit Assessment Items. 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 (7)
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 (7)
Allows user to define the weight of the assessment item group relative to other assessment item groups for 'Final' grading period.
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UNIT_ASS_ITEM_GROUP_ID
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      GROUP_NAME
,      MIDTERM_FORMULA_CODE
,      MIDTERM_FORMULA_QTY
,      MIDTERM_WEIGHT_QTY
,      FINAL_FORMULA_CODE
,      FINAL_FORMULA_QTY
,      FINAL_WEIGHT_QTY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AS_UNIT_AI_GRP;

Dependencies

[top of page]

IGS.IGS_AS_UNIT_AI_GRP does not reference any database object

IGS.IGS_AS_UNIT_AI_GRP is referenced by following:

SchemaAPPS
SynonymIGS_AS_UNIT_AI_GRP