Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ClientID | Unknown | 0 | null |
|
|
Client reference - Reference to the primary client record |
||
| ClientName | varchar | 100 | √ | null |
|
|
Name field - Descriptive name or identifier for AllClientData records |
|
| DataType | Unknown | 0 | null |
|
|
Data type - Classification of the data being stored |
||
| DataValue | Unknown | 0 | null |
|
|
Data value - The actual data value or measurement |
||
| DateRecorded | Unknown | 0 | null |
|
|
Recording date - Date when this data was recorded or calculated |
||
| TotalPatient | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for AllClientData records |
|
| TotalClaim | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for AllClientData records |
|
| TotalCharge | money | 21,4 | √ | null |
|
|
Financial amount - Monetary value or rate for AllClientData financial calculations |
|
| TotalBilled | money | 21,4 | √ | null |
|
|
Financial amount - Monetary value or rate for AllClientData financial calculations |