Forms fact table

AppointmentId

VARCHAR(36)

Appointment id of the appointment for which form is filled

AppointmentNoShowOrCancel

INT

Tells whether fee is collected in case of no show or cancelled scenarios."-1": cancel and fee collected, "-2": noshow and fee collected. 0: fee not collected

centerwid

bigint

Unique identifier for the center

Bi_DimCenter

centerwid

DataTypeDesc

VARCHAR(144)

This flag indicated what type of data is stored in the input field

dimformwid

bigint

unique identifier for form. Present only in Analytics

bi_dimcustomforms

formwid

ETLCreatedDate

TIMESTAMP

Timestamp on when the row is updated in Analytics

factformid

bigint

Unique id for each record of table. Generated within Analytics

PK

Fieldname

VARCHAR(65535)

Name given to input field in the form. This is different from label that is visible in the form.

FormAppointmentStatus

INT

Current status of appointment. 0-new; 1-closed; 2-check in; 4-confirm; -1 Cancel; -2 Noshow, -3-void

formexpirydate

TIMESTAMP

Expiry date for the form

formid

varchar(36)

unique identifier of the form. Unique for a form created

Formsource

VARCHAR(64)

Indicates where form is filled

Formtype

INT

Identifes what type of form it is

FormVoided

BOOLEAN

Indicates if form is voided

formwid

bigint

unique identifier for form. Present only in Analytics

guestwid

bigint

Unique identifier of the guest. Unique for a guest across the product

Bi_Dimuser

userwid

isappointmentvoided

BOOLEAN

Indicates if appointment is void or not. "true" for void, "False" for not void

Isformsubmitted

BOOLEAN

Indicates if form is submitted or not. "true" for submitted, "false" for not submitted

OrganizationId

VARCHAR(36)

A unique identifier for the organition for which this data belongs

Bi_DimCenter

organizationID

PodName

VARCHAR(20)

Internal to the ETL, says from which POD data is being synced the table

Pointer

INT

Indicates which of the 4 columns to look at for the values against "field name column". If data is stored in "value1" column, field will be updated as "1". Similarly for "value2" it is "2", "value3", it is "3", and for "value4" it is "4"

reviewedbywid

bigint

unique identifier of reviewer

Bi_Dimuser

userwid

ReviewedOn

TIMESTAMP

Date on which form is reviewed

ReviewNeeded

BOOLEAN

Indicates if review is needed or not. "true" stands for review needed. "False" stands for review not needed

servicewid

bigint

unique identifier for the service for which form is filled

Bi_DimService

Servicewid

Startdate

TIMESTAMP

Date of appoinment

Submitteddate

TIMESTAMP

Date on which form is last updated

therapistwid

bigint

Unique identifier of Therapist

Bi_Dimuser

userwid

Value1

FLOAT

Indicates the input provided in form against "field name" section. "value1" column is stores Float data types

Value2

TIMESTAMP

Indicates the input provided in form against "field name" section. "value2" column is stores Date-time data types

Value3

BOOLEAN

Indicates the input provided in form against "field name" section. "value3" column is stores Boolean data types

Value4

VARCHAR(65535)

Indicates the input provided in form against "field name" section. "value4" column is stores String data types

void

BOOLEAN

Indicates if the row is void or not

lastupdateddate

TIMESTAMP

Indicates when was the last time form is updated

IsV3Form

BOOLEAN

Indicates if the form filled for appointment is created using HTML feature or Form Builder Feature. No- HTML , Yes- Form Builder

groupid

Internal to Zenoti. Used for data processing.

BIGINT

apphtmlformpk

BIGINT

Internal identifier for Forms ETL process

htmlformpk

BIGINT

Internal identifier for forms ETL process