About
This report is used to view a patient's Portal Account status found in OP. The following are the value definitions found in the IC_ACCOUNT column.
- 0=Inactive Portal Status.
- 1=Active Portal Status.
- Blank=Patients whose status is unknown, the patient account has not been refreshed.
A sample image of this SQL report run in the Database Viewer is shown below:
Code
To highlight and copy the code below to your clipboard, simply click the Copy button.
Select PATNO, FNAME, LNAME, STATUS_PAT, IC_ACCOUNT_ACTIVE FROM REGISTER WHERE STATUS_PAT = 'ACTIVE'
