Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SpeedThink
  • Content: Threads
  • Order by date
  1. SpeedThink

    SQL - Scalar and Aggregate data on same record

    Currently, I am using the following query to extract data from an Oracle database via a Hyperion (Brio) query: SELECT AL2.ACCT, AL3.ENCOUNTER_NO, trunc(AL3.ADMIT_DATE), trunc(AL3.DISCHARGE_DATE), AL3.DATE_BILLED, AL3.TOTAL_CHARGES, AL3.EXPECTED_REIMBURSEMENT, AL2.TOTAL_PAYMENTS...
  2. SpeedThink

    Oracle SQL - Computed Column via Subquery

    Currently, I have Oracle version 8.1.7 and have the following SQL that has not worked: Select pe.acct_no, pe.expected_reimbursement, pe.total_charges, ep.total_payments, pe.contract_no, pe.admit_date, pe.allowable, balance (computed), calculated_allowable(computed) from patient_encounter pe...
  3. SpeedThink

    Excel VBA - Worksheet Change

    Currently, I have an Excel Spreadsheet that I plan to populate via a MS Query that "pulls" data from an Oracle Database (version 8.1.7). In essence, the spreadsheet is setup to provide a "dynamic" Variance Report that will be used to monitor underpaid customer accounts. The report will be...
  4. SpeedThink

    Format Macro - Multiple Records per Account

    Upon using the text import wizard in Excel to import data from Oracle (FIXED WIDTH DELIMITED), the data is imported in two records,not one. Any clue as to a Excel macro that would "format" the records whereby there is just one line per record? Example...
  5. SpeedThink

    Matrix Report_Group by date

    Background: I am interested in creating a Matrix Report in SQLPlus that will result in a count of accounts for several contracts that had a particular diagnosis grouped by month not individual dates within the month from April 22, 2002 through August 11, 2002. Currently, I am thinking about...
  6. SpeedThink

    SQL Case Statement_Group dates by month!

    I am interested in creating a Matrix Report in SQLPlus that will result in a count of accounts for several contracts that had a particular diagnosis grouped by month not individual dates within the month from April 22, 2002 through August 11, 2002. Currently, I am thinking about doing this in...
  7. SpeedThink

    Selective VLookup

    I have the following: Invc----Line No---Cd Type---Rej1 Cd--Mod1 Cd 66095---18---------Pymt------------------------------- 66095---12---------Pymt--------ELI---------------------- 66095----1---------CH----------------------------26---- 66149---18---------Pymt--------IDER---------------------...
  8. SpeedThink

    Excel Function to selectively transpose data from column to row

    Currently, I have an Excel Worksheet with approximately 10000 records. Several records contain the same account number but different payment amounts and the corresponding payment dates as displayed below. Acct---Pymt Amt----Pymt Date---Date_1st Pymt---Amt_1st Pymt...
  9. SpeedThink

    Obtain Most Recent Pymt Date and Corresponding Pymt Amt

    Currently, I am using the following query with Brio Decision Support on an Oracle Database: SELECT DISTINCT AL2.CONTRACT_ID, AL3.ENCOUNTER_NO, trunc(AL3.ADMIT_DATE), AL3.DATE_BILLED, AL3.TOTAL_CHARGES, AL3.EXPECTED_REIMBURSEMENT, AL2.TOTAL_PAYMENTS, AL3.EXPECTED_REIMBURSEMENT -...
  10. SpeedThink

    VBA to copy range from one worksheet to another

    Currently, I select the current region of a worksheet ("source worksheet") by manually pressing "Shift" and the right arrow to select the data across columns then I press the down arrow. Finally, I copy the data to cell "B10" of another worksheet ("data worksheet"). The number of columns on my...
  11. SpeedThink

    Automatic Email and/or page someone conditional on value of cell/range

    I don't know if this is possible but I will ask: Is it possible to use VBA within Excel to "automatically" page someone on a daily or weekly basis if a cell or range on my worksheet exceeds a certain value? (Note, Lotus Notes have a paging feature whereby one can send a page to someone who is...
  12. SpeedThink

    Automatic File and Worksheet Naming

    Is anyone aware of a macro that will "automatically" name a worksheet and a file based on the contents that are typed within a range on my worksheet? I create a daily report by importing data from an Oracle application to an Excel Template. The data from the Oracle application is saved in a...
  13. SpeedThink

    Populating column based on multiple criteria

    I am working on a Excel Spreadsheet structured as follows: [Right]Invc No Chgs Code RejCd Invc w/Rej Sum_Invc [Right]'2815 $35 CH '2815 $35 CH '2815 $35 CH '2817 PY DED '2817 PY '2819 $500 CH...
  14. SpeedThink

    Creation of dynamic "calculated" column

    Currently, I am querying a Oracle Database with SQL similar to the following: select Enc No, Patient No, Contract Id, from patient_encounter, where admit_date is ... The result is as follows: Enc No Patient No Contract Id 9050068 125682 X59 I then export to Excel and insert...
  15. SpeedThink

    SQL Script Modification - Sysdate Manipulation

    Currently, my sql statements causes a encounter_no to populate my variance report when there is a Insurance Payor payment on today. When a encounter no shows on the variance report, the Revenue Collections area start to research the Variance to determine the reason for underpayment. However...
  16. SpeedThink

    I am in the process of setting up a

    I am in the process of setting up a Microsoft Access database to track underpayments on customer accounts. I have a voluminous set of information from an Oracle database, over 70,000 rows, that I imported into Access from Excel. Each and every month, there will be an additional 2000 to 5000...

Part and Inventory Search

Back
Top