eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.EDWBV_HR_PTYP_PRSN_TYP_LCV

Source

View Text - Preformatted


SELECT /* $Header: hrisvpt.odf 120.0 2005/05/29 06:44:21 appldev noship $ */ ptc.person_type_pk || '-' || inst.instance_code person_type_pk ,'ALL' all_fk ,ptc.person_type_pk name ,ptc.person_type_pk person_type_dp ,inst.instance_code instance ,hr_general.decode_lookup('YES_NO', DECODE(ptc.employee,null, DECODE(ptc.permanent,null, DECODE(ptc.intern,null, DECODE(ptc.fixed_term_lower,null, DECODE(ptc.fixed_term_upper,null, DECODE(ptc.employee_student,null, DECODE(ptc.agency,null, DECODE(ptc.self_employed,null, DECODE(ptc.consultant,null, DECODE(ptc.ex_employee,null, DECODE(ptc.applicant,null,'N','Y'), 'Y'),'Y'),'Y'),'Y'),'Y'),'Y'),'Y'),'Y'),'Y'),'Y')) potential_worker_flag ,hr_general.decode_lookup('YES_NO', DECODE(ptc.employee,null, DECODE(ptc.permanent,null, DECODE(ptc.intern,null, DECODE(ptc.fixed_term_lower,null, DECODE(ptc.fixed_term_upper,null, DECODE(ptc.employee_student,null, DECODE(ptc.agency,null, DECODE(ptc.self_employed,null, DECODE(ptc.consultant,null,'N','Y') ,'Y'),'Y'),'Y'),'Y'),'Y'),'Y'),'Y'),'Y')) pw_employee_flag ,ptc.employee pw_employee_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.employee,null, DECODE(ptc.permanent,null, DECODE(ptc.intern,null, DECODE(ptc.fixed_term_lower,null, DECODE(ptc.fixed_term_upper,null, DECODE(ptc.employee_student,null,'N','Y') ,'Y'),'Y'),'Y'),'Y'),'Y')) emp_direct_hire_flag ,hr_general.decode_lookup('YES_NO', DECODE(ptc.permanent,NULL,'N','Y')) dh_permanent_flag ,ptc.permanent dh_permanent_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.intern,NULL,'N','Y')) dh_intern_flag ,ptc.intern dh_intern_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.fixed_term_lower,NULL,'N','Y')) dh_fxd_trm_lower_flag ,ptc.fixed_term_lower dh_fxd_trm_lower_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.fixed_term_upper,NULL,'N','Y')) dh_fxd_trm_upper_flag ,ptc.fixed_term_upper dh_fxd_trm_upper_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.employee_student,NULL,'N','Y')) dh_emp_student_flag ,hr_general.decode_lookup('YES_NO', DECODE(ptc.agency,null, DECODE(ptc.self_employed,null, DECODE(ptc.consultant,null,'N','Y'),'Y'),'Y')) emp_cntngnt_wrkfrc_flag ,hr_general.decode_lookup('YES_NO', DECODE(ptc.agency,NULL,'N','Y')) cw_agncy_cntrctr_flag ,ptc.agency cw_agncy_cntrctr_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.self_employed,NULL,'N','Y')) cw_self_employed_flag ,ptc.self_employed cw_self_employed_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.consultant,NULL,'N','Y')) cw_consultant_flag ,ptc.consultant cw_consultant_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.ex_employee,NULL,'N','Y')) pw_ex_employee_flag ,ptc.ex_employee pw_ex_employee_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.applicant,NULL,'N','Y')) pw_applicant_flag ,ptc.applicant pw_applicant_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.contact,null, DECODE(ptc.dependent,null, DECODE(ptc.retiree,null, DECODE(ptc.beneficiary,null,'N','Y'),'Y'),'Y'),'Y')) non_worker_flag ,ptc.contact nw_contact_flag ,hr_general.decode_lookup('YES_NO', DECODE(ptc.dependent,NULL,'N','Y')) nw_dependent_flag ,ptc.dependent nw_dependent_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.retiree,NULL,'N','Y')) nw_retiree_flag ,ptc.retiree nw_retiree_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.beneficiary,NULL,'N','Y')) nw_beneficiary_flag ,ptc.beneficiary nw_beneficiary_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.surviving_family_member,NULL,'N','Y')) srviving_fmly_mbr_flag ,ptc.surviving_family_member srviving_fmly_mbr_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.surviving_spouse,NULL,'N','Y')) srviving_spouse_flag ,ptc.surviving_spouse srviving_spouse_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.ex_applicant,NULL,'N','Y')) ex_applicant_flag ,ptc.ex_applicant ex_applicant_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.other,NULL,'N','Y')) other_flag ,ptc.other other_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.participant,NULL,'N','Y')) participant_flag ,ptc.participant participant_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.former_spouse,NULL,'N','Y')) former_spouse_flag ,ptc.former_spouse former_spouse_type ,hr_general.decode_lookup('YES_NO', DECODE(ptc.former_family_member,NULL,'N','Y')) former_fmly_mbr_flag ,ptc.former_family_member former_fmly_mbr_type ,NVL(ptc.last_update_date,to_date('01-01-2000','DD-MM-YYYY')) last_update_date ,ptc.creation_date creation_date FROM hri_person_type_cmbns ptc ,edw_local_instance inst

