Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ApprovalStatus | Unknown | 0 | null |
|
|
Approval status - Status of transaction approval workflow |
|||||
| ApprovedBy | Unknown | 0 | null |
|
|
Approved by user - UserID of the person who approved the transaction |
|||||
| ApprovedDate | Unknown | 0 | null |
|
|
Approval date - Date when the transaction was approved |
|||||
| BankAccount | Unknown | 0 | null |
|
|
Bank account - Bank account information for electronic payments |
|||||
| CheckNumber | Unknown | 0 | null |
|
|
Check number - Check number for check payments |
|||||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each daycare transaction |
||||
| fkInvoiceID | int | 4 | √ | null |
|
|
Invoice reference - Links to DaycareInvoices table for the associated invoice |
||||
| fkPatientID | int | 4 | √ | null |
|
|
Patient reference - Links to the patient receiving daycare services |
||||
| DateFrom | datetime | 16,3 | √ | null |
|
|
Service start date - Start date of the service period for this transaction |
||||
| DateTo | datetime | 16,3 | √ | null |
|
|
Service end date - End date of the service period for this transaction |
||||
| TransactionType | nvarchar | 100 | √ | null |
|
|
Transaction type - Type of transaction |
||||
| TransactionCategory | nvarchar | 200 | √ | null |
|
|
Transaction category - Category or subcategory of the transaction |
||||
| TransactionAmount | decimal | 20,2 | √ | null |
|
|
Transaction amount - Monetary amount of the transaction |
||||
| Comments | nvarchar | 1073741823 | √ | null |
|
|
Transaction comments - Additional notes about the transaction |
||||
| DeletedBy | Unknown | 0 | null |
|
|
Deleted by user - UserID of the person who deleted the transaction |
|||||
| PatientId | Unknown | 0 | null |
|
|
Patient reference - Links to Patient table for the child receiving daycare services |
|||||
| PaysourceId | int | 4 | √ | null |
|
|
Paysource reference - Links to AccessUser table for the paysource |
||||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the transaction was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the transaction |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date when the transaction was last updated |
||||
| ReferenceNumber | Unknown | 0 | null |
|
|
Reference number - External reference number for the transaction |
|||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the transaction |
||||
| DateDeleted | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
||||
| StripeChargeId | nvarchar | 100 | √ | null |
|
|
Stripe charge ID - Stripe payment processor charge identifier |
||||
| PaymentMethod | nvarchar | 100 | √ | null |
|
|
Payment method - Method of payment (Credit Card, Check, Cash, etc.) |
||||
| fkEnrollmentIDs | nvarchar | 1073741823 | √ | null |
|
|
Enrollment references - Comma-separated list of enrollment IDs associated with this transaction |
||||
| CasePaysourceId | int | 4 | √ | null |
|
|
Case paysource reference - Links to case-specific paysource information |
||||
| Note | varchar | 2147483647 | √ | null |
|
|
Additional notes - Additional notes about the transaction |
||||
| fkTransactionCategoryId | int | 4 | √ | null |
|
|
Transaction category reference - Links to transaction category definition |
||||
| fkSiteId | int | 4 | √ | null |
|
|
Site reference - Links to AgencySite table for the service location |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_DaycareTransactions | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
