Appointment redo fact table
Bi_FactAppointmentRedo_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
FactAppointmentRedoId | DECIMAL(19,0) | Unique identifier for the row. Primary Key | Yes | ||
AppointmentId | VARCHAR(36) | unique identifier for an appointment | |||
InvoiceitemId | VARCHAR(36) | unique identifier for a line item within an invoice | |||
EmployeeId | VARCHAR(36) | unique identifier for an employee | Bi_Dimuser_s3 userid | ||
InvoiceId | VARCHAR(36) | unique identifier for an invoice | |||
CommissionFactor | DECIMAL(19,4) | 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. | |||
CenterID | VARCHAR(36) | unique identifier for a center | Bi_DimCenter_s3 centerid | ||
InvoiceDiscount | DECIMAL(19,4) | The total discount applied to the corresponding invoice item id. | |||
ItemId | VARCHAR(36) | unique identifier for an item sold | Bi_DimItems_S3 itemid | ||
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 | |||
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. | |||
StartTimeInCenter | TIMESTAMP | The date on which the appointment is scheduled to start. | |||
EndTimeInCenter | TIMESTAMP | Date and time on which the appointment is scheduled to end | |||
etlCreatedBy | DECIMAL(19,0) | ETL system admin user who inserted or updated the corresponding record in this table. | |||
etlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
PrimaryEmp | BOOLEAN | A flag indicating whether the corresponding employee is the primary employee to service the guest. | |||
appointmentstatus | INT | A unique identifier that signifies the status of the Appointment, generated in status dimension(Bi_DimStatus) | |||
Processed | INT | A code that indicates staus of the invoice. | |||
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. | |||
issegment | BOOLEAN | A flag indicating whether the corresponding appointment is a segment or not. | |||
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
AppointmentPk | DECIMAL(19,0) | A unique identifier for each appointment. If the appointment is a segment, this is the segment pk. This is generated within Analytics. | |||
SourceAppointmentPk | DECIMAL(19,0) | 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. | |||
ParentAppointmentPk | DECIMAL(19,0) | 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 | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organization for which this data belongs | Bi_DimCenter_s3 OrganizationId | ||
groupid | BIGINT | Internal to Zenoti. Used for data processing. | |||
InvoiceNo | VARCHAR(160) | Invoice number that helps in identifying and tracking the invoice. | |||