gmmisc_transactioncode

The gmmisc_transactioncode file contains information for transaction codes that are used in applying financial transactions, such as, payments, adjustments, refunds and transfers of responsibility, to patient accounts.

Notes:

gmmisc_transactioncode

Field Name

Type

Length

Provider_ID

varchar

5 MUL

Row_Index

int

11 MUL

Record_Type

char

1

Name

varchar

20

Professional_Name

varchar

30

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

9,2

YTD_Payments

decimal

9,2

YTD_Adjust_Refund

decimal

9,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 MUL