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

Oracle Property Manager Open Interfaces

This chapter describes the open interfaces in Oracle Property Manager.

This chapter covers the following topics:

Oracle Property Manager Open Interfaces

You can use the space open interface to extract employee space assignment data and space definition data from vendors' applications, and import this data into Oracle Property Manager. You can also export data from Oracle Property Manager into vendors' applications.

Related Topics

Property Manager Open Interface Tables

Computer-Assisted Facilities Management, Oracle Property Manager User Guide

Exporting Location Information

You can export location or space assignment information from Oracle Property Manager to computer-assisted design (CAD) or computer-assisted facilities management (CAFM) applications using the Export to CAD Interface concurrent program. For details, see Export to CAD Interface, Oracle Property Manager User Guide.

Importing Property Information

You can import employee space assignment entries or location records into Oracle Property Manager by using the Import from CAD concurrent program. After importing the space assignment or location information, you can create, update, or delete employee space assignments or modify location information. For details, see Import to CAD Interface, Oracle Property Manager User Guide.

Purge Open Interface Tables

Use the Purge Open Interface Tables concurrent program after you submit the Export to CAD Interface or Import from CAD concurrent program. This program purges records from the Property Manager open interface tables PN_SPACE_ASSIGN_ITF and PN_LOCATIONS_ITF.

For details on the Purge Interface Tables concurrent program, see Purge Interface Tables, Oracle Property Manager User Guide.

Integration with eAM Property Manager

The integration between Oracle Property Manager and eAM enables eAM assets to correspond with locations defined in Oracle Property Manager. The information transferred from Oracle Property Manager are the three-level land or building hierarchies, and the associated Location codes within Oracle Property Manager. See Export Locations to Enterprise Asset Management, Oracle Property Manager User Guide.

Related Topics

Overview of eAM Property Manager, Oracle Enterprise Asset Management User’s Guide

Oracle Property Manager Open Interface Table Descriptions

The following sections list the columns in the Oracle Property Manager Open Interface tables and indicate which columns require values for importing and exporting information to and from Oracle Property Manager. For more information, see the Oracle eTechnical Reference Manual. See also: Table Definitions (Oracle Property Manager Technical Reference Manual).

Although columns are validated against columns in other tables, the tables have no foreign key relationships.

Oracle Property Manager includes the following interface tables:

PN_LOCATIONS_ITF

The following sections describe the column names and requirements for the PN_LOCATIONS_ITF table.

BATCH_NAME

Enter the name of the batch. The interface program looks for this column in the table to select the records that need to be processed.

Variable Description
Validation: None
Destination: None

ENTRY_TYPE

Specify the type of the entry being made.

Variable Description
Validation: Value must be one of the following:
A: Add (create a new row - used when adding a new location)
R: Replace (replace the existing row value only if the column in the interface table is not null - used when changing only selected location data)
U: Update (update the existing row value with the null or non-null interface table column value - used when changing all location data)
Destination: None

LOCATION_ID

Internal identifier for the location, generated from an Oracle database sequence. This should be mapped or tagged to the vendor's own location identifier for reference and subsequent updates to the location record.

Variable Description
Validation: If the ENTRY_TYPE is U or R, then the value you enter must be for an existing, valid location, present in PN_LOCATIONS.LOCATION_ID. If the ENTRY_TYPE is A, then the value must be unique and must not be present in PN_LOCATIONS.LOCATION_ID.
Destination: PN_LOCATIONS.LOCATION_ID

LOCATION_TYPE_LOOKUP_CODE

Specify the type of location, for example, building, floor, office, land, parcel, or section.

Variable Description
Validation: The value must be a valid value present in the system defined lookup code, PN_LOCATION_TYPES.
Destination: PN_LOCATIONS.LOCATION_TYPE_ LOOKUP_CODE

LOCATION_CODE

Enter the location code. This is a system generated unique value for every location defined in Oracle Property Manager.

