V_PatientInformation
The V_PatientInformation view displays basic patient information that is recorded in the patient profile in AcuityLogic POS. The view contains the following data:
| Column Heading | Unique to SQL Database | Description | 
|---|---|---|
| 
                                                             ID  | 
                                                        
                                                             Y  | 
                                                        
                                                             This ID is unique to the V_PatientInformation view, and can be linked to the PatientID to access additional patient information, if needed.  | 
                                                    
| 
                                                             FirstName  | 
                                                        
                                                             
  | 
                                                        
                                                             Patient’s first name.  | 
                                                    
| 
                                                             LastName  | 
                                                        
                                                             
  | 
                                                        
                                                             Patient’s last name.  | 
                                                    
| 
                                                             DOB  | 
                                                        
                                                             
  | 
                                                        
                                                             Patient’s date of birth.  | 
                                                    
| 
                                                             Address1  | 
                                                        
                                                             
  | 
                                                        
                                                             Patient’s address.  | 
                                                    
Here is an example of the V_PatientInformation view imported into a spreadsheet: