Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PermittedLevel2Users | int | 4 | √ | null |
|
|
Permitted Level 2 users - Maximum number of Level 2 users allowed for this agency’s subscription |
|
| PermittedLevel3Users | int | 4 | √ | null |
|
|
Permitted Level 3 users - Maximum number of Level 3 users allowed for this agency’s subscription |
|
| ActivePatients | int | 4 | √ | null |
|
|
Active patients count - Total number of active patients currently being served by this agency |
|
| AdmittedCases | int | 4 | √ | null |
|
|
Admitted cases count - Total number of cases that have been admitted for services |
|
| ActiveProviders | int | 4 | √ | null |
|
|
Active providers count - Total number of active healthcare providers associated with this agency |
|
| BillingPeriod | Unknown | 0 | null |
|
|
Billing period - Time period for this billing record |
||
| BillingRate | Unknown | 0 | null |
|
|
Billing rate - Rate charged per user at this level |
||
| CompanyName | varchar | 50 | √ | null |
|
|
Company name - Name of the agency or organization for billing identification |
|
| fkAgencyID | Unknown | 0 | null |
|
|
Agency reference - Reference to the agency |
||
| PermittedLevel1Users | int | 4 | √ | null |
|
|
Permitted Level 1 users - Maximum number of Level 1 users allowed for this agency’s subscription |
|
| L1WithAccess | int | 4 | √ | null |
|
|
Level 1 users with access - Number of Level 1 users who currently have system access |
|
| L2WithAccess | int | 4 | √ | null |
|
|
Level 2 users with access - Number of Level 2 users who currently have system access |
|
| L3WithAccess | int | 4 | √ | null |
|
|
Level 3 users with access - Number of Level 3 users who currently have system access |
|
| ProvidersWithAccess | int | 4 | √ | null |
|
|
Providers with access - Number of healthcare providers who currently have system access |
|
| RecordId | Unknown | 0 | null |
|
|
Primary key - InvoiceUsersByLevel unique identifier for each user level billing record |
||
| TotalBilledClaimsForCurrentMonth | int | 4 | √ | null |
|
|
Current month billed claims - Total number of claims billed for the current billing month |
|
| TotalBilledClaimsForPreviousMonth | int | 4 | √ | null |
|
|
Previous month billed claims - Total number of claims billed for the previous billing month |
|
| Invoice | varchar | 20 | √ | null |
|
|
Invoice number - Invoice identifier for this billing period and agency |
|
| RateFlat | money | 21,4 | √ | null |
|
|
Flat rate - Fixed monthly rate charged regardless of usage volume |
|
| RateUnit | money | 21,4 | √ | null |
|
|
Per-unit rate - Rate charged per unit of service or transaction |
|
| RateSCUnit | money | 21,4 | √ | null |
|
|
Service coordination unit rate - Rate charged per service coordination unit or activity |
|
| CurrDate | datetime | 16,3 | null |
|
|
Current date - Date when this billing record was generated or last updated |
||
| UserCount | Unknown | 0 | null |
|
|
User count - Number of users at this level |
||
| UserLevel | Unknown | 0 | null |
|
|
User level - Access level or role of the users |