patnum | trial_lname_2 | fname | middlei | trial_preferred_5 | patstatus | gender | position | trial_birthdate_9 | ssn | address | address2 | trial_city_13 | trial_state_14 | zip | hmphone | wkphone | wirelessphone | guarantor | credittype | email | salutation | estbalance | priprov | trial_secprov_25 | feesched | billingtype | imagefolder | addrnote | famfinurgnote | medurgnote | apptmodnote | studentstatus | trial_schoolname_34 | chartnumber | trial_medicaidid_36 | trial_bal_0_30_37 | trial_bal_31_60_38 | bal_61_90 | balover90 | insest | trial_baltotal_42 | trial_employernum_43 | employmentnote | trial_county_45 | trial_gradelevel_46 | urgency | datefirstvisit | clinicnum | hasins | trial_trophyfolder_51 | plannedisdone | trial_premed_53 | trial_ward_54 | preferconfirmmethod | prefercontactmethod | trial_preferrecallmethod_57 | trial_schedbeforetime_58 | schedaftertime | scheddayofweek | language | admitdate | title | payplandue | sitenum | trial_datetstamp_66 | trial_responsparty_67 | canadianeligibilitycode | trial_asktoarriveearly_69 | trial_prefercontactconfidential_70 | superfamily | txtmsgok | trial_smokingsnomed_73 | country | datetimedeceased | trial_billingcycleday_76 | secusernumentry | secdateentry | trial_hassuperbilling_79 | patnumclonefrom | discountplannum | trial_hassignedtil_82 | shortcodeoptin | trial_securityhash_84 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7 | Smith | 4 | 0 | 0 | 0001-01-01T00:00:00.000Z | 7 | 0 | 1 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 00:00:00 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 2023-07-11T13:51:13.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 266927001 | 0001-01-01T00:00:00.000Z | 1 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | Exception | ||||||||||||||||||||||||||||||||
14 | PPO | LittleAnnie | 0 | 0 | 0 | 2002-03-27T00:00:00.000Z | 4528 Panama St SE | * TRI | CA | 52981 | * TRIAL * TRI | 8 | 0 | 3 | 0 | 0 | 40 | PPOLittleAnnie14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2009-04-30T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 00:00:00 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 2023-07-11T13:51:13.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 266927001 | 0001-01-01T00:00:00.000Z | 1 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | Exception | |||||||||||||||||||||||||
18 | Smith | Sis | 0 | 1 | 2 | 2008-06-25T00:00:00.000Z | * TRIAL * TRIAL * | San Jose | CA | * TRI | * TRIAL * TRI | 15 | 0 | 1 | 0 | 0 | 40 | SmithSis18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2009-03-30T00:00:00.000Z | 0 | I | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 00:00:00 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 2023-07-11T13:51:13.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 266927001 | 0001-01-01T00:00:00.000Z | 1 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | * TRIAL * | ||||||||||||||||||||||||
19 | Smith | 4 | 0 | 0 | 0001-01-01T00:00:00.000Z | 125 Satin Heights | San Jose | CA | 05698 | (536)624-5871 | 19 | 0 | 1 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 00:00:00 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 2023-07-11T13:51:13.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 266927001 | 0001-01-01T00:00:00.000Z | 1 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | Exception | |||||||||||||||||||||||||||
20 | Zarren | Amy | 0 | 1 | 1 | 1949-04-02T00:00:00.000Z | * TRIAL * TRIAL | * TRIA | TX | 25415 | (625)879-5462 | 21 | 0 | 3 | 0 | 0 | 40 | ZarrenAmy20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2009-04-30T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 00:00:00 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 2023-07-11T13:51:13.000Z | 0 | 0 | 0 | 0 | 0 | 0 | * TRIAL * | 0001-01-01T00:00:00.000Z | 1 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | Exception | |||||||||||||||||||||||||
21 | * TRIA | Bob | 0 | 0 | 1 | 1951-06-09T00:00:00.000Z | 3652 Memory Lane | Dallas | TX | 25415 | (625)879-5462 | 21 | 0 | 3 | 0 | 0 | 40 | ZarrenBob21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2009-04-30T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 00:00:00 | 00:00:00 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 2023-07-11T13:51:13.000Z | 0 | 0 | 0 | 0 | 0 | 0 | 266927001 | 0001-01-01T00:00:00.000Z | 1 | 0 | 0001-01-01T00:00:00.000Z | 0 | 0 | 0 | 0 | 0 | Exception |