[Home] [Help]
[Dependency Information]
[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:
APPS
EDW_HR_PTYP_PRSN_TYP_LTC
|
|
|
|