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

VIEW: APPS.IGS_AS_UNITASS_ITEM

Object Details
Object Name: IGS_AS_UNITASS_ITEM
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AS_UNITASS_ITEM
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


IGS_AS_UNITASS_ITEM describes the assessment items that are allocated to a unit version within a nominated teaching calendar instance, such as unit offering pattern. A unit might be assigned many assessment items, and in turn, an assessment item might be assessable within many units.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORG_ID NUMBER (15)
UNIT_CD VARCHAR2 (10) Yes
VERSION_NUMBER NUMBER (3) Yes
CAL_TYPE VARCHAR2 (10) Yes
CI_SEQUENCE_NUMBER NUMBER (6) Yes
ASS_ID NUMBER (10) Yes
SEQUENCE_NUMBER NUMBER (6) Yes
CI_START_DT DATE
Yes
CI_END_DT DATE
Yes
UNIT_CLASS VARCHAR2 (0)
--OBSOLETE
UNIT_MODE VARCHAR2 (0)
--OBSOLETE
LOCATION_CD VARCHAR2 (0)
--OBSOLETE
DUE_DT DATE

REFERENCE VARCHAR2 (30)
DFLT_ITEM_IND VARCHAR2 (1) Yes
LOGICAL_DELETE_DT DATE

ACTION_DT DATE

EXAM_CAL_TYPE VARCHAR2 (10)
EXAM_CI_SEQUENCE_NUMBER NUMBER (6)
GRADING_SCHEMA_CD VARCHAR2 (10) Yes Grading Schema for the assessment type . These can be only of the system type assessment item
GS_VERSION_NUMBER NUMBER (3) Yes The version of grading schema for the assessment item associated with student assessment item.
RELEASE_DATE DATE

Date on which assessment item outcome is released to Student. If the value is null the outcome is not displayed to student on self service screens.
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)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

UNIT_ASS_ITEM_ID NUMBER (15) Yes Unique Identifier of the Assessment items attached at the unit level
DESCRIPTION VARCHAR2 (180)
The item description defined at the unit level.
UNIT_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.
Query Text

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


SELECT ROW_ID
,      ORG_ID
,      UNIT_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      ASS_ID
,      SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      UNIT_CLASS
,      UNIT_MODE
,      LOCATION_CD
,      DUE_DT
,      REFERENCE
,      DFLT_ITEM_IND
,      LOGICAL_DELETE_DT
,      ACTION_DT
,      EXAM_CAL_TYPE
,      EXAM_CI_SEQUENCE_NUMBER
,      GRADING_SCHEMA_CD
,      GS_VERSION_NUMBER
,      RELEASE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      UNIT_ASS_ITEM_ID
,      DESCRIPTION
,      UNIT_ASS_ITEM_GROUP_ID
,      MIDTERM_MANDATORY_TYPE_CODE
,      MIDTERM_WEIGHT_QTY
,      FINAL_MANDATORY_TYPE_CODE
,      FINAL_WEIGHT_QTY
FROM APPS.IGS_AS_UNITASS_ITEM;

Dependencies

[top of page]

APPS.IGS_AS_UNITASS_ITEM references the following:

SchemaAPPS
SynonymIGS_AS_UNITASS_ITEM_ALL
APPS.IGS_AS_UNITASS_ITEM is referenced by following:

SchemaAPPS
Package BodyIGS_AS_ADI_UPLD_AIO_PKG - show dependent code
Package BodyIGS_AS_ANON_GRD_PKG - show dependent code
Package BodyIGS_AS_APPR_GRD_SCH_PKG - show dependent code
Package BodyIGS_AS_COURSE_TYPE_PKG - show dependent code
Package BodyIGS_AS_GEN_003 - show dependent code
PL/SQL PackageIGS_AS_GEN_003 - show dependent code
Package BodyIGS_AS_GEN_005 - show dependent code
Package BodyIGS_AS_GEN_006 - show dependent code
Package BodyIGS_AS_GEN_007 - show dependent code
ViewIGS_AS_UAI_EXAM_CI_INIT_V
ViewIGS_AS_UAI_EXAM_CI_V
ViewIGS_AS_UNIT_ASSESSMENT_ITEM_V
Package BodyIGS_AS_VAL_AI - show dependent code
Package BodyIGS_AS_VAL_EI - show dependent code
Package BodyIGS_AS_VAL_SUAAI - show dependent code
Package BodyIGS_AS_VAL_UAI - show dependent code
Package BodyIGS_AS_VAL_UAPI - show dependent code
Package BodyIGS_PS_GEN_008 - show dependent code