[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_PROGUGAI_ADI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_PROGUGAI_ADI_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Assessment Progression/UnitGrade/AssessmentItem WebADI View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_NUMBER | VARCHAR2 | (30) | Person Number | |
PERSON_NAME | VARCHAR2 | (363) | Person Name | |
ANONYMOUS_ID | VARCHAR2 | (30) | Anonymous Identifier | |
COURSE_CD | VARCHAR2 | (6) | Course Code | |
COURSE_TYPE | VARCHAR2 | (10) | Course Type | |
RESPONSIBLE_ORG_UNIT_CD | VARCHAR2 | (30) | Organisational Unit Responsibility | |
UNIT_SET_CD | VARCHAR2 | (10) | Unit Set Code | |
PRG_ALTERNATE_CD | VARCHAR2 | (10) | Progression Alternate Code | |
PRG_CAL_TYPE | VARCHAR2 | (10) | Progression Calendar Type | |
PRG_CI_SEQUENCE_NUMBER | NUMBER | Progression Sequence Number | ||
PROGRESSION_OUTCOME_TYPE | VARCHAR2 | (10) | Progression Outcome Type | |
YOP_GRADE | VARCHAR2 | (10) | YOP Grade | |
YOP_MARK | NUMBER | YOP Mark | ||
UNIT_CD | VARCHAR2 | (10) | Unit Code | |
SUA_VERSION_NUMBE | NUMBER | Version Number | ||
TEACH_CAL_TYPE | VARCHAR2 | (10) | Teaching Calendar Type | |
TEACH_CI_SEQUENCE_NUMBER | NUMBER | Teaching Sequence Number | ||
UOO_ID | NUMBER | Unit Offering Option Identifier | ||
LOCATION_CD | VARCHAR2 | (10) | Location Code | |
GRADING_PERIOD_CD | VARCHAR2 | (30) | Grading Period Code | |
GRADING_SCHEMA_CD | VARCHAR2 | (10) | Grading Schema Code | |
GS_VERSION_NUMBER | NUMBER | Grading Schema Version Number | ||
UNIT_GRADE | VARCHAR2 | (5) | Unit Grade | |
UNIT_MARK | NUMBER | Unit Mark | ||
FINALISED_OUTCOME_INDICATOR | VARCHAR2 | (1) | Finalised Outcome Indicator | |
ASSESSMENT_ID | NUMBER | Assessment Identifier | ||
ASSESSMENT_TYPE | VARCHAR2 | (10) | Assessment Type | |
AI_GRADING_SCHEMA_CD | VARCHAR2 | (10) | Assessment Item Grading Schema Code | |
AI_GS_VERSION_NUMBER | NUMBER | Version Number | ||
AI_MARK | NUMBER | Mark | ||
AI_GRADE | VARCHAR2 | (5) | Grade | |
RECORD_TYPE | VARCHAR2 | (4) | Record Type | |
UNIT_CLASS | VARCHAR2 | (10) | Unit Class | |
REFERENCE | VARCHAR2 | (4000) | Reference |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_NUMBER
, PERSON_NAME
, ANONYMOUS_ID
, COURSE_CD
, COURSE_TYPE
, RESPONSIBLE_ORG_UNIT_CD
, UNIT_SET_CD
, PRG_ALTERNATE_CD
, PRG_CAL_TYPE
, PRG_CI_SEQUENCE_NUMBER
, PROGRESSION_OUTCOME_TYPE
, YOP_GRADE
, YOP_MARK
, UNIT_CD
, SUA_VERSION_NUMBE
, TEACH_CAL_TYPE
, TEACH_CI_SEQUENCE_NUMBER
, UOO_ID
, LOCATION_CD
, GRADING_PERIOD_CD
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, UNIT_GRADE
, UNIT_MARK
, FINALISED_OUTCOME_INDICATOR
, ASSESSMENT_ID
, ASSESSMENT_TYPE
, AI_GRADING_SCHEMA_CD
, AI_GS_VERSION_NUMBER
, AI_MARK
, AI_GRADE
, RECORD_TYPE
, UNIT_CLASS
, REFERENCE
FROM APPS.IGS_AS_PROGUGAI_ADI_V;
APPS.IGS_AS_PROGUGAI_ADI_V is not referenced by any database object
|
|
|