Re: HD 6.0 - Field Attributes

[Ian Trimnell]

** Sanford, Claire wrote: Does anyone know where Remedy stores the attributes for a field? Ie 0=New, 1=Assigned? Is this in a table somewhere??? Our DBA is trying to pull the data without using the ARODBC and he can't seem to find the value instead of just the integer. Thanks! ARS 6.3 HD 6 Oracle 10 something Claire, This information is stored in the field_enum_values table.  Cross reference the schemaId of the table (found in arschema) and you should find all the values for any enumerated fields there. HTH Ian Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support & Information Team, Academic & Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741   web: http://www.open.ac.uk/ __20060125_______________________This posting was submitted with HTML in it___