[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EDW_HR_PERSON_M |
|---|---|
| Object Type: | TABLE |
| Owner: | HRI |
| FND Design Data: |  BIS.EDW_HR_PERSON_M
HRI.EDW_HR_PERSON_M
|
| Subobject Name: | |
| Status: | VALID |
This is Person dimension table. This is a denormalized star table and contains records for the lowest level of the dimension and every level above.
The Person dimension is used to group together the attributes that describe the characteristics of a person, for example, name, nationality, date of birth. It contains information about all people related to the Enterprise including employees, applicants and contacts.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 30 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| EDW_HR_PERSON_M_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 ASGN_ASSIGNMENT_PK
ASGN_ASSIGNMENT_PK_KEY
|
| EDW_HR_PERSON_M_U2 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
ASGN_ASSIGNMENT_PK_KEY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ASGN_ASSIGNMENT_PK | VARCHAR2 | (1000) | Textual Unique Identifier for the Person Level | |
| ASGN_ASSIGNMENT_PK_KEY | NUMBER | Yes | Unique Warehouse Identifier for the Person Level | |
| ASGN_BUSINESS_GROUP | VARCHAR2 | (240) | Business Group of person | |
| ASGN_END_DATE | DATE | End date of person | ||
| ASGN_INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
| ASGN_NAME | VARCHAR2 | (1000) | Person Name for the Person Level | |
| ASGN_START_DATE | DATE | Start date of the person | ||
| ASGN_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute | |
| ASGN_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute | |
| ASGN_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute | |
| ASGN_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute | |
| ASGN_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute | |
| ALL_ALL_PK_KEY | NUMBER | Unique Warehouse Identifier for the All People Level | ||
| ALL_ALL_PK | VARCHAR2 | (40) | Textual Unique Identifier for the All People Level | |
| ALL_NAME | VARCHAR2 | (80) | Name for the All Level | |
| ASGN_RESUME_EXISTS | VARCHAR2 | (80) | Whether a resume exists for the person | |
| ASGN_RESUME_UPDATED_DATE | DATE | Date the resume was last updated | ||
| ASGN_SALESREP_ID | NUMBER | Internal use only | ||
| ASGN_SALES_REP_FLAG | VARCHAR2 | (80) | Whether the Person is a Sales Representative | |
| ASGN_STUDENT_STATUS | VARCHAR2 | (80) | Type of student, if applicable | |
| ASGN_SYS_GEN_FLAG | VARCHAR2 | (80) | Internal use only | |
| ASGN_TITLE | VARCHAR2 | (30) | Name Title (e.g. Mr. or Mrs.) | |
| ASGN_TOWN_OF_BIRTH | VARCHAR2 | (90) | Town of birth | |
| ASGN_NATIONALITY | VARCHAR2 | (30) | Nationality of person | |
| ASGN_NATIONAL_IDENTIFIER | VARCHAR2 | (30) | National Identifier of the person | |
| ASGN_PERSON_DP | VARCHAR2 | (1000) | Reserved for future use | |
| ASGN_PERSON_ID | NUMBER | Hidden identifier for the Person from the data source | ||
| ASGN_PERSON_NUM | VARCHAR2 | (30) | System generated Employee or Applicant Number for the person | |
| ASGN_PLANNER_CODE | VARCHAR2 | (30) | Internal use only | |
| ASGN_PLANNER_FLAG | VARCHAR2 | (80) | Whether the person is a planner | |
| ASGN_PREVIOUS_LAST_NAME | VARCHAR2 | (150) | Previous last name of person | |
| ASGN_REGION_OF_BIRTH | VARCHAR2 | (90) | Region of birth | |
| ASGN_REHIRE_RCMMNDTN | VARCHAR2 | (30) | Re-hire recommendation | |
| ASGN_GENDER | VARCHAR2 | (80) | Gender (e.g. Male or Female) | |
| ASGN_GLOBAL_PERSON_ID | VARCHAR2 | (30) | Hidden Identifier for the Global Person from the data source | |
| ASGN_INTERNAL_LOCATION | VARCHAR2 | (45) | Internal location of person | |
| ASGN_KNOWN_AS | VARCHAR2 | (80) | Preferred name of person | |
| ASGN_LAST_NAME | VARCHAR2 | (150) | Last name of person | |
| ASGN_LAST_UPDATE_DATE | DATE | Internal use only | ||
| ASGN_MAILSTOP | VARCHAR2 | (45) | Mailstop | |
| ASGN_MARITAL_STATUS | VARCHAR2 | (80) | Marital status of person (e.g. Single, Divorced) | |
| ASGN_MIDDLE_NAMES | VARCHAR2 | (60) | Middle names of person | |
| ASGN_NAME_PREFIX | VARCHAR2 | (30) | Name prefix | |
| ASGN_NAME_SUFFIX | VARCHAR2 | (30) | Name suffix | |
| CREATION_DATE | DATE | Standard who column | ||
| LAST_UPDATE_DATE | DATE | Standard who column | ||
| ASGN_DISABILITY_FLAG | VARCHAR2 | (80) | Whether the person is classified as disabled | |
| ASGN_EFFECTIVE_END_DATE | DATE | Date tracked end date for the current person record | ||
| ASGN_EFFECTIVE_START_DATE | DATE | Date tracked start date for the current person record | ||
| ASGN_EMAIL_ADDRESS | VARCHAR2 | (240) | Email address of person | |
| ASGN_FAST_PATH_EMPLOYEE | VARCHAR2 | (30) | Whether the person is a fast path employee | |
| ASGN_FIRST_NAME | VARCHAR2 | (150) | First name of person | |
| ASGN_FTE_CAPACITY | NUMBER | Full Time Equivalent capacity of person | ||
| ASGN_FULL_NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by | |
| ASGN_BUYER_FLAG | VARCHAR2 | (80) | Whether the person is a buyer | |
| ASGN_COUNTRY_OF_BIRTH | VARCHAR2 | (90) | Country of birth | |
| ASGN_CREATION_DATE | DATE | Internal use only | ||
| ASGN_CRRSPNDNC_LANGUAGE | VARCHAR2 | (30) | Correspondance language | |
| ASGN_DATE_EMP_DATA_VRFD | DATE | Date employee data was last verified | ||
| ASGN_DATE_OF_BIRTH | DATE | Date of birth | ||
| ASGN_EMPLOYEE_FLAG | VARCHAR2 | (80) | Whether the person is an employee | |
| ASGN_APPLICANT_FLAG | VARCHAR2 | (80) | Whether the person is an applicant | |
| S15_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S14_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S13_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S11_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S12_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S15_PERSON_ID | NUMBER | Internal use only | ||
| S14_PERSON_ID | NUMBER | Internal use only | ||
| S13_PERSON_ID | NUMBER | Internal use only | ||
| S12_PERSON_ID | NUMBER | Internal use only | ||
| S11_PERSON_ID | NUMBER | Internal use only | ||
| S15_SPRVSR_LVL15_PK_KEY | NUMBER | Internal use only | ||
| S14_SPRVSR_LVL14_PK_KEY | NUMBER | Internal use only | ||
| S13_SPRVSR_LVL13_PK_KEY | NUMBER | Internal use only | ||
| S12_SPRVSR_LVL12_PK_KEY | NUMBER | Internal use only | ||
| S11_SPRVSR_LVL11_PK_KEY | NUMBER | Internal use only | ||
| S09_PERSON_ID | NUMBER | Internal use only | ||
| S08_PERSON_ID | NUMBER | Internal use only | ||
| S07_PERSON_ID | NUMBER | Internal use only | ||
| S06_PERSON_ID | NUMBER | Internal use only | ||
| S05_PERSON_ID | NUMBER | Internal use only | ||
| S04_PERSON_ID | NUMBER | Internal use only | ||
| S03_PERSON_ID | NUMBER | Internal use only | ||
| S02_PERSON_ID | NUMBER | Internal use only | ||
| S10_PERSON_ID | NUMBER | Internal use only | ||
| S01_PERSON_ID | NUMBER | Internal use only | ||
| S09_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S08_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S07_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S06_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S05_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S04_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S03_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S02_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S10_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S01_ASSIGNMENT_ID | NUMBER | Internal use only | ||
| S03_SPRVSR_LVL3_PK_KEY | NUMBER | Internal use only | ||
| S02_SPRVSR_LVL2_PK_KEY | NUMBER | Internal use only | ||
| S01_SPRVSR_LVL1_PK_KEY | NUMBER | Internal use only | ||
| S05_SPRVSR_LVL5_PK_KEY | NUMBER | Internal use only | ||
| S04_SPRVSR_LVL4_PK_KEY | NUMBER | Internal use only | ||
| S09_SPRVSR_LVL9_PK_KEY | NUMBER | Internal use only | ||
| S08_SPRVSR_LVL8_PK_KEY | NUMBER | Internal use only | ||
| S07_SPRVSR_LVL7_PK_KEY | NUMBER | Internal use only | ||
| S06_SPRVSR_LVL6_PK_KEY | NUMBER | Internal use only | ||
| S10_SPRVSR_LVL10_PK_KEY | NUMBER | Internal use only | ||
| S11_SPRVSR_LVL11_PK | VARCHAR2 | (400) | Internal use only | |
| S15_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S15_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S15_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S15_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S15_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S15_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S15_NAME | VARCHAR2 | (240) | Internal use only | |
| S15_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S15_SPRVSR_LVL15_PK | VARCHAR2 | (400) | Internal use only | |
| S14_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S14_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S14_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S14_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S14_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S14_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S14_NAME | VARCHAR2 | (240) | Internal use only | |
| S14_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S14_SPRVSR_LVL14_PK | VARCHAR2 | (400) | Internal use only | |
| S13_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S13_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S13_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S13_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S13_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S13_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S13_NAME | VARCHAR2 | (240) | Internal use only | |
| S13_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S13_SPRVSR_LVL13_PK | VARCHAR2 | (400) | Internal use only | |
| S12_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S12_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S12_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S12_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S12_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S12_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S12_NAME | VARCHAR2 | (240) | Internal use only | |
| S12_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S12_SPRVSR_LVL12_PK | VARCHAR2 | (400) | Internal use only | |
| S11_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S11_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S11_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S11_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S11_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S11_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S11_NAME | VARCHAR2 | (240) | Internal use only | |
| S11_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S06_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S09_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S09_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S09_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S09_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S09_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S09_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S09_NAME | VARCHAR2 | (240) | Internal use only | |
| S09_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S09_SPRVSR_LVL9_PK | VARCHAR2 | (400) | Internal use only | |
| S08_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S08_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S08_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S08_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S08_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S08_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S08_NAME | VARCHAR2 | (240) | Internal use only | |
| S08_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S08_SPRVSR_LVL8_PK | VARCHAR2 | (400) | Internal use only | |
| S07_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S07_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S07_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S07_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S07_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S07_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S07_NAME | VARCHAR2 | (240) | Internal use only | |
| S06_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S06_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S06_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S06_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S06_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S06_NAME | VARCHAR2 | (240) | Internal use only | |
| S06_SPRVSR_LVL6_PK | VARCHAR2 | (400) | Internal use only | |
| S05_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S05_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S05_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S05_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S05_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S05_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S05_NAME | VARCHAR2 | (240) | Internal use only | |
| S05_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S05_SPRVSR_LVL5_PK | VARCHAR2 | (400) | Internal use only | |
| S04_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S04_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S04_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S04_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S04_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S04_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S04_NAME | VARCHAR2 | (240) | Internal use only | |
| S04_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S04_SPRVSR_LVL4_PK | VARCHAR2 | (400) | Internal use only | |
| S03_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S03_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S03_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S03_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S03_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S10_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S10_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S10_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S10_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S10_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S10_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S10_NAME | VARCHAR2 | (240) | Internal use only | |
| S10_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S02_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S10_SPRVSR_LVL10_PK | VARCHAR2 | (400) | Internal use only | |
| S02_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S02_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S02_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S02_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S02_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S03_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S03_NAME | VARCHAR2 | (240) | Internal use only | |
| S03_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S03_SPRVSR_LVL3_PK | VARCHAR2 | (400) | Internal use only | |
| S01_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S01_USER_ATTRIBUTE4 | VARCHAR2 | (240) | Internal use only | |
| S01_USER_ATTRIBUTE3 | VARCHAR2 | (240) | Internal use only | |
| S01_USER_ATTRIBUTE2 | VARCHAR2 | (240) | Internal use only | |
| S01_USER_ATTRIBUTE1 | VARCHAR2 | (240) | Internal use only | |
| S01_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S01_SPRVSR_DP | VARCHAR2 | (240) | Internal use only | |
| S01_NAME | VARCHAR2 | (240) | Internal use only | |
| S01_SPRVSR_LVL1_PK | VARCHAR2 | (400) | Internal use only | |
| S02_NAME | VARCHAR2 | (240) | Internal use only | |
| S02_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S02_SPRVSR_LVL2_PK | VARCHAR2 | (400) | Internal use only | |
| S07_INSTANCE | VARCHAR2 | (40) | Internal use only | |
| S07_SPRVSR_LVL7_PK | VARCHAR2 | (400) | Internal use only | |
| S06_USER_ATTRIBUTE5 | VARCHAR2 | (240) | Internal use only | |
| S15_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S15_CREATION_DATE | DATE | Internal use only | ||
| S14_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S14_CREATION_DATE | DATE | Internal use only | ||
| S13_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S13_CREATION_DATE | DATE | Internal use only | ||
| S12_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S12_CREATION_DATE | DATE | Internal use only | ||
| S11_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S11_CREATION_DATE | DATE | Internal use only | ||
| S09_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S09_CREATION_DATE | DATE | Internal use only | ||
| S08_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S08_CREATION_DATE | DATE | Internal use only | ||
| S07_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S06_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S06_CREATION_DATE | DATE | Internal use only | ||
| S05_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S05_CREATION_DATE | DATE | Internal use only | ||
| S04_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S04_CREATION_DATE | DATE | Internal use only | ||
| S10_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S10_CREATION_DATE | DATE | Internal use only | ||
| S03_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S03_CREATION_DATE | DATE | Internal use only | ||
| S01_CREATION_DATE | DATE | Internal use only | ||
| S01_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S02_LAST_UPDATE_DATE | DATE | Internal use only | ||
| S02_CREATION_DATE | DATE | Internal use only | ||
| S07_CREATION_DATE | DATE | Internal use only | ||
| S01_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S02_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S03_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S04_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S05_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S06_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S07_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S08_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S09_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S10_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S11_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S12_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S13_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S14_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| S15_NAME_DISPLAY | VARCHAR2 | (240) | Internal use only | |
| ASGN_NAME_DISPLAY | VARCHAR2 | (240) | Assignment Name Display | |
| ASGN_BUSINESS_GROUP_ID | NUMBER | Assignment Business Group Id | ||
| ASGN_PERSON_TYPE_ID | NUMBER | Assignment Person Type Id | ||
| ASGN_EMPLOYEE_NUMBER | VARCHAR2 | (30) | Assignment Employee Number | |
| ASGN_APPLICANT_NUMBER | VARCHAR2 | (30) | Assignment Applicant Number |
Cut, paste (and edit) the following text to query this object:
SELECT ASGN_ASSIGNMENT_PK
, ASGN_ASSIGNMENT_PK_KEY
, ASGN_BUSINESS_GROUP
, ASGN_END_DATE
, ASGN_INSTANCE
, ASGN_NAME
, ASGN_START_DATE
, ASGN_USER_ATTRIBUTE1
, ASGN_USER_ATTRIBUTE2
, ASGN_USER_ATTRIBUTE3
, ASGN_USER_ATTRIBUTE4
, ASGN_USER_ATTRIBUTE5
, ALL_ALL_PK_KEY
, ALL_ALL_PK
, ALL_NAME
, ASGN_RESUME_EXISTS
, ASGN_RESUME_UPDATED_DATE
, ASGN_SALESREP_ID
, ASGN_SALES_REP_FLAG
, ASGN_STUDENT_STATUS
, ASGN_SYS_GEN_FLAG
, ASGN_TITLE
, ASGN_TOWN_OF_BIRTH
, ASGN_NATIONALITY
, ASGN_NATIONAL_IDENTIFIER
, ASGN_PERSON_DP
, ASGN_PERSON_ID
, ASGN_PERSON_NUM
, ASGN_PLANNER_CODE
, ASGN_PLANNER_FLAG
, ASGN_PREVIOUS_LAST_NAME
, ASGN_REGION_OF_BIRTH
, ASGN_REHIRE_RCMMNDTN
, ASGN_GENDER
, ASGN_GLOBAL_PERSON_ID
, ASGN_INTERNAL_LOCATION
, ASGN_KNOWN_AS
, ASGN_LAST_NAME
, ASGN_LAST_UPDATE_DATE
, ASGN_MAILSTOP
, ASGN_MARITAL_STATUS
, ASGN_MIDDLE_NAMES
, ASGN_NAME_PREFIX
, ASGN_NAME_SUFFIX
, CREATION_DATE
, LAST_UPDATE_DATE
, ASGN_DISABILITY_FLAG
, ASGN_EFFECTIVE_END_DATE
, ASGN_EFFECTIVE_START_DATE
, ASGN_EMAIL_ADDRESS
, ASGN_FAST_PATH_EMPLOYEE
, ASGN_FIRST_NAME
, ASGN_FTE_CAPACITY
, ASGN_FULL_NAME
, ASGN_BUYER_FLAG
, ASGN_COUNTRY_OF_BIRTH
, ASGN_CREATION_DATE
, ASGN_CRRSPNDNC_LANGUAGE
, ASGN_DATE_EMP_DATA_VRFD
, ASGN_DATE_OF_BIRTH
, ASGN_EMPLOYEE_FLAG
, ASGN_APPLICANT_FLAG
, S15_ASSIGNMENT_ID
, S14_ASSIGNMENT_ID
, S13_ASSIGNMENT_ID
, S11_ASSIGNMENT_ID
, S12_ASSIGNMENT_ID
, S15_PERSON_ID
, S14_PERSON_ID
, S13_PERSON_ID
, S12_PERSON_ID
, S11_PERSON_ID
, S15_SPRVSR_LVL15_PK_KEY
, S14_SPRVSR_LVL14_PK_KEY
, S13_SPRVSR_LVL13_PK_KEY
, S12_SPRVSR_LVL12_PK_KEY
, S11_SPRVSR_LVL11_PK_KEY
, S09_PERSON_ID
, S08_PERSON_ID
, S07_PERSON_ID
, S06_PERSON_ID
, S05_PERSON_ID
, S04_PERSON_ID
, S03_PERSON_ID
, S02_PERSON_ID
, S10_PERSON_ID
, S01_PERSON_ID
, S09_ASSIGNMENT_ID
, S08_ASSIGNMENT_ID
, S07_ASSIGNMENT_ID
, S06_ASSIGNMENT_ID
, S05_ASSIGNMENT_ID
, S04_ASSIGNMENT_ID
, S03_ASSIGNMENT_ID
, S02_ASSIGNMENT_ID
, S10_ASSIGNMENT_ID
, S01_ASSIGNMENT_ID
, S03_SPRVSR_LVL3_PK_KEY
, S02_SPRVSR_LVL2_PK_KEY
, S01_SPRVSR_LVL1_PK_KEY
, S05_SPRVSR_LVL5_PK_KEY
, S04_SPRVSR_LVL4_PK_KEY
, S09_SPRVSR_LVL9_PK_KEY
, S08_SPRVSR_LVL8_PK_KEY
, S07_SPRVSR_LVL7_PK_KEY
, S06_SPRVSR_LVL6_PK_KEY
, S10_SPRVSR_LVL10_PK_KEY
, S11_SPRVSR_LVL11_PK
, S15_USER_ATTRIBUTE5
, S15_USER_ATTRIBUTE4
, S15_USER_ATTRIBUTE3
, S15_USER_ATTRIBUTE2
, S15_USER_ATTRIBUTE1
, S15_SPRVSR_DP
, S15_NAME
, S15_INSTANCE
, S15_SPRVSR_LVL15_PK
, S14_USER_ATTRIBUTE5
, S14_USER_ATTRIBUTE4
, S14_USER_ATTRIBUTE3
, S14_USER_ATTRIBUTE2
, S14_USER_ATTRIBUTE1
, S14_SPRVSR_DP
, S14_NAME
, S14_INSTANCE
, S14_SPRVSR_LVL14_PK
, S13_USER_ATTRIBUTE5
, S13_USER_ATTRIBUTE4
, S13_USER_ATTRIBUTE3
, S13_USER_ATTRIBUTE2
, S13_USER_ATTRIBUTE1
, S13_SPRVSR_DP
, S13_NAME
, S13_INSTANCE
, S13_SPRVSR_LVL13_PK
, S12_USER_ATTRIBUTE5
, S12_USER_ATTRIBUTE4
, S12_USER_ATTRIBUTE3
, S12_USER_ATTRIBUTE2
, S12_USER_ATTRIBUTE1
, S12_SPRVSR_DP
, S12_NAME
, S12_INSTANCE
, S12_SPRVSR_LVL12_PK
, S11_USER_ATTRIBUTE5
, S11_USER_ATTRIBUTE4
, S11_USER_ATTRIBUTE3
, S11_USER_ATTRIBUTE2
, S11_USER_ATTRIBUTE1
, S11_SPRVSR_DP
, S11_NAME
, S11_INSTANCE
, S06_INSTANCE
, S09_USER_ATTRIBUTE5
, S09_USER_ATTRIBUTE4
, S09_USER_ATTRIBUTE3
, S09_USER_ATTRIBUTE2
, S09_USER_ATTRIBUTE1
, S09_SPRVSR_DP
, S09_NAME
, S09_INSTANCE
, S09_SPRVSR_LVL9_PK
, S08_USER_ATTRIBUTE5
, S08_USER_ATTRIBUTE4
, S08_USER_ATTRIBUTE3
, S08_USER_ATTRIBUTE2
, S08_USER_ATTRIBUTE1
, S08_SPRVSR_DP
, S08_NAME
, S08_INSTANCE
, S08_SPRVSR_LVL8_PK
, S07_USER_ATTRIBUTE5
, S07_USER_ATTRIBUTE4
, S07_USER_ATTRIBUTE3
, S07_USER_ATTRIBUTE2
, S07_USER_ATTRIBUTE1
, S07_SPRVSR_DP
, S07_NAME
, S06_USER_ATTRIBUTE4
, S06_USER_ATTRIBUTE3
, S06_USER_ATTRIBUTE2
, S06_USER_ATTRIBUTE1
, S06_SPRVSR_DP
, S06_NAME
, S06_SPRVSR_LVL6_PK
, S05_USER_ATTRIBUTE5
, S05_USER_ATTRIBUTE4
, S05_USER_ATTRIBUTE3
, S05_USER_ATTRIBUTE2
, S05_USER_ATTRIBUTE1
, S05_SPRVSR_DP
, S05_NAME
, S05_INSTANCE
, S05_SPRVSR_LVL5_PK
, S04_USER_ATTRIBUTE5
, S04_USER_ATTRIBUTE4
, S04_USER_ATTRIBUTE3
, S04_USER_ATTRIBUTE2
, S04_USER_ATTRIBUTE1
, S04_SPRVSR_DP
, S04_NAME
, S04_INSTANCE
, S04_SPRVSR_LVL4_PK
, S03_USER_ATTRIBUTE5
, S03_USER_ATTRIBUTE4
, S03_USER_ATTRIBUTE3
, S03_USER_ATTRIBUTE2
, S03_USER_ATTRIBUTE1
, S10_USER_ATTRIBUTE5
, S10_USER_ATTRIBUTE4
, S10_USER_ATTRIBUTE3
, S10_USER_ATTRIBUTE2
, S10_USER_ATTRIBUTE1
, S10_SPRVSR_DP
, S10_NAME
, S10_INSTANCE
, S02_USER_ATTRIBUTE5
, S10_SPRVSR_LVL10_PK
, S02_USER_ATTRIBUTE4
, S02_USER_ATTRIBUTE3
, S02_USER_ATTRIBUTE2
, S02_USER_ATTRIBUTE1
, S02_SPRVSR_DP
, S03_SPRVSR_DP
, S03_NAME
, S03_INSTANCE
, S03_SPRVSR_LVL3_PK
, S01_USER_ATTRIBUTE5
, S01_USER_ATTRIBUTE4
, S01_USER_ATTRIBUTE3
, S01_USER_ATTRIBUTE2
, S01_USER_ATTRIBUTE1
, S01_INSTANCE
, S01_SPRVSR_DP
, S01_NAME
, S01_SPRVSR_LVL1_PK
, S02_NAME
, S02_INSTANCE
, S02_SPRVSR_LVL2_PK
, S07_INSTANCE
, S07_SPRVSR_LVL7_PK
, S06_USER_ATTRIBUTE5
, S15_LAST_UPDATE_DATE
, S15_CREATION_DATE
, S14_LAST_UPDATE_DATE
, S14_CREATION_DATE
, S13_LAST_UPDATE_DATE
, S13_CREATION_DATE
, S12_LAST_UPDATE_DATE
, S12_CREATION_DATE
, S11_LAST_UPDATE_DATE
, S11_CREATION_DATE
, S09_LAST_UPDATE_DATE
, S09_CREATION_DATE
, S08_LAST_UPDATE_DATE
, S08_CREATION_DATE
, S07_LAST_UPDATE_DATE
, S06_LAST_UPDATE_DATE
, S06_CREATION_DATE
, S05_LAST_UPDATE_DATE
, S05_CREATION_DATE
, S04_LAST_UPDATE_DATE
, S04_CREATION_DATE
, S10_LAST_UPDATE_DATE
, S10_CREATION_DATE
, S03_LAST_UPDATE_DATE
, S03_CREATION_DATE
, S01_CREATION_DATE
, S01_LAST_UPDATE_DATE
, S02_LAST_UPDATE_DATE
, S02_CREATION_DATE
, S07_CREATION_DATE
, S01_NAME_DISPLAY
, S02_NAME_DISPLAY
, S03_NAME_DISPLAY
, S04_NAME_DISPLAY
, S05_NAME_DISPLAY
, S06_NAME_DISPLAY
, S07_NAME_DISPLAY
, S08_NAME_DISPLAY
, S09_NAME_DISPLAY
, S10_NAME_DISPLAY
, S11_NAME_DISPLAY
, S12_NAME_DISPLAY
, S13_NAME_DISPLAY
, S14_NAME_DISPLAY
, S15_NAME_DISPLAY
, ASGN_NAME_DISPLAY
, ASGN_BUSINESS_GROUP_ID
, ASGN_PERSON_TYPE_ID
, ASGN_EMPLOYEE_NUMBER
, ASGN_APPLICANT_NUMBER
FROM HRI.EDW_HR_PERSON_M;
HRI.EDW_HR_PERSON_M does not reference any database object
HRI.EDW_HR_PERSON_M is referenced by following:
APPS
EDW_HR_PERSON_M
|
|
|
|