Property Fields

This section provides a list of property fields.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.

Name

Label

Data Type

Description

Entity Type to Which Property Refers

property_desc.pdentity

INTEGER

Integer value that corresponds to the type of entity to which the property belongs to.

ID

property_desc.propertyid

INTEGER

Unique internal identifier of the property in the system

Property ID

property_name.pn_propertyid

INTEGER

Unique internal identifier that corresponds to the property identifier

Property Label

property_desc.pdlabel

VARCHAR2

Unique external identifier of the property

Property Language

property_name.pn_lid

INTEGER

Integer that corresponds to the language defined for the property name.

Property Name

property_name.pntext

VARCHAR2

Name of the property

Text Entry Identifier

property_name.pnindex

VARCHAR2

Internal property name identifier (0-property name, -1 = property hint, other integer of string value - identifier of enumeration value)