Adoption summary fact table
Bi_FactScheduledCollections_s3
Field | Field Type | Description | PrimaryKey | Mapped DimensionTable DimensionTableField | |
|---|---|---|---|---|---|
CenterId | VARCHAR(36) | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter_s3 CenterId | ||
CollectedAmount | DECIMAL(19,4) | amount collected | |||
CollectedDateInCenter | DATE | date on which amount is collected | |||
CollectedDateTimeInCenter | TIMESTAMP | date and time on which amount is collected | |||
CollectionAmount | DECIMAL(19,4) | amount to be collected | |||
CollectionDateInCenter | DATE | date on which amount is expected to be collected | |||
CollectionSource | VARCHAR(400) | This field tells if amount is collected manually/online/etc | |||
CollectionStatus | NVARCHAR(MAX) | Status of scheduled collection | |||
ConsiderInFinancials | BOOLEAN | This flag indicates whether the custom payment method should be considered in the sales or collections reports. This is a flag in the core system under Admin > Categories > Custom Payments. - True indicates that the custom payment method should be considered in the financial reports. - False indicates that the custom payment method should not be considered in the financial reports | |||
CreatedDateInCenter | DATE | date on which schedule is created | |||
CreatedDateTimeInCenter | TIMESTAMP | date and time on which schedule is created | |||
CustomPaymentName | VARCHAR(1600) | For custom payments, the name of the custom payment method gets populated in the custom payment name field. If the appropriate option isn't there, the user can enter the information in the Custom payment additional details field | |||
EtlCreatedBy | DECIMAL(19,0) | unique identfier in Table. Exists only in Analytics | |||
EtlCreatedDate | TIMESTAMP | unique identfier in Table. Exists only in Analytics | |||
FactSegmentId | INT | Unique identifier for the row in the table | Yes | ||
InvoiceId | VARCHAR(36) | A unique identifier for the invoice. It is unique within the organization. | |||
LastTriedOn | DATE | latest date on which collection is attempted | |||
NextTryAt | DATE | upcoming date for scheduled collection. In case payment is to be made monthly, you will have one row each for all future payments with future collection date of each month for each row. In case payments fail or fall into "pending" status, Next Try at date still shoes original collection date | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 OrganizationId | ||
paymentoptiontype | VARCHAR(400) | For card payments, the type of card gets populated here. For cheque payments, the name of the cheque gets populated here | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
ScheduledCollectionPK | INT | A unique identifier for every collection at the most granular level in this table. This is generated in Analytics, it does not exist in the core system | |||
ScheduledPaymentType | VARCHAR(400) | type of payment used to make payment | |||
UserId | VARCHAR(36) | A unique identifier for the guest. This is a non-blank value that gets populated for every guest | Bi_Dimuser_s3 userid | ||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
scheduledcollectionwid | |||||