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 |