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. |
StatementRCTransactionInfoId |
Definition | Auto generated unique primary key value. |
StatementArtifactID |
Definition | A foreign key to the StatementArtifactID column in the SXARCMStatementArtifact table. |
TransactionID |
Definition | A foreign key to the TransactionID column in the SXARCMTransaction table. |
BatchID |
Definition | A foreign key to the BatchID column in the SXARCMBatch table. |
PostedUTC |
Definition | Contains the Posted UTC of the transaction |
TransactionCodeMasterID |
Definition | Contains the TransactionCodeMasterID of the transaction |
Amount |
Definition | Contains the Amount of the transaction |
VisitID |
Definition | Contains the VisitID of the transaction |
ReverseTransactionID |
Definition | Contains the Reverse TransactionID |
TransactionCodeDescription |
Definition | Contains the Transaction Code Description |
IsLateCharge |
Definition | Contains the LateCharge status |
PostingStatus |
Definition | Contains the Posting Status |
IsEditedAfterPost |
Definition | Contains the EditedAfterPost status |
IsAutoGenerated |
Definition | Contains the AutoGenerated status |
TransactionNote |
Definition | PHI: Contains the Transaction Note |
IsTransferred |
Definition | Contains the Transferred status |
TransactionYear |
Definition | A foreign key to the TransactionYear column in the SXARCMTransaction table. |
EpisodeID |
Definition | Contains the Episode ID associated to the transaction |
WorksheetID |
Definition | Contains the WorksheetID associated to the transaction |
WorksheetTypeID |
Definition | Contains the Worksheet Type ID of the worksheet |
WorkSheetYear |
Definition | Contains the statement artifact Id's WorksheetYear to which the records are associated |
TransactionType |
Definition | Transaction Type Information like Charge, Adjustment etc. |
TransactionCodeMaster |
Definition | Transaction Code Master information |
WorksheetTransferTransactionID |
Definition | A foreign key to the WorksheetTransferTransactionID column in the SXARCMWorksheetTransferTransaction table. |
Provider |
Definition | Stores Provider name |
StatementArtifactYear |
Definition | A foreign key to the WorkSheetYear column in the SXARCMStatementArtifact table. |
ServiceDescription |
Definition | stores transaction code description |
ServiceDate |
Definition | PHI: Stores transaction service date |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
RevenueCode |
Definition | Stores revenue code of transaction |
RevenueCodeDescription |
Definition | Stores revenue code description of transaction |
AlternateDescription1 |
Definition | store transaction code description1 associated with transaction code |
AlternateDescription2 |
Definition | store transaction code description2 associated with transaction code |