ACTIVATE_PROPERTY_CHANNEL_DETAILS
Shared for feedback purposes
Table Schema
| column_name | type | description |
|---|---|---|
| CHANNEL_ID | TEXT | Unique identifier for a channel |
| CHANNEL_NAME | TEXT | Name of the channel. Does not have to be unique |
| CHANNEL_DESCRIPTION | TEXT | Long form description of the channel |
| CHANNEL_TYPE | TEXT | The type of channel, such as: property, restaurant, company, retail. |
| SLUG | TEXT | Channel URL identifier |
| CHANNEL_URL | TEXT | Deep link to the Lane platform channel homepage for a given channel |
| CHANNEL_CREATED_AT | TIMESTAMP_NTZ | UTC timestamp when the channel was created |
| CHANNEL_ADDRESS | TEXT | Street address for the channel |
| CHANNEL_ADDRESS_EXTRA | TEXT | Additional address info if provided. Mostly includes floor numbers and suite numbers |
| CHANNEL_CITY | TEXT | City where the channel is located |
| CHANNEL_STATE | TEXT | State or province where the channel is located |
| CHANNEL_COUNTRY | TEXT | Country where the channel is located |
| CHANNEL_ZIP_CODE | TEXT | Postal or ZIP where the channel is located |
| RENTABLE_SQUARE_FEET | VARIANT | Rentable square feet recorded for the property. Mandatory field for CBRE |
| SQUARE_FEET | VARIANT | Square footage as entered by implementation or CS on the channel settings |
| HEAD_COUNT | NUMBER | Occupancy estimate of the channel as entered by implementation or CS on the channel settings |
| IS_DEMO | BOOLEAN | Indicates if a channel is a demo\n |
| IS_PUBLIC | BOOLEAN | Channel is visible to all members of the Lane platform |
| IS_INVITE_ONLY | BOOLEAN | Boolean indicating whether or not users can join without an invitation frome existing members |
| IS_DISCOVERABLE | BOOLEAN | Indicates whether or not channel is searchable via user onboarding process in company and building selection |
| LAST_DISCOVERABLE_AT | TIMESTAMP_NTZ | Most recent date the is_discoverable toggle on a channel was flipped to true |
| CHANNEL_FILTERS | VARIANT | If filters is enabled this shows an array of email domains that are allowed to join the channel |
| IS_FILTERS_ENABLED | BOOLEAN | Boolean flag indicating whether or not the channel uses filters to whitelist member emails |
| SETTINGS | VARIANT | JSON blob of channel settings |
| HAS_RESERVABLE_MANAGEMENT_ENABLED | BOOLEAN | Denotes if the channel has a Reservable Manager feature enabled |
| IS_PARENT_CHANNEL | BOOLEAN | Boolean indicating whether or not the channel is at the top of the hierarchy |
| PARENT_NAME | TEXT | Name of the parent channel |
| PARENT_ID | TEXT | Channel identifier of the parent channel |
| PARENT_IDS | VARIANT | Array containing all parent channel identifiers |
| CHILD_IDS | VARIANT | Array containing all child channel identifiers |
| TENANT_CHANNEL_IDS | ARRAY | Array of tenant channel identifiers if the channel has tenant relationships configured |
| TENANT_CHANNELS | ARRAY | Array of channel names if the channel has tenant relationships configured |
| TENANT_OF_CHANNEL_IDS | ARRAY | Channel IDs that Channel is associated as a tenant |
| TENANT_OF_CHANNELS | ARRAY | Tenant Channel IDs |
| CHANNEL_DISPLAY_NAME | TEXT | In-app name of channel |
| CLIENT_NAME | VARIANT | Name of the client residing in property |
| WHITELABEL_ID | TEXT | ID associated with Whitelable version of Activate App |
| WHITELABEL_NAME | TEXT | Name of the whitelabel that the channel is on |
| WHITELABEL_DESCRIPTION | TEXT | Short description of the whitelabel |
| WHITELABEL_URL | TEXT | Base url for the whitelabel. For example the Lane whitelabel is app.joinlane.com |
| WHITELABEL_IDS | VARIANT | Array of whitelabel identifiers associated with a channel |
SETTINGS JSON Blob details:
The structure and the content of the JSON block is subject to change. Fields may be added, removed, or modified without prior notice, but updates will be reflected in the documentation.
{
"areUserTemplatesAllowed":false,
"channelLanguages":null,
"enabledLanguagesForMembers":null,
"groupRoleJoinRules":[
{
"_id":"abcde123-a6db-43c5-ad20-9d8bxxxxxxx",
"channelId":"abcde123-1445-42ee-a6c7-cf4f8xxxxxxxx",
"groupRoleId":"abcde123-f853-4d71-bf29-55facxxxxxx2",
"joinGroupRoleId":"abcde123-b251-43a2-93c8-xxxxxx3c3f5"
}
],
"hasAccessControlEnabled":false,
"hasBillingPaymentsEnabled":null,
"hasHardwareManagementEnabled":false,
"hasHardwarePinManagementEnabled":null,
"hasMessagingAndMarketplaceEnabled":null,
"hasPerksEnabled":false,
"hasReservableManagementEnabled":false,
"hasSmartUserManagementEnabled":null,
"hasSurveysEnabled":true,
"hasVisitorManagementEnabled":false,
"hasWorkOrderCrossPropertyEnabled":false,
"hasWorkOrderEquipmentEnabled":null,
"hasWorkOrderPreventiveMaintenanceEnabled":null,
"hasWorkOrderServiceRequestsEnabled":null,
"hasWorkOrdersEnabled":false,
"isParcelManagementEnabled":null,
"maxUsers":0,
"multiLanguageEnabled":null,
"offboardingDelayDays":0,
"requirements":null,
"subscribersAreDecoyed":false,
"subscribersJoinParent":false
}
Updated 5 days ago