Skip to main content

Avatar PM 2022 Update 118

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

Avatar PM required
RADplus required

Recommended Update Level

Avatar Appointment Scheduling 2022 Update 20

Product Update Form Description

The client middle name in avatar has been updated to allow 25 characters. In addition, a new registry setting 'Allow Spaces in Client Name' is introduced and when used in conjunction with the detailed name functionality, will allow spaces in the client first and middle name.

Included Updates

3, 9, 13, 18, 25, 34, 41, 48, 51, 55, 58, 59, 61, 62, 67, 73, 77, 78, 84, 87, 88, 90, 91, 94, 95, 97, 99, 100, 103, 107, 108, 109, 114

Required Updates

Avatar PM 2022 Update 58
Details
NEW1 CHANGED0 FIXED0
New (1)
Avatar PM is modified to increase length of client name and allow spaces to be included.
The client middle name in Avatar has been updated to allow 25 characters. In addition, a new registry setting 'Allow Spaces in Client Name' is introduced. When used in conjunction with the 'detailed name' functionality, spaces will be allowed in the client first and middle names.
In addition to the new registry setting, the existing setting 'Avatar PM->Client Information->Client Demographics->->->Client Demographics - Additional Fields' must include '3:'Detailed Client Name'.
Value Added: Extends the allowable length of client middle name and adds ability to include spaces in the client name.
Topics
• Admission (Outpatient) • Cross Episode Financial Eligibility • Financial Eligibility • NX • Registry Settings • Update Client Data
 
Acceptance Tests
AV-82230 Summary | Details
Avatar PM is modified to increase length of client name and allow spaces to be included.
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Admission (Outpatient)
  • Chart View (Client Header)
  • Update Client Data
  • Pre Admit Discharge
  • Cross Episode Financial Eligibility
Scenario 1: Admission - validate Registry setting 'Allow spaces in Client Name'.
Specific Setup:
  • Registry Setting 'Avatar PM->Client Information->Client Demographics->->->Allow Spaces in Client Name' is set to 'Y' to allow spaces. Note: Once enabled, the user will only be able to edit an existing client 'Client Name' field within 'Update Client Data' form.
  • Registry Setting 'Client Demographics - Additional Fields' must be set to include '3: 'Detailed Client Name' to enable this functionality. This setting will add the 'Detail Client Name' fields to the 'Demographics' section of Admission forms.
Steps
  1. Open 'Admission (Outpatient)' form.
  2. Set the 'Last Name' on the 'Select Client' popup window to any name value.
  3. Set the 'First Name' on the 'Select Client' popup window to any name value.
  4. Select the gender in the 'Sex' drop down list.
  5. Click [Search].
  6. Click [OK] on the 'Search Results' popup window: 'No matches found'.
  7. Click [New Client].
  8. Click [Yes] on the 'Auto Assign Next ID Number' popup window.
  9. Click on the 'Demographics' section.
  10. Set the 'Client Last Name' to any name including one or more spaces. i.e.: 'Last Name'.
  11. Set the 'Client First Name' to any name including one or more spaces. i.e.: 'First Name'
  12. Set the 'Client Middle Name' to any name including one or more spaces. i.e.: 'Middle Name'.
  13. Complete any required fields.
  14. Click the 'Admission' section.
  15. Verify the 'Client Name' field contains the full name, including spaces.
  16. Click [Submit].
  17. Right click on the client name in the 'Recent Clients' section.
  18. Click 'Display Chart'.
  19. Verify the client name displays all characters entered in the 'Admission' form. Note that the user may need to place the cursor over the client name and review the 'hover help' as it will display the client name.
Scenario 2: Update Client Data - Validate client name allows spaces and client middle name displays up to 25 characters.
Specific Setup:
  • Avatar RADplus 2022 Update 126 is required for full functionality.
  • Registry Setting 'Avatar PM->Client Information->Client Demographics->->->Allow Spaces in Client Name' is set to 'Y' to allow spaces. Note: Once enabled, the user will only be able to edit an existing client 'Client Name' field within 'Update Client Data' form.
  • Registry Setting 'Client Demographics - Additional Fields' must be set to include '3: 'Detailed Client Name' to enable this functionality. This setting will add the 'Detail Client Name' fields to the 'Demographics' section of Admission forms.
Steps
  1. Open 'Update Client Data' form for an existing client.
  2. Set the 'Client Last Name' field to a last name which includes spaces in the name i.e.: 'FRANKLIN MILLER MOTT'
  3. Set the 'Client First Name' field to a first name which includes spaces in the name i.e: 'BENJAMIN WALLY'
  4. Set the 'Client Middle Name' field to a middle name which includes spaces and is maximum of 25 characters i.e: 'BILL ED MIDDLE NAME LONG'
  5. Click [Submit].
  6. Right click on the client name in the 'Recent Clients' list.
  7. Select 'Display Chart'.
  8. Verify the name displays in the client banner, including all spaces and a maximum of 25 characters for the middle name.
  9. Close the client chart.
Scenario 3: Pre Admit Discharge web service validation
Specific Setup:
  • Existing 'Pre Admit' client whose full name is longer than 40 characters.
  • Registry Setting 'Avatar PM->Client Information->Client Demographics->->->Allow Spaces in Client Name' is set to 'Y' to allow spaces. Note: Once enabled, the user will only be able to edit an existing client 'Client Name' field within 'Update Client Data' form.
  • Registry Setting 'Client Demographics - Additional Fields' must be set to include '3: 'Detailed Client Name' to enable this functionality. This setting will add the 'Detail Client Name' fields to the 'Demographics' section of Admission forms.
  • RADplus 2022 Update 126 is required for full functionality.
  • Access to, and understanding of, SoapUI or other Web Service tools.
Steps
  1. Using 'SoapUI' or another web service tool, consume the WSDL for the 'Pre Admit Discharge' form.
  2. Set the 'SystemCode' code to the agency system code for testing.
  3. Set the 'UserName' to the logged in user name.
  4. Set the 'Password' to the logged in user password.
  5. Set the 'DateOfDischarge' to the discharge date.
  6. Set the 'DischargeTime' to the time of discharge.
  7. Set the 'Discharge Practitioner' to a practitioner code (not the practitioner name).
  8. Set the 'Client ID' to the ID for the client to be discharged.
  9. Set the 'EpisodeNumber' to the client episode to be discharged.
  10. Click [Send].
  11. Review the response and verify the response message displays: <Message>Client Pre-Admit Discharge web service has been filed successfully.</Message>
  12. Open 'Pre Admit Discharge' in Avatar.
  13. Select the client discharged in the Web Service.
  14. Verify the 'Date of Discharge' is set to the date entered in the Web Service.
  15. Verify the 'Time of Discharge' is set to the time entered in the Web Service.
  16. Verify the 'Discharge Practitioner' is set to the practitioner entered in the Web Service.
  17. Click [Close Form].
