Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| STAGE_ID | int | 4 | null |
|
|
The checklist item ID |
||
| STAGE_DESCRIPTION | varchar | 50 | √ | null |
|
|
The checklist item description |
|
| STAGE_VERSION | int | 4 | √ | null |
|
|
The current version number of the checklist item |
|
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the checklist item belongs to (NULL for all sites) |
|
| SITE_NAME | varchar | 255 | √ | null |
|
|
The name of the site that the checklist item belongs to (NULL for all sites) |
|
| SHOW_ONLINE | varchar | 5 | √ | null |
|
|
Whether the checklist item should be shown online (Yes/No) |
|
| ITEM_TYPE | varchar | 15 | √ | null |
|
|
The type of checklist item (Information / Waiver) |
|
| ITEM_TEXT | varchar | 8000 | √ | null |
|
|
The waiver text for the checklist item |
|
| UPLOADED_FILE_ID | int | 4 | √ | null |
|
|
The ID of the attached document |
|
| WAIVER_DURATION_DAYS | int | 4 | √ | null |
|
|
The number of days that the waiver applies for |
|
| ITEM_SIGNED_ONLINE | varchar | 5 | √ | null |
|
|
Whether the checklist item can be signed online (Yes/No) |
|
| IS_REQUIRED | varchar | 5 | √ | null |
|
|
Whether the item is required prior to its due date (Yes/No) |
|
| DUE_BEFORE_DAYS | int | 4 | √ | null |
|
|
The number of days prior to the event that the item is due |
|
| IS_GLOBAL | varchar | 5 | √ | null |
|
|
Whether this is a global item (Yes/No) |
|
| SHOW_SIGNATURE_LINE | varchar | 5 | √ | null |
|
|
Whether a signature line should be displayed for this item (Yes/No) |
|
| REQUIRED_BEFORE_COMPLETING_TRANSACTION | varchar | 5 | √ | null |
|
|
Whether the item is required prior to completing the transaction (Yes/No) |
|
| REQUIRE_INITIALS_ONLINE | varchar | 15 | √ | null |
|
|
How the acceptance of the item should be performed online (Initials / Checkbox / E-signature) |
|
| PRINT_PAYER_AND_CUSTOMER | varchar | 5 | √ | null |
|
|
Whether the payer and the customer should both be printed on the waiver (Yes/No) |
|
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time Hub record was last modified |
||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
|
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |