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 |
|
bigint |
NO |
Auto generated unique primary key value. |
ReportDefinitionName |
|
varchar(100) |
NO |
Unique userfriendly name |
ReportingAgencyID |
|
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 |
|
bigint |
YES |
A foreign key to the ReportHeaderTemplateLayoutMasterID column in the SXARCMSRReportHeaderTemplateLayoutMaster table. |
ReportHeaderMasterID |
|
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 |
|
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. |