PeopleSoft Technical Blog

Sometimes we have to dig through the metadata tables to report or otherwise make sense of the PeopleSoft record structures. This post is pure reference, is credited to an old post on the web, and refers to the field in PSRECFIELD that determines the properties of a given field within the context of a record.

Note that the values are additive so if USEEDIT = 11 for a given field, then it would be a Key, Duplicate Order Key and Audit Field Add (or 1 + 2 + 8). Makes perfect sense, no?

PSRECFIELD.USEEDIT
bit    value  flag
  0        1  Key
  1        2  Duplicate Order Key
  2        4  System Maintained
  3        8  Audit Field Add
  4       16  Alternate Search Key
  5       32  List Box Item
  6       64  Descending Key
  7      128  Audit Field Change
  8      256  Required
  9      512  Translate Table Edit
 10     1024  Audit Field Delete
 11     2048  Search Key
 12     4096  Reasonable Date
 13     8192  Yes/No Table Edit
 14    16384  Prompt Table Edit
 15    32768  Auto-Update
 16    65536  Identifies field as Field in SubRecord
 17   131072  (Reserved / Not Used)
 18   262144  From Search Field
 19   524288  Through Search Field

Original source: http://www.sqrug.org/sqr-users/sqrusers_99q3/msg00424.html