ACRM's Data Model is implemented as an abstraction of the underlying back-end DB, be it Oracle or MSSQL. In this model, records are identified by the three following values:
- Station ID: depending on the area of the product, this can be abbreviated as StaNo, StnID, or StatNo. Please refer to the manual section on Stations for more information.
- Record ID: abbreviated as SerNo, SeqNo, or, simply, ID.
- Info Area code: Info Areas take the place of tables in the ACRM Data Model, and are identified by a two-character code in the Maintenance module. StaNo/SerNo combinations are unique per Info Area, but can be re-used for records in other Info Areas.
StaNo and SerNo
The Station and Record IDs are stored for every record in the StaNo and SerNo fields (note that the exact field names change depending on the Info Area):
Finding the StaNo and SerNo of a record
These fields are not always displayed in the record's mask in CRM.win, or the ExpandView in CRM.web. To inspect the value of this field, you will need to follow these steps:
- CRM.win: With the record open, click on View > All Mask Fields
- CRM.web: The option to display all fields can be included in an Info Area's context menus in CRM.designer:
Alternatively, you can include the StaNo and SerNo fields in a given Expand view, as explained in Understanding Expand Views. The same can be done for Field Group Controls for Search&List, among others.
A UID or RecID is a unique identifier for a record constructed from the Station and Serial numbers for the record, and which may be preceded by a code identifying the Info Area. It is used in several areas of the product, including URLs for the records in CRM.web. They usually appear in the form of a hexadecimal code.
Finding the UID of a Record in the DB
Unlike the StaNo and SerNo, UIDs are not part of the Data Model in the form of a field. Instead, they appear in the DB, under the ID column. Note that, in this case, the UID will be displayed in base 10, instead of the usual Hex value:
Calculating the UID from a Record's SerNo and StaNo
It is possible to calculate a UID for a record using the SerNo and StaNo values, as described in Obtain the UID or RECID from a Record's StaNo and SerNo.