Where do i get the detail db schema field level description

Management and Administration Documentation
#1

Hi,

I want to load ICD10 and own billing codes into the codes table. I am trying to import Excel files for these tables which use in another system but need to create the CSV file in the same format as the codes table. Unfortunately, i could not find any field level schema description for each table. All i could find is table usage description. If there was any, then appreciate any help possible.

I would most willing to create a schema description in the format we use which contains translations as well. See attached file for format. I do have the codes in excel files also which i can share in the forum.

mpn Db Schema - Lookups V02.52.xlsx (110.5 KB)

#2

For loading ICD 10 navigate to administration -> codes -> external data loads. Select ICD 10 and follow the instructions to download and import ICD 10.

Screenshot_20210820-170043
Screenshot_20210820-1700431440×2960 175 KB

Screenshot_20210820-170116
Screenshot_20210820-1701161440×2960 205 KB

#3

Hi Rachel,

Thank you for the reply but that did not address my question. I am looking for database schema field level descriptions.

#4

Hi @murugappan, here’s a related thread

#5

Hi Stephen,

Thank you so much for your assistance. Unfortunately, these are just DB and tables schema. My needs are Database Table Fields Schema which describes each field in each table. Some similar to the spreadsheet which i linked in my initial post.

This schema will greatly help us in using reporting tools to render reports for the users.

#6

hi @murugappan, that’s the best available in the community currently

but there’s database.sql that you may find useful

#7

Hi @stephenwaite , thank you for the help. Guess i have to look more deeper elsewhere.