Appointment redo fact table
Bi_FactAppointmentRedo
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
AppointmentId | VARCHAR(36) | unique identifier for an appointment | |||
AppointmentPk | bigint | A unique identifier for each appointment. If the appointment is a segment, this is the segment pk. This is generated within Analytics. | |||
appstatuswid | bigint | A unique identifier that signifies the status of the Appointment, generated in status dimension(Bi_DimStatus) | |||
centerwid | bigint | unique identifier for a center | Bi_DimCenter centerwid | ||
CommissionFactor | float | The commission factor or adjustment applicable for the corresponding employee. For example, if this is 200%, the employee earns double the configured commission. If this is 50%, the employee earns half the configured commission. | |||
Employeewid | bigint | unique identifier for an employee | Bi_Dimuser userwid | ||
EndTimeInCenter | TIMESTAMP | Date and time on which the appointment is scheduled to end | |||
etlCreatedBy | bigint | ETL system admin user who inserted or updated the corresponding record in this table. | |||
etlCreatedDate | date | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
FactAppointmentRedoId | bigint | Unique identifier for the row. Primary Key | |||
FactAppointmentRedowId | bigint | Unique identifier for the row. Primary Key | Yes | ||
InvoiceDiscount | DECIMAL(19,4) | The total discount applied to the corresponding invoice item id. | |||
InvoiceId | VARCHAR(36) | unique identifier for an invoice | |||
InvoiceitemId | VARCHAR(36) | unique identifier for a line item within an invoice | |||
IsRedo | BOOLEAN | A flag indicating whether the corresponding appointment is a redo appointment or not. - True: Indicates that the appointment is a redo appointment - False: Indicates that the appointment is not a redo appointment | |||
issegment | BOOLEAN | A flag indicating whether the corresponding appointment is a segment or not. | |||
Itemwid | bigint | unique identifier for an item sold | Bi_DimItems itemwid | ||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter OrganizationId | ||
parentappointmentid | VARCHAR(36) | If the appointment is a segment, this field is filled. This field populates the appointment id of the parent appointment corresponding to the segment. | |||
ParentAppointmentPk | bigint | If the appointment is a segment, this field is filled. This field populates the appointment pk of the parent appointment corresponding to the segment. | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
PrimaryEmp | BOOLEAN | A flag indicating whether the corresponding employee is the primary employee to service the guest. | |||
Processed | smallint | A code that indicates staus of the invoice. | |||
SourceAppointmentId | VARCHAR(36) | If the appointment is a redo appointment, this field is filled. This field populates the appointment id of the source appointment corresponding to the redo appointment. | |||
SourceAppointmentPk | bigint | If the appointment is a redo appointment, this field is filled. This field populates the appointment pk of the source appointment corresponding to the redo appointment. | |||
StartTimeInCenter | TIMESTAMP | The date on which the appointment is scheduled to start. | |||
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||
InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. | |||