Skip Headers

Oracle Property Manager Implementation Guide
Release 12.1
Part Number E13611-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Public Views

Views are customized presentations of the data in one or more tables. In other words, views are logical tables whose data are not stored permanently. Public views provide read-only access so you can use them for custom reporting and similar requirements. For information on how to modify Oracle Property Manager data using third-party software, see Oracle Property Manager Open Interfaces.

This appendix covers the following topics:

Oracle Property Manager Public Views

Oracle Property Manager provides public views based on location and space assignment tables. Third-party vendors can use these public views to access location and space assignment data in Oracle Property Manager.

PN_LOCATIONS_PUB_V

You use the PN_LOCATIONS_PUB_V public view to access location information. By default, the public view displays area and vacancy data as of the system date or the location end date (whichever is earlier.)

Retrieving Data for a Particular Date

You can specify the date for which you want area and vacancy data by calling the PNP_UTIL_FUNC.SET_AS_OF_DATE_4_LOC_PUBVIEW (userDate) API before retrieving data from the PN_LOCATIONS_PUB_V view.

PNP_UTIL_FUNC.SET_AS_OF_DATE_4_LOC_PUBVIEW (userDate) sets the date for which locations space availability and assignment information should be displayed.

PN_SPACE_ASSIGN_CUST_PUB_V

You use the PN_SPACE_ASSIGN_CUST_PUB_V public view to retrieve customer assignment information.

PN_SPACE_ASSIGN_EMP_PUB_V

You use the PN_SPACE_ASSIGN_EMP_PUB_V public view to retrieve information on employee space assignments. By default, the public view displays data as of the system date.

Retrieving Data for a Particular Date

You can specify the date for which you want space assignment data by calling the PNP_UTIL_FUNC.SET_AS_OF_DATE_4_EMP_PUBVIEW(userDate) API before retrieving data from the PN_SPACE_ASSIGN_EMP_PUB_V public view.

PNP_UTIL_FUNC.SET_AS_OF_DATE_4_EMP_PUBVIEW(userDate) sets the date for which employee data (for example, the employee’s job code from Oracle HRMS) is retrieved.