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 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.
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.)
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.
You use the PN_SPACE_ASSIGN_CUST_PUB_V public view to retrieve customer assignment information.
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.
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.