Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Settings identifier - Unique identifier for each visit entry settings configuration |
|
| fkCPID | int | 4 | null |
|
|
Claim type program reference - Links to claim type program configuration that these settings apply to |
||
| EntryType | nvarchar | 40 | null |
|
|
Entry type - Type of visit entry form (e.g., therapy, evaluation, service coordination) |
||
| TimeStart | int | 4 | √ | null |
|
|
Start time setting - Configuration for start time field display and behavior |
|
| TimeEnd | int | 4 | √ | null |
|
|
End time setting - Configuration for end time field display and behavior |
|
| Minutes | int | 4 | √ | null |
|
|
Minutes setting - Configuration for minutes/duration field display and behavior |
|
| Units | int | 4 | √ | null |
|
|
Units setting - Configuration for billing units field display and behavior |
|
| File | int | 4 | √ | null |
|
|
File setting - Configuration for file attachment functionality |
|
| Form | int | 4 | √ | null |
|
|
Form setting - Configuration for form selection and display |
|
| ServiceCoordinator | int | 4 | √ | null |
|
|
Service coordinator setting - Configuration for service coordinator field display |
|
| ICD | int | 4 | √ | null |
|
|
ICD setting - Configuration for ICD diagnosis code field display and behavior |
|
| DefaultICD | int | 4 | √ | null |
|
|
Default ICD setting - Default ICD diagnosis code selection behavior |
|
| CPT | int | 4 | √ | null |
|
|
CPT setting - Configuration for CPT procedure code field display and behavior |
|
| DefaultCPT | int | 4 | √ | null |
|
|
Default CPT setting - Default CPT procedure code selection behavior |
|
| Auth | int | 4 | √ | null |
|
|
Authorization setting - Configuration for authorization field display and validation |
|
| Location | int | 4 | √ | null |
|
|
Location setting - Configuration for service location field display |
|
| Provider | int | 4 | √ | null |
|
|
Provider setting - Configuration for service provider field display and selection |
|
| CreatedDate | datetime | 16,3 | null |
|
|
Settings creation date - Date when these visit entry settings were created |
||
| CreatedBy | int | 4 | null |
|
|
Settings created by - UserID of the person who created these settings |
||
| ModifiedDate | datetime | 16,3 | √ | null |
|
|
Settings modification date - Date when these settings were last modified |
|
| ModifiedBy | int | 4 | √ | null |
|
|
Settings modified by - UserID of the person who last modified these settings |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Settings deletion date - Soft delete timestamp for audit trail purposes |
|
| DeletedBy | int | 4 | √ | null |
|
|
Settings deleted by - UserID of the person who deleted these settings |
|
| CaseSite | int | 4 | √ | ((0)) |
|
|
Case site setting - Configuration for case site field display |
|
| PaymentSource | int | 4 | √ | ((0)) |
|
|
Payment source setting - Configuration for payment source field display |
|
| Times | int | 4 | √ | null |
|
|
Times setting - Configuration for time-related field behavior |
|
| Note1 | int | 4 | √ | ((1)) |
|
|
Note 1 setting - Configuration for first note field display and behavior |
|
| QuickAction | varchar | 250 | √ | null |
|
|
Quick action setting - Configuration for quick action buttons and functionality |
|
| ShowAllActivePatients | int | 4 | ((0)) |
|
|
Show all active patients flag - Controls whether all active patients are shown in patient selection |
||
| ViewEnteredDetails | int | 4 | ((1)) |
|
|
View entered details flag - Controls whether entered visit details are viewable |
||
| ShowSignatureDate | int | 4 | ((0)) |
|
|
Show signature date flag - Controls whether signature date is displayed |
||
| ShowPayroll | int | 4 | ((0)) |
|
|
Show payroll flag - Controls whether payroll information is displayed |
||
| AllowFutureDates | bit | 1 | √ | null |
|
|
Allow future dates flag - Controls whether future service dates are allowed |
|
| CalculateUnits | bit | 1 | √ | null |
|
|
Calculate units flag - Controls whether billing units are automatically calculated |
|
| DefaultLocation | int | 4 | √ | null |
|
|
Default location - Default service location selection |
|
| DefaultRateCode | int | 4 | √ | null |
|
|
Default rate code - Default rate code selection for billing |
|
| DefaultRateCode2 | int | 4 | √ | null |
|
|
Default rate code 2 - Second default rate code selection |
|
| DefaultRateCode3 | int | 4 | √ | null |
|
|
Default rate code 3 - Third default rate code selection |
|
| Note1Label | varchar | 250 | √ | null |
|
|
Note 1 label - Custom label for the first note field |
|
| Note2 | int | 4 | √ | null |
|
|
Note 2 setting - Configuration for second note field display and behavior |
|
| Note2Label | varchar | 250 | √ | null |
|
|
Note 2 label - Custom label for the second note field |
|
| Note3 | int | 4 | √ | null |
|
|
Note 3 setting - Configuration for third note field display and behavior |
|
| Note3Label | varchar | 250 | √ | null |
|
|
Note 3 label - Custom label for the third note field |
|
| Note4 | int | 4 | √ | null |
|
|
Note 4 setting - Configuration for fourth note field display and behavior |
|
| Note4Label | varchar | 250 | √ | null |
|
|
Note 4 label - Custom label for the fourth note field |
|
| Note5 | int | 4 | √ | null |
|
|
Note 5 setting - Configuration for fifth note field display and behavior |
|
| Note5Label | varchar | 250 | √ | null |
|
|
Note 5 label - Custom label for the fifth note field |
|
| NotEditWhenSignatureLocked | bit | 1 | √ | ((0)) |
|
|
No edit when signature locked flag - Prevents editing when signature is locked |
|
| NotEditWhenStatusCodeIds | nvarchar | 500 | √ | null |
|
|
No edit when status codes - List of status codes that prevent editing |
|
| RateCode | int | 4 | √ | null |
|
|
Rate code setting - Configuration for rate code field display and behavior |
|
| RateCode2 | int | 4 | √ | null |
|
|
Rate code 2 setting - Configuration for second rate code field |
|
| RateCode2Label | varchar | 250 | √ | null |
|
|
Rate code 2 label - Custom label for the second rate code field |
|
| RateCode3 | int | 4 | √ | null |
|
|
Rate code 3 setting - Configuration for third rate code field |
|
| RateCode3Label | varchar | 250 | √ | null |
|
|
Rate code 3 label - Custom label for the third rate code field |
|
| RateCodeLabel | varchar | 250 | √ | null |
|
|
Rate code label - Custom label for the primary rate code field |
|
| EnableMinutes | bit | 1 | √ | ((0)) |
|
|
Enable minutes flag - Controls whether minutes field is enabled for input |
|
| DefaultVisitCode | int | 4 | ((0)) |
|
|
Default visit code - Default visit code selection |
||
| DontShowTimeSelector | bit | 1 | ((0)) |
|
|
Don’t show time selector flag - Hides time selector interface |
||
| RequireObjectives | bit | 1 | ((0)) |
|
|
Require objectives flag - Makes objectives selection mandatory |
||
| DontAllowDifferentAuthMinutes | bit | 1 | ((0)) |
|
|
Don’t allow different auth minutes flag - Prevents minutes different from authorization |
||
| DontAutomaticallyCalculateEndTime | bit | 1 | ((0)) |
|
|
Don’t auto calculate end time flag - Disables automatic end time calculation |
||
| DefaultTab | int | 4 | √ | null |
|
|
Default tab - Default tab to display when opening visit entry |
|
| ShowVisitCodeAndFormFirst | int | 4 | √ | null |
|
|
Show visit code and form first - Controls display order of visit code and form fields |
|
| Outcomes | int | 4 | √ | null |
|
|
Outcomes setting - Configuration for outcomes field display and behavior |
|
| ShowButtonAvailableMakeUps | bit | 1 | √ | ((0)) |
|
|
Show available make-ups button flag - Controls display of make-up sessions button |
|
| DontAllowEnterMakeUpdate | bit | 1 | √ | null |
|
|
Don’t allow enter make update flag - Prevents entering make-up updates |
|
| CheckClaim | int | 4 | √ | null |
|
|
Check claim setting - Configuration for claim validation checking |
|
| ShowIfSelectMakeUpVisitCode | bit | 1 | √ | null |
|
|
Show if select make-up visit code flag - Controls display when make-up visit code is selected |
|
| ShowScNoteButton | int | 4 | √ | null |
|
|
Show SC note button - Configuration for service coordination note button display |
|
| AuthorizationFilter | int | 4 | √ | null |
|
|
Authorization filter - Configuration for authorization filtering options |
|
| ActionsUnderVisitDetails | nvarchar | 500 | √ | null |
|
|
Actions under visit details - Configuration for action buttons under visit details |
|
| AutomaticallyPopulateEndTimeByEnteringMinutes | bit | 1 | √ | null |
|
|
Auto populate end time by minutes flag - Automatically calculates end time when minutes are entered |
|
| FilterDiagnosisByServiceDate | bit | 1 | √ | null |
|
|
Filter diagnosis by service date flag - Filters diagnosis options by service date |
|
| NumberOfDayGracePeriodTheDiagnosis | int | 4 | √ | null |
|
|
Diagnosis grace period days - Number of days grace period for diagnosis validity |
|
| ClaimActionIdsWorkAnyStatus | nvarchar | 1000 | √ | null |
|
|
Claim action IDs work any status - List of claim action IDs that work with any status |
|
| ServiceType | int | 4 | √ | null |
|
|
Service type setting - Configuration for service type field display and behavior |
|
| FilterProviderDropdownByRole | varchar | 2147483647 | √ | null |
|
|
Filter provider dropdown by role - Filters provider dropdown options by user role |
|
| RequiredNumberOfOutComesAndObjectives | int | 4 | √ | null |
|
|
Required number of outcomes and objectives - Minimum number of outcomes and objectives required |
|
| BillableDatesServiceValidation | bit | 1 | √ | null |
|
|
Billable dates service validation flag - Enables validation for billable service dates |
|
| BillableCalculatedDateService | int | 4 | √ | null |
|
|
Billable calculated date service - Configuration for billable date calculation |
|
| NonBillableDatesServiceValidation | bit | 1 | √ | null |
|
|
Non-billable dates service validation flag - Enables validation for non-billable service dates |
|
| NonBillableCalculatedDateService | int | 4 | √ | null |
|
|
Non-billable calculated date service - Configuration for non-billable date calculation |
|
| WorkDayDifference | int | 4 | √ | null |
|
|
Work day difference - Number of work days difference allowed for service dates |
|
| OpenEnterSCByAuthActionInNewTab | bit | 1 | √ | null |
|
|
Open enter SC by auth action in new tab flag - Opens service coordination entry in new tab |
|
| ShowActionSaveBillingOnly | bit | 1 | √ | null |
|
|
Show action save billing only flag - Shows save billing only action button |
|
| EvalBilingual | int | 4 | √ | null |
|
|
Evaluation bilingual setting - Configuration for bilingual evaluation options |
|
| FilterDiagnosisByServiceType | bit | 1 | √ | null |
|
|
Filter diagnosis by service type flag - Filters diagnosis options by service type |
|
| OverlapTimeBuffer | int | 4 | √ | null |
|
|
Overlap time buffer - Time buffer in minutes to prevent scheduling overlaps |
|
| DisplayAssignedAuthorizationOnlyWhenEdit | bit | 1 | √ | null |
|
|
Display assigned authorization only when edit flag - Shows assigned authorization only during editing |
|
| EnableSelectProviderWhenEditing | bit | 1 | √ | null |
|
|
Enable select provider when editing flag - Allows provider selection during editing |
|
| NumberInGroup | int | 4 | √ | null |
|
|
Number in group - Default number of participants in group sessions |
|
| DontAllowEnterFutureDate | bit | 1 | √ | null |
|
|
Don’t allow enter future date flag - Prevents entry of future service dates |
|
| IgnoreOutcomesAndObjectivesValidation | bit | 1 | √ | null |
|
|
Ignore outcomes and objectives validation flag - Bypasses outcomes and objectives validation |
|
| EvalDefaultIsAuthServiceType | bit | 1 | √ | null |
|
|
Evaluation default is auth service type flag - Uses authorization service type as default for evaluations |
|
| EnableNumberInGroupValidation | bit | 1 | √ | null |
|
|
Enable number in group validation flag - Enables validation for number of group participants |
|
| AllowSelectModifier | bit | 1 | √ | null |
|
|
Allow select modifier flag - Allows selection of procedure modifiers |
|
| ValidatePayrollBeforeClaimDelete | bit | 1 | √ | null |
|
|
Validate payroll before claim delete flag - Validates payroll status before allowing claim deletion |
|
| ServiceSetting | int | 4 | √ | null |
|
|
Service setting - Configuration for service-related field behavior |
|
| ShowAddress | int | 4 | √ | null |
|
|
Show address setting - Configuration for address field display |
|
| ShowCity | int | 4 | √ | null |
|
|
Show city setting - Configuration for city field display |
|
| ShowZipCode | int | 4 | √ | null |
|
|
Show zip code setting - Configuration for zip code field display |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_VisitEntrySettings | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
