dbo.SXARCMGLIncomeAnalysis 
Default Table Name  SXARCMGLIncomeAnalysis 
Definition  Holds income analysis after going through GL process 

dbo.SXARCMGLIncomeAnalysis 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. 
IncomeAnalysisID(PK)    bigint  NO  Auto generated unique primary key value. 
TransactionID(FK)    bigint  NO  A foreign key to the TransactionID column in the SXARCMTransaction table. 
AccountingPeriodID(FK)    int  NO  A foreign key to the AccountingPeriodID column in the SXARCMAccountingPeriod table. 
AccountingYear    int  NO  Accounting year of the transaction 
FacilityID    HVCIDdt  YES  Stores the facility ID for the transaction 
FinancialClassID(FK)    int  YES  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 
AccountGroup    int  YES  Stores the account group of the visit 
InsuranceCarrierID    HVCIDdt  YES  Stores the insurance carrier ID of visit 
ServiceID    HVCIDdt  YES  Stores the service id of the visit 
VisitTypeCode    varchar(30)  YES  Stores the visit type of the visit 
AccommodationID    int  YES  Stores the accommodation id of the visit 
DepartmentCodeID(FK)    int  YES  A foreign key to the DepartmentCodeMasterID column in the SXARCMDepartmentCodeMaster table. 
TransactionTypeID(FK)    int  YES  A foreign key to the TransactionTypeMasterID column in the SXARCMTransactionTypeMaster table. 
GroupPracticeID    int  YES  Stores the group practice ID of the transaction 
BillingProviderID    HVCIDdt  YES  Stores the billing provider ID of transaction 
RenderingProviderID    HVCIDdt  YES  Stores the rendering provider ID of transaction 
OrderingProviderID    HVCIDdt  YES  Stores the ordering provider ID of transaction 
RevenueCodeID    int  YES  Stores the ID which points to revenue code of transaction 
Cost    SXACurrencyDt  YES  Stores the cost of the transaction 
TotalCount    int  YES  Stores the count of the transaction 
Amount    SXACurrencyDt  YES  Stores the amount of the transaction 
Unit    numeric(7, 3)  YES  Stores the unit of the transaction 
SubDepartmentID(FK)    int  YES  A foreign key to the SubDepartmentCodeMasterID column in the SXARCMSubDepartmentCodeMaster table. 
TransactionSubTypeID(FK)    int  YES  A foreign key to the TransactionSubTypeMasterID column in the SXARCMTransactionSubTypeMaster table. 
TransactionCodeID(FK)    int  YES  A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. 
AccountingPeriodStatusID(FK)    int  NO  A foreign key to the AccountingPeriodStatusID column in the SXARCMAccountingPeriodStatus table. 
TransactionYear(FK)    int  NO  A foreign key to the TransactionYear column in the SXARCMTransaction table. 
GLRunDetailsID    int  YES  GLRunDetails ID from SXARCMGLDailyRunDetails Table 
LocationGUID    HVCIDdt  YES  Stores the location of the transaction 
WorkRVU    HVCIDdt  YES  Stores the work rvu of the transaction 
TotalRVU    HVCIDdt  YES  Stores the total rvu of the transaction 
IsBilled    bit  NO  Stores the is billed of the transaction 
IsClosed    bit  NO  Flag denotes if record falls in closed accounting period 
ReverseOfIncomeAnalysisID(FK)    bigint  YES  A foreign key to the IncomeAnalysisID column in the SXARCMGLIncomeAnalysis table. 
IsMovedtoGLData    bit  NO  Flag set if IA data is processed to GL data 
OpenAccountingPeriodID    int  YES  Stores the Accounting period ID in which this IA record will fall after updation 
InsurancePlanID    bigint  YES  Stores Insurance Plan ID 
HCPCSCode    varchar(50)  YES  Stores the HCPCS code attached to transaction 
ClosedAPDtm    datetime  YES  Stored the closed accounting period datetime 
PostingUTC    datetimeoffset(3)  YES  Stored the Posting Date 
TransactionCodeMasterID    bigint  YES  Stores the TransactionCodeMasterID 
VisitID    bigint  YES  Stores the VisitID 
IsBadDebt    bit  NO  Bad Debt flag 
ServiceDate    date  YES  Stores service date for income analysis 
JobID    bigint  YES  A foreign key to the JobID column in the SXARCMJob table. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
CareLevelGUID    HVCIDdt  YES  Specifies carelevel visit type GUID from CV3CareLevel 
TransactionLocationGUID    HVCIDdt  YES  Specifies GUID TransactionLocation key 
VisitTypeDailyGUID    HVCIDdt  YES  Used to store Visit Type GUID changing on a daily basis 
CareLevelDailyGUID    HVCIDdt  YES  Used to store Care Level GUID changing on a daily basis 

dbo.SXARCMGLIncomeAnalysis Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMGLIncomeAnalysisPK  PrimaryKey  IncomeAnalysisID