Resource Location Fields

This section provides a list of resource location fields.

Field

Label

Data Type

Description

Latitude

location.lcoord_y

FLOAT

Geographic coordinate Y resolved for the location

Location Address

location.laddress

VARCHAR2

Address resolved for the location

Location City

location.lcity

VARCHAR2

City resolved for the location

Location ID

location.lid

INTEGER

Internal identifier for the location

Location Label

location.llabel

VARCHAR2

Label of the location which is assigned to the resource

Location Postal Code

location.lzip

VARCHAR2

ZIP/Postal code resolved for the location

Location State

location.lstate

VARCHAR2

State/Area resolved for the location

Location Type

provider_location.pltype

VARCHAR2

Type of the location which is assigned to the resource

Location by days

provider_location.plweekdays

INTEGER

Days of the week on which the location is assigned to the resource

Longitude

location.lcoord_x

FLOAT

Longitude

Resource External ID

provider.external_id

VARCHAR2

External identifier for resource with the location

Resource ID

provider_location.pl_pid

INTEGER

Identifier of the resource to which the location is assigned