(Properties) on the Fields tab of the Advanced Determination
Designer Properties screen.Click (Properties) on the Fields tab of the Advanced Determination
Designer Properties screen.
| Field | Description |
| Code | The unique code for the Advanced Determination Field. |
| Data Type | The data type for the Advanced Determination Field. |
| Default value | The default value for the Advanced Determination Field. |
| Unique | Check to make the Advanced Determination Field unique. At least one field must be unique to enable entering runtime data. |
| Localizable | Check to make the Advanced Determination Field localizable. |
| Business entity | Select which entity should be added to project when creating a GPM Project. The value should be FUID (from the Operation_Category table) for "Category", a unique field for "Determination", or OperationCode (from the Operation table) for "Operation". |
| Reference field | Enabled if the Business Entity is "Determination". Only unique fields are available in this drop-down. |
| Reference project |
Appears when the Business Entity is set to Operation.
The drop-down contains PB Projects.
In runtime, when a PB Project is chosen, the Operation selected in the runtime values drop-down (Advanced Determination Values Editor) is validated against the selected Project. To generate a GPM package correctly, it is necessary to add the PB Project with the selected Operation as a dependency in a GPM Project. It is also possible not to select any Project in the Reference project field and still generate a GPM package. For details about PB Projects, see Process Builder Help. |
| Editor source type | The editor source type for the Advanced Determination Field. See the Editor Source Types table below. |
| Short/Medium/Extended description | The description of the Advanced Determination Field. |
 (Edit
languages)
|
Click to add, edit, and remove languages for the description fields. |
An Advanced Determination Field's properties can not be edited if the Advanced Determination has at least one revision in an Active status.
| Editor Source Type | Description |
| Constant | A constant value. The default value will be displayed when a new row is created. |
| Long Constant | A constant value that can be edited with a multiline editor. The default value will be displayed when a new row is created. |
| SQL Dictionary | A SQL command provided by the user that is displayed as a drop-down in Edit Values. This command can only use system parameters (see Query Editor). |
| SQL Dynamic Dictionary |
A SQL command provided by the user that is displayed as a drop-down in Edit Values. This command can use both system and custom parameters (see Query Editor). There is a sliding cache to store the results of each executed dynamic SQL statement. Unused items stay in the cache for the period specified (in seconds) in the value of the DeterminationCacheSlidingExpirationSpan Central Configuration key. Default value is 600 (10 minutes). |
| Static Dictionary | A static key/value list that is displayed as a drop-down in Edit Values. When selected, an Editor Source Parameter grid will appear where the list can be edited. |
System Parameters can be used in the Query Editor. After typing "@" in the query, the System Parameters will be available in the drop-down. To display values for inactive entries, use DET2_* tables instead of DET2_* views in the SQL statement.
Supported System Parameters are:
| Parameter | Description |
| CurrentLocalDatetime | Standard system parameter. |
| CurrentUtcDatetime | Standard system parameter. |
| Det2ID | The ID of the current Determination (ID from table DET2). Can be used in SQL Dictionary and SQL Dynamic Dictionary. |
| Det2ValuesRevisionID | The ID of the current Revision (ID from table DET2_VALUES_REVISION). Can be used in SQL Dictionary and SQL Dynamic Dictionary. |
| EmployeeID | Standard system parameter. |
| EmployeeNo | Standard system parameter. |
| EquipmentID | Standard system parameter. |
| Facility | Standard system parameter. |
| ID | The ID of the current entry (ID from table DET2_ENTRY). Can be used in SQL Dynamic Dictionary. |
| LanguageID | Standard system parameter. |
| ParentDet2EntryID | The ID of the parent entry (ParentDet2EntryID from table DET2_ENTRY). Can be used in SQL Dynamic Dictionary. |
| WorkCenter | Standard system parameter. |
Example: "SELECT Code, Code AS Text FROM DET2_PORTAL_FORM_CONTROL WHERE ParentID =@ID AND Code IS NOT NULL AND Type != 24"
| Field | Description |
| Last Update On | The date and time of the latest modifications. |
| Last Updated By | The unique ID of the user who performed the latest modifications. |
| Created On | The date and time when the entity was created in the database. |
| Created By | The unique ID of the user who created the entity. |