Variable Description
Validation: If the ENTRY_TYPE is U or R, then the code you enter must be for an existing, valid location, present in PN_LOCATIONS.LOCATION_CODE. If the ENTRY_TYPE is A, then the code must be unique and must not be present in PN_LOCATIONS.LOCATION_CODE.
Destination: PN_LOCATIONS.LOCATION_CODE

BUILDING

Enter the name of the building or land.

Variable Description
Validation: None
Destination: PN_LOCATIONS.BUILDING

FLOOR

Enter the name of the floor or parcel.

Variable Description
Validation: None
Destination: PN_LOCATIONS.FLOOR

OFFICE

Enter the name of the office or section.

Variable Description
Validation: None
Destination: PN_LOCATIONS.OFFICE

LEASED_OR_OWNED

Enter the tenure of the location. Default to Leased.

Variable Description
Validation: The value must be a valid one from the system defined lookup code PN_LEASED_OR_OWNED. The pre-seeded values are Leased, Managed, Mixed, and Owned.
Destination: PN_LOCATIONS.LEASED_OR_OWNED

ADDRESS_LINE1

Enter the address of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.ADDRESS_LINE1

ADDRESS_LINE2

Enter the address of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.ADDRESS_LINE2

ADDRESS_LINE3

Enter the address of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.ADDRESS_LINE3

ADDRESS_LINE4

Enter the address of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.ADDRESS_LINE4

COUNTY

Enter the county of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.COUNTY

CITY

Enter the city of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.CITY

STATE

Enter the state of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.STATE

PROVINCE

Enter the province of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.PROVINCE

ZIP_CODE

Enter the zip code of the building or land.

Variable Description
Validation: None
Destination: PN_ADDRESSES.ZIP_CODE

COUNTRY

Enter the country where the building or land is located.

Variable Description
Validation: Must be populated only for land and buildings. The value must be a valid value in the system-defined lookup code, FND_TERRITORIES.
Destination: PN_ADDRESSES.COUNTRY

ADDRESS_STYLE

Used as a context value for the flexible address format descriptive flexfield.

Variable Description
Validation: None
Destination: PN_ADDRESSES.ADDRESS_STYLE

MAX_CAPACITY

Enter the maximum capacity of the location.

Variable Description
Validation: The maximum capacity of a location must always be greater than or equal to its optimum capacity. This field must be populated only for Office and Section. This value rolls up for Buildings, Land, Floors, and Parcels, and therefore, cannot be entered for them.
Destination: PN_LOCATIONS.MAX_CAPACITY

OPTIMUM_CAPACITY

Enter the optimum capacity of the location.

Variable Description
Validation: The optimum capacity of a location must always be less than or equal to its maximum capacity. This field must be populated only for Office and Section. This value is rolled up for Buildings, Land, Floors, and Parcels, and therefore, cannot be entered for them.
Destination: PN_LOCATIONS.OPTIMUM_CAPACITY

RENTABLE_AREA

Enter the rentable area of the location. The rentable area is captured in both IFMA and BOMA space measurement standards.

Variable Description
Validation: The rentable area of a location must always be less than or equal to its gross area, and greater than or equal to its usable area. This field must be populated only for Office and Section. This value rolls up for Buildings, Land, Floors, and Parcels and therefore, must not be entered for them.
Destination: PN_LOCATIONS.RENTABLE_AREA

USABLE_AREA

Enter the usable area of the location. The usable area is captured in both IFMA and BOMA space measurement standards.

Variable Description
Validation: The usable area of a location must always be less than or equal to its rentable area and greater than or equal to its assignable area. This field must be populated only for Office and Section. This value is rolled up for Buildings, Land, Floors, and Parcels and therefore must not be entered for them.
Destination: PN_LOCATIONS.USABLE_AREA

ALLOCATE_COST_CENTER_CODE

Enter the cost center to which the location is allocated.

Variable Description
Validation: None
Destination: PN_LOCATIONS.ADDRESS_STYLE

UOM_CODE

