[NO/URSA-CORE] Billing Transaction Details

Object Description

One record per billing transaction detail item; typically used to capture claim adjustment reason codes (CARCs) and remittance advice remark codes (RARCs).

Metadata

• Table Name: ursa.no_ursa_core_fin_017
• Layer: NATURAL_OBJECT
• Object Type: Single Stack
• Temporal Class: Event
• Case ID: Transaction Detail ID
• Event Date:
• Primary Key: Transaction Detail ID

Published Fields

• Data Model Keys

  • Transaction Detail ID -- The internal database identifier (used, e.g., for joins and primary keys) for the Transaction Detail record. (See also [URSA-CORE] Claim or Billing Transaction Detail)
  • Transaction ID -- The internal database identifier (used, e.g., for joins and primary keys) for the transaction. (See also [URSA-CORE] Claim or Billing Transaction)
  • Transaction Detail Line Number -- The integer representing the ordinal position of a transaction detail item within a parent transaction record. (See also [URSA-CORE] Claim or Billing Transaction Detail, [URSA-CORE] Claim or Billing Transaction)
  • Bill ID -- The identifier for a professional or institutional bill header record; Bill ID values are consistent over the lifetime of a bill, including when a bill is adjusted. On a claim record, this field refers to the bill sent to the plan that originated the claim record.
  • Bill Service Line Item ID -- The identifier for a service line item on an institutional or professional bill.
  • Source ID -- The identifier for the original source data system from which the current record originated.

• Source Local Keys

  • Source Local Transaction Detail ID -- The internal database identifier for the transaction detail in the source data system this record originated from. (See also [URSA-CORE] Claim or Billing Transaction Detail)
  • Source Local Transaction ID -- The internal database identifier for the transaction in the source data system this record originated from. (See also [URSA-CORE] Claim or Billing Transaction)
  • Source Local Transaction Detail Line Number -- The integer representing the ordinal position of a transaction detail item within a parent transaction record in the original source data system from which the current record originated. (See also [URSA-CORE] Claim or Billing Transaction Detail, [URSA-CORE] Claim or Billing Transaction)

• Billing and Claims Fields

  • Claim Adjustment Group Code -- The standard 2-character Claim Adjustment Group Code; e.g., CO = Contractual Obligation, OA = Other Adjustment, etc.
  • Claim Adjustment Reason Code -- The standard 1-, 2- or 3-character Claim Adjustment Reason Code (CARC); e.g., 1 = Deductible amount, 253 = Sequestration reduction in federal payment, B4 = Late filing penalty, etc.
  • Claim Adjustment Reason Description -- The natural language description of the Claim Adjustment Reason Code (CARC). (See also [URSA-CORE] Claim Adjustment Reason Code)
  • Remittance Advice Remark Code -- The standard 2-, 3-, or 4-character Remittance Advice Remark Code (RARC); e.g., M23 = Missing invoice, N203 = Missing/incomplete/invalid dispensed date, etc.
  • Remittance Advice Remark Description -- The natural language description of the Remittance Advice Remark Code (RARC).

• Metadata Fields

  • Record Last Updated Datetime -- The date and time the current record was last updated in the original data source.
  • Source Data Effective Datetime -- The "as of" date and time of the original source data system at the moment the current record was extracted. For example, if a snapshot of the data in a production system is taken at 12:05 AM on the first of each month and used to generate a package of flat files that are eventually loaded into the Ursa Studio client database later that month, the Source Data Effective Datetime of all records in that month's package will be 12:05 AM on the first. Not to be confused with Record Last Updated Datetime. (See also [URSA-CORE] Record Last Updated Datetime)

Foreign Keys

• trx_id → ursa.no_ursa_core_fin_016.trx_id

Dedicated Precursors

• [NO/URSA-CORE] Billing Transaction Details, Precursor 1 (All Source Records): One record per billing transaction detail item.