Product: | HRI - Human Resources Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.EDW_HR_PTYP_PRSN_TYP_LCV |
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ 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