[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_USECAI_SUA_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AS_USECAI_SUA_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. | |
| PERSON_ID | NUMBER | (15) | Yes | Student for whom the assessment item and its outcome is getting recorded |
| COURSE_CD | VARCHAR2 | (6) | Yes | The program for the student. |
| UNIT_CD | VARCHAR2 | (10) | Yes | The unit for the student to which the assessment item is linked. |
| VERSION_NUMBER | NUMBER | (3) | Yes | Version number is used to uniquely identify each version of a unit. |
| CAL_TYPE | VARCHAR2 | (10) | Yes | Students enrolled teaching calendar type |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Students teaching calendar sequence number. It helps in identifying the instance for the calendar |
| UOO_ID | NUMBER | (7) | Yes | The unique identifier for a unit offering option. |
| 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. |
| SEQUENCE_NUMBER | NUMBER | (6) | Yes | Secquence number |
| USAI_LOCATION_CD | VARCHAR2 | (0) | This field is the location name or code. The location represents a geographical location and is used to indicate where units are offered.--OBSOLETE | |
| USAI_UNIT_CLASS | VARCHAR2 | (0) | This field describes the code that uniquely identifies the unit class--OBSOLETE | |
| USAI_UNIT_MODE | VARCHAR2 | (0) | Unit mode.--OBSOLETE | |
| USAI_REFERENCE | VARCHAR2 | (30) | References of the assessment item | |
| USAI_DUE_DT | DATE | Due Date. | ||
| USAI_DFLT_ITEM_IND | VARCHAR2 | (1) | Yes | Indicates the defaulted assessment item. |
| USAI_LOGICAL_DELETE_DT | DATE | Logical deletion date for the assessment item for a unit offering. | ||
| USAI_ACTION_DT | DATE | Action Date | ||
| SUA_LOCATION_CD | VARCHAR2 | (0) | This field is the location name or code. The location represents a geographical location and is used to indicate where units are offered.--OBSOLETE | |
| SUA_UNIT_CLASS | VARCHAR2 | (0) | This field describes the code that uniquely identifies the unit class--OBSOLETE | |
| SUA_UNIT_MODE | VARCHAR2 | (0) | Unit Mode.--OBSOLETE | |
| 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 | |
| DESCRIPTION | VARCHAR2 | (180) | The item description defined at the unit level. | |
| GRADING_SCHEMA_CD | VARCHAR2 | (10) | Yes | Grading Schema Code |
| GS_VERSION_NUMBER | NUMBER | (3) | Yes | Grading Schema Version Number |
| UNIT_SECTION_ASS_ITEM_ID | NUMBER | Yes | Unique Identifier of the Assessment items attached at the unit section level | |
| US_ASS_ITEM_GROUP_ID | NUMBER | (15) | 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
, PERSON_ID
, COURSE_CD
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, UOO_ID
, ASS_ID
, SEQUENCE_NUMBER
, USAI_LOCATION_CD
, USAI_UNIT_CLASS
, USAI_UNIT_MODE
, USAI_REFERENCE
, USAI_DUE_DT
, USAI_DFLT_ITEM_IND
, USAI_LOGICAL_DELETE_DT
, USAI_ACTION_DT
, SUA_LOCATION_CD
, SUA_UNIT_CLASS
, SUA_UNIT_MODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DESCRIPTION
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, UNIT_SECTION_ASS_ITEM_ID
, US_ASS_ITEM_GROUP_ID
, MIDTERM_MANDATORY_TYPE_CODE
, MIDTERM_WEIGHT_QTY
, FINAL_MANDATORY_TYPE_CODE
, FINAL_WEIGHT_QTY
FROM APPS.IGS_AS_USECAI_SUA_V;
APPS
IGS_AS_ASSESSMNT_ITM_ALL
IGS_AS_UNIT_CLASS
IGS_AS_VAL_UAI
- show dependent code
IGS_EN_SU_ATTEMPT
IGS_PS_UNITASS_ITEM
IGS_PS_UNIT_OFR_OPT
APPS
IGS_EN_GEN_010
- show dependent code
|
|
|
|