Enter the unit of measure code. Oracle seeded examples are SFT (square feet), SYD (square yards), and SMT (square meters).

Variable Description
Validation: The value must be a valid value present in the system-defined lookup code, PN_UNITS_OF_MEASURE.
Destination: PN_LOCATIONS.UOM_CODE

PARENT_LOCATION_ID

Enter the ID of the parent location. In Property Manager, Building is the parent of Floor, and Floor is the parent of Office. Land, Parcel, and Section have a similar parent-child relationship. Also, Land and Buildings are considered children of Property. For example, the PARENT_LOCATION_ID of a floor will be that of the parent building.

Variable Description
Validation: The PARENT_LOCATION_ID you enter must belong to a valid location, which is a parent of the current location, and must be present either in PN_LOCATIONS.LOCATION_ID or in PN_LOCATIONS_ITF.LOCATION_ID.
Destination: PN_LOCATIONS.PARENT_LOCATION_ID

LAST_UPDATE_DATE

An Oracle Standard Who column. Enter the last update date for this record. Property Manager uses this date for reference and audit purposes only.

Variable Description
Validation: Must be in valid date format. Must be populated only if ENTRY_TYPE is U. Must be left null in all other cases.
Destination: None

NEW_ACTIVE_START_DATE

This is an Oracle Standard Who column.

Variable Description
Validation: When the start date is updated from the interface table, the import program validates for location overlaps, location gaps, and active tenancies dates.
Destination: PN_LOCATIONS.ACTIVE_START_DATE

NEW_ACTIVE_END_DATE

This is an Oracle Standard Who column.

Variable Description
Validation: When the end date is updated from the interface table, the import program validates for location overlaps, location gaps, and active tenancies dates.
Destination: PN_LOCATIONS.ACTIVE_END_DATE

LAST_UPDATE_LOGIN

This is an Oracle Standard Who column.

Variable Description
Validation: This column must be left null.
Destination: None

CREATED_BY

This is an Oracle Standard Who column.

Variable Description
Validation: This column must be left null.
Destination: None

LAST_UPDATED_BY

This is an Oracle Standard Who column.

Variable Description
Validation: This column must be left null.
Destination: None

ATTRIBUTE_CATEGORY

Enter the descriptive flexfield category for the descriptive flexfield information you want to import.

Variable Description
Validation: None
Destination: PN_LOCATIONS.ATTRIBUTE_CATEGORY

ATTRIBUTE[1-15]

Enter descriptive flexfield information that you want to import. The structure of the information you enter in these columns ( data types, value sets) must match the structure of the descriptive flexfield segments you have defined for your properties and/or sites, or you will experience validation problems when you try to access the information in the location windows.

Variable Description
Validation: None
Destination: PN_LOCATIONS.ATTRIBUTE[1-15]

ADDR_ATTRIBUTE_CATEGORY

Enter the descriptive flexfield category for the descriptive flexfield information you want to import for the location address.

Variable Description
Validation: None
Destination: PN_ADDRESSES.ATTRIBUTE_CATEGORY

ADDR_ATTRIBUTE[1-15]

Enter descriptive flexfield information that you want to import for the location address. The structure of the information you enter in these columns (data types, value sets) must match the structure of the descriptive flexfield segments you have defined for your addresses, or you will experience validation problems when you try to access the information using the forms.

Variable Description
Validation: None
Destination: PN_ADDRESSES.ATTRIBUTE[1-5]

TRANSFERRED_TO_CAD

A flag specifying if the record was transferred from Property Manager to a CAFM vendor.

Variable Description
Validation: This column must be left null.
Destination: None

TRANSFERRED_TO_PN

A flag specifying if the record was transferred from a CAFM vendor to Property Manager.

Variable Description
Validation: This column must be left null.
Destination: None

ERROR_MESSAGE

Used by Property Manager Import/Export programs to indicate validation or other errors encountered while running the program, in conjunction with ERROR_CODE.

Variable Description
Validation: This column must be left null.
Destination: None

SOURCE

