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_LSTG

Object Details

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

This is the staging table for the Person level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Person dimension level table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_HR_PERM_ASSIGN_LSTG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ASSIGNMENT_PK
EDW_HR_PERM_ASSIGN_LSTG_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	COLLECTION_STATUS

Columns

Name	Datatype	Length	Comments
ASSIGNMENT_PK	VARCHAR2	(1000)	Textual Unique Identifier for the Person Level
BUSINESS_GROUP	VARCHAR2	(240)	Business Group of person
COLLECTION_STATUS	VARCHAR2	(30)	Loading status code for the record
CREATION_DATE	DATE		Standard who column
END_DATE	DATE		End date of person
ERROR_CODE	VARCHAR2	(2000)	Code used to store error messages
INSTANCE	VARCHAR2	(40)	Identity of Data Source
LAST_UPDATE_DATE	DATE		Standard who column
NAME	VARCHAR2	(1000)	Person Name for the Person Level
OPERATION_CODE	VARCHAR2	(30)	Code used by the loader program to determine whether to insert/update/delete this record
REQUEST_ID	NUMBER		Identifier used by collection program
ROW_ID	ROWID	(10)	Row identifier
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
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
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
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
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
EMPLOYEE_FLAG	VARCHAR2	(80)	Whether the person is an employee
APPLICANT_FLAG	VARCHAR2	(80)	Whether the person is an applicant
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
,      BUSINESS_GROUP
,      COLLECTION_STATUS
,      CREATION_DATE
,      END_DATE
,      ERROR_CODE
,      INSTANCE
,      LAST_UPDATE_DATE
,      NAME
,      OPERATION_CODE
,      REQUEST_ID
,      ROW_ID
,      START_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      NATIONAL_IDENTIFIER
,      PERSON_DP
,      PERSON_ID
,      PERSON_NUM
,      PLANNER_CODE
,      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
,      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
,      FULL_NAME
,      GENDER
,      GLOBAL_PERSON_ID
,      INTERNAL_LOCATION
,      KNOWN_AS
,      LAST_NAME
,      MAILSTOP
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NAME_PREFIX
,      NAME_SUFFIX
,      NATIONALITY
,      EMPLOYEE_FLAG
,      APPLICANT_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_LSTG;

Dependencies

[top of page]

HRI.EDW_HR_PERM_ASSIGN_LSTG does not reference any database object

HRI.EDW_HR_PERM_ASSIGN_LSTG is referenced by following:

APPS: EDW_HR_PERM_ASSIGN_LSTG