View Object Model - Data / PS Tools
The View Object Model page of the Data / PS Tools section of the System Administrator Dashboard allows you to view information about database tables and fields in Lucernex.
To navigate to the View Object Model page:
-
Click Admin in the toolbar in the upper-right corner of the window.
The System Administrator Dashboard page opens.
-
Click View Object Model link in the Data / PS Tools section.
The View Object Model page opens.
-
Follow a procedure below.
Note:
The page will update as you apply filters.
To filter the View Object Model page:
-
Select the database table you want to view from the Show Table Details for field.
Important!
Selecting All Tables from this field may cause the system to lag. Consider applying other filters first, to narrow your results.
-
Select the Show Code Tables check box if you want to have the system display the code database tables in the Show Table Details for field.
In Lucernex, there are many "code" database tables which store values for your client-configured fields. If you choose to select this check box, these database tables will be displayed in the Show Table Details for field.
Examples of "code" database tables include the Document Content Code database table, the Job Function Code database table, and the ASC 842 Schedule Type Code database table.
-
Select one of four options:
-
All: Returns all field types.
-
Editable: Returns only editable fields.
-
Math: Returns only math fields.
-
Computed: Returns fields whose values are calculated by the system.
Note:
For example, the ExpAccrualAcct1Number is editable on the CodeExpenseType table, but computed on the AccrualTransaction table. This is because the value of the ExpAccrualAcct1Number field is configured by the user on the expense type record, and the value is pulled onto the accrual transaction by the system.
-
If you want to view fields which were added in a specific release, select the release number from the Added field.
-
If you want to view fields which were modified in a specific release, select the release number from the Modified field.
-
Select between two options:
The following columns appear on the View Object Model page. Not all columns may appear, depending upon what fields are returned by the system.
-
Field Name: the name of the field in the database
-
Required: indicates whether the field is required
Note:
If the value in this column is blank, it means the field is not required. If the value in this column reads Required, it means the field is required.
-
Type: a short descriptor of the field type
For example, Percentage, Currency, Date, or Text.
-
UI Label: the name of the field as it appears in the Report Builder
-
Maximum Size: the field character limit or maximum value. Not all fields will have a value in this column.
-
Version Added / Added: the version this field was added to Lucernex
-
Modified: the last version when this field was modified
-
Change Summary: any notes from the development team regarding the changes made
Not all fields will have a value in this column.
Filter the View Object Model Page