View Text - HTML Formatted

SELECT /* $HEADER: HRISVPT.ODF 120.0 2005/05/29 06:44:21 APPLDEV NOSHIP $ */ PTC.PERSON_TYPE_PK || '-' || INST.INSTANCE_CODE PERSON_TYPE_PK
, 'ALL' ALL_FK
, PTC.PERSON_TYPE_PK NAME
, PTC.PERSON_TYPE_PK PERSON_TYPE_DP
, INST.INSTANCE_CODE INSTANCE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.EMPLOYEE
, NULL
, DECODE(PTC.PERMANENT
, NULL
, DECODE(PTC.INTERN
, NULL
, DECODE(PTC.FIXED_TERM_LOWER
, NULL
, DECODE(PTC.FIXED_TERM_UPPER
, NULL
, DECODE(PTC.EMPLOYEE_STUDENT
, NULL
, DECODE(PTC.AGENCY
, NULL
, DECODE(PTC.SELF_EMPLOYED
, NULL
, DECODE(PTC.CONSULTANT
, NULL
, DECODE(PTC.EX_EMPLOYEE
, NULL
, DECODE(PTC.APPLICANT
, NULL
, 'N'
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')) POTENTIAL_WORKER_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.EMPLOYEE
, NULL
, DECODE(PTC.PERMANENT
, NULL
, DECODE(PTC.INTERN
, NULL
, DECODE(PTC.FIXED_TERM_LOWER
, NULL
, DECODE(PTC.FIXED_TERM_UPPER
, NULL
, DECODE(PTC.EMPLOYEE_STUDENT
, NULL
, DECODE(PTC.AGENCY
, NULL
, DECODE(PTC.SELF_EMPLOYED
, NULL
, DECODE(PTC.CONSULTANT
, NULL
, 'N'
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')) PW_EMPLOYEE_FLAG
, PTC.EMPLOYEE PW_EMPLOYEE_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.EMPLOYEE
, NULL
, DECODE(PTC.PERMANENT
, NULL
, DECODE(PTC.INTERN
, NULL
, DECODE(PTC.FIXED_TERM_LOWER
, NULL
, DECODE(PTC.FIXED_TERM_UPPER
, NULL
, DECODE(PTC.EMPLOYEE_STUDENT
, NULL
, 'N'
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')
, 'Y')) EMP_DIRECT_HIRE_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.PERMANENT
, NULL
, 'N'
, 'Y')) DH_PERMANENT_FLAG
, PTC.PERMANENT DH_PERMANENT_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.INTERN
, NULL
, 'N'
, 'Y')) DH_INTERN_FLAG
, PTC.INTERN DH_INTERN_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.FIXED_TERM_LOWER
, NULL
, 'N'
, 'Y')) DH_FXD_TRM_LOWER_FLAG
, PTC.FIXED_TERM_LOWER DH_FXD_TRM_LOWER_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.FIXED_TERM_UPPER
, NULL
, 'N'
, 'Y')) DH_FXD_TRM_UPPER_FLAG
, PTC.FIXED_TERM_UPPER DH_FXD_TRM_UPPER_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.EMPLOYEE_STUDENT
, NULL
, 'N'
, 'Y')) DH_EMP_STUDENT_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.AGENCY
, NULL
, DECODE(PTC.SELF_EMPLOYED
, NULL
, DECODE(PTC.CONSULTANT
, NULL
, 'N'
, 'Y')
, 'Y')
, 'Y')) EMP_CNTNGNT_WRKFRC_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.AGENCY
, NULL
, 'N'
, 'Y')) CW_AGNCY_CNTRCTR_FLAG
, PTC.AGENCY CW_AGNCY_CNTRCTR_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.SELF_EMPLOYED
, NULL
, 'N'
, 'Y')) CW_SELF_EMPLOYED_FLAG
, PTC.SELF_EMPLOYED CW_SELF_EMPLOYED_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.CONSULTANT
, NULL
, 'N'
, 'Y')) CW_CONSULTANT_FLAG
, PTC.CONSULTANT CW_CONSULTANT_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.EX_EMPLOYEE
, NULL
, 'N'
, 'Y')) PW_EX_EMPLOYEE_FLAG
, PTC.EX_EMPLOYEE PW_EX_EMPLOYEE_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.APPLICANT
, NULL
, 'N'
, 'Y')) PW_APPLICANT_FLAG
, PTC.APPLICANT PW_APPLICANT_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.CONTACT
, NULL
, DECODE(PTC.DEPENDENT
, NULL
, DECODE(PTC.RETIREE
, NULL
, DECODE(PTC.BENEFICIARY
, NULL
, 'N'
, 'Y')
, 'Y')
, 'Y')
, 'Y')) NON_WORKER_FLAG
, PTC.CONTACT NW_CONTACT_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.DEPENDENT
, NULL
, 'N'
, 'Y')) NW_DEPENDENT_FLAG
, PTC.DEPENDENT NW_DEPENDENT_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.RETIREE
, NULL
, 'N'
, 'Y')) NW_RETIREE_FLAG
, PTC.RETIREE NW_RETIREE_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.BENEFICIARY
, NULL
, 'N'
, 'Y')) NW_BENEFICIARY_FLAG
, PTC.BENEFICIARY NW_BENEFICIARY_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.SURVIVING_FAMILY_MEMBER
, NULL
, 'N'
, 'Y')) SRVIVING_FMLY_MBR_FLAG
, PTC.SURVIVING_FAMILY_MEMBER SRVIVING_FMLY_MBR_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.SURVIVING_SPOUSE
, NULL
, 'N'
, 'Y')) SRVIVING_SPOUSE_FLAG
, PTC.SURVIVING_SPOUSE SRVIVING_SPOUSE_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.EX_APPLICANT
, NULL
, 'N'
, 'Y')) EX_APPLICANT_FLAG
, PTC.EX_APPLICANT EX_APPLICANT_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.OTHER
, NULL
, 'N'
, 'Y')) OTHER_FLAG
, PTC.OTHER OTHER_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.PARTICIPANT
, NULL
, 'N'
, 'Y')) PARTICIPANT_FLAG
, PTC.PARTICIPANT PARTICIPANT_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.FORMER_SPOUSE
, NULL
, 'N'
, 'Y')) FORMER_SPOUSE_FLAG
, PTC.FORMER_SPOUSE FORMER_SPOUSE_TYPE
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, DECODE(PTC.FORMER_FAMILY_MEMBER
, NULL
, 'N'
, 'Y')) FORMER_FMLY_MBR_FLAG
, PTC.FORMER_FAMILY_MEMBER FORMER_FMLY_MBR_TYPE
, NVL(PTC.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY')) LAST_UPDATE_DATE
, PTC.CREATION_DATE CREATION_DATE
FROM HRI_PERSON_TYPE_CMBNS PTC
, EDW_LOCAL_INSTANCE INST