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 |