[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_SLIST_ADI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_SLIST_ADI_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
Assessment Student List WebADI View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UNIT_CD | VARCHAR2 | (10) | Yes | Unit Code |
VERSION_NUMBER | NUMBER | (3) | Yes | Version Number |
CALL_NUMBER | NUMBER | Call Number | ||
UNIT_TITLE | VARCHAR2 | (90) | Yes | Title of Unit |
CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar Type |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Calendar Sequence Number |
INSTRUCTOR_ID | NUMBER | Instructor Identifier | ||
UOO_ID | NUMBER | (7) | Yes | Unit Offering Option Identifier |
PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
PERSON_NAME | VARCHAR2 | (363) | Person Name | |
COURSE_CD | VARCHAR2 | (6) | Yes | Course Code |
CLASS_ATTEMPT_STATUS | VARCHAR2 | (4000) | Class Attempt Status | |
PROGRAM_TITLE | VARCHAR2 | (90) | Yes | Program Title |
DATE_OF_LAST_ACTIVITY | DATE | Last Activity Date | ||
ALTERNATE_CODE | VARCHAR2 | (10) | Alternate Code | |
SURNAME | VARCHAR2 | (150) | Person Last Name | |
WAITLISTED_POSITION | NUMBER | Waitlisted Position | ||
NOM_COMPL_YR | VARCHAR2 | (72) | Nominated Completion Year | |
YR_PROG | VARCHAR2 | (4000) | Year of Program | |
UNIT_ATTEMPT_STATUS | VARCHAR2 | (30) | Yes | Unit Attempt Status |
NO_ASSESSMENT_IND | VARCHAR2 | (1) | Yes | Audit Type Unit Attempt Indicator |
LOAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Name of a type calendar used within the institution. For example, ACAD-YR, SEM-1, LOAD-1. |
LOAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Unique identifier of the calendar instance |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_CD
, VERSION_NUMBER
, CALL_NUMBER
, UNIT_TITLE
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, INSTRUCTOR_ID
, UOO_ID
, PERSON_ID
, PERSON_NUMBER
, PERSON_NAME
, COURSE_CD
, CLASS_ATTEMPT_STATUS
, PROGRAM_TITLE
, DATE_OF_LAST_ACTIVITY
, ALTERNATE_CODE
, SURNAME
, WAITLISTED_POSITION
, NOM_COMPL_YR
, YR_PROG
, UNIT_ATTEMPT_STATUS
, NO_ASSESSMENT_IND
, LOAD_CAL_TYPE
, LOAD_CI_SEQUENCE_NUMBER
FROM APPS.IGS_AS_SLIST_ADI_V;
APPS.IGS_AS_SLIST_ADI_V is not referenced by any database object
|
|
|