Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each visit entry setting configuration, auto-incrementing integer |
|
| fkCPID | int | 4 | √ | null |
|
|
Care plan reference - Foreign key linking to care plan or program for which these settings apply |
|
| EntryType | nvarchar | 40 | √ | null |
|
|
Entry type classification - Type of visit entry this configuration applies to (e.g., Individual, Group, Assessment) |
|
| Minutes | int | 4 | √ | null |
|
|
Minutes field setting - Configuration for minutes field display and behavior |
|
| Units | int | 4 | √ | null |
|
|
Units field setting - Configuration for units field display and behavior |
|
| File | int | 4 | √ | null |
|
|
File attachment setting - Configuration for file attachment functionality |
|
| Form | int | 4 | √ | null |
|
|
Form selection setting - Configuration for form selection and display |
|
| ServiceCoordinator | int | 4 | √ | null |
|
|
Service coordinator setting - Configuration for service coordinator field |
|
| ICD | int | 4 | √ | null |
|
|
ICD code setting - Configuration for ICD diagnosis code field |
|
| DefaultICD | int | 4 | √ | null |
|
|
Default ICD setting - Configuration for default ICD code selection |
|
| CPT | int | 4 | √ | null |
|
|
CPT code setting - Configuration for CPT procedure code field |
|
| DefaultCPT | int | 4 | √ | null |
|
|
Default CPT setting - Configuration for default CPT code selection |
|
| Auth | int | 4 | √ | null |
|
|
Authorization setting - Configuration for authorization field display |
|
| Location | int | 4 | √ | null |
|
|
Location setting - Configuration for location field display and selection |
|
| Provider | int | 4 | √ | null |
|
|
Provider setting - Configuration for provider field display and selection |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this configuration was first created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this configuration |
|
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this configuration was most recently updated |
|
| ModifiedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this configuration was logically deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user - User ID who deleted this configuration |
|
| PaymentSource | int | 4 | √ | null |
|
|
Payment source setting - Configuration for payment source field |
|
| CaseSite | int | 4 | √ | null |
|
|
Case site setting - Configuration for case site field |
|
| Times | int | 4 | √ | null |
|
|
Times setting - Configuration for time-related fields |
|
| TimeStart | int | 4 | √ | null |
|
|
Start time setting - Configuration for visit start time field |
|
| TimeEnd | int | 4 | √ | null |
|
|
End time setting - Configuration for visit end time field |
|
| ViewEnteredDetails | int | 4 | √ | null |
|
|
Detail view setting - Configuration for viewing entered visit details |
|
| QuickAction | varchar | 250 | √ | null |
|
|
Quick action configuration - Configuration for quick action buttons and shortcuts |
|
| ShowAllActivePatients | int | 4 | √ | null |
|
|
Patient display setting - Configuration for showing all active patients |
|
| Note1 | int | 4 | √ | null |
|
|
Note field 1 setting - Configuration for first note field |
|
| ShowSignatureDate | int | 4 | √ | null |
|
|
Signature date setting - Configuration for signature date display |
|
| ShowPayroll | int | 4 | √ | null |
|
|
Payroll setting - Configuration for payroll-related field display |
|
| RateCode | int | 4 | √ | null |
|
|
Rate code setting - Configuration for rate code field |
|
| DefaultRateCode | int | 4 | √ | null |
|
|
Default rate code setting - Configuration for default rate code selection |
|
| DefaultLocation | int | 4 | √ | null |
|
|
Default location setting - Configuration for default location selection |
|
| Note2 | int | 4 | √ | null |
|
|
Note field 2 setting - Configuration for second note field |
|
| Note2Label | varchar | 250 | √ | null |
|
|
Note 2 label - Custom label for second note field |
|
| Note3 | int | 4 | √ | null |
|
|
Note field 3 setting - Configuration for third note field |
|
| Note3Label | varchar | 250 | √ | null |
|
|
Note 3 label - Custom label for third note field |
|
| Note4 | int | 4 | √ | null |
|
|
Note field 4 setting - Configuration for fourth note field |
|
| Note4Label | varchar | 250 | √ | null |
|
|
Note 4 label - Custom label for fourth note field |
|
| Note1Label | varchar | 250 | √ | null |
|
|
Note 1 label - Custom label for first note field |
|
| RateCode2 | int | 4 | √ | null |
|
|
Rate code 2 setting - Configuration for second rate code field |
|
| DefaultRateCode2 | int | 4 | √ | null |
|
|
Default rate code 2 setting - Configuration for default second rate code |
|
| RateCode3 | int | 4 | √ | null |
|
|
Rate code 3 setting - Configuration for third rate code field |
|
| DefaultRateCode3 | int | 4 | √ | null |
|
|
Default rate code 3 setting - Configuration for default third rate code |
|
| Note5 | int | 4 | √ | null |
|
|
Note field 5 setting - Configuration for fifth note field |
|
| Note5Label | varchar | 250 | √ | null |
|
|
Note 5 label - Custom label for fifth note field |
|
| RateCodeLabel | varchar | 250 | √ | null |
|
|
Rate code label - Custom label for primary rate code field |
|
| RateCode2Label | varchar | 250 | √ | null |
|
|
Rate code 2 label - Custom label for second rate code field |
|
| RateCode3Label | varchar | 250 | √ | null |
|
|
Rate code 3 label - Custom label for third rate code field |
|
| AllowFutureDates | bit | 1 | √ | null |
|
|
Future dates allowed - Boolean controlling whether future dates can be entered |
|
| CalculateUnits | bit | 1 | √ | null |
|
|
Auto-calculate units - Boolean controlling automatic unit calculation |
|
| NotEditWhenSignatureLocked | bit | 1 | √ | null |
|
|
Signature lock edit restriction - Boolean preventing edits when signature is locked |
|
| NotEditWhenStatusCodeIds | nvarchar | 40 | √ | null |
|
|
Status-based edit restriction - Status codes that prevent editing |
|
| EnableMinutes | bit | 1 | √ | null |
|
|
Minutes field enabled - Boolean controlling minutes field availability |
|
| DefaultVisitCode | int | 4 | √ | null |
|
|
Default visit code - Default visit code for new entries |
|
| DontShowTimeSelector | bit | 1 | √ | null |
|
|
Hide time selector - Boolean controlling time selector visibility |
|
| RequireObjectives | bit | 1 | √ | null |
|
|
Objectives required - Boolean requiring objectives to be entered |
|
| DontAllowDifferentAuthMinutes | bit | 1 | √ | null |
|
|
Auth minutes restriction - Boolean preventing different authorization minutes |
|
| DontAutomaticallyCalculateEndTime | bit | 1 | √ | null |
|
|
Manual end time - Boolean disabling automatic end time calculation |
|
| DefaultTab | int | 4 | √ | null |
|
|
Default tab setting - Default tab to display in visit entry interface |
|
| ShowVisitCodeAndFormFirst | int | 4 | √ | null |
|
|
Visit code priority - Setting for showing visit code and form first |
|
| Outcomes | int | 4 | √ | null |
|
|
Outcomes setting - Configuration for outcomes tracking |
|
| ShowButtonAvailableMakeUps | bit | 1 | √ | null |
|
|
Make-up button visibility - Boolean controlling make-up visit button display |
|
| DontAllowEnterMakeUpdate | bit | 1 | √ | null |
|
|
Make-up entry restriction - Boolean preventing make-up visit entry |
|
| CheckClaim | int | 4 | √ | null |
|
|
Claim checking setting - Configuration for claim validation |
|
| ShowIfSelectMakeUpVisitCode | bit | 1 | √ | null |
|
|
Make-up code visibility - Boolean controlling make-up visit code display |
|
| ShowScNoteButton | int | 4 | √ | null |
|
|
SC note button visibility - Configuration for service coordinator note button |
|
| AuthorizationFilter | int | 4 | √ | null |
|
|
Authorization filter setting - Configuration for authorization filtering |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Schedule__3214EC2750FB042B | Primary key | Asc | ID |