VIEW: APPS.EDW_HR_PTYP_PRSN_TYP_LCV

Source

View Text - Preformatted

SELECT /* $Header: hrisvpt.odf 120.0 2005/05/29 06:44:21 appldev noship $ */ person_type_pk ,all_fk ,name ,person_type_dp ,instance ,potential_worker_flag ,pw_employee_flag ,pw_employee_type ,emp_direct_hire_flag ,dh_permanent_flag ,dh_permanent_type ,dh_intern_flag ,dh_intern_type ,dh_fxd_trm_lower_flag ,dh_fxd_trm_lower_type ,dh_fxd_trm_upper_flag ,dh_fxd_trm_upper_type ,dh_emp_student_flag ,emp_cntngnt_wrkfrc_flag ,cw_agncy_cntrctr_flag ,cw_agncy_cntrctr_type ,cw_self_employed_flag ,cw_self_employed_type ,cw_consultant_flag ,cw_consultant_type ,pw_ex_employee_flag ,pw_ex_employee_type ,pw_applicant_flag ,pw_applicant_type ,non_worker_flag ,nw_contact_flag ,nw_dependent_flag ,nw_dependent_type ,nw_retiree_flag ,nw_retiree_type ,nw_beneficiary_flag ,nw_beneficiary_type ,srviving_fmly_mbr_flag ,srviving_fmly_mbr_type ,srviving_spouse_flag ,srviving_spouse_type ,ex_applicant_flag ,ex_applicant_type ,other_flag ,other_type ,participant_flag ,participant_type ,former_spouse_flag ,former_spouse_type ,former_fmly_mbr_flag ,former_fmly_mbr_type ,last_update_date ,creation_date ,null ,null ,null ,null ,null FROM edwbv_hr_ptyp_prsn_typ_lcv

View Text - HTML Formatted

SELECT /* $HEADER: HRISVPT.ODF 120.0 2005/05/29 06:44:21 APPLDEV NOSHIP $ */ PERSON_TYPE_PK
, ALL_FK
, NAME
, PERSON_TYPE_DP
, INSTANCE
, POTENTIAL_WORKER_FLAG
, PW_EMPLOYEE_FLAG
, PW_EMPLOYEE_TYPE
, EMP_DIRECT_HIRE_FLAG
, DH_PERMANENT_FLAG
, DH_PERMANENT_TYPE
, DH_INTERN_FLAG
, DH_INTERN_TYPE
, DH_FXD_TRM_LOWER_FLAG
, DH_FXD_TRM_LOWER_TYPE
, DH_FXD_TRM_UPPER_FLAG
, DH_FXD_TRM_UPPER_TYPE
, DH_EMP_STUDENT_FLAG
, EMP_CNTNGNT_WRKFRC_FLAG
, CW_AGNCY_CNTRCTR_FLAG
, CW_AGNCY_CNTRCTR_TYPE
, CW_SELF_EMPLOYED_FLAG
, CW_SELF_EMPLOYED_TYPE
, CW_CONSULTANT_FLAG
, CW_CONSULTANT_TYPE
, PW_EX_EMPLOYEE_FLAG
, PW_EX_EMPLOYEE_TYPE
, PW_APPLICANT_FLAG
, PW_APPLICANT_TYPE
, NON_WORKER_FLAG
, NW_CONTACT_FLAG
, NW_DEPENDENT_FLAG
, NW_DEPENDENT_TYPE
, NW_RETIREE_FLAG
, NW_RETIREE_TYPE
, NW_BENEFICIARY_FLAG
, NW_BENEFICIARY_TYPE
, SRVIVING_FMLY_MBR_FLAG
, SRVIVING_FMLY_MBR_TYPE
, SRVIVING_SPOUSE_FLAG
, SRVIVING_SPOUSE_TYPE
, EX_APPLICANT_FLAG
, EX_APPLICANT_TYPE
, OTHER_FLAG
, OTHER_TYPE
, PARTICIPANT_FLAG
, PARTICIPANT_TYPE
, FORMER_SPOUSE_FLAG
, FORMER_SPOUSE_TYPE
, FORMER_FMLY_MBR_FLAG
, FORMER_FMLY_MBR_TYPE
, LAST_UPDATE_DATE
, CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_HR_PTYP_PRSN_TYP_LCV