Provider Detail With Address

Posted on By David Kittell 
SELECT firstname
	,lastname
	,prov_nbr
	,npi
	,address1
	,city
	,STATE
	,zip
FROM provider
	,address
WHERE addr_who = 'P ' || prov_nbr
	AND ymdeff <= to_char(sysdate, 'yyyymmdd')
	AND ymdend >= to_char(sysdate, 'yyyymmdd')
	AND void <> 'Y'
	AND substr(addrtype_who, 1, 1) = 'D'
	AND prov_nbr = '<Provider Number>';
Originally Posted on September 16, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Amisys Code Oracle SQL

Related Posts

UNIX – Laptop Setup

Posted on

This is my basic setup for a laptop/desktop that I have for my family to use. Debian Based Should work on Debian, Ubuntu (all Ubuntu flavors) sudo apt-get –assume-yes install ntp sudo timedatectl set-timezone America/Detroit sudo service ntp stop sudo ntpdate us.pool.ntp.org sudo service ntp start echo nameserver 208.67.222.123 >…

Read More

Open On Screen Keyboard (OSK)

Posted on

In order for this to work you need to follow these steps Go to “Project”, Select “ Properties…” Click on “Compile”, At the bottom of the screen click on “Advanced Compile Options…” Change “Target CPU:” to “AnyCPU” and click “OK” Public Class Form1 Private oskProcess As System.Diagnostics.Process Private Sub Button1_Click_1(ByVal…

Read More

C# ASPX Phone Number Validation

Posted on

<asp:TextBox ID="RequestorPhone" runat="server" MaxLength="20" /> <asp:RequiredFieldValidator runat="server" ControlToValidate="RequestorPhone" Display="Dynamic" ErrorMessage="Phone # is required" /> <asp:RegularExpressionValidator ID="revPhone" runat="server" ControlToValidate="RequestorPhone" Display="Dynamic" ErrorMessage="Phone # is invalid" ValidationExpression="^(?:(?:+?1s*(?:[.-]s*)?)?(?:(s*([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9])s*)|([2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9]))s*(?:[.-]s*)?)?([2-9]1[02-9]|[2-9][02-9]1|[2-9][02-9]{2})s*(?:[.-]s*)?([0-9]{4})(?:s*(?:#|x.?|ext.?|extension)s*(d+))?$" /> Credit: fatcat1111 @ stackoverflow.com Originally Posted on January 9, 2015Last Updated on October 26, 2015 All information on this site is shared with the intention…

Read More