LINFO returns Location information such as Description, Address, etc for the specified Location.

SYNTAX:

LINFO(Location, Field)

Location: The Location Name or LocId (the internal key field) to retrieve field information for.  Can be a string (i.e. “Influent”),a cell reference (i.e. C2) that contains a string, a numeric id (1), or a cell reference that contains a number. 

Field: Which field to retrieve from the location table.  Valid settings include:

AUDITUSER 
OWNER
AUDITTIMESTAMP 
NOTES
LOCID 
LOCIDTYPE
LOCATION
LOCATION_PATH or PATH - The full location path separated by \. 
CHILDREN_LIST - A comma seperated list of the LOCIDs of the Children (all levels) of the specfied location.
PARENTID - LOCID of Location's Parent.
AREAID
DESCRIPTION 
ACRES
RECORDER 
CROP
SITEADDRESS 
APPSEASONFROM
SITESTATE 
APPSEASONTO
SITECITY 
SITEZIP 
SITECOUNTRY 
SITECONTACT 
SITEEMAIL
SITEPHONE
SOILSERIES
SOILTEXTURE
SOILDRAINAGE
WATERTABLE
LEGALDESC
MAILADDRESS
PERMITNUMBER 
PERMITSTARTDATE 
PERMITENDDATE
MAILSTATE
MAILCITY
MAILZIP
MAILCOUNTRY
MAILCONTACT
MAILEMAIL
MAILPHONE
NAICS_SIC1 
NAICS_SIC2
PWSID
WSFID
SAMP_POINT_ID
LVL1_ID..LVL8_ID 
UD1 
UD2 
UD3 
UD4 
UD5
UD6
UD7
UD8
UD9
UD10
LOCATION_I.fieldname - The Location Additional Info field specified by fieldname. 

EXAMPLES:

LINFO("INFLUENT","PERMITNUMBER") returns the permitnumber for the location Influent

LINFO(17, "UD2") returns the LOCATION.UD2 field for location id 17. 

LINFO(17,"LOCATION_I.POPULATION_SERVED") returns the LOCATION_I.Population_Served (Additional info field) value for location id 17. 

LINFO(LINFO("24hr Comp","LVL1_ID"),"LOCATION") returns the Level 1 Location for the 24hr Comp location.