Pinnacle_Signature_Import

130 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TableID int identity 4 √ null
Agency varchar 150 √ null
Sample_Month int 4 √ null
Sample_Year int 4 √ null
Complete int 4 √ null
First_Name varchar 50 √ null
Middle_Initial varchar 5 √ null
Last_Name varchar 50 √ null
MRN varchar 50 √ null
Received_Care varchar 50 √ null
Services_Explained varchar 50 √ null
Home_Safety varchar 50 √ null
Medication_Discussion varchar 50 √ null
See_Medication varchar 50 √ null
Nurse varchar 50 √ null
Therapist varchar 50 √ null
Aide varchar 50 √ null
Providers_Informed varchar 50 √ null
Pain_Discussion varchar 50 √ null
Change_Medication varchar 50 √ null
New_Meds_Purpose varchar 50 √ null
New_Meds_Times varchar 50 √ null
New_Meds_Side_Effects varchar 50 √ null
Arrival_Communication varchar 50 √ null
Gentleness varchar 50 √ null
Understand_Explanation varchar 50 √ null
Listening varchar 50 √ null
Courtesy_and_Respect varchar 50 √ null
Overall_Care varchar 50 √ null
Contact_Office varchar 50 √ null
Received_Help varchar 50 √ null
Help_Response varchar 50 √ null
Care_Problems varchar 50 √ null
Recommend_to_Others varchar 50 √ null
Share_Information varchar 50 √ null
Proxy_Respondent varchar 1000 √ null
Areas_Appreciated varchar 1000 √ null
Staff_Member_Appreciated varchar 1000 √ null
Recommended_Improvements varchar 1000 √ null
Heard_About varchar 1000 √ null
Benefit varchar 1000 √ null
Company varchar 100 √ null
CreatedDate datetime 16,3 √ (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK__Pinnacle__7D5F018ED11F9658 Primary key Asc TableID

Diagram producer might be missing

No diagrams were produced please see application output for any errors