[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EDW_HR_PRSN_TYP_M |
|---|---|
| Object Type: | TABLE |
| Owner: | HRI |
| FND Design Data: |  HRI.EDW_HR_PRSN_TYP_M
|
| Subobject Name: | |
| Status: | VALID |
This is the Person Type dimension table. This is a denormalized star table and contains records for the lowest level of the dimension and every level above.
The Person Type dimension enables you to categorize people in different ways, for example, as applicants or employees.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 30 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| EDW_HR_PRSN_TYP_M_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 PERT_PERSON_TYPE_PK
PERT_PERSON_TYPE_PK_KEY
|
| EDW_HR_PRSN_TYP_M_U2 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
PERT_PERSON_TYPE_PK_KEY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERT_FORMER_SPOUSE_FLAG | VARCHAR2 | (80) | Whether the person is the former spouse of an employee | |
| PERT_FORMER_FMLY_MBR_FLAG | VARCHAR2 | (80) | Whether the person was in an employee's family | |
| PERT_PARTICIPANT_FLAG | VARCHAR2 | (80) | Whether the person is a participant | |
| PERT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute | |
| PERT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute | |
| PERT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute | |
| ALL_ALL_PK_KEY | NUMBER | Unique Warehouse Identifier for the All Person Types Level | ||
| ALL_NAME | VARCHAR2 | (80) | Name for the All Level | |
| PERT_NAME | VARCHAR2 | (240) | Person Type Name for Person Type Level | |
| PERT_INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
| PERT_POTENTIAL_WORKER_FLAG | VARCHAR2 | (80) | Whether the person is potentially part of the workforce | |
| PERT_PW_EMPLOYEE_FLAG | VARCHAR2 | (80) | Whether the person is an employee | |
| PERT_EMP_DIRECT_HIRE_FLAG | VARCHAR2 | (80) | Whether an employee is a direct hire | |
| PERT_PW_EMPLOYEE_TYPE | VARCHAR2 | (80) | Employee Person Type | |
| PERT_SRVIVNG_FMLY_MBR_TYPE | VARCHAR2 | (80) | Surviving Family Member Person Type | |
| PERT_SRVIVNG_SPOUSE_TYPE | VARCHAR2 | (80) | Surviving Spouse Person Type | |
| PERT_EX_APPLICANT_TYPE | VARCHAR2 | (80) | Ex-Applicant Person Type | |
| PERT_OTHER_TYPE | VARCHAR2 | (80) | Other Person Type | |
| PERT_PARTICIPANT_TYPE | VARCHAR2 | (80) | Participant Person Type | |
| PERT_FORMER_SPOUSE_TYPE | VARCHAR2 | (80) | Former Spouse Person Type | |
| PERT_FORMER_FMLY_MBR_TYPE | VARCHAR2 | (80) | Former Family Member Person Type | |
| PERT_LAST_UPDATE_DATE | DATE | Internal use only | ||
| PERT_CREATION_DATE | DATE | Internal use only | ||
| PERT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute | |
| PERT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute | |
| PERT_DH_EMP_STUDENT_FLAG | VARCHAR2 | (80) | Whether the employee is a part time student | |
| PERT_EMP_CNTNGNT_WRKFRC_FLAG | VARCHAR2 | (80) | Whether employee is part of the contingent workforce | |
| PERT_PW_EX_EMPLOYEE_TYPE | VARCHAR2 | (80) | Ex-Employee Person Type | |
| PERT_PW_APPLICANT_TYPE | VARCHAR2 | (80) | Applicant Person Type | |
| PERT_NON_WORKER_FLAG | VARCHAR2 | (80) | Whether the person is not part of the workforce | |
| PERT_NW_CONTACT_FLAG | VARCHAR2 | (80) | Whether the person is a contact | |
| PERT_NW_DEPENDANT_TYPE | VARCHAR2 | (80) | Dependent Person Type | |
| PERT_NW_RETIREE_TYPE | VARCHAR2 | (80) | Retiree Person Type | |
| PERT_NW_BENEFICIARY_TYPE | VARCHAR2 | (80) | Beneficiary Person Type | |
| ALL_ALL_PK | VARCHAR2 | (40) | Textual Unique Identifier for the All Person Types Level | |
| PERT_PERSON_TYPE_PK_KEY | NUMBER | Yes | Unique Warehouse Identifier for the Person Type Level | |
| PERT_PERSON_TYPE_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Person Type Level | |
| PERT_PERSON_TYPE_DP | VARCHAR2 | (240) | Reserved for future use | |
| PERT_CW_AGNCY_CNTRCTR_TYPE | VARCHAR2 | (80) | Agency Contractor Person Type | |
| PERT_CW_CONSULTANT_TYPE | VARCHAR2 | (80) | Consultant Person Type | |
| PERT_DH_PERMANENT_FLAG | VARCHAR2 | (80) | Whether the person is a permanent employee | |
| PERT_CW_SELF_EMPLOYED_TYPE | VARCHAR2 | (80) | Self Employed Contractor Person Type | |
| PERT_DH_FXD_TRM_LOWER_TYPE | VARCHAR2 | (80) | Fixed Term (lower band) Person Type | |
| PERT_DH_FXD_TRM_UPPER_TYPE | VARCHAR2 | (80) | Fixed Term (upper band) Person Type | |
| PERT_DH_INTERN_TYPE | VARCHAR2 | (80) | Intern Person Type | |
| PERT_DH_INTERN_FLAG | VARCHAR2 | (80) | Whether the person is an intern | |
| PERT_DH_FXD_TRM_LOWER_FLAG | VARCHAR2 | (80) | Whether the employee is on a fixed term (lower band) contract | |
| PERT_DH_FXD_TRM_UPPER_FLAG | VARCHAR2 | (80) | Whether the employee is on a fixed term (upper band) contract | |
| PERT_CW_AGNCY_CNTRCTR_FLAG | VARCHAR2 | (80) | Whether the person is an agency contractor | |
| PERT_CW_SELF_EMPLOYED_FLAG | VARCHAR2 | (80) | Whether the person is a self employed contractor | |
| PERT_CW_CONSULTANT_FLAG | VARCHAR2 | (80) | Whether the person is a consultant | |
| PERT_PW_EX_EMPLOYEE_FLAG | VARCHAR2 | (80) | Whether the person is an ex-employee | |
| PERT_PW_APPLICANT_FLAG | VARCHAR2 | (80) | Whether the person is an applicant | |
| PERT_NW_DEPENDANT_FLAG | VARCHAR2 | (80) | Whether the person is a dependent | |
| PERT_NW_RETIREE_FLAG | VARCHAR2 | (80) | Whether the person is a retiree | |
| PERT_NW_BENEFICIARY_FLAG | VARCHAR2 | (80) | Whether the person is a beneficiary | |
| PERT_SRVIVNG_FMLY_MBR_FLAG | VARCHAR2 | (80) | Whether the person is a surviving family member | |
| PERT_SRVIVNG_SPOUSE_FLAG | VARCHAR2 | (80) | Whether the person is a surviving spouse | |
| PERT_OTHER_FLAG | VARCHAR2 | (80) | Whether the person has a person type in the Other category | |
| PERT_DH_PERMANENT_TYPE | VARCHAR2 | (80) | Permanent Person Type | |
| PERT_EX_APPLICANT_FLAG | VARCHAR2 | (80) | Whether the person is an ex-applicant | |
| CREATION_DATE | DATE | Standard who column | ||
| LAST_UPDATE_DATE | DATE | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT PERT_FORMER_SPOUSE_FLAG
, PERT_FORMER_FMLY_MBR_FLAG
, PERT_PARTICIPANT_FLAG
, PERT_USER_ATTRIBUTE3
, PERT_USER_ATTRIBUTE4
, PERT_USER_ATTRIBUTE5
, ALL_ALL_PK_KEY
, ALL_NAME
, PERT_NAME
, PERT_INSTANCE
, PERT_POTENTIAL_WORKER_FLAG
, PERT_PW_EMPLOYEE_FLAG
, PERT_EMP_DIRECT_HIRE_FLAG
, PERT_PW_EMPLOYEE_TYPE
, PERT_SRVIVNG_FMLY_MBR_TYPE
, PERT_SRVIVNG_SPOUSE_TYPE
, PERT_EX_APPLICANT_TYPE
, PERT_OTHER_TYPE
, PERT_PARTICIPANT_TYPE
, PERT_FORMER_SPOUSE_TYPE
, PERT_FORMER_FMLY_MBR_TYPE
, PERT_LAST_UPDATE_DATE
, PERT_CREATION_DATE
, PERT_USER_ATTRIBUTE1
, PERT_USER_ATTRIBUTE2
, PERT_DH_EMP_STUDENT_FLAG
, PERT_EMP_CNTNGNT_WRKFRC_FLAG
, PERT_PW_EX_EMPLOYEE_TYPE
, PERT_PW_APPLICANT_TYPE
, PERT_NON_WORKER_FLAG
, PERT_NW_CONTACT_FLAG
, PERT_NW_DEPENDANT_TYPE
, PERT_NW_RETIREE_TYPE
, PERT_NW_BENEFICIARY_TYPE
, ALL_ALL_PK
, PERT_PERSON_TYPE_PK_KEY
, PERT_PERSON_TYPE_PK
, PERT_PERSON_TYPE_DP
, PERT_CW_AGNCY_CNTRCTR_TYPE
, PERT_CW_CONSULTANT_TYPE
, PERT_DH_PERMANENT_FLAG
, PERT_CW_SELF_EMPLOYED_TYPE
, PERT_DH_FXD_TRM_LOWER_TYPE
, PERT_DH_FXD_TRM_UPPER_TYPE
, PERT_DH_INTERN_TYPE
, PERT_DH_INTERN_FLAG
, PERT_DH_FXD_TRM_LOWER_FLAG
, PERT_DH_FXD_TRM_UPPER_FLAG
, PERT_CW_AGNCY_CNTRCTR_FLAG
, PERT_CW_SELF_EMPLOYED_FLAG
, PERT_CW_CONSULTANT_FLAG
, PERT_PW_EX_EMPLOYEE_FLAG
, PERT_PW_APPLICANT_FLAG
, PERT_NW_DEPENDANT_FLAG
, PERT_NW_RETIREE_FLAG
, PERT_NW_BENEFICIARY_FLAG
, PERT_SRVIVNG_FMLY_MBR_FLAG
, PERT_SRVIVNG_SPOUSE_FLAG
, PERT_OTHER_FLAG
, PERT_DH_PERMANENT_TYPE
, PERT_EX_APPLICANT_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
FROM HRI.EDW_HR_PRSN_TYP_M;
HRI.EDW_HR_PRSN_TYP_M does not reference any database object
HRI.EDW_HR_PRSN_TYP_M is referenced by following:
APPS
EDW_HR_PRSN_TYP_M
|
|
|
|