[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_PTYP_PRSN_TYP_LTC |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_PTYP_PRSN_TYP_LTC |
Subobject Name: | |
Status: | VALID |
This is the level table for the Person Type level of the Person Type dimension. This stores all combinations of different Person Types held by people within the Enterprise.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_PTYP_PRSN_TYP_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | PERSON_TYPE_PK_KEY |
EDW_HR_PTYP_PRSN_TYP_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PERSON_TYPE_PK
PERSON_TYPE_PK_KEY |
EDW_HR_PTYP_PRSN_TYP_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ALL_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DH_PERMANENT_FLAG | VARCHAR2 | (80) | Whether the person is a permanent employee | |
DH_INTERN_FLAG | VARCHAR2 | (80) | Whether the person is an intern | |
DH_FXD_TRM_LOWER_FLAG | VARCHAR2 | (80) | Whether the employee is on a fixed term (lower band) contract | |
DH_FXD_TRM_UPPER_FLAG | VARCHAR2 | (80) | Whether the employee is on a fixed term (upper band) contract | |
CW_AGNCY_CNTRCTR_FLAG | VARCHAR2 | (80) | Whether the person is an agency contractor | |
CW_SELF_EMPLOYED_FLAG | VARCHAR2 | (80) | Whether the person is a self employed contractor | |
PW_EX_EMPLOYEE_FLAG | VARCHAR2 | (80) | Whether the person is an ex-employee | |
CW_CONSULTANT_FLAG | VARCHAR2 | (80) | Whether the person is a consultant | |
PW_APPLICANT_FLAG | VARCHAR2 | (80) | Whether the person is an applicant | |
NW_DEPENDENT_FLAG | VARCHAR2 | (80) | Whether the person is a dependent | |
NW_RETIREE_FLAG | VARCHAR2 | (80) | Whether the person is a retiree | |
NW_BENEFICIARY_FLAG | VARCHAR2 | (80) | Whether the person is a beneficiary | |
SRVIVING_FMLY_MBR_FLAG | VARCHAR2 | (80) | Whether the person is a surviving family member | |
SRVIVING_SPOUSE_FLAG | VARCHAR2 | (80) | Whether the person is a surviving spouse | |
EX_APPLICANT_FLAG | VARCHAR2 | (80) | Whether the person is an ex-applicant | |
OTHER_FLAG | VARCHAR2 | (80) | Whether the person has a person type in the Other category | |
PERSON_TYPE_PK | VARCHAR2 | (1000) | Textual Unique Identifier for the Person Type Level | |
ALL_FK | VARCHAR2 | (30) | Textual Foreign Key to the All Person Types Level | |
PERSON_TYPE_PK_KEY | NUMBER | Unique Warehouse Identifier for the Person Type Level | ||
ALL_FK_KEY | NUMBER | Warehouse Foreign Key to the All Person Types Level | ||
NAME | VARCHAR2 | (1000) | Person Type Name for Person Type Level | |
PERSON_TYPE_DP | VARCHAR2 | (1000) | Reserved for future use | |
INSTANCE | VARCHAR2 | (30) | Identity of Data Source | |
POTENTIAL_WORKER_FLAG | VARCHAR2 | (80) | Whether the person is potentially part of the workforce | |
PW_EMPLOYEE_TYPE | VARCHAR2 | (80) | Employee Person Type | |
EMP_DIRECT_HIRE_FLAG | VARCHAR2 | (80) | Whether an employee is a direct hire | |
DH_PERMANENT_TYPE | VARCHAR2 | (80) | Permanent Person Type | |
DH_INTERN_TYPE | VARCHAR2 | (80) | Intern Person Type | |
DH_FXD_TRM_LOWER_TYPE | VARCHAR2 | (80) | Fixed Term (lower band) Person Type | |
DH_FXD_TRM_UPPER_TYPE | VARCHAR2 | (80) | Fixed Term (upper band) Person Type | |
DH_EMP_STUDENT_FLAG | VARCHAR2 | (80) | Whether the employee is a part time student | |
EMP_CNTNGNT_WRKFRC_FLAG | VARCHAR2 | (80) | Whether employee is part of the contingent workforce | |
CW_AGNCY_CNTRCTR_TYPE | VARCHAR2 | (80) | Agency Contractor Person Type | |
CW_SELF_EMPLOYED_TYPE | VARCHAR2 | (80) | Self Employed Contractor Person Type | |
CW_CONSULTANT_TYPE | VARCHAR2 | (80) | Consultant Person Type | |
PW_EX_EMPLOYEE_TYPE | VARCHAR2 | (80) | Ex-Employee Person Type | |
PW_APPLICANT_TYPE | VARCHAR2 | (80) | Applicant Person Type | |
NON_WORKER_FLAG | VARCHAR2 | (80) | Whether the person is not part of the workforce | |
NW_CONTACT_FLAG | VARCHAR2 | (80) | Whether the person is a contact | |
NW_DEPENDENT_TYPE | VARCHAR2 | (80) | Dependent Person Type | |
NW_RETIREE_TYPE | VARCHAR2 | (80) | Retiree Person Type | |
NW_BENEFICIARY_TYPE | VARCHAR2 | (80) | Beneficiary Person Type | |
SRVIVING_FMLY_MBR_TYPE | VARCHAR2 | (80) | Surviving Family Member Person Type | |
SRVIVING_SPOUSE_TYPE | VARCHAR2 | (80) | Surviving Spouse Person Type | |
EX_APPLICANT_TYPE | VARCHAR2 | (80) | Ex-Applicant Person Type | |
OTHER_TYPE | VARCHAR2 | (80) | Other Person Type | |
PARTICIPANT_TYPE | VARCHAR2 | (80) | Participant Person Type | |
FORMER_SPOUSE_TYPE | VARCHAR2 | (80) | Former Spouse Person Type | |
FORMER_FMLY_MBR_TYPE | VARCHAR2 | (80) | Former Family Member Person Type | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute | |
PW_EMPLOYEE_FLAG | VARCHAR2 | (80) | Whether the person is an employee | |
PARTICIPANT_FLAG | VARCHAR2 | (80) | Whether the person is a participant | |
FORMER_SPOUSE_FLAG | VARCHAR2 | (80) | Whether the person is the former spouse of an employee | |
FORMER_FMLY_MBR_FLAG | VARCHAR2 | (80) | Whether the person was in an employee's family |
Cut, paste (and edit) the following text to query this object:
SELECT DH_PERMANENT_FLAG
, DH_INTERN_FLAG
, DH_FXD_TRM_LOWER_FLAG
, DH_FXD_TRM_UPPER_FLAG
, CW_AGNCY_CNTRCTR_FLAG
, CW_SELF_EMPLOYED_FLAG
, PW_EX_EMPLOYEE_FLAG
, CW_CONSULTANT_FLAG
, PW_APPLICANT_FLAG
, NW_DEPENDENT_FLAG
, NW_RETIREE_FLAG
, NW_BENEFICIARY_FLAG
, SRVIVING_FMLY_MBR_FLAG
, SRVIVING_SPOUSE_FLAG
, EX_APPLICANT_FLAG
, OTHER_FLAG
, PERSON_TYPE_PK
, ALL_FK
, PERSON_TYPE_PK_KEY
, ALL_FK_KEY
, NAME
, PERSON_TYPE_DP
, INSTANCE
, POTENTIAL_WORKER_FLAG
, PW_EMPLOYEE_TYPE
, EMP_DIRECT_HIRE_FLAG
, DH_PERMANENT_TYPE
, DH_INTERN_TYPE
, DH_FXD_TRM_LOWER_TYPE
, DH_FXD_TRM_UPPER_TYPE
, DH_EMP_STUDENT_FLAG
, EMP_CNTNGNT_WRKFRC_FLAG
, CW_AGNCY_CNTRCTR_TYPE
, CW_SELF_EMPLOYED_TYPE
, CW_CONSULTANT_TYPE
, PW_EX_EMPLOYEE_TYPE
, PW_APPLICANT_TYPE
, NON_WORKER_FLAG
, NW_CONTACT_FLAG
, NW_DEPENDENT_TYPE
, NW_RETIREE_TYPE
, NW_BENEFICIARY_TYPE
, SRVIVING_FMLY_MBR_TYPE
, SRVIVING_SPOUSE_TYPE
, EX_APPLICANT_TYPE
, OTHER_TYPE
, PARTICIPANT_TYPE
, FORMER_SPOUSE_TYPE
, FORMER_FMLY_MBR_TYPE
, LAST_UPDATE_DATE
, CREATION_DATE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, PW_EMPLOYEE_FLAG
, PARTICIPANT_FLAG
, FORMER_SPOUSE_FLAG
, FORMER_FMLY_MBR_FLAG
FROM HRI.EDW_HR_PTYP_PRSN_TYP_LTC;
HRI.EDW_HR_PTYP_PRSN_TYP_LTC does not reference any database object
HRI.EDW_HR_PTYP_PRSN_TYP_LTC is referenced by following:
|
|
|