Build 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  Optimistic lock identifier using rowversion datatype. 

ReportDefinitionID 
Definition  Auto generated unique primary key value. 

ReportDefinitionName 
Definition  Unique userfriendly name 

ReportingAgencyID 
Definition  A foreign key to the ReportingAgencyID column in the SXARCMRRReportingAgency table. 

QualifyingVisitSQLQuery 
Definition  query used for selecting the qualifying visit for this report. 

SSISPackageName 
Definition  name of the SSIS package that will generate the required ouput 

ProcessedVisitStagingTableName 
Definition  name of the staging table that holds the denormalized data required for generating the output 

OutputDirectoryPath 
Definition  directory path where the out files will be placed 

FileMask 
Definition  mask text based on the mask text output file name will be determined 

VisitProcessingSP 
Definition  stored procedure name that’s used for generating the denormalized data 

FrequencyOfReportingInMonths 
Definition  interval in months to determine the frequency with which the report will be generated 

IsActive 
Definition  determines whether the report is active or inactive 

PreProcessingLagDays 
Definition  waiting period in days for starting processing. 

ReportHeaderTemplateLayoutMasterID 
Definition  A foreign key to the ReportHeaderTemplateLayoutMasterID column in the SXARCMSRReportHeaderTemplateLayoutMaster table. 

ReportHeaderMasterID 
Definition  A foreign key to the ReportHeaderMasterID column in the SXARCMSRReportHeaderMaster table. 

EffectiveEndDate 
Definition  Stores report effective End date 

EffectiveFromDate 
Definition  Stores report effective from date 

InitialStartDate 
Definition  Stores report Initial Start Date 

Abbreviation 
Definition  This stores the abbrevation 

Description 
Definition  This stores the data description 

OutputFileFormat 
Definition  Specifies the output file format like XML or Flat file 

EditReportFileFormat 
Definition  Specifies the Edit Report file format like PDF or Excel 

EditReportHeaderLabel 
Definition  Header label of Edit report 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsEditReportOnly 
Definition  This will be a one bit flag to set visibility off/on for generate edit report only 

IsRegenerationVisible 
Definition  Value contains whether to show checkbox for Regeneration 

IsTestFileVisible 
Definition  Value contains whether to show checkbox for Testfile 

ReportSchemaDefinitionXML 
Definition  This Column is used to store xsd file. 

VersionNumber 
Definition  Stores Version Number of the current Report Type 

ContentID 
Definition  A foreign key to the ContentID column in the SXARCMContent table. 

FallbackRevenueCodeCategory 
Definition  Stores Default Revenue Code Category to be excluded while processing 

ExclusionRevenueCodeCategory 
Definition  Stores Default Revenue Code Category to be excluded while processing 

FirstMonthOfFiscalYear 
Definition  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 
Definition  The value indicates whether the VisitTypeVisible needs to shown the screen or not. 

IsExcludeInsurancePlanVisible 
Definition  The value indicates whether the ExcludeInsurancePlanVisible needs to shown the screen or not. 

IsSkipUnbilledVisitsVisible 
Definition  The value indicates whether the SkipUnbilledVisitsVisible needs to shown the screen or not. 

IsSkipVisitInEditReport 
Definition  The value indicates whether the SkipVisitInEditReport needs to shown the screen or not. 

IsRevCPTCodeTranslationRequired 
Definition  The value indicates whether the Translation for rev HCPCS code needs to be considered during the state report generation. 

IsDefaultValueSupported 
Definition  The value indicates whether the Default value drop down needs to be shown in translation dictionary screen or not. 

BatchSize 
Definition  The value indicates the volumne of visits qualified in single batch during the state report file generation. 

IsSpecificVisitsVisible 
Definition  The value indicates whether the Specific Visits multicombobox needs to shown the screen or not. 

IsSkipZeroChargeVisitsVisible 
Definition  The value indicates whether the SkipZeroChargeVisits checkbox needs to shown the screen or not. 

IsIncludeServiceTypeVisible 
Definition  Indicates whether the service type selection control will be visible in the Regulatory Reporting workflow activity. 

IsIncludeSubDepartmentVisible 
Definition  Indicates whether the subdepartment selection control will be visible in the Regulatory Reporting workflow activity.