Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each visit entry configuration |
|
| fkCPID | int | 4 | √ | null |
|
|
Claim type program reference - Links to claim type program configuration |
|
| EntryType | nvarchar | 40 | √ | null |
|
|
Entry type - Type of visit entry (Scheduled, Walk-in, etc.) |
|
| 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 field setting - Configuration for file attachment field |
|
| Form | int | 4 | √ | null |
|
|
Form field setting - Configuration for form selection field |
|
| ServiceCoordinator | int | 4 | √ | null |
|
|
Service coordinator field setting - Configuration for service coordinator selection |
|
| ICD | int | 4 | √ | null |
|
|
ICD field setting - Configuration for ICD diagnosis code field |
|
| DefaultICD | int | 4 | √ | null |
|
|
Default ICD code - Default ICD diagnosis code for new visits |
|
| CPT | int | 4 | √ | null |
|
|
CPT field setting - Configuration for CPT procedure code field |
|
| DefaultCPT | int | 4 | √ | null |
|
|
Default CPT code - Default CPT procedure code for new visits |
|
| Auth | int | 4 | √ | null |
|
|
Authorization field setting - Configuration for authorization selection field |
|
| Location | int | 4 | √ | null |
|
|
Location field setting - Configuration for service location field |
|
| Provider | int | 4 | √ | null |
|
|
Provider field setting - Configuration for provider selection field |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this configuration was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this configuration |
|
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Modification date - Date when this configuration was last modified |
|
| ModifiedBy | int | 4 | √ | null |
|
|
Modified by user - UserID of the person who last modified this configuration |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this configuration was marked as deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted this configuration |
|
| PaymentSource | int | 4 | √ | null |
|
|
Payment source field setting - Configuration for payment source selection |
|
| CaseSite | int | 4 | √ | null |
|
|
Case site field setting - Configuration for case site selection |
|
| Times | int | 4 | √ | null |
|
|
Times field setting - Configuration for time-related fields |
|
| TimeStart | int | 4 | √ | null |
|
|
Start time field setting - Configuration for visit start time field |
|
| TimeEnd | int | 4 | √ | null |
|
|
End time field setting - Configuration for visit end time field |
|
| ViewEnteredDetails | int | 4 | √ | null |
|
|
View entered details setting - Configuration for viewing previously entered details |
|
| QuickAction | varchar | 250 | √ | null |
|
|
Quick action configuration - Quick action buttons and shortcuts available |
|
| ShowAllActivePatients | int | 4 | √ | null |
|
|
Show all active patients setting - Configuration for patient selection scope |
|
| Note1 | int | 4 | √ | null |
|
|
Note 1 field setting - Configuration for first custom note field |
|
| ShowSignatureDate | int | 4 | √ | null |
|
|
Show signature date setting - Configuration for signature date display |
|
| ShowPayroll | int | 4 | √ | null |
|
|
Show payroll setting - Configuration for payroll information display |
|
| RateCode | int | 4 | √ | null |
|
|
Rate code field setting - Configuration for primary rate code field |
|
| DefaultRateCode | int | 4 | √ | null |
|
|
Default rate code - Default rate code for new visits |
|
| DefaultLocation | int | 4 | √ | null |
|
|
Default location - Default service location for new visits |
|
| Note2 | int | 4 | √ | null |
|
|
Note 2 field setting - Configuration for second custom note field |
|
| Note2Label | varchar | 250 | √ | null |
|
|
Note 2 label - Custom label for the second note field |
|
| Note3 | int | 4 | √ | null |
|
|
Note 3 field setting - Configuration for third custom note field |
|
| Note3Label | varchar | 250 | √ | null |
|
|
Note 3 label - Custom label for the third note field |
|
| Note4 | int | 4 | √ | null |
|
|
Note 4 field setting - Configuration for fourth custom note field |
|
| Note4Label | varchar | 250 | √ | null |
|
|
Note 4 label - Custom label for the fourth note field |
|
| Note1Label | varchar | 250 | √ | null |
|
|
Note 1 label - Custom label for the first note field |
|
| RateCode2 | int | 4 | √ | null |
|
|
Rate code 2 field setting - Configuration for second rate code field |
|
| DefaultRateCode2 | int | 4 | √ | null |
|
|
Default rate code 2 - Default second rate code for new visits |
|
| RateCode3 | int | 4 | √ | null |
|
|
Rate code 3 field setting - Configuration for third rate code field |
|
| DefaultRateCode3 | int | 4 | √ | null |
|
|
Default rate code 3 - Default third rate code for new visits |
|
| Note5 | int | 4 | √ | null |
|
|
Note 5 field setting - Configuration for fifth custom note field |
|
| Note5Label | varchar | 250 | √ | null |
|
|
Note 5 label - Custom label for the fifth note field |
|
| RateCodeLabel | varchar | 250 | √ | null |
|
|
Rate code label - Custom label for the primary rate code field |
|
| RateCode2Label | varchar | 250 | √ | null |
|
|
Rate code 2 label - Custom label for the second rate code field |
|
| RateCode3Label | varchar | 250 | √ | null |
|
|
Rate code 3 label - Custom label for the third rate code field |
|
| AllowFutureDates | bit | 1 | √ | null |
|
|
Allow future dates flag - Whether future dates are allowed for visit entry |
|
| CalculateUnits | bit | 1 | √ | null |
|
|
Calculate units flag - Whether units should be automatically calculated |
|
| NotEditWhenSignatureLocked | bit | 1 | √ | null |
|
|
No edit when signature locked - Prevents editing when signature is locked |
|
| NotEditWhenStatusCodeIds | nvarchar | 40 | √ | null |
|
|
No edit status codes - Status codes that prevent editing |
|
| EnableMinutes | bit | 1 | √ | null |
|
|
Enable minutes flag - Whether minutes field is enabled |
|
| DefaultVisitCode | int | 4 | √ | null |
|
|
Default visit code - Default visit code for new visits |
|
| DontShowTimeSelector | bit | 1 | √ | null |
|
|
Hide time selector flag - Whether to hide time selection controls |
|
| RequireObjectives | bit | 1 | √ | null |
|
|
Require objectives flag - Whether objectives are required for visit entry |
|
| DontAllowDifferentAuthMinutes | bit | 1 | √ | null |
|
|
Restrict auth minutes flag - Prevents different minutes than authorized |
|
| DontAutomaticallyCalculateEndTime | bit | 1 | √ | null |
|
|
No auto end time flag - Prevents automatic end time calculation |
|
| DefaultTab | int | 4 | √ | null |
|
|
Default tab setting - Default tab to display on visit entry form |
|
| ShowVisitCodeAndFormFirst | int | 4 | √ | null |
|
|
Show visit code first setting - Whether to show visit code and form fields first |
|
| Outcomes | int | 4 | √ | null |
|
|
Outcomes field setting - Configuration for outcomes tracking field |
|
| ShowButtonAvailableMakeUps | bit | 1 | √ | null |
|
|
Show make-up button flag - Whether to show available make-up sessions button |
|
| DontAllowEnterMakeUpdate | bit | 1 | √ | null |
|
|
No make-up entry flag - Prevents entry of make-up visits |
|
| CheckClaim | int | 4 | √ | null |
|
|
Check claim setting - Configuration for claim validation checks |
|
| ShowIfSelectMakeUpVisitCode | bit | 1 | √ | null |
|
|
Show make-up visit code flag - Whether to show make-up visit code selection |
|
| ShowScNoteButton | int | 4 | √ | null |
|
|
Show SC note button setting - Configuration for service coordinator note button |
|
| AuthorizationFilter | int | 4 | √ | null |
|
|
Authorization filter setting - Configuration for authorization filtering options |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Schedule__3214EC27099EB674 | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