Scenario 4: Cross Episode Financial Eligibility - validate client name display with spaces and up to 100 characters in the name
Specific Setup:
  • A client (Client A) is admitted where the first name, middle name, and last name combined is up to 100 characters and spaces are included in the name. Note that a space will count as a character.
  • Avatar PM 2022 Update 118 is required for full functionality.
  • RADplus 2022 Update 126 is required for full functionality.
Steps
  1. Open 'Cross Episode Financial Eligibility' form for Client A.
  2. Click 'Guarantor Selection' section.
  3. Click [Add New Item].
  4. Select any value in the 'Guarantor #' field.
  5. Click [OK] on the 'Selecting This Guarantor Will Over-Write Any Previous Plan Information' pop up window.
  6. Complete remaining required fields as needed.
  7. Select 'Self' in the 'Client's Relationship to Subscriber' field.
  8. Verify the 'Subscriber's Last Name' field is populated with up to 40 characters.
  9. Verify the 'Subscriber's First Name' field is populated with up to 40 characters.
  10. Verify the 'Subscriber's Middle Name' field is populated with up to 25 characters.
  11. Click 'Cross Episode Financial Eligibility' section.
  12. Select a value from the 'Guarantor #1' drop down list.
  13. Click [Submit].
Scenario 5: Validate Client Demographics web service updates the Update Client Data fields.
Specific Setup:
  • SoapUI or other web service tool.
  • Client admitted with a long first and last name of up to 40 characters, and middle name of up to 25 characters. Spaces can be included.
  • Avatar RADplus 2022 Update 126 is required for full functionality.
  • Registry Setting 'Avatar PM->Client Information->Client Demographics->->->Allow Spaces in Client Name' is set to 'Y' to allow spaces. Note: Once enabled, the user will only be able to edit an existing client 'Client Name' field within 'Update Client Data' form.
  • Registry Setting 'Client Demographics - Additional Fields' must be set to include '3: 'Detailed Client Name' to enable this functionality. This setting will add the 'Detail Client Name' fields to the 'Demographics' section of Admission forms.
Steps
  1. Open SoapUI or another web service tool.
  2. Consume the WebSvc.ClientDemographics.cls wsdl.
  3. Set the 'SystemCode', 'UserName', and 'Password' to correct values.
  4. Set 'ClientFirstName' to the first name of the client with a long first name, up to 40 characters.
  5. Set 'ClientMiddleName' to the middle name of the client with a long middle name, up to 25 characters.
  6. Set 'ClientName' to the <client last name,client first name>.
  7. Set 'ClientID' to the client id for the test client.
  8. Set any other field to the appropriate data such as ClientEmailAddress.
  9. Click 'Send'.
  10. Review the Response.
  11. Verify the message displays: <Message>Client Demographics web service has been filed successfully.</Message>
  12. Open the 'Update Client Data' form for the same client.
  13. Verify the data filed in the web service displays as entered.
  14. Close the form.
Scenario 6: Financial Eligibility web service - validate client names with spaces and the name contains a maximum of 100 characters.
Specific Setup:

UP / PERMISSIONS

  • Access to, and a working understanding of, SoapUI or other web service tool.
  • Avatar RADplus 2022 Update 126 is required for full functionality.
  • Client admitted where the client last and first names are maximum of 40 characters, including space(s). The client middle name should be a maximum of 25 characters, including spaces(s).
  • Registry Setting 'Avatar PM->Client Information->Client Demographics->->->Allow Spaces in Client Name' is set to 'Y' to allow spaces. Note: Once enabled, the user will only be able to edit an existing client 'Client Name' field within 'Update Client Data' form.
  • Registry Setting 'Client Demographics - Additional Fields' must be set to include '3: 'Detailed Client Name' to enable this functionality. This setting will add the 'Detail Client Name' fields to the 'Demographics' section of Admission forms.
Steps
  1. Open SoapUI or another web service tool.
  2. Consume the Websvc.FinancialEligibility.cls wsdl.
  3. Expand the WEBSVC.FinancialEligibility item.
  4. Expand FinancialEligibilitySoap item.
  5. Expand 'AddFinancialElig' item.
  6. Double click on 'Request 1'.
  7. Set the 'SystemCode', 'UserName', and 'Password' to correct values.
  8. Set 'ClientsRelationship' to any value such as '1'.
  9. Set 'CoverageEffectiveDate' to the date coverage started for the client.
  10. Set 'CustomizeGuarantorPlan' to '1'.
  11. Set 'GuarantorName' to the name of the guarantor being assigned.
  12. Set 'GuarantorNumber' to the ID number of the guarantor.
  13. Set 'GuarantorOrderNumber' to the number where the guarantor is to be listed. Use '1' if there is just one guarantor.
  14. Set 'GuarantorPlan' to any value such as '1'.
  15. Set 'EligibilityVerified' to 'Y'.
  16. Set 'MaximumCoveredDollars' to any dollar value.
  17. Set 'SubscribersName' to the full name of the client, up to 100 characters. Format is 'LastName,FirstName'.
  18. Set 'ClientID' to the ID number for the test client.
  19. Click 'Send'.
  20. Review the Response text.
  21. Complete any additional required fields.
  22. Click 'Send' again.
  23. Verify the Response states : <Message>Financial Eligibility web service has been filed successfully.</Message>
  24. Open 'Financial Eligibility' form in Avatar PM for the same client.
  25. Verify 'Guarantor #1' field is populated with the guarantor submitted in the web service.
  26. Click 'Guarantor Selection' tab.
  27. Verify the information sent thru the web service is populated correctly.
  28. Close the form.
Scenario 7: Cross Episode Financial Eligibility web service - validate client names with spaces and the name contains a maximum of 100 characters.
Specific Setup:
  • Access to, and a working understanding of, SoapUI or other web service tool.
  • Avatar RADplus 2022 Update 126 is required for full functionality.
  • Client admitted where the client last and first names are maximum of 40 characters, including space(s). The client middle name should be a maximum of 25 characters, including spaces(s).
  • Registry Setting 'Avatar PM->Client Information->Client Demographics->->->Allow Spaces in Client Name' is set to 'Y' to allow spaces. Note: Once enabled, the user will only be able to edit an existing client 'Client Name' field within 'Update Client Data' form.
  • Registry Setting 'Client Demographics - Additional Fields' must be set to include '3: 'Detailed Client Name' to enable this functionality. This setting will add the 'Detail Client Name' fields to the 'Demographics' section of Admission forms.
Steps
  1. Open SoapUI or another web service tool.
  2. Consume the Websvc.CrossFinancialEligibility.cls wsdl.
  3. Expand the WEBSVC.CrossEpisodeFinancialEligibility item.
  4. Expand CrossEpisodeFinancialEligibilitySoap item.
  5. Expand 'AddCrossEpisodeFinancialElig' item.
  6. Double click on 'Request 1'.
  7. Set the 'SystemCode', 'UserName', and 'Password' to correct values.
  8. Set 'ClientsRelationship' to any value such as '1'.
  9. Set 'CoverageEffectiveDate' to the date coverage started for the client.
  10. Set 'CustomizeGuarantorPlan' to '1'.
  11. Set 'GuarantorName' to the name of the guarantor being assigned.
  12. Set 'GuarantorNumber' to the ID number of the guarantor.
  13. Set 'GuarantorOrderNumber' to the number where the guarantor is to be listed. Use '1' if there is just one guarantor.
  14. Set 'GuarantorPlan' to any value such as '1'.
  15. Set 'EligibilityVerified' to 'Y'.
  16. Set 'MaximumCoveredDollars' to any dollar value.
  17. Set 'SubscribersName' to the full name of the client, up to 100 characters. Format is 'LastName,FirstName'.
  18. Set 'ClientID' to the ID number for the test client.
  19. Click 'Send'.
  20. Review the Response text.
  21. Complete any additional required fields.
  22. Click 'Send' again.
  23. Verify the Response states : <Message>Cross Episode Financial Eligibility web service has been filed successfully.</Message>
  24. Open 'Cross Episode Financial Eligibility' form in Avatar PM for the same client.
  25. Verify 'Guarantor #1' field is populated with the guarantor submitted in the web service.
  26. Click 'Guarantor Selection' tab.
  27. Verify the information sent thru the web service is populated correctly.
  28. Close the form.
Topics
• Admission (Outpatient) • Cross Episode Financial Eligibility • Financial Eligibility • NX • Registry Settings • Update Client Data
Table Changes
Table Column Change
SYSTEM.admissiondata client_name Updated field length
SYSTEM.auditdeletedmvmt patient_name Updated field length
SYSTEM.auditpcpassociation client_name Updated field length
SYSTEM.bem834errors patient_name Updated field length
SYSTEM.billing271beneinfo client_name Updated field length
SYSTEM.billing271dependent client_name Updated field length
SYSTEM.billing271resp client_name Updated field length
SYSTEM.billing271respchg client_name Updated field length
SYSTEM.billing271subscriber client_name Updated field length
SYSTEM.billing271updatedinfo client_name Updated field length
SYSTEM.billing271validateinfo client_name Updated field length
SYSTEM.billing276errors patient_name Updated field length
SYSTEM.billing276report patient_name Updated field length
SYSTEM.billing277clmstatus patient_name Updated field length
SYSTEM.billing277svcstatus patient_name Updated field length
SYSTEM.billing278response client_name Updated field length
SYSTEM.billing837d4010errors patient_name Updated field length
SYSTEM.billing837derrors patient_name Updated field length
SYSTEM.billing837i4010errors patient_name Updated field length
SYSTEM.billing837ierrors patient_name Updated field length
SYSTEM.billing837p4010errors patient_name Updated field length
SYSTEM.billing837perrors patient_name Updated field length
SYSTEM.billingclientspdunnmsg v_patient_name Updated field length
SYSTEM.billingncpdprespdtl client_name Updated field length
SYSTEM.billingsppayarrangement v_patient_name Updated field length
SYSTEM.billingtxfailedcompliance v_patient_name Updated field length
SYSTEM.disclomgmt client_name Updated field length
SYSTEM.eb278permstorage client_name Updated field length
SYSTEM.episodehistory v_patient_name Updated field length
SYSTEM.fileimportdepositentry client_name Updated field length
SYSTEM.fileimporttx client_name Updated field length
SYSTEM.internalclientreferrals client_name Updated field length
SYSTEM.patientcurrentdemographics patient_name Updated field length
SYSTEM.patientdemographichistory patient_name Updated field length
SYSTEM.pcpassociation client_name Updated field length
SYSTEM.staffcaseload client_name Updated field length
SYSTEM.tablebed client_name Updated field length
SYSTEM.viewepisodesummaryadmit patient_name Updated field length
SYSTEM.viewepisodesummarycurrent patient_name Updated field length
SYSTEM.viewepisodesummarydischarge patient_name Updated field length
SYSTEM.admission_data AH_uniqueid Added SQL Documentation
SYSTEM.admission_data EPISODE_NUMBER Added SQL Documentation
SYSTEM.admission_data FACILITY Added SQL Documentation
SYSTEM.admission_data GUID Added SQL Documentation
SYSTEM.admission_data ID Added SQL Documentation
SYSTEM.admission_data PATID Added SQL Documentation
SYSTEM.admission_data UTCTimeStamp Added SQL Documentation
SYSTEM.admission_data admission_date Added SQL Documentation
SYSTEM.admission_data admission_time Added SQL Documentation
SYSTEM.admission_data client_name Added SQL Documentation
SYSTEM.admission_data data_entry_by Added SQL Documentation
SYSTEM.admission_data data_entry_by_option Added SQL Documentation
SYSTEM.admission_data data_entry_date Added SQL Documentation
SYSTEM.admission_data data_entry_offset Added SQL Documentation
SYSTEM.admission_data data_entry_source Added SQL Documentation
SYSTEM.admission_data data_entry_time Added SQL Documentation
SYSTEM.admission_data data_entry_time_j Added SQL Documentation
SYSTEM.admission_data data_entry_timezone_info_all Added SQL Documentation
SYSTEM.admission_data data_entry_timezone_short Added SQL Documentation
SYSTEM.admission_data data_entry_user_id Added SQL Documentation
SYSTEM.admission_data data_entry_user_name Added SQL Documentation
SYSTEM.admission_data data_entry_utc Added SQL Documentation
SYSTEM.admission_data decision_to_admit_date Added SQL Documentation
SYSTEM.admission_data decision_to_admit_time Added SQL Documentation
SYSTEM.admission_data expected_discharge_date Added SQL Documentation
SYSTEM.admission_data military_branch_code Added SQL Documentation
SYSTEM.admission_data military_branch_value Added SQL Documentation
SYSTEM.admission_data military_related_dis_code Added SQL Documentation
SYSTEM.admission_data military_related_dis_value Added SQL Documentation
SYSTEM.admission_data military_service_from_date Added SQL Documentation
SYSTEM.admission_data military_service_through_date Added SQL Documentation
SYSTEM.admission_data option_desc Added SQL Documentation
SYSTEM.admission_data option_id Added SQL Documentation
SYSTEM.admission_data program_code Added SQL Documentation
SYSTEM.admission_data program_value Added SQL Documentation
SYSTEM.admission_data provid Added SQL Documentation
SYSTEM.admission_data provider_name Added SQL Documentation
SYSTEM.admission_data source_of_admission_code Added SQL Documentation
SYSTEM.admission_data source_of_admission_value Added SQL Documentation
SYSTEM.admission_data type_of_adm_X_ub92_code Added SQL Documentation
SYSTEM.admission_data type_of_adm_X_ub92_value Added SQL Documentation
SYSTEM.admission_data type_of_admission_code Added SQL Documentation
SYSTEM.admission_data type_of_admission_value Added SQL Documentation
SYSTEM.admission_data user_row_access_code Added SQL Documentation
SYSTEM.admission_data veteran_code Added SQL Documentation
SYSTEM.admission_data veteran_value Added SQL Documentation
SYSTEM.bem_834_errors EPISODE_NUMBER Added SQL Documentation
SYSTEM.bem_834_errors FACILITY Added SQL Documentation
SYSTEM.bem_834_errors GUARANTOR_ID Added SQL Documentation
SYSTEM.bem_834_errors ID Added SQL Documentation
SYSTEM.bem_834_errors PATID Added SQL Documentation
SYSTEM.bem_834_errors data_entry_by Added SQL Documentation
SYSTEM.bem_834_errors data_entry_by_option Added SQL Documentation
SYSTEM.bem_834_errors data_entry_date Added SQL Documentation
SYSTEM.bem_834_errors data_entry_time Added SQL Documentation
SYSTEM.bem_834_errors data_entry_user_id Added SQL Documentation
SYSTEM.bem_834_errors data_entry_user_name Added SQL Documentation
SYSTEM.bem_834_errors episode_index Added SQL Documentation
SYSTEM.bem_834_errors error_index Added SQL Documentation
SYSTEM.bem_834_errors error_message Added SQL Documentation
SYSTEM.bem_834_errors file_description Added SQL Documentation
SYSTEM.bem_834_errors file_index Added SQL Documentation
SYSTEM.bem_834_errors file_status Added SQL Documentation
SYSTEM.bem_834_errors guarantor_name Added SQL Documentation
SYSTEM.bem_834_errors patient_name Added SQL Documentation
SYSTEM.bem_834_errors priority Added SQL Documentation
SYSTEM.bem_834_errors program_code Added SQL Documentation
SYSTEM.bem_834_errors program_value Added SQL Documentation
SYSTEM.bem_834_errors through_date Added SQL Documentation
SYSTEM.bem_834_errors user_row_access_code Added SQL Documentation
SYSTEM.bem_834_errors version Added SQL Documentation
SYSTEM.billing_271_resp_chg EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_271_resp_chg FACILITY Added SQL Documentation
SYSTEM.billing_271_resp_chg GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_271_resp_chg ID Added SQL Documentation
SYSTEM.billing_271_resp_chg PATID Added SQL Documentation
SYSTEM.billing_271_resp_chg action_cd Added SQL Documentation
SYSTEM.billing_271_resp_chg action_val Added SQL Documentation
SYSTEM.billing_271_resp_chg client_name Added SQL Documentation
SYSTEM.billing_271_resp_chg data_entry_by Added SQL Documentation
SYSTEM.billing_271_resp_chg data_entry_by_option Added SQL Documentation
SYSTEM.billing_271_resp_chg data_entry_date Added SQL Documentation
SYSTEM.billing_271_resp_chg data_entry_time Added SQL Documentation
SYSTEM.billing_271_resp_chg data_entry_user_id Added SQL Documentation
SYSTEM.billing_271_resp_chg data_entry_user_name Added SQL Documentation
SYSTEM.billing_271_resp_chg file_index Added SQL Documentation
SYSTEM.billing_271_resp_chg file_info_str Added SQL Documentation
SYSTEM.billing_271_resp_chg file_name Added SQL Documentation
SYSTEM.billing_271_resp_chg file_status Added SQL Documentation
SYSTEM.billing_271_resp_chg group_index Added SQL Documentation
SYSTEM.billing_271_resp_chg guarantor_name Added SQL Documentation
SYSTEM.billing_271_resp_chg inquiry_type Added SQL Documentation
SYSTEM.billing_271_resp_chg inquiry_type_desc Added SQL Documentation
SYSTEM.billing_271_resp_chg inquiry_type_index Added SQL Documentation
SYSTEM.billing_271_resp_chg previous_segment_data Added SQL Documentation
SYSTEM.billing_271_resp_chg previous_segment_data_msg Added SQL Documentation
SYSTEM.billing_271_resp_chg segment Added SQL Documentation
SYSTEM.billing_271_resp_chg segment_data Added SQL Documentation
SYSTEM.billing_271_resp_chg segment_data_msg Added SQL Documentation
SYSTEM.billing_271_resp_chg segment_index Added SQL Documentation
SYSTEM.billing_271_resp_chg user_row_access_code Added SQL Documentation
SYSTEM.billing_271_resp_chg version Added SQL Documentation
SYSTEM.billing_276_errors EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_276_errors FACILITY Added SQL Documentation
SYSTEM.billing_276_errors GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_276_errors ID Added SQL Documentation
SYSTEM.billing_276_errors PATID Added SQL Documentation
SYSTEM.billing_276_errors data_entry_by Added SQL Documentation
SYSTEM.billing_276_errors data_entry_by_option Added SQL Documentation
SYSTEM.billing_276_errors data_entry_date Added SQL Documentation
SYSTEM.billing_276_errors data_entry_time Added SQL Documentation
SYSTEM.billing_276_errors data_entry_user_id Added SQL Documentation
SYSTEM.billing_276_errors data_entry_user_name Added SQL Documentation
SYSTEM.billing_276_errors date_of_birth Added SQL Documentation
SYSTEM.billing_276_errors error_index Added SQL Documentation
SYSTEM.billing_276_errors error_message Added SQL Documentation
SYSTEM.billing_276_errors file_description Added SQL Documentation
SYSTEM.billing_276_errors file_index Added SQL Documentation
SYSTEM.billing_276_errors file_status Added SQL Documentation
SYSTEM.billing_276_errors financial_class_code Added SQL Documentation
SYSTEM.billing_276_errors financial_class_value Added SQL Documentation
SYSTEM.billing_276_errors guarantor_name Added SQL Documentation
SYSTEM.billing_276_errors option_desc Added SQL Documentation
SYSTEM.billing_276_errors option_id Added SQL Documentation
SYSTEM.billing_276_errors patient_name Added SQL Documentation
SYSTEM.billing_276_errors patient_sex_code Added SQL Documentation
SYSTEM.billing_276_errors priority Added SQL Documentation
SYSTEM.billing_276_errors program_code Added SQL Documentation
SYSTEM.billing_276_errors program_value Added SQL Documentation
SYSTEM.billing_276_errors user_row_access_code Added SQL Documentation
SYSTEM.billing_276_errors version Added SQL Documentation
SYSTEM.billing_276_report CLAIM_NUMBER Added SQL Documentation
SYSTEM.billing_276_report EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_276_report FACILITY Added SQL Documentation
SYSTEM.billing_276_report GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_276_report ID Added SQL Documentation
SYSTEM.billing_276_report PATID Added SQL Documentation
SYSTEM.billing_276_report cost_of_service Added SQL Documentation
SYSTEM.billing_276_report data_entry_by Added SQL Documentation
SYSTEM.billing_276_report data_entry_by_option Added SQL Documentation
SYSTEM.billing_276_report data_entry_date Added SQL Documentation
SYSTEM.billing_276_report data_entry_time Added SQL Documentation
SYSTEM.billing_276_report data_entry_user_id Added SQL Documentation
SYSTEM.billing_276_report data_entry_user_name Added SQL Documentation
SYSTEM.billing_276_report date_of_birth Added SQL Documentation
SYSTEM.billing_276_report date_of_claim Added SQL Documentation
SYSTEM.billing_276_report date_of_service Added SQL Documentation
SYSTEM.billing_276_report file_index Added SQL Documentation
SYSTEM.billing_276_report financial_class_code Added SQL Documentation
SYSTEM.billing_276_report financial_class_value Added SQL Documentation
SYSTEM.billing_276_report guarantor_name Added SQL Documentation
SYSTEM.billing_276_report option_desc Added SQL Documentation
SYSTEM.billing_276_report option_id Added SQL Documentation
SYSTEM.billing_276_report pat_control_num Added SQL Documentation
SYSTEM.billing_276_report patient_name Added SQL Documentation
SYSTEM.billing_276_report patient_sex_code Added SQL Documentation
SYSTEM.billing_276_report procedure_code Added SQL Documentation
SYSTEM.billing_276_report revenue_code Added SQL Documentation
SYSTEM.billing_276_report total_claim_amount Added SQL Documentation
SYSTEM.billing_276_report units_of_service Added SQL Documentation
SYSTEM.billing_276_report user_row_access_code Added SQL Documentation
SYSTEM.billing_276_report version Added SQL Documentation
SYSTEM.billing_276_report xx_index Added SQL Documentation
SYSTEM.billing_277_clm_status CLAIM_NUMBER Added SQL Documentation
SYSTEM.billing_277_clm_status EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_277_clm_status FACILITY Added SQL Documentation
SYSTEM.billing_277_clm_status GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_277_clm_status ID Added SQL Documentation
SYSTEM.billing_277_clm_status PATID Added SQL Documentation
SYSTEM.billing_277_clm_status data_entry_by Added SQL Documentation
SYSTEM.billing_277_clm_status data_entry_by_option Added SQL Documentation
SYSTEM.billing_277_clm_status data_entry_date Added SQL Documentation
SYSTEM.billing_277_clm_status data_entry_time Added SQL Documentation
SYSTEM.billing_277_clm_status data_entry_user_id Added SQL Documentation
SYSTEM.billing_277_clm_status data_entry_user_name Added SQL Documentation
SYSTEM.billing_277_clm_status guarantor_name Added SQL Documentation
SYSTEM.billing_277_clm_status option_desc Added SQL Documentation
SYSTEM.billing_277_clm_status option_id Added SQL Documentation
SYSTEM.billing_277_clm_status pat_control_num Added SQL Documentation
SYSTEM.billing_277_clm_status patient_name Added SQL Documentation
SYSTEM.billing_277_clm_status payer_clm_cntrl_num Added SQL Documentation
SYSTEM.billing_277_clm_status status_cat_code Added SQL Documentation
SYSTEM.billing_277_clm_status status_cat_code_value Added SQL Documentation
SYSTEM.billing_277_clm_status status_code Added SQL Documentation
SYSTEM.billing_277_clm_status status_code_value Added SQL Documentation
SYSTEM.billing_277_clm_status status_type_code Added SQL Documentation
SYSTEM.billing_277_clm_status status_type_code_value Added SQL Documentation
SYSTEM.billing_277_clm_status status_update_date Added SQL Documentation
SYSTEM.billing_277_clm_status user_row_access_code Added SQL Documentation
SYSTEM.billing_277_svc_status CLAIM_NUMBER Added SQL Documentation
SYSTEM.billing_277_svc_status EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_277_svc_status FACILITY Added SQL Documentation
SYSTEM.billing_277_svc_status GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_277_svc_status ID Added SQL Documentation
SYSTEM.billing_277_svc_status JOIN_TO_TX_HISTORY Added SQL Documentation
SYSTEM.billing_277_svc_status PATID Added SQL Documentation
SYSTEM.billing_277_svc_status data_entry_by Added SQL Documentation
SYSTEM.billing_277_svc_status data_entry_by_option Added SQL Documentation
SYSTEM.billing_277_svc_status data_entry_date Added SQL Documentation
SYSTEM.billing_277_svc_status data_entry_time Added SQL Documentation
SYSTEM.billing_277_svc_status data_entry_user_id Added SQL Documentation
SYSTEM.billing_277_svc_status data_entry_user_name Added SQL Documentation
SYSTEM.billing_277_svc_status guarantor_name Added SQL Documentation
SYSTEM.billing_277_svc_status option_desc Added SQL Documentation
SYSTEM.billing_277_svc_status option_id Added SQL Documentation
SYSTEM.billing_277_svc_status pat_control_num Added SQL Documentation
SYSTEM.billing_277_svc_status patient_name Added SQL Documentation
SYSTEM.billing_277_svc_status status_type_code Added SQL Documentation
SYSTEM.billing_277_svc_status status_type_code_value Added SQL Documentation
SYSTEM.billing_277_svc_status svc_status_cat_code Added SQL Documentation
SYSTEM.billing_277_svc_status svc_status_cat_code_value Added SQL Documentation
SYSTEM.billing_277_svc_status svc_status_code Added SQL Documentation
SYSTEM.billing_277_svc_status svc_status_code_value Added SQL Documentation
SYSTEM.billing_277_svc_status svc_status_update_date Added SQL Documentation
SYSTEM.billing_277_svc_status user_row_access_code Added SQL Documentation
SYSTEM.billing_278_response CER_uniqueid Added SQL Documentation
SYSTEM.billing_278_response EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_278_response FACILITY Added SQL Documentation
SYSTEM.billing_278_response GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_278_response ID Added SQL Documentation
SYSTEM.billing_278_response PATID Added SQL Documentation
SYSTEM.billing_278_response action_code Added SQL Documentation
SYSTEM.billing_278_response action_value Added SQL Documentation
SYSTEM.billing_278_response authorization_number Added SQL Documentation
SYSTEM.billing_278_response certification_number Added SQL Documentation
SYSTEM.billing_278_response client_name Added SQL Documentation
SYSTEM.billing_278_response data_entry_by Added SQL Documentation
SYSTEM.billing_278_response data_entry_by_option Added SQL Documentation
SYSTEM.billing_278_response data_entry_date Added SQL Documentation
SYSTEM.billing_278_response data_entry_time Added SQL Documentation
SYSTEM.billing_278_response data_entry_user_id Added SQL Documentation
SYSTEM.billing_278_response data_entry_user_name Added SQL Documentation
SYSTEM.billing_278_response file_index Added SQL Documentation
SYSTEM.billing_278_response file_info_str Added SQL Documentation
SYSTEM.billing_278_response file_name Added SQL Documentation
SYSTEM.billing_278_response file_status Added SQL Documentation
SYSTEM.billing_278_response follow_act_code Added SQL Documentation
SYSTEM.billing_278_response follow_act_value Added SQL Documentation
SYSTEM.billing_278_response group Added SQL Documentation
SYSTEM.billing_278_response group_index Added SQL Documentation
SYSTEM.billing_278_response guarantor_name Added SQL Documentation
SYSTEM.billing_278_response hcpcs_composite Added SQL Documentation
SYSTEM.billing_278_response modifier Added SQL Documentation
SYSTEM.billing_278_response posting_message Added SQL Documentation
SYSTEM.billing_278_response procedure_code Added SQL Documentation
SYSTEM.billing_278_response procedure_value Added SQL Documentation
SYSTEM.billing_278_response reason_code Added SQL Documentation
SYSTEM.billing_278_response reject_rea_code Added SQL Documentation
SYSTEM.billing_278_response reject_rea_value Added SQL Documentation
SYSTEM.billing_278_response revenue_code Added SQL Documentation
SYSTEM.billing_278_response revenue_value Added SQL Documentation
SYSTEM.billing_278_response segment Added SQL Documentation
SYSTEM.billing_278_response segment_data Added SQL Documentation
SYSTEM.billing_278_response segment_index Added SQL Documentation
SYSTEM.billing_278_response trace_number Added SQL Documentation
SYSTEM.billing_278_response user_row_access_code Added SQL Documentation
SYSTEM.billing_278_response version Added SQL Documentation
SYSTEM.billing_837d_4010_errors EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_837d_4010_errors FACILITY Added SQL Documentation
SYSTEM.billing_837d_4010_errors GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_837d_4010_errors ID Added SQL Documentation
SYSTEM.billing_837d_4010_errors PATID Added SQL Documentation
SYSTEM.billing_837d_4010_errors batch_number Added SQL Documentation
SYSTEM.billing_837d_4010_errors bill_type_code Added SQL Documentation
SYSTEM.billing_837d_4010_errors bill_type_value Added SQL Documentation
SYSTEM.billing_837d_4010_errors client_interimb_code Added SQL Documentation
SYSTEM.billing_837d_4010_errors client_interimb_value Added SQL Documentation
SYSTEM.billing_837d_4010_errors consolid_hcfa_sort Added SQL Documentation
SYSTEM.billing_837d_4010_errors create_claims_code Added SQL Documentation
SYSTEM.billing_837d_4010_errors create_claims_value Added SQL Documentation
SYSTEM.billing_837d_4010_errors data_entry_by Added SQL Documentation
SYSTEM.billing_837d_4010_errors data_entry_by_option Added SQL Documentation
SYSTEM.billing_837d_4010_errors data_entry_date Added SQL Documentation
SYSTEM.billing_837d_4010_errors data_entry_time Added SQL Documentation
SYSTEM.billing_837d_4010_errors data_entry_user_id Added SQL Documentation
SYSTEM.billing_837d_4010_errors data_entry_user_name Added SQL Documentation
SYSTEM.billing_837d_4010_errors date_of_claim Added SQL Documentation
SYSTEM.billing_837d_4010_errors error_index Added SQL Documentation
SYSTEM.billing_837d_4010_errors error_message Added SQL Documentation
SYSTEM.billing_837d_4010_errors file_description Added SQL Documentation
SYSTEM.billing_837d_4010_errors file_index Added SQL Documentation
SYSTEM.billing_837d_4010_errors file_status Added SQL Documentation
SYSTEM.billing_837d_4010_errors financial_class_code Added SQL Documentation
SYSTEM.billing_837d_4010_errors financial_class_value Added SQL Documentation
SYSTEM.billing_837d_4010_errors first_date_of_service Added SQL Documentation
SYSTEM.billing_837d_4010_errors guarantor_name Added SQL Documentation
SYSTEM.billing_837d_4010_errors last_date_of_service Added SQL Documentation
SYSTEM.billing_837d_4010_errors medical_diag_sort Added SQL Documentation
SYSTEM.billing_837d_4010_errors patient_name Added SQL Documentation
SYSTEM.billing_837d_4010_errors priority Added SQL Documentation
SYSTEM.billing_837d_4010_errors program_code Added SQL Documentation
SYSTEM.billing_837d_4010_errors program_value Added SQL Documentation
SYSTEM.billing_837d_4010_errors user_row_access_code Added SQL Documentation
SYSTEM.billing_837d_4010_errors version Added SQL Documentation
SYSTEM.billing_837_d_errors EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_837_d_errors FACILITY Added SQL Documentation
SYSTEM.billing_837_d_errors GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_837_d_errors ID Added SQL Documentation
SYSTEM.billing_837_d_errors PATID Added SQL Documentation
SYSTEM.billing_837_d_errors batch_number Added SQL Documentation
SYSTEM.billing_837_d_errors bill_type_code Added SQL Documentation
SYSTEM.billing_837_d_errors bill_type_value Added SQL Documentation
SYSTEM.billing_837_d_errors client_interimb_code Added SQL Documentation
SYSTEM.billing_837_d_errors client_interimb_value Added SQL Documentation
SYSTEM.billing_837_d_errors consolid_hcfa_sort Added SQL Documentation
SYSTEM.billing_837_d_errors create_claims_code Added SQL Documentation
SYSTEM.billing_837_d_errors create_claims_value Added SQL Documentation
SYSTEM.billing_837_d_errors data_entry_by Added SQL Documentation
SYSTEM.billing_837_d_errors data_entry_by_option Added SQL Documentation
SYSTEM.billing_837_d_errors data_entry_date Added SQL Documentation
SYSTEM.billing_837_d_errors data_entry_time Added SQL Documentation
SYSTEM.billing_837_d_errors data_entry_user_id Added SQL Documentation
SYSTEM.billing_837_d_errors data_entry_user_name Added SQL Documentation
SYSTEM.billing_837_d_errors date_of_claim Added SQL Documentation
SYSTEM.billing_837_d_errors error_index Added SQL Documentation
SYSTEM.billing_837_d_errors error_message Added SQL Documentation
SYSTEM.billing_837_d_errors file_description Added SQL Documentation
SYSTEM.billing_837_d_errors file_index Added SQL Documentation
SYSTEM.billing_837_d_errors file_status Added SQL Documentation
SYSTEM.billing_837_d_errors financial_class_code Added SQL Documentation
SYSTEM.billing_837_d_errors financial_class_value Added SQL Documentation
SYSTEM.billing_837_d_errors first_date_of_service Added SQL Documentation
SYSTEM.billing_837_d_errors guarantor_name Added SQL Documentation
SYSTEM.billing_837_d_errors last_date_of_service Added SQL Documentation
SYSTEM.billing_837_d_errors medical_diag_sort Added SQL Documentation
SYSTEM.billing_837_d_errors patient_name Added SQL Documentation
SYSTEM.billing_837_d_errors priority Added SQL Documentation
SYSTEM.billing_837_d_errors program_code Added SQL Documentation
SYSTEM.billing_837_d_errors program_value Added SQL Documentation
SYSTEM.billing_837_d_errors user_row_access_code Added SQL Documentation
SYSTEM.billing_837_d_errors version Added SQL Documentation
SYSTEM.billing_837i_4010_errors EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_837i_4010_errors FACILITY Added SQL Documentation
SYSTEM.billing_837i_4010_errors GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_837i_4010_errors ID Added SQL Documentation
SYSTEM.billing_837i_4010_errors PATID Added SQL Documentation
SYSTEM.billing_837i_4010_errors batch_number Added SQL Documentation
SYSTEM.billing_837i_4010_errors bill_type_code Added SQL Documentation
SYSTEM.billing_837i_4010_errors bill_type_value Added SQL Documentation
SYSTEM.billing_837i_4010_errors client_interimb_code Added SQL Documentation
SYSTEM.billing_837i_4010_errors client_interimb_value Added SQL Documentation
SYSTEM.billing_837i_4010_errors consolid_hcfa_sort Added SQL Documentation
SYSTEM.billing_837i_4010_errors create_claims_code Added SQL Documentation
SYSTEM.billing_837i_4010_errors create_claims_value Added SQL Documentation
SYSTEM.billing_837i_4010_errors data_entry_by Added SQL Documentation
SYSTEM.billing_837i_4010_errors data_entry_by_option Added SQL Documentation
SYSTEM.billing_837i_4010_errors data_entry_date Added SQL Documentation
SYSTEM.billing_837i_4010_errors data_entry_time Added SQL Documentation
SYSTEM.billing_837i_4010_errors data_entry_user_id Added SQL Documentation
SYSTEM.billing_837i_4010_errors data_entry_user_name Added SQL Documentation
SYSTEM.billing_837i_4010_errors date_of_claim Added SQL Documentation
SYSTEM.billing_837i_4010_errors error_index Added SQL Documentation
SYSTEM.billing_837i_4010_errors error_message Added SQL Documentation
SYSTEM.billing_837i_4010_errors file_description Added SQL Documentation
SYSTEM.billing_837i_4010_errors file_index Added SQL Documentation
SYSTEM.billing_837i_4010_errors file_status Added SQL Documentation
SYSTEM.billing_837i_4010_errors financial_class_code Added SQL Documentation
SYSTEM.billing_837i_4010_errors financial_class_value Added SQL Documentation
SYSTEM.billing_837i_4010_errors first_date_of_service Added SQL Documentation
SYSTEM.billing_837i_4010_errors guarantor_name Added SQL Documentation
SYSTEM.billing_837i_4010_errors last_date_of_service Added SQL Documentation
SYSTEM.billing_837i_4010_errors medical_diag_sort Added SQL Documentation
SYSTEM.billing_837i_4010_errors patient_name Added SQL Documentation
SYSTEM.billing_837i_4010_errors priority Added SQL Documentation
SYSTEM.billing_837i_4010_errors program_code Added SQL Documentation
SYSTEM.billing_837i_4010_errors program_value Added SQL Documentation
SYSTEM.billing_837i_4010_errors user_row_access_code Added SQL Documentation
SYSTEM.billing_837i_4010_errors version Added SQL Documentation
SYSTEM.billing_837_i_errors EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_837_i_errors FACILITY Added SQL Documentation
SYSTEM.billing_837_i_errors GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_837_i_errors ID Added SQL Documentation
SYSTEM.billing_837_i_errors JOIN_TO_TX_HISTORY Added SQL Documentation
SYSTEM.billing_837_i_errors PATID Added SQL Documentation
SYSTEM.billing_837_i_errors PROVIDER_ID Added SQL Documentation
SYSTEM.billing_837_i_errors SERVICE_CODE Added SQL Documentation
SYSTEM.billing_837_i_errors batch_number Added SQL Documentation
SYSTEM.billing_837_i_errors bill_type_code Added SQL Documentation
SYSTEM.billing_837_i_errors bill_type_value Added SQL Documentation
SYSTEM.billing_837_i_errors client_interimb_code Added SQL Documentation
SYSTEM.billing_837_i_errors client_interimb_value Added SQL Documentation
SYSTEM.billing_837_i_errors consolid_hcfa_sort Added SQL Documentation
SYSTEM.billing_837_i_errors cost_of_service Added SQL Documentation
SYSTEM.billing_837_i_errors create_claims_code Added SQL Documentation
SYSTEM.billing_837_i_errors create_claims_value Added SQL Documentation
SYSTEM.billing_837_i_errors data_entry_by Added SQL Documentation
SYSTEM.billing_837_i_errors data_entry_by_option Added SQL Documentation
SYSTEM.billing_837_i_errors data_entry_date Added SQL Documentation
SYSTEM.billing_837_i_errors data_entry_time Added SQL Documentation
SYSTEM.billing_837_i_errors data_entry_user_id Added SQL Documentation
SYSTEM.billing_837_i_errors data_entry_user_name Added SQL Documentation
SYSTEM.billing_837_i_errors date_of_claim Added SQL Documentation
SYSTEM.billing_837_i_errors error_class_code Added SQL Documentation
SYSTEM.billing_837_i_errors error_class_value Added SQL Documentation
SYSTEM.billing_837_i_errors error_code Added SQL Documentation
SYSTEM.billing_837_i_errors error_code_value Added SQL Documentation
SYSTEM.billing_837_i_errors error_index Added SQL Documentation
SYSTEM.billing_837_i_errors error_message Added SQL Documentation
SYSTEM.billing_837_i_errors error_scope_code Added SQL Documentation
SYSTEM.billing_837_i_errors error_scope_value Added SQL Documentation
SYSTEM.billing_837_i_errors error_type_code Added SQL Documentation
SYSTEM.billing_837_i_errors error_type_value Added SQL Documentation
SYSTEM.billing_837_i_errors file_description Added SQL Documentation
SYSTEM.billing_837_i_errors file_index Added SQL Documentation
SYSTEM.billing_837_i_errors file_status Added SQL Documentation
SYSTEM.billing_837_i_errors financial_class_code Added SQL Documentation
SYSTEM.billing_837_i_errors financial_class_value Added SQL Documentation
SYSTEM.billing_837_i_errors first_date_of_service Added SQL Documentation
SYSTEM.billing_837_i_errors guarantor_name Added SQL Documentation
SYSTEM.billing_837_i_errors last_date_of_service Added SQL Documentation
SYSTEM.billing_837_i_errors medical_diag_sort Added SQL Documentation
SYSTEM.billing_837_i_errors patient_name Added SQL Documentation
SYSTEM.billing_837_i_errors priority Added SQL Documentation
SYSTEM.billing_837_i_errors program_code Added SQL Documentation
SYSTEM.billing_837_i_errors program_value Added SQL Documentation
SYSTEM.billing_837_i_errors qb_batch_number Added SQL Documentation
SYSTEM.billing_837_i_errors qbinfo Added SQL Documentation
SYSTEM.billing_837_i_errors user_row_access_code Added SQL Documentation
SYSTEM.billing_837_i_errors v_PROVIDER_NAME Added SQL Documentation
SYSTEM.billing_837_i_errors v_service_value Added SQL Documentation
SYSTEM.billing_837_i_errors version Added SQL Documentation
SYSTEM.billing_837p_4010_errors EPISODE_NUMBER Added SQL Documentation
SYSTEM.billing_837p_4010_errors FACILITY Added SQL Documentation
SYSTEM.billing_837p_4010_errors GUARANTOR_ID Added SQL Documentation
SYSTEM.billing_837p_4010_errors ID Added SQL Documentation
SYSTEM.billing_837p_4010_errors PATID Added SQL Documentation
SYSTEM.billing_837p_4010_errors batch_number Added SQL Documentation
SYSTEM.billing_837p_4010_errors bill_type_code Added SQL Documentation
SYSTEM.billing_837p_4010_errors bill_type_value Added SQL Documentation
SYSTEM.billing_837p_4010_errors client_interimb_code Added SQL Documentation
SYSTEM.billing_837p_4010_errors client_interimb_value Added SQL Documentation
SYSTEM.billing_837p_4010_errors consolid_hcfa_sort Added SQL Documentation
SYSTEM.billing_837p_4010_errors create_claims_code Added SQL Documentation
SYSTEM.billing_837p_4010_errors create_claims_value Added SQL Documentation
SYSTEM.billing_837p_4010_errors data_entry_by Added SQL Documentation
SYSTEM.billing_837p_4010_errors data_entry_by_option Added SQL Documentation
SYSTEM.billing_837p_4010_errors data_entry_date Added SQL Documentation
SYSTEM.billing_837p_4010_errors data_entry_time Added SQL Documentation
SYSTEM.billing_837p_4010_errors data_entry_user_id Added SQL Documentation
SYSTEM.billing_837p_4010_errors data_entry_user_name Added SQL Documentation
SYSTEM.billing_837p_4010_errors date_of_claim Added SQL Documentation
SYSTEM.billing_837p_4010_errors error_index Added SQL Documentation
SYSTEM.billing_837p_4010_errors error_message Added SQL Documentation
SYSTEM.billing_837p_4010_errors file_description Added SQL Documentation
SYSTEM.billing_837p_4010_errors file_index Added SQL Documentation
SYSTEM.billing_837p_4010_errors file_status Added SQL Documentation
SYSTEM.billing_837p_4010_errors financial_class_code Added SQL Documentation
SYSTEM.billing_837p_4010_errors financial_class_value Added SQL Documentation
SYSTEM.billing_837p_4010_errors first_date_of_service Added SQL Documentation
SYSTEM.billing_837p_4010_errors guarantor_name Added SQL Documentation
SYSTEM.billing_837p_4010_errors last_date_of_service Added SQL Documentation
SYSTEM.billing_837p_4010_errors medical_diag_sort Added SQL Documentation
SYSTEM.billing_837p_4010_errors patient_name Added SQL Documentation
SYSTEM.billing_837p_4010_errors priority Added SQL Documentation
SYSTEM.billing_837p_4010_errors program_code Added SQL Documentation
SYSTEM.billing_837p_4010_errors program_value Added SQL Documentation
SYSTEM.billing_837p_4010_errors user_row_access_code Added SQL Documentation
SYSTEM.billing_837p_4010_errors version Added SQL Documentation
SYSTEM.view_episode_summary_current patient_name_first Updated for client name with spaces