Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 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 |
||||||||||||||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
Company name that the permit is for |
||||||||||||||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Customer ID that the permit is for |
||||||||||||||||
| CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
Customer name that the permit is for |
||||||||||||||||
| CUSTOMER_TYPE_ID | int | 4 | √ | null |
|
|
Customer type ID |
||||||||||||||||
| CUSTOMER_TYPE | varchar | 60 | √ | null |
|
|
Customer type name |
||||||||||||||||
| PERMIT_DATE | datetime | 16,3 | √ | null |
|
|
Date that the permit was created |
||||||||||||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
System user ID who created the permit |
||||||||||||||||
| SYSTEM_USER_NAME | varchar | 511 | √ | null |
|
|
System user name who created the permit |
||||||||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
Site ID that the permit belongs to |
||||||||||||||||
| SITE_NAME | varchar | 255 | √ | 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 |
||||||||||||||||
| PERMIT_ADMINISTRATOR_NAME | varchar | 511 | √ | null |
|
|
System user name 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 | 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 |
||||||||||||||||
| source_id | int | 4 | √ | null |
|
|
The ID value from the Active Net system |