Indicates a CAFM vendor or other source (such as a spreadsheet).

Variable Description
Validation: The value must be a valid value present in the user defined lookup code, PN_SOURCE.
Destination: PN_LOCATIONS.SOURCE

REQUEST_ID

Keeps track of the concurrent request during which this row was created or updated.

Variable Description
Validation: This column must be left null.
Destination: None

PROGRAM_APPLICATION_ID

Keeps track of information about the concurrent program that created or updated each row, in conjunction with the PROGRAM_ID.

Variable Description
Validation: This column must be left null.
Destination: None

PROGRAM_ID

Keeps track of information about the concurrent program that created or updated each row, in conjunction with the PROGRAM_APPLICATION_ID.

Variable Description
Validation: This column must be left null.
Destination: None

PROGRAM_UPDATE_DATE

Stores the date on which the concurrent program created or updated the row.

Variable Description
Validation: This column must be left null.
Destination: None

SPACE_TYPE_LOOKUP_CODE

Used to track how the space is being utilized.

Variable Description
Validation: The value must be a valid value present in the user defined lookup code, PN_SPACE_TYPE_LOOKUP_CODE.
Destination: PN_LOCATIONS.SPACE_TYPE_LOOKUP_ CODE

GROSS_AREA

Enter the gross area of the location. Property Manager measures gross area only for Land and Buildings, as a part of IFMA Space Measurement Standard.

Variable Description
Validation: Must be entered only if the location_type_lookup_code is LAND or BUILDING. Also, when populated, the Gross Area must always be greater than or equal to the rentable area.
Destination: PN_LOCATIONS.GROSS_AREA

ASSIGNABLE_AREA

Enter the assignable area of the location. The assignable area is captured only by IFMA Space Measurement Standard.

Variable Description
Validation: The assignable area of a location must always be less than or equal to its usable area. This field must be populated only for Office and Section. This value rolls up for Buildings, Land, Floors, and Parcels and hence must not be entered for them.
Destination: PN_LOCATIONS.ASSIGNABLE_AREA

CLASS

Used to categorize real estate (such as office building).

Variable Description
Validation: Must be a valid value in PN_CLASS_TYPE
Destination: PN_LOCATIONS.CLASS

STATUS_TYPE

Indicates whether the location is active or inactive.

Variable Description
Validation: Must be either A (active) or I (inactive).
Destination: PN_LOCATIONS.STATUS

SUITE

Enter the suite information for an office.

Variable Description
Validation: Must be populated only if LOCATION_Type_LOOKUP_CODE is office. The value must be a valid value present in the user defined lookup code, PN_SUITES.
Destination: PN_LOCATIONS.SUITE

COMMON_AREA

Enter the common area of the location. The common area is captured only by IFMA Space Measurement Standard.

Variable Description
Validation: The common area of a location must always be less than or equal to its usable area. This field must be populated only for Office and Section. This value rolls up for Buildings, Land, Floors, and Parcels, and therefore, must not be entered for them.
Destination: PN_LOCATIONS.COMMON_AREA

COMMON_AREA_FLAG

If the value is Y, then the office/section being defined is a common area and the COMMON_AREA field becomes mandatory. If the value is N, then the office/section being defined is not a common area and ASSIGNABLE_AREA field becomes mandatory. The default is N.

Variable Description
Validation: None
Destination: PN_LOCATIONS.COMMON_AREA_FLAG

PN_EMP_SPACE_ASSIGN_ITF

The following sections describe the column names and requirements for the PN_EMP_SPACE_ASSIGN_ITF table.

BATCH_NAME

Enter the name of the batch. The interface program looks for this column in the table to select the records that need to be processed.

Variable Description
Validation: None
Destination: None

ENTRY_TYPE

Specify the type of the entry being made.

Variable Description
Validation: The value must be one of the following:
A: Add (Create a new row)
U: Update (Modify an existing row)
R: Replace (Replace an existing row)
Destination: None

COST_CENTER_CODE

Enter the cost center of the employee who is being assigned.

Variable Description
Validation: The COST_CENTER_CODE you enter must be for an existing one present in COST_CENTER_CODE, defined in Oracle HR.
Destination: PN_SPACE_ASSIGN_EMP.COST_CENTER_CODE

LOCATION_ID

Enter the Location ID of the location that is being assigned.

Variable Description
Validation: The LOCATION_ID you enter must be for an existing, valid location, present in PN_LOCATIONS.LOCATION_ID.
Destination: PN_SPACE_ASSIGN_EMP.LOCATION_ID.

ALLOCATED_AREA

Enter the area assigned to the employee. Note that this value is not a percent of the location area.

Variable Description
Validation: When the Automatic Space Assignment option is set to YES, the allocated area for the space is automatically calculated as USABLE_AREA/total number of space assignments to a location. If the Automatic Space Assignment option is set to NO, this column must be populated, and the assigned area must be less than or equal to the vacant area of the location.
Destination: PN_SPACE_ASSIGN_EMP.ALLOCATED_AREA.

EMPLOYEE_SPACE_ASSIGN_ID

The internal identifier for the assignment, generated from an Oracle database sequence. This should be mapped or tagged to the vendor's own space assignment identifier for reference and subsequent updates to the space assignment record.

Variable Description
Validation: If the ENTRY_TYPE is U or R, then the value you enter must be for an existing, valid assignment, present in PN_SPACE_ASSIGN_EMP.SPACE_ASSIGNMENT_ID. If the ENTRY_TYPE is A, then the value must be unique and must not be present in PN_SPACE_ASSIGN_EMP.SPACE_ASSIGNMENT_ID.
Destination: PN_SPACE_ASSIGN_EMP.SPACE_ASSIGNMENT_ID

PERSON_ID

The unique identifier for the employee to whom the space is allocated.

Variable Description
Validation: Must be a valid PERSON_ID in PER_PEOPLE_F.
Destination: PN_SPACE_ASSIGN_EMP.PERSON_ID

ALLOCATE_COST_CENTER_CODE

The cost center to which the space is charged.

Variable Description
Validation: None
Destination: PN_SPACE_ASSIGN_EMP.COST_CENTER_CODE

LAST_UPDATE_DATE

An Oracle Standard Who column. Enter the last update date for this record. Property Manager uses this date for reference and audit purposes only.

Variable Description
Validation: Must be in valid date format. Must be populated only if ENTRY_TYPE is U. Must be left null in all other cases.
Destination: None

CREATION_DATE

This is an Oracle Standard Who column.

Variable Description
Validation: This column must be left null.
Destination: None

LAST_UPDATE_LOGIN

This is an Oracle Standard Who column.

Variable Description
Validation: This column must be left null.
Destination: None

CREATED_BY

This is an Oracle Standard Who column.

Variable Description
Validation: This column must be left null.
Destination: None

LAST_UPDATED_BY

This is an Oracle Standard Who column.

Variable Description
Validation: This column must be left null.
Destination: None

ATTRIBUTE_CATEGORY

Enter the descriptive flexfield category for the descriptive flexfield information you want to import.

Variable Description
Validation: None
Destination: PN_SPACE_ASSIGN_EMP.ATTRIBUTE_ CATEGORY

ATTRIBUTE[1-15]

Enter descriptive flexfield information that you want to import. The structure of the information you enter in these columns (data types, value sets) must match the structure of the descriptive flexfield segments you have defined for your locations and/or sites, or you will experience validation problems when you try to access the information in the location windows.

Variable Description
Validation: None
Destination: PN_SPACE_ASSIGN_EMP.ATTRIBUTE[1-15]

TRANSFERRED_TO_CAD

A flag specifying if the record was transferred from Property Manager to a CAFM vendor.

Variable Description
Validation: This column must be left null.
Destination: None

TRANSFERRED_TO_PN

A flag specifying if the record was transferred from a CAFM vendor to Property Manager.

Variable Description
Validation: This column must be left null.
Destination: None

ERROR_MESSAGE

This column is used by Property Manager Import/Export programs to indicate validation or other errors encountered while running the program.

Variable Description
Validation: This column must be left null.
Destination: None

SOURCE

Indicates a CAFM vendor or other source (such as a spreadsheet).

Variable Description
Validation: The value must be a valid value present in the user-defined lookup code, PN_SOURCE.
Destination: PN_SPACE_ASSIGN_EMP.SOURCE

REQUEST_ID

Keeps track of the concurrent request during which this row was created or updated.

Variable Description
Validation: This column must be left null.
Destination: None

PROGRAM_APPLICATION_ID

Keeps track of the information about which concurrent program created or updated each row, in conjunction with the PROGRAM_ID.

Variable Description
Validation: This column must be left null.
Destination: None

PROGRAM_ID

Keeps track of the information about which concurrent program created or updated each row, in conjunction with the PROGRAM_APPLICATION_ID.

Variable Description
Validation: This column must be left null.
Destination: None

PROGRAM_UPDATE_DATE

Stores the date on which the concurrent program created or updated the row.

Variable Description
Validation: This column must be left null.
Destination: None

UTILIZED_AREA

Enter the number of occupants occupying the space.

Variable Description
Validation: None
Destination: PN_SPACE_ASSIGN_EMP.UTILIZED

EMP_ASSIGN_START_DATE

Enter the from occupancy date for the entity.

Variable Description
Validation: Must be in valid date format.
Destination: PN_SPACE_ASSIGN_EMP.EMP_ASSIGN_START_DATE

EMP_ASSIGN_END_DATE

Enter the to occupancy date for the entity.

Variable Description
Validation: Must be in valid date format. Must be later than or the same as the start date.
Destination: PN_SPACE_ASSIGN_EMP.EMP_ASSIGN_END_ DATE

PN_VOL_HIST_BATCH_ITF

The following sections describe the column names and requirements for the PN_VOL_HIST_BATCH_ITF table.

BATCH_ID

Volume history batch identifier.

Variable Description
Validation: None
Destination: None

BATCH_NAME

Batch name.

Variable Description
Validation: None
Destination: None

MIN_REP_DATE

Minimum reporting date for volume history batch.

Variable Description
Validation: None
Destination: None

MAX_REP_DATE

Maximum reporting date for volume history batch.

Variable Description
Validation: None
Destination: None

VOLUME_TYPE

Volume type of volume history batch that includes Actual, Forecasted, and Deduction.

Variable Description
Validation: The only possible values are Actual, Forecasted, and Deduction.
Destination: None

STATUS

Volume history batch status.

Variable Description
Validation: None
Destination: None

LAST_UPDATE_DATE

An Oracle Standard Who column. Property Manager uses this date for reference and audit purposes only.

Variable Description
Validation: None
Destination: None

LAST_UPDATED_BY

An Oracle Standard Who column.

Variable Description
Validation: None
Destination: None

CREATION_DATE

An Oracle Standard Who column.

Variable Description
Validation: None
Destination: None

CREATED_BY

An Oracle Standard Who column.

Variable Description
Validation: None
Destination: None

LAST_UPDATE_LOGIN

An Oracle Standard Who column.

Variable Description
Validation: None
Destination: None

PN_VOL_HIST_LINES_ITF

The following sections describe the column names and requirements for the PN_VOL_HIST_LINES_ITF table.

BATCH_ID

Volume history batch identifier.

Variable Description
Validation: None
Destination: None

VAR_RENT_ID

Variable rent agreement identifier.

Variable Description
Validation: Must be a valid VAR_RENT_ID in PN_VAR_RENTS_ALL table belonging to an existing variable rent term.
Destination: None

LINE_ITEM_ID

Line item identifier of the variable rent agreement.

Variable Description
Validation: This must be a valid Line Item ID in PN_VAR_LINES_ALL for a Period ID defined for Variable Rent ID.
Destination: If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.LINE_ITEM_ID
If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.LINE_ITEM_ID

REP_STR_DATE

Reporting start date.

Variable Description
Validation: Reporting Start Date should be equal to or greater than the Group Start Date in the PN_VAR_GRP_DATES_ALL table for a Variable Rent ID, Period ID, and Group Date ID.
Destination: If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.START_DATE
If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.START_DATE

REP_END_DATE

Reporting end date.

Variable Description
Validation: Reporting End Date should be equal to or greater than the Group End Date in the PN_VAR_GRP_DATES_ALL table for a Variable Rent ID and Period ID.
Destination: If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.END_DATE
If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.END_DATE

AMOUNT

Volume history batch line amount.

Variable Description
Validation: None
Destination: If Volume Type is Actual: PN_VAR_VOL_HIST_ALL.ACTUAL_AMOUNT
If Volume Type is Forecasted: PN_VAR_VOL_HIST_ALL.FORECASTED_ AMOUNT
If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.DEDUCTION_ AMOUNT

DEDUCTION_AMT

Volume history batch line deduction amount.

Variable Description
Validation: None
Destination: None

DEDUCTION_TYPE_CODE

Volume history batch line deduction type code.

Variable Description
Validation: None
Destination: None

STATUS

Volume history batch line status.

Variable Description
Validation: None
Destination: None

ERROR_LOG

Error log message for volume history batch line.

Variable Description
Validation: None
Destination: None

GROUP_DATE

Volume history batch line group date.

Variable Description
Validation: None
Destination: None

LAST_UPDATE_DATE

An Oracle Standard Who column. Property Manager uses this date for reference and audit purposes only.

Variable Description
Validation: None
Destination: None

LAST_UPDATED_BY

An Oracle Standard Who column.

Variable Description
Validation: None
Destination: None

CREATION_DATE

An Oracle Standard Who column.

Variable Description
Validation: None
Destination: None

CREATED_BY

An Oracle Standard Who column.

Variable Description
Validation: None
Destination: None

LAST_UPDATE_LOGIN

An Oracle Standard Who column.

Variable Description
Validation: None
Destination: None

REPORTING_DATE

The reporting date for the volume record.

Variable Description
Validation: None
Destination: If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.REPORTING_DATE
If Volume Type is Deduction: None

VOL_HIST_STATUS_CODE

The code specifying the status of the volume.

Variable Description
Validation: Must be a valid volume history status as defined in the PN_BATCH_TRANS_STATUS lookup
Destination: If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.VOL_HIST_STATUS_CODE
If Volume Type is Deduction: None

REPORT_TYPE_CODE

The code specifying the report type of the volume.

Variable Description
Validation: Must be a valid report type as defined in the PN_REPORT_TYPE lookup
Destination: If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.REPORT_TYPE_CODE
If Volume Type is Deduction: None

VOL_DEDUCT_ID

The identifier of the volume or deduction record.

Variable Description
Validation: None (value is automatically generated)
Destination: If Volume Type is Actual or Forecasted: PN_VAR_VOL_HIST_ALL.VOL_HIST_ID
If Volume Type is Deduction: PN_VAR_DEDUCTIONS_ALL.DEDUCTION_ID

PN_REC_EXP_ITF

The following sections describe the column names and requirements for the PN_REC_EXP_ITF table.

EXPENSE_LINE_DTL_ID

The internal identifier for the expense lines generated from an Oracle database sequence. It is populated by the extraction process and used to identify the expense line detail associated with the line of data.

Variable Description
Validation: None
Destination: None

PROPERTY_ID

Enter the property identifier from the properties table associated with the information in this row. The Property ID or the Location ID field, or both, must be entered.

Variable Description
Validation: The property type ID must validly exist in the PN_PROPERTIES table.
Destination: PN_REC_EXP_LINE_DTL_ALL.PROPERTY_ID

LOCATION_ID

Enter the location identifier from the locations table associated with the information in this row. The Property ID or the Location ID field, or both. must be entered.

