[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_UNITASS_ITEM_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AS_UNITASS_ITEM_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) | Rowid | |
| ORG_ID | NUMBER | (15) | Multi-Org operating units | |
| UNIT_CD | VARCHAR2 | (10) | Yes | Unit Code |
| VERSION_NUMBER | NUMBER | (3) | Yes | Unit Version Number |
| CAL_TYPE | VARCHAR2 | (10) | Yes | Unit Load Calendar Type |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unit Load Calendar Instance |
| ASS_ID | NUMBER | (10) | Yes | The assessment item ID of an assessment item that has been linked to the student and against whom the history is getting tracked. An assessment item ID is a system-generated number that is used to uniquely identify an assessment item. An assessment item must first be assigned to one or more unit offerings before it can be assigned to student unit attempts. |
| DSP_ASSESSMENT_TYPE | VARCHAR2 | (10) | Yes | Description of the assessment type. |
| ASS_ID_DESC | VARCHAR2 | (180) | Description for the Assessment Items given at the Unit level and if it is not defined at the unit level then it will display the generic Assessment Item Description. | |
| SEQUENCE_NUMBER | NUMBER | (6) | Yes | Sequence number |
| CI_START_DT | DATE | Yes | This field describes the date from which an instance of a calendar is effective | |
| CI_END_DT | DATE | Yes | This field is the date from which an instance of a calendar is no longer effective example- teaching period Semester 1, 1999 may end on30/06/1999. | |
| UNIT_CLASS | VARCHAR2 | (0) | This field describes the code that uniquely identifies the unit class--OBSOLETE | |
| DSP_UNIT_MODE | VARCHAR2 | (0) | Description for Unit mode. | |
| UNIT_MODE | VARCHAR2 | (0) | Unit mode.--OBSOLETE | |
| LOCATION_CD | VARCHAR2 | (0) | Location Code--OBSOLETE | |
| DUE_DT | DATE | Due Date | ||
| REFERENCE | VARCHAR2 | (30) | References of the assessment item | |
| DFLT_ITEM_IND | VARCHAR2 | (1) | Yes | Indicates the defaulted assessment item. |
| LOGICAL_DELETE_DT | DATE | Logical deletion date for the assessment item for a unit offering. | ||
| ACTION_DT | DATE | Action Date | ||
| EXAM_CAL_TYPE | VARCHAR2 | (10) | Type of exam calendar | |
| EXAM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Exam load calendar instance. | |
| EXAM_CAL_DESCRIPTION | VARCHAR2 | (30) | Examination Calendar Description | |
| 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. |
| DSP_GRD_SCHEMA_DESC | VARCHAR2 | (60) | Yes | Description of grading schema. |
| 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 | 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 | |
| REQUEST_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent programs | ||
| UNIT_ASS_ITEM_ID | NUMBER | (15) | Yes | Unique Identifier of the Unit items attached 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. |
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
, DSP_ASSESSMENT_TYPE
, ASS_ID_DESC
, SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, UNIT_CLASS
, DSP_UNIT_MODE
, UNIT_MODE
, LOCATION_CD
, DUE_DT
, REFERENCE
, DFLT_ITEM_IND
, LOGICAL_DELETE_DT
, ACTION_DT
, EXAM_CAL_TYPE
, EXAM_CI_SEQUENCE_NUMBER
, EXAM_CAL_DESCRIPTION
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, DSP_GRD_SCHEMA_DESC
, 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
, 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_V;
APPS
IGS_AS_ASSESSMNT_ITM_ALL
IGS_AS_GRD_SCHEMA
IGS_AS_UNITASS_ITEM_ALL
IGS_CA_INST
APPS.IGS_AS_UNITASS_ITEM_V is not referenced by any database object
|
|
|
|