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. 

PPS3MOutputDataID 
Definition  Auto generated unique primary key value. 

VisitID 
Definition  A foreign key to the GUID column in the CV3ClientVisit table. 

WorksheetID 
Definition  A foreign key to the WorksheetID column in the SXARCMWorksheet table. 

CoinsurancePayment 
Definition  Coinsurance payment amount received in 3M output data 

MedicarePayment 
Definition  Medicare payment amount received in 3M output data 

PatientResponsibilityPayment 
Definition  Patient Responsibility Payment received in 3M output data 

OtherPatientResponsibilityPayment 
Definition  Other Patient Responsibility Payment received in 3M output data 

CostOutlierPayment 
Definition  Cost Outlier Payment amount received in 3M output data 

EapgPayment 
Definition  EAPG Payment amount received in 3M output data 

AddOnPayment 
Definition  Add on Payment amount received in 3M output data 

ExistingPayment 
Definition  Existing Payment amount received in 3M output data 

HacAdjustedDrg 
Definition  HAC (Hospital Acquired Condition) Adjusted DRG (Diagnoses related group) field received in 3M output data 

PaymentStatus 
Definition  Payment Status field received in 3M output data 

HacAdjustedMdc 
Definition  HAC Adjusted MDC (Major Diagnostic Category) field received in 3M output data 

Mdc 
Definition  MDC field received in 3M output data 

HacAdjustedMedicalSurgicalDrgFlag 
Definition  HAC Adjusted Medical Surgical DRG Flag field received in 3M output data 

MedicalSurgicalDrgFlag 
Definition  Medical Surgical Drg Flag field received in 3M output data 

Weight 
Definition  Weight received in 3M output data 

PaymentAction 
Definition  Payment Action field received in 3M output data 

MeanLos 
Definition  Mean LOS (Length of stay) amount received in 3M output data 

PrincipalDiagnosisUsed 
Definition  Principal Diagnosis Used field received in 3M output data 

TotalPayment 
Definition  Total Payment Amount received in 3M output data 

TotalCharges 
Definition  Total Charges Amount received in 3M output data 

PrincipalDiagnosisPoaUsed 
Definition  Used to store the output field received from 3M. The present on admission (POA) value used during processing. 

MappingIndicator 
Definition  Used to store the output field received from 3M. Indicates if mapping was called and if it occurred 

WorksheetYear 
Definition  A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. 

Drg 
Definition  Stores the Drg received from 3M service call 

GrouperTypeUsed 
Definition  To store Grouper Type for DRG 

ReimbursementTypeUsed 
Definition  To store Reimbursement Type for DRG 

RateCode 
Definition  To store Rate Code for EAPG 

HacAdjustedDrgName 
Definition  Holds HAC Adjusted DRG Name in case of HL7. 

MdcName 
Definition  Holds MDC Name in case of HL7. 

DrgDescription 
Definition  Holds DRG Description in case of HL7. 

PreviewWorksheetID 
Definition  A foreign key to the PreviewWorksheetID column in the SXARCMPreviewWorksheet table. 

PreviewWorksheetYear 
Definition  A foreign key to the WorkSheetYear column in the SXARCMPreviewWorksheet table. 

CapitalCostOutlierPayment 
Definition  Contains the CapitalCostOutlierPayment amount 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

GrouperVersion 
Definition  3M Grouper Version 

SeverityOfIllness 
Definition  Hold the version string of the Grouper used for a particular visit 

MedicareBeforeSequestrationPayment 
Definition  Total claim Medicare payment before the 2% sequestration reduction is applied. 

TotalExcludingPassThroughPayment 
Definition  The total expected payment without the miscellaneous per diem amounts based on the interim payments to the hospital for costs representing direct medical education, organ acquisition, as well as other costs 

TotalExcludingOutliersPayment 
Definition  Claim payment before cost outlier and add-on payments. 

MedicareSequestrationAmount 
Definition  The difference between the claim Medicare payment before the sequestration reduction is applied and the claim Medicare payment after the sequestration reduction is applied. 

MeanLos2 
Definition  Geometric Mean Length of Stay used for certain schemes 

DrgBaseAmount 
Definition  The DRG base amount 

DrgBasePayment 
Definition  The DRG base payment