[Home] [Help] [Dependency Information]
Object Name: | EDWBV_HR_PTYP_PRSN_TYP_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HRI.EDWBV_HR_PTYP_PRSN_TYP_LCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
This view contains
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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
FROM APPS.EDWBV_HR_PTYP_PRSN_TYP_LCV;
|
|
|