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

VIEW: APPS.HRU_JP_CREATE_EDUC_ADD

Object Details
Object Name: HRU_JP_CREATE_EDUC_ADD
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HRU_JP_CREATE_EDUC_ADD
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
HIRE_DATE VARCHAR2 (0)
DATE_RECEIVED VARCHAR2 (0)
BUSINESS_GROUP_ID VARCHAR2 (0)
LAST_NAME VARCHAR2 (0)
LAST_NAME_KANA VARCHAR2 (0)
SEX VARCHAR2 (0)
PERSON_TYPE_ID VARCHAR2 (0)
PER_COMMENTS VARCHAR2 (0)
DATE_EMPLOYEE_DATA_VERIFIED VARCHAR2 (0)
DATE_OF_BIRTH VARCHAR2 (0)
EMAIL_ADDRESS VARCHAR2 (0)
APPLICANT_NUMBER VARCHAR2 (0)
EXPENSE_CHECK_SEND_TO_ADDRES VARCHAR2 (0)
FIRST_NAME VARCHAR2 (0)
FIRST_NAME_KANA VARCHAR2 (0)
KNOWN_AS VARCHAR2 (0)
MARITAL_STATUS VARCHAR2 (0)
MIDDLE_NAMES VARCHAR2 (0)
NATIONALITY VARCHAR2 (0)
NATIONAL_IDENTIFIER VARCHAR2 (0)
PREVIOUS_LAST_NAME VARCHAR2 (0)
PREVIOUS_LAST_NAME_KANA VARCHAR2 (0)
REGISTERED_DISABLED_FLAG VARCHAR2 (0)
TITLE VARCHAR2 (0)
VENDOR_ID VARCHAR2 (0)
WORK_TELEPHONE VARCHAR2 (0)
PER_ATTRIBUTE_CATEGORY VARCHAR2 (0)
PER_ATTRIBUTE1 VARCHAR2 (0)
PER_ATTRIBUTE2 VARCHAR2 (0)
PER_ATTRIBUTE3 VARCHAR2 (0)
PER_ATTRIBUTE4 VARCHAR2 (0)
PER_ATTRIBUTE5 VARCHAR2 (0)
PER_ATTRIBUTE6 VARCHAR2 (0)
PER_ATTRIBUTE7 VARCHAR2 (0)
PER_ATTRIBUTE8 VARCHAR2 (0)
PER_ATTRIBUTE9 VARCHAR2 (0)
PER_ATTRIBUTE10 VARCHAR2 (0)
PER_ATTRIBUTE11 VARCHAR2 (0)
PER_ATTRIBUTE12 VARCHAR2 (0)
PER_ATTRIBUTE13 VARCHAR2 (0)
PER_ATTRIBUTE14 VARCHAR2 (0)
PER_ATTRIBUTE15 VARCHAR2 (0)
PER_ATTRIBUTE16 VARCHAR2 (0)
PER_ATTRIBUTE17 VARCHAR2 (0)
PER_ATTRIBUTE18 VARCHAR2 (0)
PER_ATTRIBUTE19 VARCHAR2 (0)
PER_ATTRIBUTE20 VARCHAR2 (0)
PER_ATTRIBUTE21 VARCHAR2 (0)
PER_ATTRIBUTE22 VARCHAR2 (0)
PER_ATTRIBUTE23 VARCHAR2 (0)
PER_ATTRIBUTE24 VARCHAR2 (0)
PER_ATTRIBUTE25 VARCHAR2 (0)
PER_ATTRIBUTE26 VARCHAR2 (0)
PER_ATTRIBUTE27 VARCHAR2 (0)
PER_ATTRIBUTE28 VARCHAR2 (0)
PER_ATTRIBUTE29 VARCHAR2 (0)
PER_ATTRIBUTE30 VARCHAR2 (0)
PERSON_ID VARCHAR2 (0)
ASSIGNMENT_ID VARCHAR2 (0)
APPLICATION_ID VARCHAR2 (0)
PER_OBJECT_VERSION_NUMBER VARCHAR2 (0)
ASG_OBJECT_VERSION_NUMBER VARCHAR2 (0)
APL_OBJECT_VERSION_NUMBER VARCHAR2 (0)
PER_EFFECTIVE_START_DATE VARCHAR2 (0)
PER_EFFECTIVE_END_DATE VARCHAR2 (0)
FULL_NAME VARCHAR2 (0)
PER_COMMENT_ID VARCHAR2 (0)
ASSIGNMENT_SEQUENCE VARCHAR2 (0)
ASSIGNMENT_NUMBER VARCHAR2 (0)
NAME_COMBINATION_WARNING VARCHAR2 (0)
ASSIGN_PAYROLL_WARNING VARCHAR2 (0)
PEA_COMMENTS VARCHAR2 (0)
PEA_DATE_FROM VARCHAR2 (0)
PEA_DATE_TO VARCHAR2 (0)
REQUEST_ID VARCHAR2 (0)
PROGRAM_APPLICATION_ID VARCHAR2 (0)
PROGRAM_ID VARCHAR2 (0)
PROGRAM_UPDATE_DATE VARCHAR2 (0)
PEA_ATTRIBUTE_CATEGORY VARCHAR2 (0)
PEA_ATTRIBUTE1 VARCHAR2 (0)
PEA_ATTRIBUTE2 VARCHAR2 (0)
PEA_ATTRIBUTE3 VARCHAR2 (0)
PEA_ATTRIBUTE4 VARCHAR2 (0)
PEA_ATTRIBUTE5 VARCHAR2 (0)
PEA_ATTRIBUTE6 VARCHAR2 (0)
PEA_ATTRIBUTE7 VARCHAR2 (0)
PEA_ATTRIBUTE8 VARCHAR2 (0)
PEA_ATTRIBUTE9 VARCHAR2 (0)
PEA_ATTRIBUTE10 VARCHAR2 (0)
PEA_ATTRIBUTE11 VARCHAR2 (0)
PEA_ATTRIBUTE12 VARCHAR2 (0)
PEA_ATTRIBUTE13 VARCHAR2 (0)
PEA_ATTRIBUTE14 VARCHAR2 (0)
PEA_ATTRIBUTE15 VARCHAR2 (0)
PEA_ATTRIBUTE16 VARCHAR2 (0)
PEA_ATTRIBUTE17 VARCHAR2 (0)
PEA_ATTRIBUTE18 VARCHAR2 (0)
PEA_ATTRIBUTE19 VARCHAR2 (0)
PEA_ATTRIBUTE20 VARCHAR2 (0)
SCHOOL_TYPE VARCHAR2 (0)
SCHOOL_ID VARCHAR2 (0)
SCHOOL_NAME VARCHAR2 (0)
SCHOOL_NAME_KANA VARCHAR2 (0)
MAJOR VARCHAR2 (0)
MAJOR_KANA VARCHAR2 (0)
GRADUATION_DATE VARCHAR2 (0)
ADVISOR VARCHAR2 (0)
NOTE VARCHAR2 (0)
LAST_FLAG VARCHAR2 (0)
SCHOOL_FLAG VARCHAR2 (0)
PEA_OBJECT_VERSION_NUMBER VARCHAR2 (0)
ANALYSIS_CRITERIA_ID VARCHAR2 (0)
PERSON_ANALYSIS_ID VARCHAR2 (0)
PRIMARY_FLAG VARCHAR2 (0)
ADD_DATE_FROM VARCHAR2 (0)
ADD_DATE_TO VARCHAR2 (0)
ADDRESS_TYPE VARCHAR2 (0)
ADD_COMMENTS VARCHAR2 (0)
ADDRESS_LINE1 VARCHAR2 (0)
ADDRESS_LINE2 VARCHAR2 (0)
ADDRESS_LINE3 VARCHAR2 (0)
DISTRICT_CODE VARCHAR2 (0)
STYLE VARCHAR2 (0)
ADDRESS_LINE2_KANA VARCHAR2 (0)
ADDRESS_LINE3_KANA VARCHAR2 (0)
COUNTY VARCHAR2 (0)
POSTCODE VARCHAR2 (0)
COUNTRY VARCHAR2 (0)
TELEPHONE_NUMBER_1 VARCHAR2 (0)
TELEPHONE_NUMBER_2 VARCHAR2 (0)
FAX_NUMBER VARCHAR2 (0)
ADDR_ATTRIBUTE_CATEGORY VARCHAR2 (0)
ADDR_ATTRIBUTE1 VARCHAR2 (0)
ADDR_ATTRIBUTE2 VARCHAR2 (0)
ADDR_ATTRIBUTE3 VARCHAR2 (0)
ADDR_ATTRIBUTE4 VARCHAR2 (0)
ADDR_ATTRIBUTE5 VARCHAR2 (0)
ADDR_ATTRIBUTE6 VARCHAR2 (0)
ADDR_ATTRIBUTE7 VARCHAR2 (0)
ADDR_ATTRIBUTE8 VARCHAR2 (0)
ADDR_ATTRIBUTE9 VARCHAR2 (0)
ADDR_ATTRIBUTE10 VARCHAR2 (0)
ADDR_ATTRIBUTE11 VARCHAR2 (0)
ADDR_ATTRIBUTE12 VARCHAR2 (0)
ADDR_ATTRIBUTE13 VARCHAR2 (0)
ADDR_ATTRIBUTE14 VARCHAR2 (0)
ADDR_ATTRIBUTE15 VARCHAR2 (0)
ADDR_ATTRIBUTE16 VARCHAR2 (0)
ADDR_ATTRIBUTE17 VARCHAR2 (0)
ADDR_ATTRIBUTE18 VARCHAR2 (0)
ADDR_ATTRIBUTE19 VARCHAR2 (0)
ADDR_ATTRIBUTE20 VARCHAR2 (0)
ADDRESS_ID VARCHAR2 (0)
ADD_OBJECT_VERSION_NUMBER VARCHAR2 (0)
ADDRESS_LINE1_KANA VARCHAR2 (0)
EMPLOYEE_NUMBER VARCHAR2 (0)
ORIG_HIRE_WARNING VARCHAR2 (0)
DATE_OF_DEATH VARCHAR2 (0)
BLOOD_TYPE VARCHAR2 (0)
CORRESPONDENCE_LANGUAGE VARCHAR2 (0)
FTE_CAPACITY VARCHAR2 (0)
HOLD_APPLICANT_DATE_UNTIL VARCHAR2 (0)
HONORS VARCHAR2 (0)
INTERNAL_LOCATION VARCHAR2 (0)
LAST_MEDICAL_TEST_BY VARCHAR2 (0)
LAST_MEDICAL_TEST_DATE VARCHAR2 (0)
MAILSTOP VARCHAR2 (0)
OFFICE_NUMBER VARCHAR2 (0)
ON_MILITARY_SERVICE VARCHAR2 (0)
RESUME_EXISTS VARCHAR2 (0)
RESUME_LAST_UPDATED VARCHAR2 (0)
SECOND_PASSPORT_EXISTS VARCHAR2 (0)
STUDENT_STATUS VARCHAR2 (0)
WORK_SCHEDULE VARCHAR2 (0)
ORIGINAL_DATE_OF_HIRE VARCHAR2 (0)
Query Text

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


