eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HRI.EDW_HR_PERM_ASSIGN_LTC

Object Details

Object Name:	EDW_HR_PERM_ASSIGN_LTC
Object Type:	TABLE
Owner:	HRI
FND Design Data:	BIS.EDW_HR_PERM_ASSIGN_LTC HRI.EDW_HR_PERM_ASSIGN_LTC
Subobject Name:
Status:	VALID

This is the level table for the Person level of the Person dimension. This stores the personal details of people within, or related to, the Enterprise.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_HR_PERM_ASSIGN_LTC_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_PK_KEY
EDW_HR_PERM_ASSIGN_LTC_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_PK ASSIGNMENT_PK_KEY
EDW_HR_PERM_ASSIGN_LTC_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ALL_FK

Columns

Name	Datatype	Length	Comments
ASSIGNMENT_PK	VARCHAR2	(1000)	Textual Unique Identifier for the Person Level
ASSIGNMENT_PK_KEY	NUMBER		Unique Warehouse Identifier for the Person Level
BUSINESS_GROUP	VARCHAR2	(240)	Business Group of person
CREATION_DATE	DATE		Standard who column
END_DATE	DATE		End date of person
INSTANCE	VARCHAR2	(40)	Identity of Data Source
LAST_UPDATE_DATE	DATE		Standard who column
NAME	VARCHAR2	(1000)	Person Name for the Person Level
START_DATE	DATE		Start date of the person
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
FULL_NAME	VARCHAR2	(240)	Concatenation of last name, title, first name, middle names and the name the person is known by
GENDER	VARCHAR2	(80)	Gender (e.g. Male or Female)
GLOBAL_PERSON_ID	VARCHAR2	(30)	Hidden Identifier for the Global Person from the data source
INTERNAL_LOCATION	VARCHAR2	(45)	Internal location of person
KNOWN_AS	VARCHAR2	(80)	Preferred name of person
LAST_NAME	VARCHAR2	(150)	Last name of person
MAILSTOP	VARCHAR2	(45)	Mailstop
MARITAL_STATUS	VARCHAR2	(30)	Marital status of person (e.g. Single, Divorced)
MIDDLE_NAMES	VARCHAR2	(60)	Middle names of person
NAME_PREFIX	VARCHAR2	(30)	Name prefix
NAME_SUFFIX	VARCHAR2	(30)	Name suffix
NATIONALITY	VARCHAR2	(30)	Nationality of person
NATIONAL_IDENTIFIER	VARCHAR2	(30)	National Identifier of the person
PERSON_DP	VARCHAR2	(1000)	Reserved for future use
PERSON_ID	NUMBER		Hidden identifier for the Person from the data source
PERSON_NUM	VARCHAR2	(30)	System generated Employee or Applicant Number for the person
PLANNER_CODE	VARCHAR2	(30)	Internal use only
ALL_FK	VARCHAR2	(40)	Textual Unique Identifier for the All People Level
ALL_FK_KEY	NUMBER		Unique Warehouse Identifier for the All People Level
BUYER_FLAG	VARCHAR2	(80)	Whether the person is a buyer
COUNTRY_OF_BIRTH	VARCHAR2	(90)	Country of birth
CRRSPNDNC_LANGUAGE	VARCHAR2	(30)	Correspondance language
DATE_EMP_DATA_VRFD	DATE		Date employee data was last verified
DATE_OF_BIRTH	DATE		Date of birth
DISABILITY_FLAG	VARCHAR2	(80)	Whether the person is classified as disabled
EFFECTIVE_END_DATE	DATE		Date tracked end date for the current person record
EFFECTIVE_START_DATE	DATE		Date tracked start date for the current person record
EMAIL_ADDRESS	VARCHAR2	(240)	Email address of person
FAST_PATH_EMPLOYEE	VARCHAR2	(30)	Whether the person is a fast path employee
FIRST_NAME	VARCHAR2	(150)	First name of person
FTE_CAPACITY	NUMBER		Full Time Equivalent capacity of person
PLANNER_FLAG	VARCHAR2	(80)	Whether the person is a planner
PREVIOUS_LAST_NAME	VARCHAR2	(150)	Previous last name of person
REGION_OF_BIRTH	VARCHAR2	(90)	Region of birth
REHIRE_RCMMNDTN	VARCHAR2	(30)	Re-hire recommendation
RESUME_EXISTS	VARCHAR2	(80)	Whether a resume exists for the person
RESUME_UPDATED_DATE	DATE		Date the resume was last updated
SALESREP_ID	NUMBER		Internal use only
SALES_REP_FLAG	VARCHAR2	(80)	Whether the Person is a Sales Representative
STUDENT_STATUS	VARCHAR2	(80)	Type of student, if applicable
SYS_GEN_FLAG	VARCHAR2	(80)	Internal use only
TITLE	VARCHAR2	(30)	Name Title (e.g. Mr. or Mrs.)
TOWN_OF_BIRTH	VARCHAR2	(90)	Town of birth
APPLICANT_FLAG	VARCHAR2	(80)	Whether the person is an applicant
EMPLOYEE_FLAG	VARCHAR2	(80)	Whether the person is an employee
SPRVSR_LVL1_FK	VARCHAR2	(400)	Internal use only
SPRVSR_LVL1_FK_KEY	NUMBER		Internal use only
NAME_DISPLAY	VARCHAR2	(240)	Name Display
BUSINESS_GROUP_ID	NUMBER		Business Group Id
PERSON_TYPE_ID	NUMBER		Person Type Id
EMPLOYEE_NUMBER	VARCHAR2	(30)	Employee Number
APPLICANT_NUMBER	VARCHAR2	(30)	Applicant Number

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSIGNMENT_PK
,      ASSIGNMENT_PK_KEY
,      BUSINESS_GROUP
,      CREATION_DATE
,      END_DATE
,      INSTANCE
,      LAST_UPDATE_DATE
,      NAME
,      START_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      FULL_NAME
,      GENDER
,      GLOBAL_PERSON_ID
,      INTERNAL_LOCATION
,      KNOWN_AS
,      LAST_NAME
,      MAILSTOP
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NAME_PREFIX
,      NAME_SUFFIX
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      PERSON_DP
,      PERSON_ID
,      PERSON_NUM
,      PLANNER_CODE
,      ALL_FK
,      ALL_FK_KEY
,      BUYER_FLAG
,      COUNTRY_OF_BIRTH
,      CRRSPNDNC_LANGUAGE
,      DATE_EMP_DATA_VRFD
,      DATE_OF_BIRTH
,      DISABILITY_FLAG
,      EFFECTIVE_END_DATE
,      EFFECTIVE_START_DATE
,      EMAIL_ADDRESS
,      FAST_PATH_EMPLOYEE
,      FIRST_NAME
,      FTE_CAPACITY
,      PLANNER_FLAG
,      PREVIOUS_LAST_NAME
,      REGION_OF_BIRTH
,      REHIRE_RCMMNDTN
,      RESUME_EXISTS
,      RESUME_UPDATED_DATE
,      SALESREP_ID
,      SALES_REP_FLAG
,      STUDENT_STATUS
,      SYS_GEN_FLAG
,      TITLE
,      TOWN_OF_BIRTH
,      APPLICANT_FLAG
,      EMPLOYEE_FLAG
,      SPRVSR_LVL1_FK
,      SPRVSR_LVL1_FK_KEY
,      NAME_DISPLAY
,      BUSINESS_GROUP_ID
,      PERSON_TYPE_ID
,      EMPLOYEE_NUMBER
,      APPLICANT_NUMBER
FROM HRI.EDW_HR_PERM_ASSIGN_LTC;

Dependencies

[top of page]

HRI.EDW_HR_PERM_ASSIGN_LTC does not reference any database object

HRI.EDW_HR_PERM_ASSIGN_LTC is referenced by following:

APPS: EDW_HR_PERM_ASSIGN_LTC