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.

[Home] [Help]

View: EDW_HR_PRSN_TYP_FKV

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 $ */ PTC.PERSON_TYPE_PK || INST.INSTANCE_CODE PERSON_TYPE_PK
, PTC.EMPLOYEE PW_EMPLOYEE_TYPE
, PTC.PERMANENT DH_PERMENANT_TYPE
, PTC.INTERN DH_INTERN_TYPE
, PTC.FIXED_TERM_LOWER DH_FXD_TRM_LOWER_TYPE
, PTC.FIXED_TERM_UPPER DH_FXD_TRM_UPPER_TYPE
, PTC.EMPLOYEE_STUDENT DH_EMP_STUDENT_FLAG
, PTC.AGENCY CW_AGNCY_CNTRCTR_TYPE
, PTC.SELF_EMPLOYED CW_SELF_EMPLOYED_TYPE
, PTC.CONSULTANT CW_CONSULTANT_TYPE
, PTC.EX_EMPLOYEE PW_EX_EMPLOYEE_TYPE
, PTC.APPLICANT PW_APPLICANT_TYPE
, PTC.CONTACT NW_CONTACT_FLAG
, PTC.DEPENDENT NW_DEPENDENT_TYPE
, PTC.RETIREE NW_RETIREE_TYPE
, PTC.BENEFICIARY NW_BENEFICIARY_TYPE
, PTC.SURVIVING_FAMILY_MEMBER SRVIVNG_FMLY_MBR_TYPE
, PTC.SURVIVING_SPOUSE SRVIVNG_SPOUSE_TYPE
, PTC.EX_APPLICANT EX_APPLICANT_TYPE
, PTC.OTHER OTHER_TYPE
, PTC.PARTICIPANT PARTICIPANT_TYPE
, PTC.FORMER_SPOUSE FORMER_SPOUSE_TYPE
, PTC.FORMER_FAMILY_MEMBER FORMER_FMLY_MBR_TYPE
FROM HRI_PERSON_TYPE_CMBNS PTC
, EDW_LOCAL_INSTANCE INST

Columns

Name
PERSON_TYPE_PK
PW_EMPLOYEE_TYPE
DH_PERMENANT_TYPE
DH_INTERN_TYPE
DH_FXD_TRM_LOWER_TYPE
DH_FXD_TRM_UPPER_TYPE
DH_EMP_STUDENT_FLAG
CW_AGNCY_CNTRCTR_TYPE
CW_SELF_EMPLOYED_TYPE
CW_CONSULTANT_TYPE
PW_EX_EMPLOYEE_TYPE
PW_APPLICANT_TYPE
NW_CONTACT_FLAG
NW_DEPENDENT_TYPE
NW_RETIREE_TYPE
NW_BENEFICIARY_TYPE
SRVIVNG_FMLY_MBR_TYPE
SRVIVNG_SPOUSE_TYPE
EX_APPLICANT_TYPE
OTHER_TYPE
PARTICIPANT_TYPE
FORMER_SPOUSE_TYPE
FORMER_FMLY_MBR_TYPE