eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CSC_HZ_EDUCATION_V

Object Details

Object Name:	CSC_HZ_EDUCATION_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_HZ_EDUCATION_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EDUCATION_ID	NUMBER	(15)	Yes	Unique identifier of this education record
COURSE_MAJOR	VARCHAR2	(60)		The name of the primary educational focus of the education effort.
PARTY_ID	NUMBER	(15)	Yes	Party identifier. FK to HZ_PARTIES
DEGREE_RECEIVED	VARCHAR2	(60)		The abbreviation for the degree. For example, BA, BSc, MBA, MSc, Phd, Gd (graduate diploma).
LAST_DATE_ATTENDED	DATE			The year and month a person last attended the educational institution.
START_DATE_ATTENDED	DATE			Date that the person's attendance starts.
SCHOOL_ATTENDED_NAME	VARCHAR2	(60)		The name of the school.
TYPE_OF_SCHOOL	VARCHAR2	(30)		The classification of the educational organization. For example, High School, College, University, Professional School. Note that the name is culturally dependent.
TYPE_OF_SCHOOL_DESC	VARCHAR2	(80)		The classification of the educational organization. For example, High School, College, University, Professional School. Note that the name is culturally dependent.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
WH_UPDATE_DATE	DATE			Warehouse update date when record was recorded or changed
STATUS	VARCHAR2	(0)		Record status flag
OBJECT_VERSION_NUMBER	NUMBER			Object Vesion Number for locking purpose

Query Text

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


SELECT EDUCATION_ID
,      COURSE_MAJOR
,      PARTY_ID
,      DEGREE_RECEIVED
,      LAST_DATE_ATTENDED
,      START_DATE_ATTENDED
,      SCHOOL_ATTENDED_NAME
,      TYPE_OF_SCHOOL
,      TYPE_OF_SCHOOL_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      STATUS
,      OBJECT_VERSION_NUMBER
FROM APPS.CSC_HZ_EDUCATION_V;

Dependencies

[top of page]

APPS.CSC_HZ_EDUCATION_V references the following:

APPS: AR_LOOKUPS; HZ_EDUCATION

APPS.CSC_HZ_EDUCATION_V is not referenced by any database object