Variable Description
Validation: The location ID must validly exist in the PN_LOCATIONS table.
Destination: PN_REC_EXP_LINE_DTL_ALL.LOCATION_ID

EXPENSE_TYPE_CODE

Enter the code of the Payment Term Purpose Type associated with the information in this row.

Variable Description
Validation: This column cannot be null. The purpose type code has to exist in FND LOOKUPS for the lookup type of PN_PAYMENT_PURPOSE_TYPE.
Destination: PN_REC_EXP_LINE_DTL_ALL.EXPENSE_TYPE_CODE

EXPENSE_ACCOUNT_ID

Enter the Account Code Combination ID associated with the information in this row.

Variable Description
Validation: This column cannot be null. The account code combination ID has to exist in the GL_CODE_COMBINATIONS table.
Destination: PN_REC_EXP_LINE_DTL_ALL.EXPENSE_ACCOUNT_ID

ACCOUNT_DESCRIPTION

Enter the General Ledger account description. This user specified field is optional.

Variable Description
Validation: None
Destination: PN_REC_EXP_LINE_DTL_ALL.ACCOUNT_DESCRIPTION

ACTUAL_AMOUNT

Enter the actual expense amount.

Variable Description
Validation: This column cannot be null.
Destination: PN_REC_EXP_LINE_DTL_ALL.BUDGETED_AMOUNT

BUDGETED_AMOUNT

Enter the budgeted expense amount.

Variable Description
Validation: None
Destination: PN_REC_EXP_LINE_DTL_ALL.BUDGETED_AMOUNT

CURRENCY_CODE

Enter the currency code of the recovery expense.

Variable Description
Validation: This column cannot be null.
Destination: PN_REC_EXP_LINE_ALL.CURRENCY_CODE

FROM_DATE

Enter the period start date to identify the beginning extraction period boundary.

Variable Description
Validation: This column cannot be null.
Destination: PN_REC_EXP_LINE_ALL.FROM_DATE

TO_DATE

Enter the period end date to identify the ending extraction period boundary.

Variable Description
Validation: This column cannot be null
Destination: PN_REC_EXP_LINE_ALL.TO_DATE

TRANSFER_FLAG

This flag indicates if the record was transferred from the interface table to the recoveries module. Choose N (not transferred) for all new records. The system will set the flag to Y (transferred) if export was successful and to E (erroneous) if it ended with an error.

Variable Description
Validation: This column cannot be null
Destination: None

MODE_FLAG

This parameter is reserved for future use when expense line corrections are allowed during a re-extraction process.

Variable Description
Validation: None
Destination: None

LAST_UPDATE_DATE

This is an Oracle standard who column.

Variable Description
Validation: This column cannot be null.
Destination: None.

LAST_UPDATED_BY

This is an Oracle standard who column.

Variable Description
Validation: This column cannot be null.
Destination: None.

CREATION_DATE

This is an Oracle standard who column.

Variable Description
Validation: This column cannot be null.
Destination: None.

CREATED_BY

This is an Oracle standard who column.

Variable Description
Validation: This column cannot be null.
Destination: None.

LAST_UPDATE_LOGIN

This is an Oracle standard who column.

Variable Description
Validation: None.
Destination: None.

ATTRIBUTE_CATEGORY

Enter the descriptive flexfield category of the descriptive flexfield information you want to import.

Variable Description
Validation: None
Destination: PN_REC_EXP_LINE_DTL_ALL.ATTRIBUTE_ CATEGORY

ATTRIBUTE[1-15]

Enter the descriptive flexfield information that you want to import. The structure of the information you enter in these columns, such as the datatypes and value sets, must match the structure of the descriptive flexfield segments defined for the properties or sites. If not, validation errors will occur when the information is accessed in the location windows.

Variable Description
Validation: None
Destination: PN_REC_EXP_LINE_DTL_ALL.ATTRIBUTE[1-15]

ORG_ID

Enter the ID of the operating unit identifier.

Variable Description
Validation: None
Destination: None