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

Email

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!