VIEW: APPS.HRBV_PEOPLE

Source

View Text - Preformatted

SELECT peo.full_name person_name ,peo.effective_start_date effective_start_date ,peo.effective_end_date effective_end_date ,peo.order_name order_name ,peo.employee_number employee_number ,hr_bis.bis_decode_lookup('TITLE',peo.title) title ,peo.middle_names middle_names ,peo.known_as preferred_name ,peo.first_name first_name ,peo.last_name last_name ,peo.pre_name_adjunct prefix ,peo.suffix suffix ,hr_bis.bis_decode_lookup('SEX',peo.sex) gender ,peo.previous_last_name previous_last_name ,hr_bis.bis_decode_lookup('REGISTERED_DISABLED',peo.registered_disabled_flag) registered_disabled ,peo.date_of_birth date_of_birth ,peo.town_of_birth town_of_birth ,DECODE(peo.marital_status, NULL, NULL, hr_bis.bis_decode_lookup('MAR_STATUS',peo.marital_status)) marital_status ,DECODE(peo.nationality, NULL, NULL, hr_bis.bis_decode_lookup('NATIONALITY',peo.nationality)) nationality ,peo.national_identifier national_identifier ,peo.applicant_number applicant_number ,peo.npw_number npw_number ,peo.email_address email_address ,DECODE(peo.expense_check_send_to_address, NULL, NULL, hr_bis.bis_decode_lookup('HOME_OFFICE', peo.expense_check_send_to_address)) mail_destination ,DECODE(peo.second_passport_exists, NULL, NULL, hr_bis.bis_decode_lookup('YES_NO',peo.second_passport_exists)) second_passport ,peo.office_number office_number ,peo.internal_location internal_location ,peo.mailstop mailstop ,hr_bis.bis_decode_lookup('WORK_SCHEDULE', peo.work_schedule) work_schedule ,peo.work_telephone work_telephone ,peo.fte_capacity fte_capacity ,DECODE(peo.resume_exists, NULL, NULL, hr_bis.bis_decode_lookup('YES_NO',peo.resume_exists)) resume_exists ,peo.resume_last_updated resume_last_updated ,hr_bis.bis_decode_lookup('YES_NO',NVL(peo.current_applicant_flag,'N')) current_applicant_flag ,hr_bis.bis_decode_lookup('YES_NO',NVL(peo.current_employee_flag,'N')) current_employee_flag ,hr_bis.bis_decode_lookup('YES_NO',NVL(peo.current_emp_or_apl_flag,'N')) current_emp_or_apl_flag ,hr_bis.bis_decode_lookup('YES_NO',NVL(peo.current_npw_flag,'N')) current_npw_flag ,peo.date_employee_data_verified date_employee_data_verified ,peo.date_of_death date_of_death ,DECODE(peo.fast_path_employee, NULL, NULL, hr_bis.bis_decode_lookup('YES_NO',peo.fast_path_employee)) fast_path_employee ,peo.hold_applicant_date_until hold_application_until ,peo.honors honors ,DECODE(peo.on_military_service, NULL, NULL, hr_bis.bis_decode_lookup('YES_NO',peo.on_military_service)) on_military_service ,peo.projected_start_date projected_start_date ,DECODE(peo.student_status, NULL, NULL, hr_bis.bis_decode_lookup('STUDENT_STATUS',peo.student_status)) student_status ,DECODE(peo.background_check_status, NULL, NULL, hr_bis.bis_decode_lookup('YES_NO',peo.background_check_status)) background_check_status ,peo.background_date_check background_date_check ,peo.rehire_authorizor rehire_authorizor ,peo.rehire_reason rehire_reason ,peo.rehire_recommendation rehire_recommendation ,DECODE(peo.blood_type, NULL, NULL, hr_bis.bis_decode_lookup('BLOOD_TYPE',peo.blood_type)) blood_type ,peo.last_medical_test_by last_medical_test_by ,peo.last_medical_test_date last_medical_test_date ,peo.original_date_of_hire original_date_of_hire ,peo.coord_ben_med_pln_no coord_ben_med_pln_no ,peo.coord_ben_no_cvg_flag coord_ben_no_cvg_flag ,peo.coord_ben_med_pl_name coord_ben_med_pl_name ,peo.coord_ben_med_insr_crr_name coord_ben_med_insr_crr_name ,peo.coord_ben_med_insr_crr_ident coord_ben_med_insr_crr_ident ,peo.coord_ben_med_ext_er coord_ben_med_ext_er ,peo.coord_ben_med_cvg_strt_dt coord_ben_med_cvg_strt_dt ,peo.coord_ben_med_cvg_end_dt coord_ben_med_cvg_end_dt ,peo.dpdnt_adoption_date dpdnt_adoption_date ,peo.dpdnt_vlntry_svce_flag dpdnt_vlntry_svce_flag ,peo.receipt_of_death_cert_date receipt_of_death_cert_date ,DECODE(peo.uses_tobacco_flag, NULL, NULL, hr_bis.bis_decode_lookup('TOBACCO_USER',peo.uses_tobacco_flag)) uses_tobacco_flag ,peo.title title_code ,peo.sex gender_code ,peo.registered_disabled_flag registered_disabled_flag_code ,peo.marital_status marital_status_code ,peo.nationality nationality_code ,peo.expense_check_send_to_address expense_check_send_addr_code ,peo.second_passport_exists second_passport_exists_code ,peo.work_schedule work_schedule_code ,peo.resume_exists resume_exists_code ,peo.current_applicant_flag current_applicant_flag_code ,peo.current_employee_flag current_employee_flag_code ,peo.current_emp_or_apl_flag current_emp_or_apl_flag_code ,peo.current_npw_flag current_npw_flag_code ,peo.fast_path_employee fast_path_employee_code ,peo.on_military_service on_military_service_code ,peo.student_status student_status_code ,peo.background_check_status background_check_status_code ,peo.blood_type blood_type_code ,peo.correspondence_language correspondence_language_code ,peo.coord_ben_med_pln_no coord_ben_med_pln_flag_no ,peo.coord_ben_no_cvg_flag coord_ben_no_cvg_flag_code ,peo.uses_tobacco_flag uses_tobacco_flag_code ,peo.region_of_birth region_of_birth_code ,peo.country_of_birth country_of_birth_code ,peo.per_information_category per_information_category ,peo.per_information1 per_information1 ,peo.per_information2 per_information2 ,peo.per_information3 per_information3 ,peo.per_information4 per_information4 ,peo.per_information5 per_information5 ,peo.per_information6 per_information6 ,peo.per_information7 per_information7 ,peo.per_information8 per_information8 ,peo.per_information9 per_information9 ,peo.per_information10 per_information10 ,peo.per_information11 per_information11 ,peo.per_information12 per_information12 ,peo.per_information13 per_information13 ,peo.per_information14 per_information14 ,peo.per_information15 per_information15 ,peo.per_information16 per_information16 ,peo.per_information17 per_information17 ,peo.per_information18 per_information18 ,peo.per_information19 per_information19 ,peo.per_information20 per_information20 ,peo.per_information21 per_information21 ,peo.per_information22 per_information22 ,peo.per_information23 per_information23 ,peo.per_information24 per_information24 ,peo.per_information25 per_information25 ,peo.per_information26 per_information26 ,peo.per_information27 per_information27 ,peo.per_information28 per_information28 ,peo.per_information29 per_information29 ,peo.per_information30 per_information30 ,'_DF:PER:PER_PEOPLE:peo' ,peo.business_group_id business_group_id ,peo.person_id person_id ,peo.global_person_id global_person_id ,peo.party_id party_id ,peo.person_type_id person_type_id ,peo.comment_id comment_id ,peo.vendor_id vendor_id ,peo.benefit_group_id benefit_group_id ,peo.last_update_date last_update_date ,peo.last_updated_by last_updated_by ,peo.last_update_login last_update_login ,peo.created_by created_by ,peo.creation_date creation_date ,CASE WHEN (peo.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, peo.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM per_people_f peo WITH READ ONLY

View Text - HTML Formatted

SELECT PEO.FULL_NAME PERSON_NAME
, PEO.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEO.ORDER_NAME ORDER_NAME
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('TITLE'
, PEO.TITLE) TITLE
, PEO.MIDDLE_NAMES MIDDLE_NAMES
, PEO.KNOWN_AS PREFERRED_NAME
, PEO.FIRST_NAME FIRST_NAME
, PEO.LAST_NAME LAST_NAME
, PEO.PRE_NAME_ADJUNCT PREFIX
, PEO.SUFFIX SUFFIX
, HR_BIS.BIS_DECODE_LOOKUP('SEX'
, PEO.SEX) GENDER
, PEO.PREVIOUS_LAST_NAME PREVIOUS_LAST_NAME
, HR_BIS.BIS_DECODE_LOOKUP('REGISTERED_DISABLED'
, PEO.REGISTERED_DISABLED_FLAG) REGISTERED_DISABLED
, PEO.DATE_OF_BIRTH DATE_OF_BIRTH
, PEO.TOWN_OF_BIRTH TOWN_OF_BIRTH
, DECODE(PEO.MARITAL_STATUS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('MAR_STATUS'
, PEO.MARITAL_STATUS)) MARITAL_STATUS
, DECODE(PEO.NATIONALITY
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('NATIONALITY'
, PEO.NATIONALITY)) NATIONALITY
, PEO.NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, PEO.APPLICANT_NUMBER APPLICANT_NUMBER
, PEO.NPW_NUMBER NPW_NUMBER
, PEO.EMAIL_ADDRESS EMAIL_ADDRESS
, DECODE(PEO.EXPENSE_CHECK_SEND_TO_ADDRESS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('HOME_OFFICE'
, PEO.EXPENSE_CHECK_SEND_TO_ADDRESS)) MAIL_DESTINATION
, DECODE(PEO.SECOND_PASSPORT_EXISTS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.SECOND_PASSPORT_EXISTS)) SECOND_PASSPORT
, PEO.OFFICE_NUMBER OFFICE_NUMBER
, PEO.INTERNAL_LOCATION INTERNAL_LOCATION
, PEO.MAILSTOP MAILSTOP
, HR_BIS.BIS_DECODE_LOOKUP('WORK_SCHEDULE'
, PEO.WORK_SCHEDULE) WORK_SCHEDULE
, PEO.WORK_TELEPHONE WORK_TELEPHONE
, PEO.FTE_CAPACITY FTE_CAPACITY
, DECODE(PEO.RESUME_EXISTS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.RESUME_EXISTS)) RESUME_EXISTS
, PEO.RESUME_LAST_UPDATED RESUME_LAST_UPDATED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(PEO.CURRENT_APPLICANT_FLAG
, 'N')) CURRENT_APPLICANT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(PEO.CURRENT_EMPLOYEE_FLAG
, 'N')) CURRENT_EMPLOYEE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(PEO.CURRENT_EMP_OR_APL_FLAG
, 'N')) CURRENT_EMP_OR_APL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, NVL(PEO.CURRENT_NPW_FLAG
, 'N')) CURRENT_NPW_FLAG
, PEO.DATE_EMPLOYEE_DATA_VERIFIED DATE_EMPLOYEE_DATA_VERIFIED
, PEO.DATE_OF_DEATH DATE_OF_DEATH
, DECODE(PEO.FAST_PATH_EMPLOYEE
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.FAST_PATH_EMPLOYEE)) FAST_PATH_EMPLOYEE
, PEO.HOLD_APPLICANT_DATE_UNTIL HOLD_APPLICATION_UNTIL
, PEO.HONORS HONORS
, DECODE(PEO.ON_MILITARY_SERVICE
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.ON_MILITARY_SERVICE)) ON_MILITARY_SERVICE
, PEO.PROJECTED_START_DATE PROJECTED_START_DATE
, DECODE(PEO.STUDENT_STATUS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('STUDENT_STATUS'
, PEO.STUDENT_STATUS)) STUDENT_STATUS
, DECODE(PEO.BACKGROUND_CHECK_STATUS
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PEO.BACKGROUND_CHECK_STATUS)) BACKGROUND_CHECK_STATUS
, PEO.BACKGROUND_DATE_CHECK BACKGROUND_DATE_CHECK
, PEO.REHIRE_AUTHORIZOR REHIRE_AUTHORIZOR
, PEO.REHIRE_REASON REHIRE_REASON
, PEO.REHIRE_RECOMMENDATION REHIRE_RECOMMENDATION
, DECODE(PEO.BLOOD_TYPE
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('BLOOD_TYPE'
, PEO.BLOOD_TYPE)) BLOOD_TYPE
, PEO.LAST_MEDICAL_TEST_BY LAST_MEDICAL_TEST_BY
, PEO.LAST_MEDICAL_TEST_DATE LAST_MEDICAL_TEST_DATE
, PEO.ORIGINAL_DATE_OF_HIRE ORIGINAL_DATE_OF_HIRE
, PEO.COORD_BEN_MED_PLN_NO COORD_BEN_MED_PLN_NO
, PEO.COORD_BEN_NO_CVG_FLAG COORD_BEN_NO_CVG_FLAG
, PEO.COORD_BEN_MED_PL_NAME COORD_BEN_MED_PL_NAME
, PEO.COORD_BEN_MED_INSR_CRR_NAME COORD_BEN_MED_INSR_CRR_NAME
, PEO.COORD_BEN_MED_INSR_CRR_IDENT COORD_BEN_MED_INSR_CRR_IDENT
, PEO.COORD_BEN_MED_EXT_ER COORD_BEN_MED_EXT_ER
, PEO.COORD_BEN_MED_CVG_STRT_DT COORD_BEN_MED_CVG_STRT_DT
, PEO.COORD_BEN_MED_CVG_END_DT COORD_BEN_MED_CVG_END_DT
, PEO.DPDNT_ADOPTION_DATE DPDNT_ADOPTION_DATE
, PEO.DPDNT_VLNTRY_SVCE_FLAG DPDNT_VLNTRY_SVCE_FLAG
, PEO.RECEIPT_OF_DEATH_CERT_DATE RECEIPT_OF_DEATH_CERT_DATE
, DECODE(PEO.USES_TOBACCO_FLAG
, NULL
, NULL
, HR_BIS.BIS_DECODE_LOOKUP('TOBACCO_USER'
, PEO.USES_TOBACCO_FLAG)) USES_TOBACCO_FLAG
, PEO.TITLE TITLE_CODE
, PEO.SEX GENDER_CODE
, PEO.REGISTERED_DISABLED_FLAG REGISTERED_DISABLED_FLAG_CODE
, PEO.MARITAL_STATUS MARITAL_STATUS_CODE
, PEO.NATIONALITY NATIONALITY_CODE
, PEO.EXPENSE_CHECK_SEND_TO_ADDRESS EXPENSE_CHECK_SEND_ADDR_CODE
, PEO.SECOND_PASSPORT_EXISTS SECOND_PASSPORT_EXISTS_CODE
, PEO.WORK_SCHEDULE WORK_SCHEDULE_CODE
, PEO.RESUME_EXISTS RESUME_EXISTS_CODE
, PEO.CURRENT_APPLICANT_FLAG CURRENT_APPLICANT_FLAG_CODE
, PEO.CURRENT_EMPLOYEE_FLAG CURRENT_EMPLOYEE_FLAG_CODE
, PEO.CURRENT_EMP_OR_APL_FLAG CURRENT_EMP_OR_APL_FLAG_CODE
, PEO.CURRENT_NPW_FLAG CURRENT_NPW_FLAG_CODE
, PEO.FAST_PATH_EMPLOYEE FAST_PATH_EMPLOYEE_CODE
, PEO.ON_MILITARY_SERVICE ON_MILITARY_SERVICE_CODE
, PEO.STUDENT_STATUS STUDENT_STATUS_CODE
, PEO.BACKGROUND_CHECK_STATUS BACKGROUND_CHECK_STATUS_CODE
, PEO.BLOOD_TYPE BLOOD_TYPE_CODE
, PEO.CORRESPONDENCE_LANGUAGE CORRESPONDENCE_LANGUAGE_CODE
, PEO.COORD_BEN_MED_PLN_NO COORD_BEN_MED_PLN_FLAG_NO
, PEO.COORD_BEN_NO_CVG_FLAG COORD_BEN_NO_CVG_FLAG_CODE
, PEO.USES_TOBACCO_FLAG USES_TOBACCO_FLAG_CODE
, PEO.REGION_OF_BIRTH REGION_OF_BIRTH_CODE
, PEO.COUNTRY_OF_BIRTH COUNTRY_OF_BIRTH_CODE
, PEO.PER_INFORMATION_CATEGORY PER_INFORMATION_CATEGORY
, PEO.PER_INFORMATION1 PER_INFORMATION1
, PEO.PER_INFORMATION2 PER_INFORMATION2
, PEO.PER_INFORMATION3 PER_INFORMATION3
, PEO.PER_INFORMATION4 PER_INFORMATION4
, PEO.PER_INFORMATION5 PER_INFORMATION5
, PEO.PER_INFORMATION6 PER_INFORMATION6
, PEO.PER_INFORMATION7 PER_INFORMATION7
, PEO.PER_INFORMATION8 PER_INFORMATION8
, PEO.PER_INFORMATION9 PER_INFORMATION9
, PEO.PER_INFORMATION10 PER_INFORMATION10
, PEO.PER_INFORMATION11 PER_INFORMATION11
, PEO.PER_INFORMATION12 PER_INFORMATION12
, PEO.PER_INFORMATION13 PER_INFORMATION13
, PEO.PER_INFORMATION14 PER_INFORMATION14
, PEO.PER_INFORMATION15 PER_INFORMATION15
, PEO.PER_INFORMATION16 PER_INFORMATION16
, PEO.PER_INFORMATION17 PER_INFORMATION17
, PEO.PER_INFORMATION18 PER_INFORMATION18
, PEO.PER_INFORMATION19 PER_INFORMATION19
, PEO.PER_INFORMATION20 PER_INFORMATION20
, PEO.PER_INFORMATION21 PER_INFORMATION21
, PEO.PER_INFORMATION22 PER_INFORMATION22
, PEO.PER_INFORMATION23 PER_INFORMATION23
, PEO.PER_INFORMATION24 PER_INFORMATION24
, PEO.PER_INFORMATION25 PER_INFORMATION25
, PEO.PER_INFORMATION26 PER_INFORMATION26
, PEO.PER_INFORMATION27 PER_INFORMATION27
, PEO.PER_INFORMATION28 PER_INFORMATION28
, PEO.PER_INFORMATION29 PER_INFORMATION29
, PEO.PER_INFORMATION30 PER_INFORMATION30
, '_DF:PER:PER_PEOPLE:PEO'
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.PERSON_ID PERSON_ID
, PEO.GLOBAL_PERSON_ID GLOBAL_PERSON_ID
, PEO.PARTY_ID PARTY_ID
, PEO.PERSON_TYPE_ID PERSON_TYPE_ID
, PEO.COMMENT_ID COMMENT_ID
, PEO.VENDOR_ID VENDOR_ID
, PEO.BENEFIT_GROUP_ID BENEFIT_GROUP_ID
, PEO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PEO.LAST_UPDATED_BY LAST_UPDATED_BY
, PEO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PEO.CREATED_BY CREATED_BY
, PEO.CREATION_DATE CREATION_DATE
, CASE WHEN (PEO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEO.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_PEOPLE_F PEO WITH READ ONLY