It's best to look into the developer studio, open the form, find the field and there the mapping is unfortunately hard coded.
I don't have access to the dev studio. I only have access to the SQL Server Database.
1 of 1 people found this helpful
The database structure is documented here - The AR System data dictionary - BMC Remedy Action Request System 8.1 - BMC Documentation
The selection field aliases are in the field_enum_values table. So, to find the values for a field, start by finding the schemaID of the form
select schemaid from arschema where name='HPD:Help Desk'
This is 1510 on my server, use that to find the field ID for the Status field
select * from field where schemaid=1510 and fieldname like '%Status%' order by fieldname
And then lookup the aliases for that schema/fieldid
select * from field_enum_values where schemaid=1510 and fieldid=7 order by enumid
Exactly what I wanted. Thank you kind sir. Have a good day.