gmmisc_referral

The gmmisc_referral file contains demographic information about the providers who refer patients to your practice.  This includes the Referral source code for each referring provider and their Unique Provider Identification Number (UPIN).

Notes:

gmmisc_referral

Field Name

Type

Length

Referral_ID

varchar

6 MUL

Row_Index

int

11 MUL

Record_Type

char

1

Name

varchar

20

Form_Type_Number1_Print_Code

varchar

12

Form_Type_Number2_Print_Code

varchar

12

Form_Type_Number3_Print_Code

varchar

12

Form_Type_Number4_Print_Code

varchar

12

Form_Type_Number5_Print_Code

varchar

12

Form_Type_Number6_Print_Code

varchar

12

Form_Type_Number7_Print_Code

varchar

12

Form_Type_Number8_Print_Code

varchar

12

Form_Type_Number9_Print_Code

varchar

12

Abbr

varchar

10

Address

varchar

25

City

varchar

15

State

char

2

Zip

int

11

Phone

bigint

20

Fax

bigint

20

Num_Filelr_1

int

11

Numb_Filler_2

int

11

Specialty_Code

char

3

Contract_Type

varchar

20

Federal_ID

varchar

20

SSN

varchar

11

Referral_Code

varchar

4