Skip to main content

Avatar PM 2023 Update 18

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

Avatar PM required
RADplus required

Product Update Form Description

An issue is resolved where the 'discipline_code' field within the 'billing_tx_master_table' may show incomplete data.

Included Updates

None

Required Updates

None

Details
NEW0 CHANGED0 FIXED1
Fixed (1)
SQL Table - SYSTEM.billing_tx_master_table
Resolves an issue to ensure that the 'SYSTEM.billing_tx_master_table' table is updated to increase the maximum character length on the 'discipline_code' field.
Topics
• Database Tables • NX
 
Acceptance Tests
AV-78454 Summary | Details
SQL Table - SYSTEM.billing_tx_master_table
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Dictionary Update (PM)
  • Form and Table Documentation (PM)
  • Registry Settings (PM)
  • Service Codes
Scenario 1: billing_tx_master_table - Validating field length of the 'discipline_code' field
Specific Setup:
  • Registry Setting:
  • The 'Fields to Include in Client Charge Input' registry setting is set to the value that includes '2'.
  • Service Codes:
  • Create a new service code or identify an existing service code. Note the service code.
  • Select all the disciplines in the discipline field. Note all the disciplines selected.
Steps
  1. Open the 'Crystal Report' or any other SQL data viewer.
  2. Query the SYSTEM.billing_tx_master_table for the discipline_code.
  3. Verify the 'discipline_code' field displays all the discipline codes for the selected disciplines in the 'Service Codes' form.
  4. Verify the 'discipline_value' field displays all the discipline values for the selected disciplines in the 'Service Codes' form.
Topics
• Database Tables • NX
Table Changes
Table Column Change
SYSTEM.billingtxmastertable discipline_code Increased maximum length to 500 characters