# \#sierra-login

**URL:** https://forum.innovativeusers.org/tag/sierra-login/227.md

[Latest](https://forum.innovativeusers.org/latest.md) · [Categories](https://forum.innovativeusers.org/categories.md) · [Tags](https://forum.innovativeusers.org/tags.md)

---

## [Using the Locations Served or portloca flat file in a query with iii\_user](https://forum.innovativeusers.org/t/using-the-locations-served-or-portloca-flat-file-in-a-query-with-iii-user/2665)

<div class="topic-metadata">

**Author:** [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)\
**Replies:** 0\
**Last updated:** [October 10, 2025, 1:44pm UTC](https://forum.innovativeusers.org/t/using-the-locations-served-or-portloca-flat-file-in-a-query-with-iii-user/2665 "2025-10-10T13:44:06Z")

</div>

In the iii\_user table, there exists a numeric column named location\_group\_port\_number. This column is effectively a foreign key, but not to any table found in the Sierra PostgreSQL database. Instead it refers to the …