Forms fact table

Bi_FactForms_s3

AppointmentId

VARCHAR(36)

Appointment id of the appointment for which form is filled

Bi_FactForms_s3

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

Bi_FactForms_s3

CenterId

VARCHAR(36)

Unique identifier for the center

Bi_DimCenter_s3

centerid

Bi_FactForms_s3

DataTypeDesc

VARCHAR(144)

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

Bi_FactForms_s3

ETLCreatedDate

TIMESTAMP

Timestamp on when the row is updated in Analytics

Bi_FactForms_s3

factformid

DECIMAL(19,0)

Unique id for each record of table. Generated within Analytics

Yes

Bi_FactForms_s3

Fieldname

VARCHAR(65535)

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

Bi_FactForms_s3

FormAppointmentStatus

INT

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

Bi_FactForms_s3

formexpirydate

TIMESTAMP

Expiry date for the form

Bi_FactForms_s3

FormId

VARCHAR(36)

unique identifier of the form. Unique for a form created

bi_dimcustomforms_S3

FormID

Bi_FactForms_s3

Formsource

VARCHAR(64)

Indicates where form is filled

bi_dimitemsource_s3

sourcename

Bi_FactForms_s3

Formtype

INT

Identifes what type of form it is

Bi_FactForms_s3

FormVoided

BOOLEAN

Indicates if form is voided

Bi_FactForms_s3

GuestId

VARCHAR(36)

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

Bi_Dimuser_s3

userid

Bi_FactForms_s3

isappointmentvoided

BOOLEAN

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

Bi_FactForms_s3

Isformsubmitted

INT

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

Bi_FactForms_s3

OrganizationId

VARCHAR(36)

A unique identifier for the organition for which this data belongs

Bi_DimCenter_s3

organizationID

Bi_FactForms_s3

PodName

VARCHAR(20)

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

Bi_FactForms_s3

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"

Bi_FactForms_s3

ReviewedBy

VARCHAR(36)

unique identifier of reviewer

Bi_Dimuser_s3

userid

Bi_FactForms_s3

ReviewedOn

TIMESTAMP

Date on which form is reviewed

Bi_FactForms_s3

ReviewNeeded

BOOLEAN

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

Bi_FactForms_s3

Serviceid

VARCHAR(36)

unique identifier for the service for which form is filled

Bi_DimService_s3

ServiceID

Bi_FactForms_s3

Startdate

TIMESTAMP

Date of appoinment

Bi_FactForms_s3

Submitteddate

TIMESTAMP

Date on which form is last updated

Bi_FactForms_s3

TherapistId

VARCHAR(36)

Unique identifier of Therapist

Bi_Dimuser_s3

userid

Bi_FactForms_s3

Value1

FLOAT

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

Bi_FactForms_s3

Value2

TIMESTAMP

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

Bi_FactForms_s3

Value3

BOOLEAN

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

Bi_FactForms_s3

Value4

VARCHAR(65535)

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

Bi_FactForms_s3

void

BOOLEAN

Indicates if the row should be inserted or deleted. 1- delete, 0-insert

Bi_FactForms_s3

IsV3Form

BOOLEAN

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

Bi_FactForms_s3

groupid

BIGINT

Internal to Zenoti. Used for data processing.

Bi_FactForms_s3

apphtmlformpk

BIGINT

Internal identifier for Forms ETL process

Bi_FactForms_s3

htmlformk

BIGINT

Internal identifier for Forms ETL process