gmsdte

Field Name

Type

Length

Account_ID

varchar

6 MUL

Row_Index

int

11 MUL

Posting_Date

date

Location_Code

char

2

Responsibility_Type

char

1

Journal_Printed

char

1

Referring_Provider

varchar

20

Provider_Code

varchar

4

Provider_Code

varchar

4

Accept_Assignment

char

1

Paid_Status

char

1

Cause

char

2

Cause_Date

date

Service_Date

date

Admission_Date

date

Discharge_Date

date

ATB_Category

int

11

Ticket_Number

int

11

Billing_Date

date

Total_Service_Amount

decimal

9,2

Total_Payment_Amount

decimal

9,2

Total_Adj_Amount

decimal

9,2

Number_Service_Days

int

11

Hold_To_Date

date

Physical_Form_Type

int

11

Encounter_Number

int

11

Batch_Number

varchar

7

Message_Code

varchar

5

Write_Off_Flag

char

1

Insurance_Code_1

varchar

5

Insurance_Code_2

varchar

5

Insurance_Code_3

varchar

5

Department_Number

char

2

Split_Ticket_Number

int

11

Original_ATB

int

11

Link_Ticket_Number

int

11

Date_Of_Charge

date

User_Number

int

11

History_Index

int

11

Filler2

int

11

Post_Run_Step

int

11

Post_Run_ID

bigint

20

Bill_To_Secondary

char

1

Ordering_Physician

varchar

4

Original_Insurance

varchar

5

Charge_Cluster

varchar

20

Supervising_Provider

varchar

4

Billing_Location_Code

char

2

Encounter_Number_Alpha

varchar

5

Force_Claim_Type

char

1

Ticket_Number_ID

varchar

8 MUL

A_Filler_3

char

1

A_Filler_4

char

1