[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EDW_HR_PTYP_PRSN_TYP_LSTG |
|---|---|
| Object Type: | TABLE |
| Owner: | HRI |
| FND Design Data: |  HRI.EDW_HR_PTYP_PRSN_TYP_LSTG
|
| Subobject Name: | |
| Status: | VALID |
This is the staging table for the Person Type level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Person Type dimension level table.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 5 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| EDW_HR_PTYP_PRSN_TYP_LSTG_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 PERSON_TYPE_PK
|
| EDW_HR_PTYP_PRSN_TYP_LSTG_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
COLLECTION_STATUS
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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 | |
| 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 | VARCHAR2 | (80) | 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 | |
| ROW_ID | ROWID | (10) | Row identifier | |
| COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record | |
| REQUEST_ID | NUMBER | Identifier used by collection program | ||
| ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
| PW_EMPLOYEE_FLAG | VARCHAR2 | (80) | Whether the person is an employee | |
| 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 | |
| CW_CONSULTANT_FLAG | VARCHAR2 | (80) | Whether the person is a consultant | |
| PW_EX_EMPLOYEE_FLAG | VARCHAR2 | (80) | Whether the person is an ex-employee | |
| 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 | |
| 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 | |
| OPERATION_CODE | VARCHAR2 | (240) | Code used by the loader program to determine whether to insert/update/delete this record |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_TYPE_PK
, ALL_FK
, 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
, ROW_ID
, COLLECTION_STATUS
, REQUEST_ID
, ERROR_CODE
, PW_EMPLOYEE_FLAG
, DH_PERMANENT_FLAG
, DH_INTERN_FLAG
, DH_FXD_TRM_LOWER_FLAG
, DH_FXD_TRM_UPPER_FLAG
, CW_AGNCY_CNTRCTR_FLAG
, CW_SELF_EMPLOYED_FLAG
, CW_CONSULTANT_FLAG
, PW_EX_EMPLOYEE_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
, PARTICIPANT_FLAG
, FORMER_SPOUSE_FLAG
, FORMER_FMLY_MBR_FLAG
, OPERATION_CODE
FROM HRI.EDW_HR_PTYP_PRSN_TYP_LSTG;
HRI.EDW_HR_PTYP_PRSN_TYP_LSTG does not reference any database object
HRI.EDW_HR_PTYP_PRSN_TYP_LSTG is referenced by following:
APPS
EDW_HR_PTYP_PRSN_TYP_LSTG
|
|
|
|