gmapptau_audit

Field Name

Type

Length

Account_ID (Key)

varchar

6 MUL

Row_Index

int

11 MUL

Record_Type

int

11

Date

date

Time

int

11

Type

varchar

5

Provider

varchar

4

Missed_Appt_Flag

int

11

Patient_Zip

int

11

Patient_Phone

bigint

20

Audit_Type

int

11

Audit_Date

date

Audit_Time

int

11

Num_Filler1

bigint

20

Num_Filler2

bigint

20

Num_Filler3

bigint

20

Type

varchar

5

Provider

varchar

4

Notes

varchar

18

Patient_Name

varchar

25

Patient_Address1

varchar

25

Patient_Address2

varchar

25

Patient_City

varchar

15

Patient_State

char

2

Oper_ID

char

3

Alpha_Filler1

char

1

Alpha_Filler2

char

1

Alpha_Filler3

char

1