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: PN.PN_EMP_SPACE_ASSIGN_ITF

Object Details

Object Name:	PN_EMP_SPACE_ASSIGN_ITF
Object Type:	TABLE
Owner:	PN
FND Design Data:	PN.PN_EMP_SPACE_ASSIGN_ITF
Subobject Name:
Status:	VALID

The PN_EMP_SPACE_ASSIGN_ITF interface table is used to Import or Export the CAD Space Data.
Scope: public
Product: PN
Lifecycle: active
Display Name: PN Employee Space Assignment Interface
Category: BUSINESS_ENTITY PN_EMPLOYEE_SPACE_ASSGNMENT

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PN_EMP_SPACE_ASSIGN_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	EMP_SPACE_ASSIGN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NAME	VARCHAR2	(30)	Yes	Name of the batch. Required when importing data into Oracle Property Manager
ENTRY_TYPE	VARCHAR2	(1)	Yes	The type of row. A indicates creation of new space assignment row, U indicates modification of space assignment row, and R indicates replacement of space assignment row. Required when importing data into Oracle Property Manager
EMP_SPACE_ASSIGN_ID	NUMBER			Identifier generated from an Oracle database sequence. Mapped to the SPACE_ALLOCATION_ID in PN_SPACE_ALLOCATIONS_ALL. Required when importing data into Oracle Property Manager
LOCATION_ID	NUMBER			Identifier location identifier used to associate location with employee or cost center space assignment. Mapped to the LOCATION_ID in PN_SPACE_ALLOCATIONS_ALL.
EMPLOYEE_ID	NUMBER			Identifier of employee. PERSON_ID from PER_PEOPLE_F
COST_CENTER_CODE	VARCHAR2	(30)		Cost center to which this space is charged. Mapped to COST_CENTER_CODE in PN_SPACE_ALLOCATIONS_ALL
ALLOCATED_AREA	NUMBER			Space assigned to the employee. Calculated as USEABLE_AREA / total number of space assignments in a location. Mapped to ALLOCATED_AREA_PCT in PN_SPACE_ALLOCATIONS_ALL and required when importing data into Oracle Property Manager.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column: Date on which the row was last updated.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column: User who last updated the row. This column is a foreign key to FND_USER.USER_ID.
CREATED_BY	NUMBER		Yes	Standard Who column: User who created the row. This column is a foreign key to FND_USER.USER_ID.
CREATION_DATE	DATE		Yes	Standard Who column: The date on which the row was created
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column: The 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
TRANSFERRED_TO_CAD	VARCHAR2	(1)		Flag indicating whether the row has been exported (Y or N). Determines whether the row should be purged. Used only by Oracle Property Manager.
TRANSFERRED_TO_PN	VARCHAR2	(1)		Flag indicating whether the row has been imported into Oracle Property Manager (Y or N). Determines whether row should be purged. Used only by Oracle Property Manager.
ERROR_MESSAGE	VARCHAR2	(240)		Message error code if import or export is unsuccessful
SOURCE	VARCHAR2	(80)		External application that created the row
REQUEST_ID	NUMBER			Concurrent program Who column: Identifier of the request for which the row was last updated. Foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID
PROGRAM_APPLICATION_ID	NUMBER			Concurrent program Who column: Identifier of the application whose program last updated this row. Foreign key to FND_APPLICATION.APPLICATION_ID
PROGRAM_ID	NUMBER			Concurrent program who column: The identifier of the program that last updated this row. This column is a foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID.
PROGRAM_UPDATE_DATE	DATE			Concurrent program who column: Date when the row was last updated.
EMP_ASSIGN_START_DATE	DATE			Start date of employee space assignment
EMP_ASSIGN_END_DATE	DATE			End date of the employee assignment
UTILIZED_AREA	NUMBER			Area of the location utilized for this space assignment
CHANGE_DATE	DATE			Date on which changes to the space assignment record are effective
CHANGE_MODE	VARCHAR2	(30)		Flag indicating whether the space assignment record should be corrected or updated. In case of update, existing space assignment is terminated and a new space assignment is created as of CHANGE_DATE.
PROJECT_ID	NUMBER			Associates the employee space assignment with a project in PA_PROJECTS_ALL
TASK_ID	NUMBER			Associates the employee space assignment with a task in PA_TASKS_ALL

Query Text

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


SELECT BATCH_NAME
,      ENTRY_TYPE
,      EMP_SPACE_ASSIGN_ID
,      LOCATION_ID
,      EMPLOYEE_ID
,      COST_CENTER_CODE
,      ALLOCATED_AREA
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TRANSFERRED_TO_CAD
,      TRANSFERRED_TO_PN
,      ERROR_MESSAGE
,      SOURCE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      EMP_ASSIGN_START_DATE
,      EMP_ASSIGN_END_DATE
,      UTILIZED_AREA
,      CHANGE_DATE
,      CHANGE_MODE
,      PROJECT_ID
,      TASK_ID
FROM PN.PN_EMP_SPACE_ASSIGN_ITF;

Dependencies

[top of page]

PN.PN_EMP_SPACE_ASSIGN_ITF does not reference any database object

PN.PN_EMP_SPACE_ASSIGN_ITF is referenced by following:

PN: PN_EMP_SPACE_ASSIGN_ITF#