FND Design Data [Home] [Help]

View: HRU_JP_CREATE_EDUC_ADD

Product: PER - Human Resources
Description: This view is Japanaes specific.
Implementation/DBA Data: ViewAPPS.HRU_JP_CREATE_EDUC_ADD
View Text

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

Columns

Name
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