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]

VIEW: APPS.PN_SPACE_ASSIGN_EMP_PUB_V

Object Details

Object Name:	PN_SPACE_ASSIGN_EMP_PUB_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PN.PN_SPACE_ASSIGN_EMP_PUB_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Identifies an employee space assignment and its attributes

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row Identifier
EMP_SPACE_ASSIGN_ID	NUMBER		Identifier of the employee space assignments row. Value is populated using the PN_SPACE_ASSIGN_EMP_S sequence
LOCATION_ID	NUMBER		Associates the employee space assignment with a location in PN_LOCATIONS_ALL
LOCATION_LOCATION_ID	NUMBER		Associates the employee space assignment with the location in PN_LOCATIONS_ALL
LOCATION_TYPE_LOOKUP_CODE	VARCHAR2	(30)	Type of location associated with the space assignment
LOCATION_SUITE_NAME	VARCHAR2	(30)	Name of the suite associated with the space assignment
LOCATION_CODE	VARCHAR2	(90)	Location Code of the location associated with the space assignment
ACTIVE_START_DATE	DATE		Date from which the location associated with the space assignment is active
ACTIVE_END_DATE	DATE		Date to which the location associated with the space assignment is active
PERSON_ID	NUMBER		Associates the employee space assignment with a person in PER_ALL_PEOPLE_F
EMP_EFFECTIVE_START_DATE	DATE		Date from which the employee associated with the space assignment is active
EMP_EFFECTIVE_END_DATE	DATE		Date to which the employee associated with the space assignment is active
ASSIGNMENT_ID	NUMBER		Assignment identifier of the employee associated with the employee space assignment
LAST_NAME	VARCHAR2	(150)	Last name of the employee
EMPLOYEE_NUMBER	VARCHAR2	(30)	Employee number
EMAIL_ADDRESS	VARCHAR2	(240)	Employee's e-mail address
FIRST_NAME	VARCHAR2	(150)	Employee's first name
FULL_NAME	VARCHAR2	(240)	Employee's full name
PERSON_TYPE_ID	NUMBER		Identifier of the employee's person type
EMPLOYEE_TYPE	VARCHAR2	(80)	Employee's Person Type
PHONE_NUMBER	VARCHAR2	(60)	Employee's phone number
POSITION_ID	NUMBER		Identifier of the employee's position
POSITION	VARCHAR2	(4000)	Employee's position
JOB_ID	NUMBER		Identifier of the employee's job
JOB	VARCHAR2	(700)	Employee's job
ORGANIZATION_ID	NUMBER		Identifier of the employee's organization
ORGANIZATION	VARCHAR2	(240)	Organization to which the employee belongs
EMPLOYMENT_CATEGORY	VARCHAR2	(30)	Identifier of the employee's category code
EMPLOYMENT_CATEGORY_MEANING	VARCHAR2	(80)	Employment Category of the employee
PROJECT_ID	NUMBER		Associates the employee space assignment with a task in PA_TASKS_ALL
TASK_ID	NUMBER		Associates the employee space assignment with a task in PA_TASKS_ALL
EMP_ASSIGN_START_DATE	DATE		Start date of the employee space assignment
EMP_ASSIGN_END_DATE	DATE		End date of the employee space assignment
COST_CENTER_CODE	VARCHAR2	(30)	Identifier of the cost center for the employee space assignment
CURRENT_COST_CENTER_CODE	VARCHAR2	(4000)	Identifier of the employee's current cost center
ALLOCATED_AREA_PCT	NUMBER		Percentage area allotted to the employee
ALLOCATED_AREA	NUMBER		Area allocated to the employee
UOM_CODE	VARCHAR2	(3)	Unit of measure used with the associated location
UTILIZED_AREA	NUMBER		Total area utilized at the associated location
EMP_SPACE_COMMENTS	VARCHAR2	(2000)	Comments regarding the employee space assignment
LAST_UPDATE_DATE	DATE		Standard Who column. Date on which a user last updated the row
LAST_UPDATED_BY	NUMBER		Standard Who column: User who last updated the row. This column is a foreign key to FND_USER.USER_ID.
CREATION_DATE	DATE		Standard Who column. Date on which the row was created
CREATED_BY	NUMBER		Standard Who column. User who created the row. Foreign key to FND_USER.USER_ID
LAST_UPDATE_LOGIN	NUMBER		Standard Who column: Operating system login of user who last updated the row. This column is a foreign key to FND_LOGINS.LOGIN_ID
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Definition of the Descriptive Flexfield structure
ATTRIBUTE1	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)	Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)	Descriptive Flexfield segment
ORG_ID	NUMBER	(15)	Organization Identifier
SOURCE	VARCHAR2	(80)	Name of the external application that created the employee row in Oracle Property Manager

Query Text

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


SELECT ROW_ID
,      EMP_SPACE_ASSIGN_ID
,      LOCATION_ID
,      LOCATION_LOCATION_ID
,      LOCATION_TYPE_LOOKUP_CODE
,      LOCATION_SUITE_NAME
,      LOCATION_CODE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      PERSON_ID
,      EMP_EFFECTIVE_START_DATE
,      EMP_EFFECTIVE_END_DATE
,      ASSIGNMENT_ID
,      LAST_NAME
,      EMPLOYEE_NUMBER
,      EMAIL_ADDRESS
,      FIRST_NAME
,      FULL_NAME
,      PERSON_TYPE_ID
,      EMPLOYEE_TYPE
,      PHONE_NUMBER
,      POSITION_ID
,      POSITION
,      JOB_ID
,      JOB
,      ORGANIZATION_ID
,      ORGANIZATION
,      EMPLOYMENT_CATEGORY
,      EMPLOYMENT_CATEGORY_MEANING
,      PROJECT_ID
,      TASK_ID
,      EMP_ASSIGN_START_DATE
,      EMP_ASSIGN_END_DATE
,      COST_CENTER_CODE
,      CURRENT_COST_CENTER_CODE
,      ALLOCATED_AREA_PCT
,      ALLOCATED_AREA
,      UOM_CODE
,      UTILIZED_AREA
,      EMP_SPACE_COMMENTS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SOURCE
FROM APPS.PN_SPACE_ASSIGN_EMP_PUB_V;

Dependencies

[top of page]

APPS.PN_SPACE_ASSIGN_EMP_PUB_V references the following:

APPS: FND_LOOKUP_VALUES; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; PER_ALL_ASSIGNMENTS_F; PER_ALL_PEOPLE_F; PER_JOBS; PER_PERSON_TYPES_TL; PER_PHONES; PNP_UTIL_FUNC - show dependent code; PN_LOCATIONS_ALL; PN_SPACE_ASSIGN_EMP_ALL

APPS.PN_SPACE_ASSIGN_EMP_PUB_V is not referenced by any database object