Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 (3) | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | | Key to the Appointment_Type_DE table. |
 | EnterpriseEntryID | [dbo].[uniqueid] | 9 | NOT NULL | | | Master (enterprise) dictionary surrogate key. Points to Dictionary_Entry.EnterpriseEntryID |
(3) | DefinitionSetID | [dbo].[dict_id] | 5 | NOT NULL | | | Points to Dict_Definition_Set.DefinitionSetID but is typically zero. |
| Entry | [dbo].[dict_id] | 5 | NOT NULL | | | Calculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set |
(3) | EntryCode | [dbo].[code] | 10 | NOT NULL | | | Unique alphanumeric code. Brief but cryptic. |
(6) | EntryName | [dbo].[name] | 255 | NOT NULL | | | Unique alphanumeric "friendly" display name |
(3) | EntryMnemonic | [dbo].[code] | 10 | NOT NULL | | | Typically the same as the Code value, but can be blank. If present, it must be unique. |
(3)![Check Constraints CK_Appointment_Type_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Appointment_Type_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is not active; N=row is active. (Rows are inactivated rather than deleted for history) |
![Check Constraints CK_Appointment_Type_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y') Check Constraints CK_Appointment_Type_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')](../../../../Images/c-constraint.png) | IsEnforcedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y=row is readonly; N=row is modifiable |
(6)![Check Constraints CK_Appointment_Type_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y') Check Constraints CK_Appointment_Type_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')](../../../../Images/c-constraint.png) | IsCurrentFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Usually 'Y' but occasionally used to subordinate rows. Not exposed to the end user. |
| EffectiveDT | datetime | 8 | NULL allowed | | | Time of last modification (not "when this row goes into effect") |
| ApptTypeCategoryDE | [dbo].[dict_id] | 5 | NOT NULL | | | Category. Refers to Appt_Type_Category_DE.ID |
| PreSchedulingMessage | [dbo].[message] | 255 | NOT NULL | | | Standard Message for an Appointment before scheduling appointment |
| PostSchedulingMessage | [dbo].[message] | 255 | NOT NULL | | | Standard Message for an Appointment post scheduling appointment |
| AnticipatedDuration | smallint | 2 | NOT NULL | | | Anticipated Duration |
| AnticipatedUsageFactor | smallint | 2 | NOT NULL | | | Usage Factor |
![Check Constraints CK_Appointment_Type_DE_CanStraddleSegmentsFLAG_Yes_Or_No : ([CanStraddleSegmentsFLAG]='N' OR [CanStraddleSegmentsFLAG]='Y') Check Constraints CK_Appointment_Type_DE_CanStraddleSegmentsFLAG_Yes_Or_No : ([CanStraddleSegmentsFLAG]='N' OR [CanStraddleSegmentsFLAG]='Y')](../../../../Images/c-constraint.png) | CanStraddleSegmentsFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Can Straddle segment Flag |
| DefaultChargeCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Default charge code. Refers to Charge_Code_DE.ID |
| FormSetDE | [dbo].[dict_id] | 5 | NOT NULL | | | Form Set. Refers to Form_Set_DE.ID |
| BenefitCategoryDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Benefit Category. Refers to Befefit_Category_DE.ID |
![Foreign Keys FK_ApptType_MedicareService: [dbo].[Medicare_Type_Of_Service_DE].MedicareTypeOfServiceDE Foreign Keys FK_ApptType_MedicareService: [dbo].[Medicare_Type_Of_Service_DE].MedicareTypeOfServiceDE](../../../../Images/fk.png) | MedicareTypeOfServiceDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Medicare Service Type. Link to Medicare_Type_Of_Service_DE.ID |
![Check Constraints CK_Appointment_Type_DE_IsTransitionofCareFLAG_Yes_Or_No : ([IsTransitionofCareFLAG]='N' OR [IsTransitionofCareFLAG]='Y') Check Constraints CK_Appointment_Type_DE_IsTransitionofCareFLAG_Yes_Or_No : ([IsTransitionofCareFLAG]='N' OR [IsTransitionofCareFLAG]='Y')](../../../../Images/c-constraint.png) | IsTransitionofCareFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag for Transition of Care |
![Check Constraints CK_ApptTypeDE_StimRepFLAG : ([IsExcludefromStimulusReportingFLAG]='Y' OR [IsExcludefromStimulusReportingFLAG]='N') Check Constraints CK_ApptTypeDE_StimRepFLAG : ([IsExcludefromStimulusReportingFLAG]='Y' OR [IsExcludefromStimulusReportingFLAG]='N')](../../../../Images/c-constraint.png) | IsExcludefromStimulusReportingFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Flag to Exclude From Stimulus Reporting. |
| DoNotGenerateSendChargeTask | bit | 1 | NOT NULL | | ((0)) | Submit Encounter Form will not be generated when the value is 1 |
| DoNotAllowCharges | bit | 1 | NOT NULL | | ((0)) | Encounter Form will not be generated when the value is 1. |
| DoCreateReviewEncounterFormTask | bit | 1 | NOT NULL | | ((0)) | Review encounter form will be generated when value is 1. |
| IsVirtualVisitFLAG | [dbo].[BOOL] | 1 | NOT NULL | | ('N') | Appointment has been setup as a virtual visit |