eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSBV_AS_UNT_SECTION_ASS_ITEMS

Product:	IGS - Student System (Obsolete)
Description:	Describes all the assessment items for a unit section
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT UNAS.UNIT_SECTION_ASS_ITEM_ID
, UNAS.DESCRIPTION
, UNAS.REFERENCE
, UNAS.UOO_ID
, UNAS.ASS_ID
, UNAS.SEQUENCE_NUMBER
, UNAS.US_ASS_ITEM_GROUP_ID
, UNAS.CI_START_DT
, UNAS.CI_END_DT
, '_LA:UNAS.MIDTERM_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, UNAS.MIDTERM_WEIGHT_QTY
, '_LA:UNAS.FINAL_MANDATORY_TYPE_CODE:IGS_LOOKUP_VALUES:IGS_AS_AI_MANDATORY_TYPES:MEANING'
, UNAS.FINAL_WEIGHT_QTY
, UNAS.GRADING_SCHEMA_CD
, UNAS.GS_VERSION_NUMBER
, UNAS.DUE_DT
, UNAS.RELEASE_DATE
, UNAS.EXAM_CAL_TYPE
, UNAS.EXAM_CI_SEQUENCE_NUMBER
, UNAS.ACTION_DT
, '_LA:UNAS.DFLT_ITEM_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, UNAS.LOGICAL_DELETE_DT
, UNAS.CREATED_BY
, UNAS.CREATION_DATE
, UNAS.LAST_UPDATED_BY
, UNAS.LAST_UPDATE_DATE
FROM IGS_PS_UNITASS_ITEM UNAS WITH READ ONLY

Columns

Name
UNIT_SECTION_AI_DESCRIPTION
UNIT_SECTION_AI_REFERENCE
UNIT_SECTION_ID
ASSESSMENT_ID
CALENDAR_START_DATE
CALENDAR_END_DATE
UNIT_SECTION_AI_GROUP_ID
MIDTERM_MNDRY_TYP_CD
MIDTERM_WEIGHT_QUANTITY
FINAL_MNDRY_TYP_CODE
FINAL_WEIGHT_QUANTITY
GRADING_SCHEMA_CODE
GRADING_SCHEMA_VERSION_NUMBER
DUE_DATE
RELEASE_DATE
EXAM_CALENDAR_TYPE
EXAM_CALENDAR_SEQUENCE_NUMBER
ACTION_DATE
"_LA:DEFAULT_ITEM_INDICATOR"
LOGICAL_DELETE_DATE
UNIT_SECTION_ASS_ITEM_ID
SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE