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. |