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: EDWBV_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 $ */ 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

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