AHRQ Ambulatory Surgery Center Survey on Patient Safety Culture Database, Supporting Statement A
Attachment E: Survey Data File Specifications
These specifications are for preparing your respondent-level data from the Ambulatory surgery center Survey on Patient Safety Culture. The instructions below tell you how to prepare your Excel data file for submission to the Ambulatory Surgery Center on Patient Safety Culture Database.
Step 1: Include a header row with the variable name for each column.
Step 2: Submit individual survey response data using the response values indicated in this document (beginning on page 4).
Step 3: Check your data before submitting for the following things:
SKIP PATTERN
There is one skip pattern in this survey. If a respondent answers 2 = No, to question GA, “Are you typically in the surgery/procedure room during surgeries, procedures, or treatments?”, then questions G1 – G3 should be blank.
OUT-OF-RANGE VALUES
You should clean your data before submitting to the database to ensure that there are no out-of-range values and that the data submitted are free from error. Make sure all response values match the response value for the question.
REVERSE CODED ITEMS
Do not submit reverse coded data on the survey’s negatively worded items—simply submit each individual’s unmodified responses to the survey items.
For example, survey item A5, “Key information about patients is missing when it is needed” is negatively worded. Regardless, the data should be submitted so that 1=Never and 5=Always, as originally indicated in the survey, as follows:
1=Never
2=Rarely
3=Sometimes
4=Most of the time
5=Always
9=Does Not Apply or Don’t Know
STAFF POSITIONS
If your ambulatory surgery center modified or added a new staff position (H1) category, you MUST RECODE your specific staff positions back to the survey’s original staff position category. If you added staff positions that do not match any of the survey’s original staff positions, re-code your specific staff positions as “OTHER” (H1 = “j”), before submitting your data.
OTHER, PLEASE SPECIFY TEXT
Do not include Other-Please Specify data and comments (question H1 and Section I). While you may find it useful to review this text, it should not be submitted to the Database.
SPANISH VERSION OF THE SURVEY
Please indicate which respondents (if any) completed a Spanish version of the safety culture survey, if you have this information available. You should do so by adding an ‘S’ to the Individual Unique Record ID, e.g. 001S.
OTHER LANGUAGE VERSION OF THE SURVEY
Please indicate which respondents (if any) completed the safety culture survey in a language that was not English or Spanish, if you have this information available. You should do so by adding an ‘N’ to the Individual Unique Record ID (UNIQUEID), e.g. 001N.
Record Identifier |
Variable Name |
Column Position |
Response Values |
Site ID |
SITEID |
Column A |
5 digits or less |
Individual Unique Record ID |
UNIQUEID |
Column B |
4 digits or less |
Survey Question |
Variable Name |
Column Position |
Response Values |
|
A1 |
Column C |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A2 |
Column D |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A3 |
Column E |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A4 |
Column F |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A5 |
Column G |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A6 |
Column H |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A7 |
Column I |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A8 |
Column J |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A9 |
Column K |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
A10 |
Column L |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
Survey Question |
Variable Name |
Column Position |
Response Values |
|
|
B1 |
Column M |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
|
B2 |
Column N |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
|
B3 |
Column O |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
|
B4 |
Column P |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
|
B5 |
Column Q |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
|
B6 |
Column R |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
|
B7 |
Column S |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
|
B8 |
Column T |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
Survey Question |
Variable Name |
Column Position |
Response Values |
|
C1 |
Column U |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
C2 |
Column V |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
C3 |
Column W |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
C4 |
Column X |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
C5 |
Column Y |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
|
C6 |
Column Z |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing |
Survey Question |
Variable Name |
Column Position |
Response Values |
|
D1 |
Column AA |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
Survey Question |
Variable Name |
Column Position |
Response Values |
|
E1 |
Column AB |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing or properly skipped |
|
E2 |
Column AC |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing or properly skipped |
|
E3 |
Column AD |
1 = Strongly Disagree 2 = Disagree 3 = Neither Agree nor Disagree 4 = Agree 5 = Strongly Agree 9 = Does Not Apply or Don’t Know blank = Missing or properly skipped |
Survey Question |
Variable Name |
Column Position |
Response Values |
|
F1 |
Column AE |
1 = Poor 2 = Fair 3 = Good 4 = Very good 5 = Excellent blank = Missing |
Survey Question |
Variable Name |
Column Position |
Response Values |
A. Are you typically in the surgery/procedure room during surgeries, procedures, or treatments? |
GA |
Column AF |
1 = Yes 2 = No blank = Missing |
If question GA (Column AF) = 2 (No) then skip to section H. |
|||
|
G1 |
Column AG |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
G2 |
Column AH |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
|
G3 |
Column AI |
1 = Never 2 = Rarely 3 = Sometimes 4 = Most of the time 5 = Always 9 = Does Not Apply or Don’t Know blank = Missing |
Survey Question |
Variable Name |
Column Position |
Response Values |
|
H1 |
Column AJ |
a = Anesthesiologist b = Doctor/Physician (excluding Anesthisiologists) or Surgeon c = Certified Registered Nurse Anesthetist (CRNA) d = Physician Assistant or Nurse Practitioner e = Managemnet f = Nurse g = Technician h = Other Clinical Staff or Clinical Support Staff i = Administrative, Clerical, or Business Staff j = Other Position blank = Missing |
TEXT FOR OTHER, SPECIFY [H1jos]* - DO NOT SUBMIT TO DATABASE |
|||
|
H2 |
Column AK |
a = 1 to 16 hours per week b = 17 to 31 hours per week c = 32 to 40 hours per week d = More than 40 hours per week blank = Missing |
TEXT FOR YOUR COMMENTS [Section I]* - DO NOT SUBMIT TO DATABASE
Two examples of SECTION G: Communication in the Surgery/Procedure Room questions are displayed below. Columns C - AE are omitted for display purposes.
Example 1: Are you typically in the surgery/procedure room during surgeries, procedures, or treatments?
1=Yes
2=No
G1 through G3 are left blank because GA is 2 (No).
Example 2: Are you typically in the surgery/procedure room during surgeries, procedures, or treatments?
1=Yes
2=No
G1 through G3 are filled in because GA was 1 (Yes).
ASC - 1117
File Type | application/vnd.openxmlformats-officedocument.wordprocessingml.document |
File Title | AHRQ Medical Office Survey on Patient Safety Culture Data File Layout |
Author | ragan_m |
File Modified | 0000-00-00 |
File Created | 2021-01-20 |