This content applies solely to Contract Writing, which must be purchased separately from the Appian base platform. This content was written for Appian 24.3 and may not reflect the interfaces or functionality of other Appian versions. |
IntroductionCopy link to clipboard
One way to customize the CW solution to your organization's needs is by modifying the reference data, which are the values in the reference data tables contained in the various interfaces in the solution.
The types of reference data in GCW are:
- Dropdown lists and their values.
- See Modifying Dropdown Lists for instructions on how to add and deactivate values in dropdown lists, and add new dropdown lists.
- Document templates.
You can identify reference data tables by looking for tables that have _R_
in the name, such as AS_GCW_R_DATA
.
This page describes the structure of the reference data tables.
Reference data tableCopy link to clipboard
Dropdown values for GCW are stored in the AS_GCW_R_DATA table. Updating this table allows you to control what dropdown values and lists display to end users moving through the award process. See Modifying Dropdown Lists for more information on how this table is used.
See the following table for a description of the fields in the AS_GCW_R_DATA
table.
Name | MySQL Data Type | Appian Data Type | Description |
---|---|---|---|
REF_DATA_ID | int(11) | Number (integer) | The primary key. |
REF_LABEL | varchar(255) | Text | The name that the end user will see in the dropdown list. |
REF_TYPE | varchar(255) | Text | What reference type the value is grouped by. For example, Evaluation Status. |
REF_ICON | varchar(50) | Text | The icon associated with the value. For more information, visit the Appian icons page. |
REF_COLOR | varchar(50) | Text | Determines the color associated with the data. Valid values: STANDARD, POSITIVE, NEGATIVE, ACCENT, or a specific hex value. For example, #FFBF00. |
SORT_ORDER | int(11) | Number (integer) | Determines the order of values displayed in the dropdown. |
IS_ACTIVE | tinyint(1) | Boolean | Determines if the value will display, or not. Valid values: 1, 0. 1 will display the value, and 0 will not display the value. |
CREATED_BY | varchar(255) | Text | The user who added the reference data originally. |
CREATED_DATETIME | timestamp | DateTime | The date and time that the reference data was originally added. |
MODIFIED_BY | varchar(255) | Text | The user who changed the reference data most recently. |
MODIFIED_DATETIME | timestamp | DateTime | The date and time that the reference data was most recently changed. |
See below for an example of what the first six columns of the reference data may look like:
REF_DATA_ID | LABEL | TYPE | REF_ICON | REF_COLOR | SORT_ORDER | IS_ACTIVE |
---|---|---|---|---|---|---|
1 | Draft | Award Status | spinner | SECONDARY | 1 | 1 |
2 | Days | Line Item Unit Measure | NULL | NULL | 1 | 1 |
17 | Contracting | Template Type | NULL | NULL | NULL | 1 |
24 | Weeks | Item Duration Unit | NULL | NULL | NULL | 1 |
25 | Approve | Review Type | thumbs-up | ACCENT | 1 | 1 |
35 | Waiver | Document Type | NULL | NULL | 5 | 1 |
76 | SF33 | Form Type | NULL | NULL | NULL | 1 |
Document Template reference data tableCopy link to clipboard
The AS_GCW_R_DOCUMENT_TEMPLATE
table stores the document templates needed for the Create Document from Template checklist item. Updating this table allows you to control what document templates are available for business users creating checklists.
See the following table for a description of the fields in the AS_GCW_R_DOCUMENT_TEMPLATE
table.
Name | MySQL Data Type | Appian Data Type | Description |
---|---|---|---|
DOCUMENT_TEMPLATE_ID | int(11) | Number (integer) | The primary key. |
DOCUMENT_NAME | varchar(255) | Text | The name of the template that will display to end users. |
FILE_TYPE | varchar(255) | Text | The type of document the template is. For example, DOCX or PDF. |
CREATED_BY | varchar(255) | Text | The user who added the reference data originally. |
CREATED_DATETIME | timestamp | DateTime | The date and time that the reference data was originally added. |
MODIFIED_BY | varchar(255) | Text | The user who changed the reference data most recently. |
MODIFIED_DATETIME | timestamp | DateTime | The date and time that the reference data was most recently changed. |
IS_ACTIVE | tinyint(1) | Boolean | Determines if the value will display, or not. Valid values: 1, 0. 1 will display the value and 0 will not display the value. |
See below for an example of what the columns of the required document table may look like.
CREATED_BY | CREATED_DATETIME | MODIFIED_BY | MODIFIED_DATETIME | IS_ACTIVE |
---|---|---|---|---|
appian.administrator | 2022-12-09 16:48:19 | appian.administrator | 2022-12-12 16:55:01 | 1 |
tom.co | 2022-12-09 16:48:19 | tom.co | 2022-12-09 16:48:19 | 1 |