[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HRU_JP_CREATE_EDUC_ADD |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PER.HRU_JP_CREATE_EDUC_ADD
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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) |
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;
PUBLIC
DUAL
APPS.HRU_JP_CREATE_EDUC_ADD is not referenced by any database object
|
|
|
|