Database server: OMONODEPROD01OMDDBPROD03 Database name: OMD_Rptg Table name: dbo.MMIS Pharma Claim (based on the selected table in
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
SQLQuery2.sql - OMDNODEPROD01\OMDDBPROD03.OMD_Rptg View Project Tools Window Help -O-B OMD_Rptg Edit Explorer ect - = O Debug New Query dbo.MHCLDSHD dbo.MHCLDSHID dbo.MHCLDSHID_STRIP dbo.MHCLDSHR dbo.MHCLDState dbo.MHCLDState_FY20 dbo.MHCLDState_FY21 dbo.MHCLDSTATE_FY22 dbo.MHCLDStateSHID Execute Debug 4 dbo.MHCLDStateSHID_FY20 dbo.MHCLDStateSHID_FY21 dbo.MHCLDSTATESHID_FY22 dbo.missing_clms_11182021_new Fdbo.Missing_Denied_Claims dbo.MissingAnalysis_1102 dbo.Missing Denied Claims_NoDups dbo.MISSINGPRA dbo.MISSINGPRA_FINAL0221 dbo.MMIS_Drug_Info dbo.MMIS_Pharma_Claim dbo.MMIS_PHARMA_CLAIM_TMP dbo.MMIS_PHARMA_CLAIM_TMP1 dbo.No_Engagement Providers_Sheet1 dbo.No_Engagement Providers_Sheet2 dbo.OLE DB Destination dbo.OLE_DB_Destination dbo.OMD_835_FF_CHKREG_REPORT_CC dbo.OMD_835_FF_CHKREG_REPORT_CC dbo.OMD_835_FLATFILE_CHKREG_REP dbo.OMD_835_FLATFILE_CHKREG_REPC dbo.OMD_835_FLATFILE_CHKREG_REP( dbo.OMD_835_FLATFILE_CHKREG_REP dbo.OMD_835_FLATFILE_CHKREG_REPC dbo.OMD_835_FLATFILE_CLMS_ORIG_S 90% (INFOMC\fabuah (69))* - Microsoft SQL Server Management Studio X SQLQuery2.sql - O... FOMC\fabuah (69))* X select from MMIS_Pharma_Claim FLE 12 2-C -| Results Messages ICN_NUMBER 1 32208202515212400 2 32208202518682000 3 32208202518682700 4 32208202515956400 5 32208202521696700 6 32208202519777800 7 32208202520641400 8 32208202523277900 9 32208202515461300 10 32208202517073900 11 32208202518674200 12 32208202523917000 13 32208202516713.500 Query canceled. 9 ACCOUNT CODE CLAIM_STATUS 0 0 0 0 0 0 0 0 0 0 0 0 0 P P P P P P P P P P Pa P aa P P Ab P P P P CLAIM_TYPE FIRST_DATE_OF_SVC LAST_DATE_OF_SVC DATE_PAID ORIG_PAY_DATE RECIP_PAY_AMT 03/26/2022 03/26/2022 01/01/0001 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 03/26/2022 01/01/0001 01/01/0001 03/26/2022 01/01/0001 01/01/0001 03/26/2022 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 P P P P P P aaa 16 P P. Generic Debugger P 03/17/2022 03/21/2022 03/21/2022 03/18/2022 03/22/2022 03/21/2022 03/22/2022 03/23/2022 03/18/2022 03/19/2022 03/21/2022 03/23/2022 03/18/2022 Quick Launch (Ctrl+Q) 03/17/2022 03/21/2022 03/21/2022 03/18/2022 03/22/2022 03/21/2022 03/22/2022 03/23/2022 03/18/2022 03/19/2022 03/21/2022 03/23/2022 03/18/2022 0000100 0000100 0000000 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000000 D P AMT_PAID BY 000000000 000000000 000000000 000000000 000000000 000000000 000000000 00000000 00000000 00000001 0000000 0000000 000000 OMDNODEPROD01\OMDDBPROD03 (... INFOMC\fabuah (69) OMD_Rptg 9 SQLQuery2.sql - OMDNODEPROD01\OMDDBPROD03.OMD_Rptg View Project Tools Window Help -O-B OMD_Rptg Edit Explorer ect - = O Debug New Query dbo.MHCLDSHD dbo.MHCLDSHID dbo.MHCLDSHID_STRIP dbo.MHCLDSHR dbo.MHCLDState dbo.MHCLDState_FY20 dbo.MHCLDState_FY21 dbo.MHCLDSTATE_FY22 dbo.MHCLDStateSHID Execute Debug 4 dbo.MHCLDStateSHID_FY20 dbo.MHCLDStateSHID_FY21 dbo.MHCLDSTATESHID_FY22 dbo.missing_clms_11182021_new Fdbo.Missing_Denied_Claims dbo.MissingAnalysis_1102 dbo.Missing Denied Claims_NoDups dbo.MISSINGPRA dbo.MISSINGPRA_FINAL0221 dbo.MMIS_Drug_Info dbo.MMIS_Pharma_Claim dbo.MMIS_PHARMA_CLAIM_TMP dbo.MMIS_PHARMA_CLAIM_TMP1 dbo.No_Engagement Providers_Sheet1 dbo.No_Engagement Providers_Sheet2 dbo.OLE DB Destination dbo.OLE_DB_Destination dbo.OMD_835_FF_CHKREG_REPORT_CC dbo.OMD_835_FF_CHKREG_REPORT_CC dbo.OMD_835_FLATFILE_CHKREG_REP dbo.OMD_835_FLATFILE_CHKREG_REPC dbo.OMD_835_FLATFILE_CHKREG_REP( dbo.OMD_835_FLATFILE_CHKREG_REP dbo.OMD_835_FLATFILE_CHKREG_REPC dbo.OMD_835_FLATFILE_CLMS_ORIG_S 90% (INFOMC\fabuah (69))* - Microsoft SQL Server Management Studio X SQLQuery2.sql - O... FOMC\fabuah (69))* X select from MMIS_Pharma_Claim FLE 12 2-C -| Results Messages ICN_NUMBER 1 32208202515212400 2 32208202518682000 3 32208202518682700 4 32208202515956400 5 32208202521696700 6 32208202519777800 7 32208202520641400 8 32208202523277900 9 32208202515461300 10 32208202517073900 11 32208202518674200 12 32208202523917000 13 32208202516713.500 Query canceled. 9 ACCOUNT CODE CLAIM_STATUS 0 0 0 0 0 0 0 0 0 0 0 0 0 P P P P P P P P P P Pa P aa P P Ab P P P P CLAIM_TYPE FIRST_DATE_OF_SVC LAST_DATE_OF_SVC DATE_PAID ORIG_PAY_DATE RECIP_PAY_AMT 03/26/2022 03/26/2022 01/01/0001 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 03/26/2022 01/01/0001 01/01/0001 03/26/2022 01/01/0001 01/01/0001 03/26/2022 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 03/26/2022 01/01/0001 P P P P P P aaa 16 P P. Generic Debugger P 03/17/2022 03/21/2022 03/21/2022 03/18/2022 03/22/2022 03/21/2022 03/22/2022 03/23/2022 03/18/2022 03/19/2022 03/21/2022 03/23/2022 03/18/2022 Quick Launch (Ctrl+Q) 03/17/2022 03/21/2022 03/21/2022 03/18/2022 03/22/2022 03/21/2022 03/22/2022 03/23/2022 03/18/2022 03/19/2022 03/21/2022 03/23/2022 03/18/2022 0000100 0000100 0000000 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000100 0000000 D P AMT_PAID BY 000000000 000000000 000000000 000000000 000000000 000000000 000000000 00000000 00000000 00000001 0000000 0000000 000000 OMDNODEPROD01\OMDDBPROD03 (... INFOMC\fabuah (69) OMD_Rptg 9
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these algorithms questions
-
A stiff, straight, horizontal wire of length 25 cm and mass 20 g is supported by electrical contacts at its ends, but is otherwise free to move vertically upward. The wire is in a uniform, horizontal...
-
What is the future value on December 31, 2020, of a deposit of $35,000 made on January 1, 2017, assuming interest of 10% compounded annually?
-
You are interested in a used specialty machine that would cost $ 1 1 0 , 0 0 0 new, would have a lifespan of ten years, and a $ 1 0 , 0 0 0 salvage value. If the machine is five years old, what is...
-
True or False. AC HI pot testing of motor winding systems provides the highest stress available for the evaluation of the winding insulation system. It should therefore be performed ONLY on a new...
-
Anita Zurbrugg was just hired as the assistant treasurer of Yorktown Stores. The company is a specialty chain store with nine retail stores concentrated in one metropolitan area. Among other things,...
-
Determine the x-y and n-t components of the 17.0 kip force F acting on the simply supported beam. Assume a 33 ft, b = 18 ft,0 = 20%, and = 45 y L--x A Answers: Fx = a C F b B i kips Fy= kips Fn =...
-
Explain the following code. do { var num = parseFloat (prompt ("Enter a number from 1 to 10")); } while (isNaN (num) || num < 1 || num > 10); if (num == 7) alert("got it"); else alert("no good");
-
Who made this statement: I still have the audacity to believe that people everywhere can have three meals a day. a) Charles Murray b) William Julius Wilson c) Barbara Bush (mother of President George...
-
Which statement is the most accurate? a) Most poor people receive public assistance (formerly called welfare). b) Public assistance has been discontinued. c) The number of people receiving public...
-
Which statement is false? a) Nearly half of all poor Americans own their own homes. b) A poor person today has roughly the same standard of living as a middle-income person 30 years ago. c) The...
-
Which is the most accurate statement about real median family income? a) It has declined steadily over the last ten years. b) It has fallen during nearly every recession since the 1960s. c) It is...
-
Who would most likely receive food stamps before the age of 20? a) a white person b) a black person c) an Asian American person d) a person who grew up in a two-parent household
-
Steps and Limits to Rational Decision Making Managers make decisions every day. Decision making is the process of choosing a solution from available alternatives. Rational decision making is a...
-
Access the Federation of Tax Administrators Internet site at www. taxadmin.org/state-tax-forms and indicate the titles of the following state tax forms and publications: a. Minnesota Form M-100 b....
-
Greg died on July 1, 2012, and left Lea, his wife, a $50,000 life insurance policy which she elects to receive at $5,000 per year plus interest for 10 years. In the current year, Lea receives $6,200....
-
Clifford Johnson has a limited partnership investment and a rental condominium. Clifford actively manages the rental condominium. During 2012, his share of the loss from the limited partnership was...
-
a. Wilson filed his individual tax return on the original due date, but failed to pay $700 in taxes that were due with the return. If Wilson pays the taxes exactly 2 months late, calculate the amount...
-
What are the percentages of observations in each of the five job satisfaction categories?
-
If the 146 customer visits is used to estimate the number of appliance department visits at the larger store population, what are the lower and upper limits of this estimate?
-
How many individuals are in each of the five different credit card categories?
Study smarter with the SolutionInn App