gmpat
The gmpat file contains patient information that can be viewed in the Patient Demographics window.
Notes:
For information about interpreting Record Tables, see Understanding Record Tables.
To view other Record Tables, see the Data Dictionary Overview.
gmpat |
||
Field Name |
Type |
Length |
Row_Index |
int |
11 MUL |
Account |
varchar |
6 MUL |
Guar_ID |
varchar |
20 |
Guar_FirstI |
varchar |
18 |
Guar_Rel |
varchar |
4 |
Insurance1 |
varchar |
5 |
Insurance2 |
varchar |
5 |
Insurance3 |
varchar |
5 |
Diagnosis1 |
varchar |
9 |
Diag1_Notes |
varchar |
20 |
Diagnosis2 |
varchar |
9 |
Diag2_Notes |
varchar |
20 |
Diagnosis3 |
varchar |
9 |
Diag3_Notes |
carchar |
20 |
Last_Diagnosis |
varchar |
9 |
Cause |
char |
2 |
Cause_Date |
date |
|
Admission_Date |
date |
|
Discharge_Date |
date |
|
Last_Serv_Date |
date |
|
Last_Pymt_Date |
date |
|
Last_Stmt_Date |
date |
|
Statement_Freq |
int |
11 |
Post_Op_Visits |
int |
11 |
Missed_Appts |
int |
11 |
Last_Surg_Proc |
varchar |
9 |
Budget_Type |
char |
1 |
Budget_Amt |
decimal |
9,2 |
Patient_Bal |
decimal |
9,2 |
Insurance_Bal |
decimal |
9,2 |
Other_Bal |
decimal |
9,2 |
Patient_Pymt_YTD |
decimal |
9,2 |
Unapplied_Credits |
decimal |
9,2 |
Comment1 |
varchar |
15 |
Comment2 |
varchar |
15 |
Comment3 |
varchar |
15 |
Cause_State |
varchar |
6 |
Last_Svc_Dt_RecNumber |
int |
11 |
Registration_Date |
date |
|