SELECT HIRE_DATE
,      DATE_RECEIVED
,      BUSINESS_GROUP_ID
,      LAST_NAME
,      LAST_NAME_KANA
,      SEX
,      PERSON_TYPE_ID
,      PER_COMMENTS
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_BIRTH
,      EMAIL_ADDRESS
,      APPLICANT_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRES
,      FIRST_NAME
,      FIRST_NAME_KANA
,      KNOWN_AS
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      PREVIOUS_LAST_NAME
,      PREVIOUS_LAST_NAME_KANA
,      REGISTERED_DISABLED_FLAG
,      TITLE
,      VENDOR_ID
,      WORK_TELEPHONE
,      PER_ATTRIBUTE_CATEGORY
,      PER_ATTRIBUTE1
,      PER_ATTRIBUTE2
,      PER_ATTRIBUTE3
,      PER_ATTRIBUTE4
,      PER_ATTRIBUTE5
,      PER_ATTRIBUTE6
,      PER_ATTRIBUTE7
,      PER_ATTRIBUTE8
,      PER_ATTRIBUTE9
,      PER_ATTRIBUTE10
,      PER_ATTRIBUTE11
,      PER_ATTRIBUTE12
,      PER_ATTRIBUTE13
,      PER_ATTRIBUTE14
,      PER_ATTRIBUTE15
,      PER_ATTRIBUTE16
,      PER_ATTRIBUTE17
,      PER_ATTRIBUTE18
,      PER_ATTRIBUTE19
,      PER_ATTRIBUTE20
,      PER_ATTRIBUTE21
,      PER_ATTRIBUTE22
,      PER_ATTRIBUTE23
,      PER_ATTRIBUTE24
,      PER_ATTRIBUTE25
,      PER_ATTRIBUTE26
,      PER_ATTRIBUTE27
,      PER_ATTRIBUTE28
,      PER_ATTRIBUTE29
,      PER_ATTRIBUTE30
,      PERSON_ID
,      ASSIGNMENT_ID
,      APPLICATION_ID
,      PER_OBJECT_VERSION_NUMBER
,      ASG_OBJECT_VERSION_NUMBER
,      APL_OBJECT_VERSION_NUMBER
,      PER_EFFECTIVE_START_DATE
,      PER_EFFECTIVE_END_DATE
,      FULL_NAME
,      PER_COMMENT_ID
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_NUMBER
,      NAME_COMBINATION_WARNING
,      ASSIGN_PAYROLL_WARNING
,      PEA_COMMENTS
,      PEA_DATE_FROM
,      PEA_DATE_TO
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PEA_ATTRIBUTE_CATEGORY
,      PEA_ATTRIBUTE1
,      PEA_ATTRIBUTE2
,      PEA_ATTRIBUTE3
,      PEA_ATTRIBUTE4
,      PEA_ATTRIBUTE5
,      PEA_ATTRIBUTE6
,      PEA_ATTRIBUTE7
,      PEA_ATTRIBUTE8
,      PEA_ATTRIBUTE9
,      PEA_ATTRIBUTE10
,      PEA_ATTRIBUTE11
,      PEA_ATTRIBUTE12
,      PEA_ATTRIBUTE13
,      PEA_ATTRIBUTE14
,      PEA_ATTRIBUTE15
,      PEA_ATTRIBUTE16
,      PEA_ATTRIBUTE17
,      PEA_ATTRIBUTE18
,      PEA_ATTRIBUTE19
,      PEA_ATTRIBUTE20
,      SCHOOL_TYPE
,      SCHOOL_ID
,      SCHOOL_NAME
,      SCHOOL_NAME_KANA
,      MAJOR
,      MAJOR_KANA
,      GRADUATION_DATE
,      ADVISOR
,      NOTE
,      LAST_FLAG
,      SCHOOL_FLAG
,      PEA_OBJECT_VERSION_NUMBER
,      ANALYSIS_CRITERIA_ID
,      PERSON_ANALYSIS_ID
,      PRIMARY_FLAG
,      ADD_DATE_FROM
,      ADD_DATE_TO
,      ADDRESS_TYPE
,      ADD_COMMENTS
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      DISTRICT_CODE
,      STYLE
,      ADDRESS_LINE2_KANA
,      ADDRESS_LINE3_KANA
,      COUNTY
,      POSTCODE
,      COUNTRY
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      FAX_NUMBER
,      ADDR_ATTRIBUTE_CATEGORY
,      ADDR_ATTRIBUTE1
,      ADDR_ATTRIBUTE2
,      ADDR_ATTRIBUTE3
,      ADDR_ATTRIBUTE4
,      ADDR_ATTRIBUTE5
,      ADDR_ATTRIBUTE6
,      ADDR_ATTRIBUTE7
,      ADDR_ATTRIBUTE8
,      ADDR_ATTRIBUTE9
,      ADDR_ATTRIBUTE10
,      ADDR_ATTRIBUTE11
,      ADDR_ATTRIBUTE12
,      ADDR_ATTRIBUTE13
,      ADDR_ATTRIBUTE14
,      ADDR_ATTRIBUTE15
,      ADDR_ATTRIBUTE16
,      ADDR_ATTRIBUTE17
,      ADDR_ATTRIBUTE18
,      ADDR_ATTRIBUTE19
,      ADDR_ATTRIBUTE20
,      ADDRESS_ID
,      ADD_OBJECT_VERSION_NUMBER
,      ADDRESS_LINE1_KANA
,      EMPLOYEE_NUMBER
,      ORIG_HIRE_WARNING
,      DATE_OF_DEATH
,      BLOOD_TYPE
,      CORRESPONDENCE_LANGUAGE
,      FTE_CAPACITY
,      HOLD_APPLICANT_DATE_UNTIL
,      HONORS
,      INTERNAL_LOCATION
,      LAST_MEDICAL_TEST_BY
,      LAST_MEDICAL_TEST_DATE
,      MAILSTOP
,      OFFICE_NUMBER
,      ON_MILITARY_SERVICE
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      SECOND_PASSPORT_EXISTS
,      STUDENT_STATUS
,      WORK_SCHEDULE
,      ORIGINAL_DATE_OF_HIRE
FROM APPS.HRU_JP_CREATE_EDUC_ADD;

Dependencies

[top of page]

APPS.HRU_JP_CREATE_EDUC_ADD references the following:

SchemaPUBLIC
SynonymDUAL
APPS.HRU_JP_CREATE_EDUC_ADD is referenced by following:

SchemaPUBLIC
SynonymHRU_JP_CREATE_EDUC_ADD