Product: | PER - Human Resources |
---|---|
Description: | This view is Japanaes specific. |
Implementation/DBA Data: |
![]() |
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