dbo.SXARCMPPS3MOutputData 
Default Table Name  SXARCMPPS3MOutputData 
Definition  Stores the data that we get from 3M after making a service call. 

dbo.SXARCMPPS3MOutputData 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. 
PPS3MOutputDataID(PK)    bigint  NO  Auto generated unique primary key value. 
VisitID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3ClientVisit table. 
WorksheetID(FK)    bigint  YES  A foreign key to the WorksheetID column in the SXARCMWorksheet table. 
CoinsurancePayment    SXACurrencyDt  YES  Coinsurance payment amount received in 3M output data 
MedicarePayment    SXACurrencyDt  YES  Medicare payment amount received in 3M output data 
PatientResponsibilityPayment    SXACurrencyDt  YES  Patient Responsibility Payment received in 3M output data 
OtherPatientResponsibilityPayment    SXACurrencyDt  YES  Other Patient Responsibility Payment received in 3M output data 
CostOutlierPayment    SXACurrencyDt  YES  Cost Outlier Payment amount received in 3M output data 
EapgPayment    SXACurrencyDt  YES  EAPG Payment amount received in 3M output data 
AddOnPayment    SXACurrencyDt  YES  Add on Payment amount received in 3M output data 
ExistingPayment    SXACurrencyDt  YES  Existing Payment amount received in 3M output data 
HacAdjustedDrg    varchar(3)  YES  HAC (Hospital Acquired Condition) Adjusted DRG (Diagnoses related group) field received in 3M output data 
PaymentStatus    varchar(2)  YES  Payment Status field received in 3M output data 
HacAdjustedMdc    varchar(2)  YES  HAC Adjusted MDC (Major Diagnostic Category) field received in 3M output data 
Mdc    varchar(2)  YES  MDC field received in 3M output data 
HacAdjustedMedicalSurgicalDrgFlag    char(1)  YES  HAC Adjusted Medical Surgical DRG Flag field received in 3M output data 
MedicalSurgicalDrgFlag    char(1)  YES  Medical Surgical Drg Flag field received in 3M output data 
Weight    decimal(12, 6)  YES  Weight received in 3M output data 
PaymentAction    varchar(2)  YES  Payment Action field received in 3M output data 
MeanLos    decimal(8, 3)  YES  Mean LOS (Length of stay) amount received in 3M output data 
PrincipalDiagnosisUsed    varchar(20)  YES  Principal Diagnosis Used field received in 3M output data 
TotalPayment    SXACurrencyDt  YES  Total Payment Amount received in 3M output data 
TotalCharges    SXACurrencyDt  YES  Total Charges Amount received in 3M output data 
PrincipalDiagnosisPoaUsed    char(1)  YES  Used to store the output field received from 3M. The present on admission (POA) value used during processing. 
MappingIndicator    char(1)  YES  Used to store the output field received from 3M. Indicates if mapping was called and if it occurred 
WorksheetYear(FK)    int  YES  A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. 
Drg    varchar(6)  YES  Stores the Drg received from 3M service call 
GrouperTypeUsed    varchar(50)  YES  To store Grouper Type for DRG 
ReimbursementTypeUsed    varchar(50)  YES  To store Reimbursement Type for DRG 
RateCode    nvarchar(60)  YES  To store Rate Code for EAPG 
HacAdjustedDrgName    varchar(200)  YES  Holds HAC Adjusted DRG Name in case of HL7. 
MdcName    varchar(200)  YES  Holds MDC Name in case of HL7. 
DrgDescription    varchar(200)  YES  Holds DRG Description in case of HL7. 
PreviewWorksheetID    bigint  YES  A foreign key to the PreviewWorksheetID column in the SXARCMPreviewWorksheet table. 
PreviewWorksheetYear    int  YES  A foreign key to the WorkSheetYear column in the SXARCMPreviewWorksheet table. 
CapitalCostOutlierPayment    SXACurrencyDt  YES  Contains the CapitalCostOutlierPayment amount 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
GrouperVersion    varchar(10)  YES  3M Grouper Version 
SeverityOfIllness    varchar(8)  YES  Hold the version string of the Grouper used for a particular visit 
MedicareBeforeSequestrationPayment    SXACurrencyDt  YES  Total claim Medicare payment before the 2% sequestration reduction is applied. 
TotalExcludingPassThroughPayment    SXACurrencyDt  YES  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    SXACurrencyDt  YES  Claim payment before cost outlier and add-on payments. 
MedicareSequestrationAmount    SXACurrencyDt  YES  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    decimal(8, 3)  YES  Geometric Mean Length of Stay used for certain schemes 
DrgBaseAmount    SXACurrencyDt  YES  The DRG base amount 
DrgBasePayment    SXACurrencyDt  YES  The DRG base payment 

dbo.SXARCMPPS3MOutputData Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMPPS3MOutputDataPK  PrimaryKey  PPS3MOutputDataID