DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.US_GOV_EDUCATION

Object Details
Object Name: US_GOV_EDUCATION
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ANALYSIS_CRITERIA_ID NUMBER (15) Yes
EDUCATIONAL_LEVEL VARCHAR2 (150)
INSTRUCTIONAL_PROGRAM VARCHAR2 (150)
YEAR_DEGREE___CERT_ATTAINED NUMBER

CREDIT_HOURS VARCHAR2 (150)
CREDIT_TYPE VARCHAR2 (150)
TYPE_OF_SCHOOL VARCHAR2 (150)
COLLEGE_MAJOR_MINOR VARCHAR2 (150)
ACADEMIC_INSTITUTION_NAME VARCHAR2 (150)
COOP_GRADUATION_DATE DATE

PROGRAM_ID NUMBER (15)
ENABLED_FLAG VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE

CREATION_DATE DATE

PROGRAM_APPLICATION_ID NUMBER (15)
END_DATE_ACTIVE DATE

CREATED_BY NUMBER (15)
REQUEST_ID NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
START_DATE_ACTIVE DATE

LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
PROGRAM_UPDATE_DATE DATE

SUMMARY_FLAG VARCHAR2 (1) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ANALYSIS_CRITERIA_ID
,      EDUCATIONAL_LEVEL
,      INSTRUCTIONAL_PROGRAM
,      YEAR_DEGREE___CERT_ATTAINED
,      CREDIT_HOURS
,      CREDIT_TYPE
,      TYPE_OF_SCHOOL
,      COLLEGE_MAJOR_MINOR
,      ACADEMIC_INSTITUTION_NAME
,      COOP_GRADUATION_DATE
,      PROGRAM_ID
,      ENABLED_FLAG
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      PROGRAM_APPLICATION_ID
,      END_DATE_ACTIVE
,      CREATED_BY
,      REQUEST_ID
,      LAST_UPDATED_BY
,      START_DATE_ACTIVE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      PROGRAM_UPDATE_DATE
,      SUMMARY_FLAG
FROM APPS.US_GOV_EDUCATION;

Dependencies

[top of page]

APPS.US_GOV_EDUCATION references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPER_ANALYSIS_CRITERIA

APPS.US_GOV_EDUCATION is not referenced by any database object