gmmisc_provider

gmmisc_provider

The gmmisc_provider file contains information about the providers in the practice.

Notes:

For information about interpreting Record Tables, see Understanding Record Tables.
To view other Record Tables, see the Data Dictionary Overview.

gmmisc_provider
Field Name	Type	Length
Provider_ID	varchar	5
Row_Index	int	11 MUL
Record_Type	char	1
Name	varchar	20
Professional_Name	varchar	20
Address	varchar	25
City	varchar	15
State	char	2
Zip	int	11
Phone	bigint	20
MTD_Services	decimal	9,2
MTD_Payments	decimal	9,2
MTD_Adjust_Refund	decimal	9,2
MTD_Number_Of_Cases	int	11
YTD_Services	decimal	11,2
YTD_Payments	decimal	11,2
YTD_Adjust_Refund	decimal	11,2
YTD_Number_Of_Cases	int	11
Discontinued	int	11
Group_Number_ID	int	11
Federal_ID_Number	varchar	15
Form_Type_Number1_Print_Code	varchar	15
Form_Type_Number2_Print_Code	varchar	15
Form_Type_Number3_Print_Code	varchar	15
Form_Type_Number4_Print_Code	varchar	15
Form_Type_Number5_Print_Code	varchar	15
Form_Type_Number6_Print_Code	varchar	15
Form_Type_Number7_Print_Code	varchar	15
Form_Type_Number8_Print_Code	varchar	15
Form_Type_Number9_Print_Code	varchar	15
Social_Security_Number	varchar	11
Last_Year_End_A_R	decimal	13,2
Provider_Code	varchar	4