Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||||||||||||||
| PERMIT_ID | int | 4 | √ | null |
|
|
Permit ID |
||||||||||||||||
| PERMIT_NUMBER | int | 4 | √ | null |
|
|
Permit number |
||||||||||||||||
| EVENT_NAME | varchar | 200 | √ | null |
|
|
Permit event name |
||||||||||||||||
| COMPANY_ID | int | 4 | √ | null |
|
|
Company ID that the permit is for |
||||||||||||||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Customer ID that the permit is for |
||||||||||||||||
| CUSTOMER_TYPE_ID | int | 4 | √ | null |
|
|
Customer type ID |
||||||||||||||||
| PERMIT_DATE | datetime | 16,3 | √ | null |
|
|
Date that the permit was created |
||||||||||||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
System user ID who created the permit |
||||||||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
Site ID that the permit belongs to |
||||||||||||||||
| PERMIT_STATUS | varchar | 20 | √ | null |
|
|
Permit status (Approved / Denied / Tentative / Stage Denied / Issued / Cancelled / Waiting Decision / Completed / On Hold) |
||||||||||||||||
| ORIGINAL_REQUEST_NUMBER | int | 4 | √ | null |
|
|
Original request number |
||||||||||||||||
| EXPIRATION_DATE | date | 20 | √ | null |
|
|
Request expiration date |
||||||||||||||||
| EVENT_DATE_DESCRIPTION | varchar | 50 | √ | null |
|
|
Event dates description |
||||||||||||||||
| RESERVATION_PERIOD_UNIT | varchar | 20 | √ | null |
|
|
Default reservation period (Use Default / Minute / Hour / Day / Week / Month / Defined Date Range / Rental Block / Overnight) |
||||||||||||||||
| PAYMENT_SCHEDULE_TYPE | varchar | 20 | √ | null |
|
|
Type of payment schedule for this permit (None / Weekly / Monthly / By First Booking / By Each Booking) |
||||||||||||||||
| DUE_DAY_OF_WEEK | varchar | 10 | √ | null |
|
|
Default due day of week (Sunday to Saturday) |
||||||||||||||||
| DUE_DAY_OF_MONTH | int | 4 | √ | null |
|
|
Default due day of month (1 to 31) |
||||||||||||||||
| DUE_MONTH_OFFSET | varchar | 20 | √ | null |
|
|
Number of days that the due date should be offset (Current Month / Previous Month / Next Month) |
||||||||||||||||
| DUE_DATE_OFFSET | int | 4 | √ | null |
|
|
Number of days that the due date should be offset from the booking date |
||||||||||||||||
| PERMIT_ADMINISTRATOR_ID | int | 4 | √ | null |
|
|
System user ID who is the permit administrator |
||||||||||||||||
| CREATED_BY_NEW_WORKFLOW | varchar | 5 | √ | null |
|
|
Whether this permit was created using the new reservation workflow (Yes / No) |
||||||||||||||||
| APPLY_CHARGE_AT_RESOURCE_LEVEL | varchar | 5 | √ | null |
|
|
Whether fees for this permit should be charged at the resource level (Yes / No) |
||||||||||||||||
| 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 |
||||||||||||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PERMITS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| PERMITS_COMPANY_ID_IX | Performance | Asc | COMPANY_ID |
| PERMITS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| PERMITS_CUSTOMER_TYPE_ID_IX | Performance | Asc | CUSTOMER_TYPE_ID |
| PERMITS_PERMIT_ADMINISTRATOR_ID_IX | Performance | Asc | PERMIT_ADMINISTRATOR_ID |
| PERMITS_PERMIT_ID_ORG_ID_UQ | Must be unique | Asc/Asc | PERMIT_ID + ORG_ID |
| PERMITS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| PERMITS_SITE_ID_IX | Performance | Asc | SITE_ID |
| PERMITS_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |