Data extract.
Need an extract of your Practice Management data? We can help with that! The following pertains to edgeMED’s non-web-based PM software.
Data extract.
Need an extract of your Practice Management data? We can help with that! The following pertains to edgeMED’s non-web-based PM software.
Data Export of Legacy edgeMED PM
You will receive an invoice that must be paid in full before we begin the export. The average time to complete a data export depends on the size of the data that needs to be extracted, averaging from 3-7 business days.
The data elements of the standard data export are listed below. You may also download them for your convenience.
ELEMENT |
DESCRIPTION |
Usersd |
Name of Users Data File |
DB# |
System Database Identifier |
User ID |
User Identification Number |
User Name |
User Name |
User Active |
Active or Inactive user |
Reftab |
Name of Referral Data File |
DB# |
System Database Identifier |
Referral ID |
Referral Identification Number |
Referral Group Name |
Corporate Name |
Ref Last Name |
Referral Last name |
Ref First Name |
Referal First Name |
Ref Degree |
Referral Degree |
Ref Mid Name |
Referral Middle Name |
Ref Address 1 |
Referral Street Address |
Ref Address 2 |
Referral Street Address2 |
Ref City |
Referral City |
Ref State |
Referral State |
Ref Zip |
Referral Zip |
Ref Phone |
Referral Phone |
Ref Mobile |
Referral Mobile Phone Number |
Ref Pager |
Referral Pager Number |
Ref Fax |
Referral Fax Number |
Ref NPI |
Referral National Provider Identification |
Ref StLicNo |
Referral State License Number |
Ref TaxID |
Referral Tax Identification |
Ref TaxonomyCode |
Referral Taxonomy Code |
Ref DEA |
Referral Drug Enforcement Number |
Ref UPIN |
Referral Unique Physician Identification Number |
Ref Specialty |
Referral Speciality |
Ref Initials |
Referral Initials |
Prvtab |
Name Of Provider Data File |
DB# |
System Database Identifier |
Provider ID |
System Provider Unique Identification |
Prov Last Name |
Provider Last Name |
Prov First Name |
Provider First Name |
Prov Mid Name |
Provider Middle Initial |
Prov Degree |
Provider Degree |
Taxonomy Code |
Provider Taxonomy Code |
NPI |
Provider National Provider Identification |
Group NPI |
Group National Provider Identification |
ProviderInitials |
Provider Initials |
ProviderTaxId |
Provider Tax Identification |
ProviderTaxIdType |
Provider Tax Identification Type |
SpecialityLicense |
Provider Organization Type |
OrganizationType DEA |
Provider Drug Enforcement Number |
AneasthesiaLicense |
Provider Aneasthesis License |
MammographyCertNo |
Provider Mammography Certificate Number |
Prov Address 1 |
Provider Street Address1 |
Prov Address 2 |
Provider Street Address2 |
Prov City |
Provider City |
Prov State |
Provider State |
Prov Zip |
Provider Zip |
Prov Phone |
Provider Phone Number |
Prov Fax |
Provider Fax Number |
Mobile |
Provider Mobile Number |
Pager |
Provider Pager Number |
Prov UPIN |
Provider Unique Physician Identification Number |
Prov Speciality |
Provider Specialty |
Prov State Lic.No. |
Provider State License Number |
USERID |
Unique Identifier Of The User That Last Accessed This Record |
Procdm |
Name Of Procedure Data File |
DB# |
System Database Identifier |
ID |
System Unique Identification |
Description |
Name Of Procedure |
CPT |
Current Procedural Terminology |
CPT-1 |
Current Procedural Terminology |
CPT-2 |
Current Procedural Terminology |
CPT-3 |
Current Procedural Terminology |
CPT-4 |
Current Procedural Terminology |
Modifier-1 |
Modifier1 |
Modifier-2 |
Modifier2 |
Modifier-3 |
Modifier3 |
Modifier-4 |
Modifier4 |
Category |
Procedure Category |
Procedure Type |
Procedure Type |
Type of Service |
Service Type |
Multiple |
Allow For Multiple |
Post Op Dayes |
Post Operation Days |
Paid at 100% |
Procedure Paid At 100% |
Req Ord Pay |
Procedure Require Ordering Physician |
Anest. Base Unit |
Anesthesis Base Uints |
Cost |
Cost Of Procedure |
UserID |
Unique Identifier Of The User That Last Accessed This Record |
Postab |
Name Of Place Of Service Data File |
DB# |
System Database Identifier |
DatabaseName |
Name of Practice |
Facility ID |
Facility Identification |
Fac NAME |
Facility Name |
Fac Address 1 |
Facility Street Address 1 |
Fac Address 2 |
Facility Street Address 2 |
Fac City |
Facility City |
Fac State |
Facility State |
Fac Zip |
Facility Zip |
Fac Phone |
Facility Phone |
Fac Fax |
Facility Fax |
Fac Email |
Facility Email |
Billing Address1 |
Facility Billing Address Line 1 |
Billing Address2 |
Facility Billing Address Line 2 |
Billing City |
Facility Billing City |
Billing State |
Facility State |
Billing Zip |
Facility Zip Code |
Billing Phone |
Facility Phone Number |
Billing Fax |
Facility Fax Number |
Billing Email |
Facility Email |
Federal Tax ID |
Facility Federal Tax identification |
CLIA ID |
Facility Clinical Laboratory Improvement Amendments Identification |
POS |
Place of service Identification |
NPI |
Facility National Provider Identification |
CheckPayableTo |
Check Payable To |
MammographyCertificationNo |
Mammography Certification Number |
FacilityCode |
Facility Code |
FacilityType |
Facility Type |
USERID |
Unique Identifier Of The User That Last Accessed This Record |
Pmtadj |
Name Of Payment Adjustment File |
DB# |
System Database Identifier |
Code |
System Unique Identification |
Description |
Name of Adjustment Code |
Category |
Category Code |
Type |
Type of Adjustment |
USERID |
Unique Identifier Of The User That Last Accessed This Record |
Patins |
Name Of Patient Insurance Data File |
DB# |
System Database Identifier |
Patient Account # |
Name of Practice |
Ins ID |
Facility Identification |
Ins Co NAME |
Insurance Company Name |
Insur Last Name |
Insured Last Name |
Insur First Name |
Insured First Name |
Insur Middle Name |
Insured Middle Name |
Insur Relation |
Insured Relation to Patient |
Insur Address 1 |
Insured Street Address 1 |
Insur Address 2 |
Insured Street Address 2 |
Insur City |
Insured City |
Insur State |
Insured State |
Insur Zip |
Insured Zip |
Insur SSN |
Insured Social Security Number |
Insur Sex |
Insured Sex |
Insur DOB |
Insured Date of Birth |
Certificate # |
Insurance Certificate Number |
Group # |
Insurance Group Number |
Group Name |
Insurance Group Name |
Co-Pay |
Insurance Co-Pay |
Co-Pay Type |
Insurance Co-Pay Type |
Ins Priority |
Insurance Priority |
Ins Plan Code |
Subscriber Plan Code (BC/BS) |
USERID |
Unique Identifier Of The User That Last Accessed This Record |
Patdmp |
Name Of Patient Data File |
DB# |
System Database Identifier |
Account # |
System Assigned Unique Identification |
Last Name |
Patient Last Name |
First Name |
Patient First Name |
Middle Name |
Patient Middle Name |
Address 1 |
Patient Street Address 1 |
Address 2 |
Patient Street Address 2 |
City |
Patient City |
State |
Patient State |
Zip |
Patient Zip |
Phone |
Patient Phone Number |
Date of Birth |
Patient Date of Birth |
Sex |
Patient Sex |
Marital Status |
Patient Marital Status |
Social Security |
Patient Social Security Number |
Remarks |
Free Form Entry |
|
Patient Email |
Referral ID |
Patient Referral Source Identifier |
Employer Name |
Patient Employer |
Employer Addr |
Patient Employer Street Address |
Employer City |
Patient Employer City |
Employer State |
Patient Employer State |
Employer Zip |
Patient Employer Zip |
Employer Phone |
Patient Employer Phone Number |
Doctor ID |
Patient Provider Identifier |
Provider Name |
Patient Provider Name |
MRN |
Patient Medical Record Number |
Emergency Contact |
Patient Emergency Contact |
Guarantor ID |
Patient Guarantor Identifier |
Guarantor Last Name |
Patient Guarantor Last name |
Guarantor First Name |
Patient Guarantor First Name |
Guar Address 1 |
Patient Guarantor Address Line 1 |
Guar Address 2 |
Patient Guarantor Address Line 2 |
Guar City |
Patient Guarantor City |
Guar State |
Patient Guarantor State |
Guar Zip |
Patient Guarantor Zip |
Guar DOB |
Patient Guarantor Date of Birth |
Relationship to Patient |
Guarantor Relation to Patient |
Rendering Physician ID |
Provider Unique Identifier |
Rendering Physician Name |
Rendering Provider Name |
USERID |
Unique Identifier Of The User That Last Accesses This Record |
Maddmp |
Name Of Miscellaneous Data File |
DB# |
System Database Identifier |
Type |
Address Type, ie. Employer, Attorney, Vendor |
Name |
Name |
Street |
Street Address Line 1 |
Address 2 |
Street Address Line 2 |
City |
Miscellaneous City |
State |
Miscellaneous State |
Country |
Miscellaneous Zip |
Phone |
Miscellaneous Phone Number |
Fax |
Miscellaneous Fax |
Category |
Miscellaneous Category |
Notes-1 |
Free Form Entry |
Notes-2 |
Free Form Entry |
USERID |
Unique Identifier Of The User That Last Accessed This Record |
Insdmp |
Name Of Insurance Data File |
DB# |
System Database Identifier |
Insurance ID |
System, Assigned Unique Identifier |
Contact Person |
Name of Contact |
Insurance name |
Insurance Company Name |
Insurance Email |
Insurance Company Email Address |
Insurance Address 1 |
Insurance Company Street Address Line 1 |
Insurance Address 2 |
Insurance Company Street Address Line 2 |
Insurance City |
Insurance Company City |
Insurance State |
Insurance Company State |
Insurance Zip |
Insurance Company Zip |
Insurance Phone |
Insurance Company Phone Number |
Insurance Fax |
Insurance Company Fax |
Website |
Insurance Company Website Address |
Payment Source |
Electronic Remittance Advance Identifier |
Claim Submission Payer ID |
Payer Identifier |
Medigap ID |
|
USERID |
Unique Identifier Of The User That Last Accessed This Record |
Diagdm |
Name Of Insurance Data File |
DB# |
System Database Identifier |
ID |
System Assigned Unique Identifier |
ICD10 |
International Classification of Disease Code |
Description |
International Classification of Disease Description |
ALT-ICD10 |
Alternate International Classification of Disease Code |
ICD10-3 |
International Classification of Disease Code |
ICD10-4 |
International Classification of Disease Code |
ICD10-5 |
International Classification of Disease Code |
USERID |
Unique Identifier Of The User That Last Accessed This Record |
Colact |
Name Of Insurance Data File |
DB# |
System Database Identifier |
Collector ID |
System Assigned Unique Identifier |
Date of Action |
Date of Activity |
Time of Action |
Time of Activity |
Patient ID |
Unique Identifier of Patient |
Claim No |
Claim Number |
User ID |
Unique Identifier Of The User That Last Accessed This Record |
Claim IR |
Insurance Responsible ie, Primary, Secondary, etc |
Activity |
Collection Activity |
Clamdt |
Name Of Claim Data File |
DB# |
System Database Identifier |
Patient ID |
Assigned Unique Patient Identifier |
Claim No |
Claim Number |
INS ID1 |
Unique Identifier of Instance Company |
INS ID2 |
Unique Identifier of Instance Company |
INS ID3 |
Unique Identifier of Instance Company |
File Date 1 |
Date Claim was Filed |
File Method 1 |
Code Indicating EDI File Type |
User ID1 |
Unique Identifier of User |
Amount 1 |
Amount Filed |
File Date 2 |
Date Claim was Filed |
File Method 2 |
Code Indicating EDI File Type |
User ID2 |
Unique Identifier of User |
Amount 2 |
Amount Filed |
File Date 3 |
Date Claim was Filed |
File Method 3 |
Code Indicating EDI File Type |
User ID3 |
Unique Identifier of User |
Amount 3 |
Amount Filed |
Chgdmp |
Name Of Charge Data File |
DB# |
System Database Identifier |
Patient ID |
Unique Patient Identifier |
Charge Rec |
Unique Identifier of Charge Record |
Name |
Patient First and Last Name |
Service DT |
Date of Service |
Posting DT |
Date of Posting |
Status |
Status of Charge |
PRV |
Unique Identifier of Provider |
POS |
Unique Identifier of Place of Service |
REF |
Unique Identifier of Referral Source |
CLM |
Unique Identifier of Claim |
Description |
Description of Service |
QTY |
Quantity of Service |
Charge Amount |
Charge Amount for Service |
Patient Amount |
Patient Responsible Amount for Service |
Allowed Amount |
Original Insurance Allowed Amount |
INS Amount |
Insurance Responsible Amount for Service |
PAT Balance |
Patient Balance Amount |
PAT Aging |
Patient Aging Date |
INS Balance |
Insurance Balance Amount |
INS Aging |
Insurance Aging Date |
INS Company |
Unique Identifier of Insurance Company |
PROC-ID |
Unique Identifier of Procedure |
DIAG1 |
Unique Identifier of Diagnosis |
DIAG2 |
Unique Identifier of Diagnosis |
DIAG3 |
Unique Identifier of Diagnosis |
DIAG4 |
Unique Identifier of Diagnosis |
MOD1 |
Modifier |
MOD2 |
Modifier |
MOD3 |
Modifier |
MOD4 |
Modifier |
USERID |
Unique Identifier Of The User That Last Accessed This Record |
Catdmp |
Name Of Category Data File |
DB# |
System Database Identifier |
Code |
Unique Patient Identifier |
Category |
Category Code |
Description |
Description of Code |
Alert |
Indicate the Alert |
User ID3 |
Unique Identifier of User |
Still need help? Contact us!