Insurance claims sorted by service data

Sorted by date patient was seen

table: claim
schema: public
claimnumpatnumdateservicedatesentclaimstatustrial_datereceived_6plannumprovtreatclaimfeeinspayestinspayamtdedappliedpreauthstringisprosthesispriordatereasonunderpaidclaimnotetrial_claimtype_18provbillreferringprovtrial_refnumstring_21placeserviceaccidentrelatedtrial_accidentdate_24accidentstemployrelatedisorthoorthoremainmorthodatepatrelatplannum2patrelat2trial_writeoff_33radiographstrial_clinicnum_35claimformtrial_attachedimages_37trial_attachedmodels_38trial_attachedflags_39attachmentidcanadianmaterialsforwardedtrial_canadianreferralprovidernum_42canadianreferralreasontrial_canadianisinitiallower_44canadiandateinitiallowercanadianmandprosthmaterialtrial_canadianisinitialupper_47trial_canadiandateinitialupper_48canadianmaxprosthmaterialtrial_inssubnum_50inssubnum2canadatransrefnumtrial_canadaesttreatstartdate_53canadainitialpaymenttrial_canadapaymentmode_55canadatreatdurationcanadanumanticipatedpaymentscanadaanticipatedpayamountpriorauthorizationnumberspecialprogramcodeuniformbilltypemedtypeadmissiontypecodeadmissionsourcecodepatientstatuscodetrial_customtracking_66dateresentcorrectiontypetrial_claimidentifier_69origrefnumprovorderoverrideorthototalmshareofcosttrial_secusernumentry_74trial_secdateentry_75secdatetedittrial_orderingreferralnum_77datesentorigtrial_dateillnessinjurypreg_79dateillnessinjurypregqualifiertrial_dateother_81dateotherqualifierisoutsidelab
1152023-06-12T00:00:00.000Z2023-07-13T00:00:00.000ZS0001-01-01T00:00:00.000Z14114012600N0001-01-01T00:00:00.000ZP100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z000000000* TR00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0600001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z015/100000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
2162023-06-12T00:00:00.000Z2023-07-13T00:00:00.000ZS0001-01-01T00:00:00.000Z15118016600*0001-01-01T00:00:00.000ZP100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z000000000* TR00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0700001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z016/200000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
3172023-06-12T00:00:00.000Z2023-07-13T00:00:00.000ZS0001-01-01T00:00:00.000Z151686800N0001-01-01T00:00:00.000Z*100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z2142000000Mail00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0760001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z017/300000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
4172023-06-12T00:00:00.000Z0001-01-01T00:00:00.000ZH0001-01-01T00:00:00.000Z14168000*0001-01-01T00:00:00.000ZS100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z215200000000001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0670001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z017/400000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z00001-01-01T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
7112023-06-12T00:00:00.000Z2023-07-13T00:00:00.000ZS0001-01-01T00:00:00.000Z121230140075N0001-01-01T00:00:00.000Z*100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z000000000Mail00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0400001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z011/700000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
8122023-06-12T00:00:00.000Z2023-07-13T00:00:00.000Z*0001-01-01T00:00:00.000Z12114012500N0001-01-01T00:00:00.000ZP100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z100000000Mail00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0400001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z012/800000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
9132023-06-12T00:00:00.000Z2023-07-13T00:00:00.000ZS0001-01-01T00:00:00.000Z13114035050*0001-01-01T00:00:00.000ZP100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z0003000000Mail00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0500001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z0* TR00000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
1092023-06-12T00:00:00.000Z2023-07-13T00:00:00.000ZR2023-07-13T00:00:00.000Z933001501500N0001-01-01T00:00:00.000ZP100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z000000000Mail00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0200001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z09/1000000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
1192023-06-14T00:00:00.000Z2023-07-13T00:00:00.000ZS0001-01-01T00:00:00.000Z9345022500*0001-01-01T00:00:00.000ZP100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z000000000* TR00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0200001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z09/1100000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
12102023-06-12T00:00:00.000Z2023-07-13T00:00:00.000Z*0001-01-01T00:00:00.000Z10115012000*0001-01-01T00:00:00.000Z*100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z000000000Mail00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0300001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z010/1200000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
1582023-07-14T00:00:00.000Z2023-07-13T00:00:00.000Z*0001-01-01T00:00:00.000Z6115062050N0001-01-01T00:00:00.000ZP100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z0001000000Mail00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0100001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z0* TR00000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-07-13T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00
1492023-04-06T00:00:00.000Z2023-04-06T00:00:00.000Z*2023-07-13T00:00:00.000Z938080800N0001-01-01T00:00:00.000Z*100 0001-01-01T00:00:00.000Z2000001-01-01T00:00:00.000Z000000000Mail00001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z0200001-01-01T00:00:00.000Z000000000001-01-01T00:00:00.000Z09/1400000001-01-01T00:00:00.000Z2023-07-13T11:48:28.000Z02023-04-06T00:00:00.000Z0001-01-01T00:00:00.000Z00001-01-01T00:00:00.000Z00