ClaimLineDetai
This table contains claim line information for claims associated with the hospital account/liability bucket. For uniform medical billing (UB) claims, this table contains pre-processing charge information, which is used in the creation of UB claim lines. Post-processing claim line data for UB claims is stored in the table. For CMS claims, this table contains the post-processing claim line data.
| Column Name | Type | Description |
|---|---|---|
| ClaimLineMolecularDiagnosticTestAuxiliaryProcedureCode | VARCHAR | Holds the auxiliary procedure code for a CMS line. |
| ClaimLineInsurancePaidAmount | NUMERIC | Stores the insurance amount paid for the claim line. |
| ResubmissionTransactionControlNumber | VARCHAR | Stores the transaction control number (TCN) if the claim is partially resubmitted. |
| ClaimLineChargeAmount | NUMERIC | Stores the charge amount for the claim line. |
| ClaimLineAdjustmentAmount | NUMERIC | Stores the adjustment amount for the claim line. |
| ProcedureDescription | VARCHAR | Stores the procedure description. |
| ProcedureStopDate | DATETIME | Stop date for timed procedures. |
| OriginalClaimLineNumber | INTEGER | Stores the original claim line number if the claim is partially resubmitted. |
| ClaimSpecialGroupingType | VARCHAR | Stores the special grouping type. Most commonly used in bundling. |
| ProcedureStopTime | DATETIME | Stop time for timed procedures. |
| ClaimLineProcedureCode | VARCHAR | Stores the Healthcare Common Procedure Coding System code for the claim line. |
| ClaimLineQuantity | NUMERIC | Stores the quantity associated with the claim line. |
| ClaimLineNonCoveredAmount | NUMERIC | Stores the non-covered amount for the claim line. |
| ClaimProcedureIdentifier | NUMERIC | Stores the internal procedure ID. |
| ProcedureStartTime | DATETIME | Start time for timed procedures. |
| ProfessionalBillingChargeLinkedAuthorizationIdentifier | NUMERIC | Stores the professional billing charge level linked authorization ID. |
| ClaimLineReimbursementAmount | NUMERIC | Stores the reimbursement amount for claim line. |
| ClaimLinePaymentAmount | NUMERIC | Stores the payment amount for the claim line. |
| DepartmentOfServiceIdentifier | NUMERIC | Department of service for the line. |
| OverrideRevenueCodeIdentifier | NUMERIC | Stores the override revenue code. |
| PlaceOfServiceTypePerTransaction | VARCHAR | Stores the place of service type per transaction. |
| ClaimLineComment | VARCHAR | Comment for the line. |
| IntraConnectInstanceOwnerCommunityIdentifier | VARCHAR | The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect. |
| ProfessionalClaimLineModifier | VARCHAR | Stores modifiers on the claim line. |
| ClaimLineRevenueLocationIdentifier | NUMERIC | Revenue location for the line. |
| ClaimLinePatientPaidAmount | NUMERIC | Stores the patient amount paid for the claim line. |
| ClaimLinePatientAmountDue | NUMERIC | Stores the patient amount due for the claim line. |
| TransactionHealthcareProcedureCodeSystemOverrideType | INTEGER | Stores the code type for the transaction level Healthcare Common Procedure Coding System code override. If a procedure has been assigned to the line without setting the override, this column will be left blank. |
| ClaimLineServiceThroughDate | DATETIME | Stores the through date for a claim line. |
| ClaimLineDiagnosisPointerList | VARCHAR | Comma-delimited list of diagnosis pointers for the claim line. |
| LineRenderingProviderIdentifier | VARCHAR | This item holds the line level rendering provider for American National Standards Institute claims. Professional claims will use this value to print the claim and line rendering provider loops. |
| ClaimLinePlaceOfServiceIdentifier | NUMERIC | Place of service ID. |
| ProcedureStartDate | DATETIME | Start date for timed procedures. |
| ClaimLineLocalCoverageDeterminationCode | VARCHAR | Stores the LCD code for the CMS 1500 line. |
| ServiceStartDate | DATETIME | Stores the from date for a claim line. For services that do not span multiple days, the service date will be held here. |
| ReimbursementMethodCategory | INTEGER | Stores the reimbursement method. |
| ClaimLineMedicarePaidAmount | NUMERIC | For eMedNY 150003 claims, this is the amount that Medicare paid for this service line. This appears in field 24K (SVC_LN_INFO_2.LN_MCR_PAID_AMT). The EMEDNY_MEDICARE_PLANS profile variable can be used to control which coverages count as Medicare coverages. |
| VARCHAR | This controls procedure description printing for professional claims. | |
| ClaimAuxiliaryProcedureCodeType | INTEGER | Holds the type of auxiliary procedure code when one is applicable to a CMS line. |
| IsPseudoBundleChargeLine | INTEGER | Indicates whether the claim line is a pseudo bundle (i.e., a partial charge bundle - a line showing left over units of a charge after the rest of that charge's quantity is bundled into a panel). |
| ReimbursementContractIdentifier | NUMERIC | Stores the PB reimbursement contract ID. |
| ClaimLineInsuranceAmountDue | NUMERIC | Stores the insurance amount due for the claim line. |
| ClaimPriorAuthorizationNumber | VARCHAR | Stores the prior-authorization number for a service line. |
| ClaimLineTypeOfService | INTEGER | Stores the type of service for the claim line. |
| ClaimServiceLineReferralNumber | VARCHAR | Stores the referral number for a service line. |