FORMAT EXAPMLE FILE FOR SORTING

Document Sample
FORMAT EXAPMLE FILE FOR SORTING Powered By Docstoc
					SrlNo      Claim ID Member ID Gross                    Net
                                           Patient Share             PATIENT ID Started   ENDED
           GDOPCR75
         1 8114                       34.2
                    4195 2011 B02122 0001            0        34.2                        16/10/2012 00:00
                                                                        240725 16/10/2012 00:00
                                I WANT TO SORT AS PER THE
                                MEMBER ID, AND STILL RETAIN THE
                                OTHER COLUMNS. AS U CAN SEE I
                                HAVE DUPLICATE CLAIMS IN MEMBER
           GDOPCR75             ID
        18 5725     4195 2011 B02151 0004
                                      170     25/01/00        145                         14/10/2012 00:00
                                                                        382375 14/10/2012 00:00




           GDOPCR75
         3 7661                      0001
                    4195 2011 B02151 378.8         25        353.8                        15/10/2012 00:00
                                                                        282732 15/10/2012 00:00




                    4195 2011
           GDOPCR75 B02122
        15 8076     0001               112         25          87                         16/10/2012 00:00
                                                                        240725 16/10/2012 00:00




           GDOPCR75
         2 5736                      0004
                    4195 2011 B02151 75.53           0       75.53                        14/10/2012 00:00
                                                                        382375 14/10/2012 00:00




           GDOPCR75
         4 7662                      0003
                    4195 2011 B02151 587.4         25        562.4                        15/10/2012 00:00
                                                                        267725 15/10/2012 00:00
  GDOPCR75
8 5731                      0003
           4195 2011 B02151 16.63   0   16.63                     14/10/2012 00:00
                                                267725 14/10/2012 00:00
           Diagnosis   ICD            CPT           Acrivity id    Activity dateQuantity        Net

16/10/2012 00:00
           Principal          268.9
                                      1828-5283-001           38 16/10/2012 00:00          8           34.2 GD11677




14/10/2012 00:00
           Secondary          780.6
           Secondary          380.4
           Secondary           472
           Principal           462
                                            99214            480 14/10/2012 00:00          1           145 GD6503


15/10/2012 00:00
           Secondary          388.7
           Secondary          477.8
           Principal         381.81
                                            92567             48 15/10/2012 00:00          1           98.8 D2991
                                            99214             49 15/10/2012 00:00          1           255 D2991




16/10/2012 00:00
           Principal          268.9
                                            99212            402 16/10/2012 00:00          1            87 GD11677



14/10/2012 00:00
           Secondary          780.6
           Secondary          380.4
           Secondary           472
           Principal           462
                                      1629-4283-001           43   14/10/2012 00:00         1           7.6   GD6503
                                      1368-2083-002           44   14/10/2012 00:00        10          6.18   GD6503
                                      1670-3464-022           45   14/10/2012 00:00         1           5.7   GD6503
                                      1615-2904-002           46   14/10/2012 00:00         1          36.1   GD6503
                                      1464-1639-002           47   14/10/2012 00:00         1         19.95   GD6503

15/10/2012 00:00
           Secondary          780.6
           Secondary           462
           Principal           490
                                            87880             50 15/10/2012 00:00          1           81.7 D2905
                                            87400             51 15/10/2012 00:00          1           81.7 D2905
                                    87071        52 15/10/2012 00:00   1    144 D2905
                                    99214        53 15/10/2012 00:00   1    255 D2905



14/10/2012 00:00
           Secondary   493.92
           Secondary    786.2
           Secondary   786.07
           Secondary    477.9
           Secondary    780.6
           Principal     490
                                1127-4234-002   213 14/10/2012 00:00   1   10.93 D2905
                                1670-3464-022   214 14/10/2012 00:00   1     5.7 D2905

				
DOCUMENT INFO
Shared By:
Stats:
views:52
posted:11/18/2012
language:
pages:4