Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| STAGE_ID | int | 4 | null |
|
|
The stage or checklist item ID |
||||||||
| STAGE_DESCRIPTION | varchar | 50 | √ | null |
|
|
The stage or checklist item description |
|||||||
| STAGE_VERSION | int | 4 | √ | null |
|
|
The current version number of the stage or checklist item |
|||||||
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the stage or 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) |
|||||||
| ALLOW_INDIVIDUAL_SELECTION | varchar | 5 | √ | null |
|
|
Whether the item can be selected individually during the transaction (Yes/No) |
|||||||
| APPROVAL_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who must approve the transaction stage |
|||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|||||||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| STAGES_STAGE_ID_ORG_ID_PK | Primary key | Asc/Asc | STAGE_ID + ORG_ID |
| STAGES_APPROVAL_SYSTEMUSER_ID_IX | Performance | Asc | APPROVAL_SYSTEMUSER_ID |
| STAGES_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| STAGES_SITE_ID_IX | Performance | Asc | SITE_ID |
| STAGES_UPLOADED_FILE_ID_IX | Performance | Asc | UPLOADED_FILE_ID |