gmmisc_procedure

The gmmisc_procedure file contains procedure information as well as specific information relating to each insurance form type your practice has.

Notes:

gmmisc_procedure

Field Name

Type

Length

Procedure_ID

varchar

9 MUL

Row_Index

int

11 MUL

Record_Type

char

1

Procedure_Description

varchar

50

Alternate_Search

varchar

10

Private_Statement

varchar

30

Department

char

2

On_Own_Ticket

char

1

Medical_Record_Test

char

2

Discontinued

char

2

Default_TOS

int

11

Standard_Fee

decimal

9,2

Private_Procedure

varchar

9

Form_Type_Number1_Print_Code

varchar

13

Form_Type_Number2_Print_Code

varchar

13

Form_Type_Number3_Print_Code

varchar

13

Form_Type_Number4_Print_Code

varchar

13

Form_Type_Number5_Print_Code

varchar

13

Form_Type_Number6_Print_Code

varchar

13

Form_Type_Number7_Print_Code

varchar

13

Form_Type_Number8_Print_Code

varchar

13

Form_Type_Number9_Print_Code

varchar

13

Form_1_Allowed_Amount

decimal

6,2

Form_1_Adjustment

decimal

6,2

Form_1_Trailer_Flag

int

11

Form_1_Procedure_Group_Flag

int

11

Form_2_Allowed_Amount

decimal

6,2

Form_2_Adjustment

decimal

6,2

Form_2_Trailer_Flag

int

11

Form_2_Procedure_Group_Flag

int

11

Form_3_Allowed_Amount

decimal

6,2

Form_3_Adjustment

decimal

6,2

Form_3_Trailer_Flag

int

11

Form_3_Procedure_Group_Flag

int

11

Form_4_Allowed_Amount

decimal

6,2

Form_4_Adjustment

decimal

6,2

Form_4_Trailer_Flag

int

11

Form_4_Procedure_Group_Flag

int

11

Form_5_Allowed_Amount

decimal

6,2

Form_5_Adjustment

decimal

6,2

Form_5_Trailer_Flag

int

11

Form_5_Procedure_Group_Flag

int

11

Form_6_Allowed_Amount

decimal

6,2

Form_6_Adjustment

decimal

6,2

Form_6_Trailer_Flag

int

11

Form_6_Procedure_Group_Flag

int

11

Form_7_Allowed_Amount

decimal

6,2

Form_7_Adjustment

decimal

6,2

Form_7_Trailer_Flag

int

11

Form_7_Procedure_Group_Flag

int

11

Form_8_Allowed_Amount

decimal

6,2

Form_8_Adjustment

decimal

6,2

Form_8_Trailer_Flag

int

11

Form_8_Procedure_Group_Flag

int

11

Form_9_Allowed_Amount

decimal

6,2

Form_9_Adjustment

decimal

6,2

Form_9_Trailer_Flag

int

11

Form_9_Procedure_Group_Flag

int

11

Procedure_Type_Code

char

1

Alternate_Description_Type

char

1