gmhispro
The gmhispro file contains historical patient charge and ticket information.
Notes:
For information about interpreting Record Tables, see Understanding Record Tables.
To view other Record Tables, see the Data Dictionary Overview.
gmhispro  | 
		
	||
Field Name  | 
		Type  | 
		Length  | 
	
Row_Index  | 
		int  | 
		11 MUL  | 
	
Ticket_Number_ID  | 
		varchar  | 
		8 MUL  | 
	
Account  | 
		varchar  | 
		6  | 
	
Procedure_Code  | 
		varchar  | 
		9  | 
	
Alt_Description  | 
		varchar  | 
		40  | 
	
Fee  | 
		decimal  | 
		9,2  | 
	
Type_Of_Service  | 
		int  | 
		11  | 
	
Number_Of_Units  | 
		int  | 
		11  | 
	
Diagnosis_Code_1  | 
		varchar  | 
		9  | 
	
Diag_Cd_1_Alt_Desc  | 
		varchar  | 
		30  | 
	
Diagnosis_Code_2  | 
		varchar  | 
		9  | 
	
Diag_Cd_2_Alt_Desc  | 
		varchar  | 
		30  | 
	
Modified_Procedure  | 
		varchar  | 
		13  | 
	
Modified_Form_Type  | 
		int  | 
		11  | 
	
Journal_Printed  | 
		char  | 
		1  | 
	
Anesthesia_Start  | 
		int  | 
		11  | 
	
Anesthesia_Stop  | 
		int  | 
		11  | 
	
Patient_Co_Pay  | 
		decimal  | 
		7,2  | 
	
Filler1  | 
		int  | 
		11  | 
	
Base_Time_MOD_Units  | 
		varchar  | 
		6  | 
	
Diag3AtDiag4  | 
		varchar  | 
		19  | 
	
Lab_Location  | 
		varchar  | 
		5  | 
	
Tracking_Number  | 
		varchar  | 
		20  | 
	
National_Drug_Code  | 
		varchar  | 
		15  | 
	
User  | 
		varchar  | 
		5  | 
	
Filler4  | 
		char  | 
		1  | 
	
Filler5  | 
		char  | 
		1  | 
	
History_Index  | 
		int  | 
		11  | 
	
Filler6  | 
		int  | 
		11  | 
	
Post_Run_Step  | 
		int  | 
		11  | 
	
Global_Sequence  | 
		bigint  | 
		20  | 
	
Date_Entered  | 
		date  | 
		
  | 
	
Time_Entered  | 
		date  | 
		
  |