dbo.SXARCMSRReportDefinition 
Default Table Name  SXARCMSRReportDefinition 
Definition  This table is used for storing state report defination 

dbo.SXARCMSRReportDefinition Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 
TouchedBy    varchar(50)  NO  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
CreatedBy    varchar(50)  NO  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
ReportDefinitionID(PK)    bigint  NO  Auto generated unique primary key value. 
ReportDefinitionName    varchar(100)  NO  Unique userfriendly name 
ReportingAgencyID(FK)    int  NO  A foreign key to the ReportingAgencyID column in the SXARCMRRReportingAgency table. 
QualifyingVisitSQLQuery    nvarchar(1000)  NO  query used for selecting the qualifying visit for this report. 
SSISPackageName    varchar(200)  NO  name of the SSIS package that will generate the required ouput 
ProcessedVisitStagingTableName    varchar(200)  YES  name of the staging table that holds the denormalized data required for generating the output 
OutputDirectoryPath    nvarchar(800)  NO  directory path where the out files will be placed 
FileMask    nvarchar(200)  NO  mask text based on the mask text output file name will be determined 
VisitProcessingSP    nvarchar(500)  NO  stored procedure name that’s used for generating the denormalized data 
FrequencyOfReportingInMonths    int  NO  interval in months to determine the frequency with which the report will be generated 
IsActive    bit  NO  determines whether the report is active or inactive 
PreProcessingLagDays    int  NO  waiting period in days for starting processing. 
ReportHeaderTemplateLayoutMasterID(FK)    bigint  YES  A foreign key to the ReportHeaderTemplateLayoutMasterID column in the SXARCMSRReportHeaderTemplateLayoutMaster table. 
ReportHeaderMasterID(FK)    bigint  YES  A foreign key to the ReportHeaderMasterID column in the SXARCMSRReportHeaderMaster table. 
EffectiveEndDate    date  YES  Stores report effective End date 
EffectiveFromDate    date  YES  Stores report effective from date 
InitialStartDate    date  YES  Stores report Initial Start Date 
Abbreviation    varchar(10)  YES  This stores the abbrevation 
Description    varchar(255)  YES  This stores the data description 
OutputFileFormat    varchar(20)  YES  Specifies the output file format like XML or Flat file 
EditReportFileFormat    varchar(20)  YES  Specifies the Edit Report file format like PDF or Excel 
EditReportHeaderLabel    varchar(200)  YES  Header label of Edit report 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsEditReportOnly    bit  NO  This will be a one bit flag to set visibility off/on for generate edit report only 
IsRegenerationVisible    bit  NO  Value contains whether to show checkbox for Regeneration 
IsTestFileVisible    bit  NO  Value contains whether to show checkbox for Testfile 
ReportSchemaDefinitionXML    xml  YES  This Column is used to store xsd file. 
VersionNumber    int  NO  Stores Version Number of the current Report Type 
ContentID(FK)    int  NO  A foreign key to the ContentID column in the SXARCMContent table. 
FallbackRevenueCodeCategory    int  YES  Stores Default Revenue Code Category to be excluded while processing 
ExclusionRevenueCodeCategory    int  YES  Stores Default Revenue Code Category to be excluded while processing 
FirstMonthOfFiscalYear    int  YES  Indicates the first month of the fiscal year. For eg. If fiscal year for a state is from July-Jun, then the reports of this state will have 7 in this column as the fiscal year starts from July 
IsIncludeVisitTypeVisible    bit  NO  The value indicates whether the VisitTypeVisible needs to shown the screen or not. 
IsExcludeInsurancePlanVisible    bit  NO  The value indicates whether the ExcludeInsurancePlanVisible needs to shown the screen or not. 
IsSkipUnbilledVisitsVisible    bit  NO  The value indicates whether the SkipUnbilledVisitsVisible needs to shown the screen or not. 
IsSkipVisitInEditReport    bit  NO  The value indicates whether the SkipVisitInEditReport needs to shown the screen or not. 
IsRevCPTCodeTranslationRequired    bit  NO  The value indicates whether the Translation for rev HCPCS code needs to be considered during the state report generation. 
IsDefaultValueSupported    bit  NO  The value indicates whether the Default value drop down needs to be shown in translation dictionary screen or not. 
BatchSize    int  YES  The value indicates the volumne of visits qualified in single batch during the state report file generation. 
IsSpecificVisitsVisible    bit  NO  The value indicates whether the Specific Visits multicombobox needs to shown the screen or not. 
IsSkipZeroChargeVisitsVisible    bit  NO  The value indicates whether the SkipZeroChargeVisits checkbox needs to shown the screen or not. 
IsIncludeServiceTypeVisible    bit  NO  Indicates whether the service type selection control will be visible in the Regulatory Reporting workflow activity. 
IsIncludeSubDepartmentVisible    bit  NO  Indicates whether the subdepartment selection control will be visible in the Regulatory Reporting workflow activity. 

dbo.SXARCMSRReportDefinition Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMSRReportDefinitionPK  PrimaryKey  ReportDefinitionID