[Home] [Help] [Dependency Information]
Object Name: | HZ_EDUCATION |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_EDUCATION |
Subobject Name: | |
Status: | VALID |
The HZ_EDUCATION table stores general information about the educational history of a party of the PERSON type. For example, a person may have attended the University of California from 1995 to 1999 and received an undergraduate degree in Computer Science with a GPA of 4.0. This table stores the information about the university, the period when the person attended, and the course that the student majored in. This table will not store detailed information about the coursework completed or performance in those courses.
.
The primary key for this table is EDUCATION_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_EDUCATION_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EDUCATION_ID |
HZ_EDUCATION_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_ID |
HZ_EDUCATION_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SCHOOL_PARTY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EDUCATION_ID | NUMBER | (15) | Yes | Unique identifier of this education record |
COURSE_MAJOR | VARCHAR2 | (60) | Primary area of study | |
PARTY_ID | NUMBER | (15) | Yes | Unique party indentifier. Foreign key to the HZ_PARTIES table |
DEGREE_RECEIVED | VARCHAR2 | (60) | 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, or professional school. Note that the classification of schools varies among different cultures. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
WH_UPDATE_DATE | DATE | Date when the record was entered or changed in a data warehouse | ||
STATUS | VARCHAR2 | (1) | Record status flag | |
SCHOOL_PARTY_ID | NUMBER | (15) | Party identifier of the school | |
OBJECT_VERSION_NUMBER | NUMBER | Version number for locking purposes | ||
APPLICATION_ID | NUMBER | (15) | Unique identifier for the application that created this record | |
CREATED_BY_MODULE | VARCHAR2 | (150) | dentifier for the source application module that created this record |
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
, 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
, SCHOOL_PARTY_ID
, OBJECT_VERSION_NUMBER
, APPLICATION_ID
, CREATED_BY_MODULE
FROM AR.HZ_EDUCATION;
AR.HZ_EDUCATION does not reference any database object
AR.HZ_EDUCATION is referenced by following:
|
|
|