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. 

DenialId 
Definition  Auto generated unique primary key value. 

DenialSourceID 
Definition  A foreign key to the DenialSourceID column in the SXARCMDenialSource table. 

DenialStatusID 
Definition  A foreign key to the DenialStatusID column in the SXARCMDenialStatus table. 

DenialLevelID 
Definition  A foreign key to the DenialLevelID column in the SXARCMDenialLevel table. 

PayerClaimControlNumber 
Definition  Stores the Payer Claim Control number. 

DenialCodeConfigID 
Definition  A foreign key to the DenialCodeConfigID column in the SXARCMDenialCodeConfig table. 

DenialTypeID 
Definition  A foreign key to the DenialTypeID column in the SXARCMDenialType table. 

DenialSeverityID 
Definition  A foreign key to the DenialSeverityID column in the SXARCMDenialSeverity table. 

DenialRootCauseID 
Definition  A foreign key to the DenialRootCauseID column in the SXARCMDenialRootCause table. 

DenialResultID 
Definition  A foreign key to the DenialResultID column in the SXARCMDenialResult table. 

DenialAreaResponsibleID 
Definition  A foreign key to the DenialAreaResponsibleID column in the SXARCMDenialAreaResponsible table. 

DenialActionID 
Definition  A foreign key to the DenialActionID column in the SXARCMDenialAction table. 

RecoveredAmount 
Definition  Stores recovered amount entered by user. 

WorksheetId 
Definition  A foreign key to the WorksheetID column in the SXARCMWorksheet table. 

WorkSheetYear 
Definition  A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. 

EpisodeYear 
Definition  Stores the status as whether a Denial is AutoClosed or not 

IsAutoClose 
Definition  A foreign key to the DenialCodeID column in the SXARCMDenialCode table. 

DenialCodeID 
Definition  A foreign key to the EpisodeYear column in the SXARCMClaimLine table. 

ClaimLineID 
Definition  A foreign key to the ClaimLineID column in the SXARCMClaimLine table. 

DenialAmount 
Definition  This column will hold the Denial Amount for WorkSheet level or Claim Line level 

DenialNote 
Definition  PHI: This column will hold Denial comment 

Phone 
Definition  PHI: This column will hold the phone number 

InsuranceRepresentativeName 
Definition  PHI: This column will hold the Insurance Representative Name 

FollowUpDate 
Definition  This column will hold the Follow up Date 

IsAdjustmentPosted 
Definition  stored Is Adjusted Posted Flaf 

AdjustmentGroupCode 
Definition  Store the Group code 

DenialCloseReason 
Definition  Stores Denial close Reason Code 

DenialCloseReasonID 
Definition  A foreign key to the DenialCloseReasonID column in the SXARCMDenialCloseReason table. 

IsDenialCreatedEventRaised 
Definition  Will contain value of event is raised for specific denial or not 

ERATransactionSetClaimID 
Definition  Will contain value of transactionset Claim ID 

ERATransactionSetClaimAdjustmentID 
Definition  A foreign key to the DenialConfigID column in the SXARCMDenialConfig table. 

ERATransactionSetClaimServiceLineAdjustmentID 
Definition  A foreign key to the DenialConfigClaimReasonID column in the SXARCMDenialConfigClaimReason table. 

DenialConfigID 
Definition  A foreign key to the DenialConfigClaimReasonExclusionID column in the SXARCMDenialConfigClaimReasonExclusion table. 

DenialConfigClaimReasonID 
Definition  A foreign key to the DenialCategoryID column in the SXARCMDenialCategory table. 

DenialConfigClaimReasonExclusionID 
Definition  A foreign key to the DenialSubCategoryID column in the SXARCMDenialSubCategory table. 

DenialCategoryID 
Definition  This is column is used to store CPT/HCPCS Code. 

DenialSubCategoryID 
Definition  This is column is used to store Revenue Code. 

CPTHCPCSCode 
Definition  PHI: Store Denial Date 

RevenueCode 
Definition  Unique GUID used to support merge replication. 

DenialDate 
Definition  This column is to store the transactionset claim adjustment ID. 

MSReplrowguid 
Definition  This column is to store the transactionset claim service line adjustment ID. 

DenialClosedDateUTC 
Definition  The date ant time when a denial was closed. 

DenialClosedBy 
Definition  The user who closed a denial. 

IsSystemOverrideOfAdjustmentCreation 
Definition  Denial get created due to override ADC configuration or not. 

DenialMarkedForClosureDateUTC 
Definition  The date and time that the denial was marked for Closure 

DenialMarkedForClosureBy 
Definition  Information about the user that marked denial for closure. 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. 

BatchID 
Definition  A foreign key to the BatchID column in the SXARCMBatch table. 

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

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

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