[Home] [Help]
View: EDW_HR_PTYP_PRSN_TYP_LCV
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
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 |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |