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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.EDW_HR_PTYP_PRSN_TYP_LCV

Object Details

Object Name:	EDW_HR_PTYP_PRSN_TYP_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HRI.EDW_HR_PTYP_PRSN_TYP_LCV
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
PERSON_TYPE_PK	VARCHAR2	(2031)
ALL_FK	CHAR	(3)
NAME	VARCHAR2	(2000)	Yes
PERSON_TYPE_DP	VARCHAR2	(2000)	Yes
INSTANCE	VARCHAR2	(30)
POTENTIAL_WORKER_FLAG	VARCHAR2	(4000)
PW_EMPLOYEE_FLAG	VARCHAR2	(4000)
PW_EMPLOYEE_TYPE	VARCHAR2	(80)
EMP_DIRECT_HIRE_FLAG	VARCHAR2	(4000)
DH_PERMANENT_FLAG	VARCHAR2	(4000)
DH_PERMANENT_TYPE	VARCHAR2	(80)
DH_INTERN_FLAG	VARCHAR2	(4000)
DH_INTERN_TYPE	VARCHAR2	(80)
DH_FXD_TRM_LOWER_FLAG	VARCHAR2	(4000)
DH_FXD_TRM_LOWER_TYPE	VARCHAR2	(80)
DH_FXD_TRM_UPPER_FLAG	VARCHAR2	(4000)
DH_FXD_TRM_UPPER_TYPE	VARCHAR2	(80)
DH_EMP_STUDENT_FLAG	VARCHAR2	(4000)
EMP_CNTNGNT_WRKFRC_FLAG	VARCHAR2	(4000)
CW_AGNCY_CNTRCTR_FLAG	VARCHAR2	(4000)
CW_AGNCY_CNTRCTR_TYPE	VARCHAR2	(80)
CW_SELF_EMPLOYED_FLAG	VARCHAR2	(4000)
CW_SELF_EMPLOYED_TYPE	VARCHAR2	(80)
CW_CONSULTANT_FLAG	VARCHAR2	(4000)
CW_CONSULTANT_TYPE	VARCHAR2	(80)
PW_EX_EMPLOYEE_FLAG	VARCHAR2	(4000)
PW_EX_EMPLOYEE_TYPE	VARCHAR2	(80)
PW_APPLICANT_FLAG	VARCHAR2	(4000)
PW_APPLICANT_TYPE	VARCHAR2	(80)
NON_WORKER_FLAG	VARCHAR2	(4000)
NW_CONTACT_FLAG	VARCHAR2	(80)
NW_DEPENDENT_FLAG	VARCHAR2	(4000)
NW_DEPENDENT_TYPE	VARCHAR2	(80)
NW_RETIREE_FLAG	VARCHAR2	(4000)
NW_RETIREE_TYPE	VARCHAR2	(80)
NW_BENEFICIARY_FLAG	VARCHAR2	(4000)
NW_BENEFICIARY_TYPE	VARCHAR2	(80)
SRVIVING_FMLY_MBR_FLAG	VARCHAR2	(4000)
SRVIVING_FMLY_MBR_TYPE	VARCHAR2	(80)
SRVIVING_SPOUSE_FLAG	VARCHAR2	(4000)
SRVIVING_SPOUSE_TYPE	VARCHAR2	(80)
EX_APPLICANT_FLAG	VARCHAR2	(4000)
EX_APPLICANT_TYPE	VARCHAR2	(80)
OTHER_FLAG	VARCHAR2	(4000)
OTHER_TYPE	VARCHAR2	(80)
PARTICIPANT_FLAG	VARCHAR2	(4000)
PARTICIPANT_TYPE	VARCHAR2	(80)
FORMER_SPOUSE_FLAG	VARCHAR2	(4000)
FORMER_SPOUSE_TYPE	VARCHAR2	(80)
FORMER_FMLY_MBR_FLAG	VARCHAR2	(4000)
FORMER_FMLY_MBR_TYPE	VARCHAR2	(80)
LAST_UPDATE_DATE	DATE
CREATION_DATE	DATE
USER_ATTRIBUTE1	VARCHAR2	(0)
USER_ATTRIBUTE2	VARCHAR2	(0)
USER_ATTRIBUTE3	VARCHAR2	(0)
USER_ATTRIBUTE4	VARCHAR2	(0)
USER_ATTRIBUTE5	VARCHAR2	(0)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.EDW_HR_PTYP_PRSN_TYP_LCV;

Dependencies

[top of page]

APPS.EDW_HR_PTYP_PRSN_TYP_LCV references the following:

APPS: EDWBV_HR_PTYP_PRSN_TYP_LCV; HR_GENERAL - show dependent code

APPS.EDW_HR_PTYP_PRSN_TYP_LCV is referenced by following:

APPS: HRI_EDW_DIM_SIZING - show dependent code