[Home] [Help] [Dependency Information]
Object Name: | IGS_DA_XML_ACADEMICPROGRAM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_DA_XML_ACADEMICPROGRAM_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
XML element AcademicProgramSub view indexed by Degree Program view Provides the provides the DA specified program information
"SPA" -- Students Selected Degree Program
"WIF" -- What-if Program
"SPECIAL" -- Special Program
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROGRAM_TYPE | VARCHAR2 | (10) | Contains the type of the program being described. | |
PROGRAM_CODE | VARCHAR2 | (30) | Contains the program. | |
PROGRAM_NAME | VARCHAR2 | (240) | Contains the name of the program. | |
PROGRAM_DECLARED_DEGREE_DATE | CHAR | (0) | Contains the declared date of program completion. | |
PROGRAM_CATALOG_YEAR | VARCHAR2 | (30) | Contains the catalog year of the program. | |
CLASS_STANDING | VARCHAR2 | (4000) | Contains the standing within the program. | |
PROGRAM_COMPLETE_OVERRIDE | CHAR | (0) | Contains an indicator that the program is not considered to be complete even if the requirements have been met. | |
BATCH_ID | NUMBER | (15) | Contains the OSS generated Batch ID for tracking purposes. | |
PERSON_ID | NUMBER | (15) | Describes the details of the person ID code that is being passed. | |
IGS_DA_REQ_STDNTS_ID | NUMBER | (15) | Student ID | |
LOAD_CAL_TYPE | VARCHAR2 | (10) | Load calendar type | |
LOAD_CI_SEQUENCE_NUMBER | NUMBER | Load calendar sequence number | ||
SOURCE | VARCHAR2 | (7) | Major1,2,3 - minor 1,2,3 - track 1,2,3 |
Cut, paste (and edit) the following text to query this object:
SELECT PROGRAM_TYPE
, PROGRAM_CODE
, PROGRAM_NAME
, PROGRAM_DECLARED_DEGREE_DATE
, PROGRAM_CATALOG_YEAR
, CLASS_STANDING
, PROGRAM_COMPLETE_OVERRIDE
, BATCH_ID
, PERSON_ID
, IGS_DA_REQ_STDNTS_ID
, LOAD_CAL_TYPE
, LOAD_CI_SEQUENCE_NUMBER
, SOURCE
FROM APPS.IGS_DA_XML_ACADEMICPROGRAM_V;
|
|
|