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. 

IncomeAnalysisID 
Definition  Auto generated unique primary key value. 

TransactionID 
Definition  A foreign key to the TransactionID column in the SXARCMTransaction table. 

AccountingPeriodID 
Definition  A foreign key to the AccountingPeriodID column in the SXARCMAccountingPeriod table. 

AccountingYear 
Definition  Accounting year of the transaction 

FacilityID 
Definition  Stores the facility ID for the transaction 

FinancialClassID 
Definition  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 

AccountGroup 
Definition  Stores the account group of the visit 

InsuranceCarrierID 
Definition  Stores the insurance carrier ID of visit 

ServiceID 
Definition  Stores the service id of the visit 

VisitTypeCode 
Definition  Stores the visit type of the visit 

AccommodationID 
Definition  Stores the accommodation id of the visit 

DepartmentCodeID 
Definition  A foreign key to the DepartmentCodeMasterID column in the SXARCMDepartmentCodeMaster table. 

TransactionTypeID 
Definition  A foreign key to the TransactionTypeMasterID column in the SXARCMTransactionTypeMaster table. 

GroupPracticeID 
Definition  Stores the group practice ID of the transaction 

BillingProviderID 
Definition  Stores the billing provider ID of transaction 

RenderingProviderID 
Definition  Stores the rendering provider ID of transaction 

OrderingProviderID 
Definition  Stores the ordering provider ID of transaction 

RevenueCodeID 
Definition  Stores the ID which points to revenue code of transaction 

Cost 
Definition  Stores the cost of the transaction 

TotalCount 
Definition  Stores the count of the transaction 

Amount 
Definition  Stores the amount of the transaction 

Unit 
Definition  Stores the unit of the transaction 

SubDepartmentID 
Definition  A foreign key to the SubDepartmentCodeMasterID column in the SXARCMSubDepartmentCodeMaster table. 

TransactionSubTypeID 
Definition  A foreign key to the TransactionSubTypeMasterID column in the SXARCMTransactionSubTypeMaster table. 

TransactionCodeID 
Definition  A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. 

AccountingPeriodStatusID 
Definition  A foreign key to the AccountingPeriodStatusID column in the SXARCMAccountingPeriodStatus table. 

TransactionYear 
Definition  A foreign key to the TransactionYear column in the SXARCMTransaction table. 

GLRunDetailsID 
Definition  GLRunDetails ID from SXARCMGLDailyRunDetails Table 

LocationGUID 
Definition  Stores the location of the transaction 

WorkRVU 
Definition  Stores the work rvu of the transaction 

TotalRVU 
Definition  Stores the total rvu of the transaction 

IsBilled 
Definition  Stores the is billed of the transaction 

IsClosed 
Definition  Flag denotes if record falls in closed accounting period 

ReverseOfIncomeAnalysisID 
Definition  A foreign key to the IncomeAnalysisID column in the SXARCMGLIncomeAnalysis table. 

IsMovedtoGLData 
Definition  Flag set if IA data is processed to GL data 

OpenAccountingPeriodID 
Definition  Stores the Accounting period ID in which this IA record will fall after updation 

InsurancePlanID 
Definition  Stores Insurance Plan ID 

HCPCSCode 
Definition  Stores the HCPCS code attached to transaction 

ClosedAPDtm 
Definition  Stored the closed accounting period datetime 

PostingUTC 
Definition  Stored the Posting Date 

TransactionCodeMasterID 
Definition  Stores the TransactionCodeMasterID 

VisitID 
Definition  Stores the VisitID 

IsBadDebt 
Definition  Bad Debt flag 

ServiceDate 
Definition  Stores service date for income analysis 

JobID 
Definition  A foreign key to the JobID column in the SXARCMJob table. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

CareLevelGUID 
Definition  Specifies carelevel visit type GUID from CV3CareLevel 

TransactionLocationGUID 
Definition  Specifies GUID TransactionLocation key 

VisitTypeDailyGUID 
Definition  Used to store Visit Type GUID changing on a daily basis 

CareLevelDailyGUID 
Definition  Used to store Care Level GUID changing on a daily basis