Programmer-Peer Audit output problem table

audit	Location	Collector	Date sent	Loc audited	TMPV2_1.mdb	TMPV2_1_audit.mdb	TASK.mdb	TASK_audit.mdb	Pending.mdb	comments
ICU_111	STBMICU	Laura	17_Nov_2009	STB_CICU	NA	NA	NA	NA	no
ICU_111	STBMICU	Laura	24_Nov_2009	STB_MICU should be STB_CCU	yes-should not be in here.	NA	NA	NA	yes-in MICU	serial number that are non audit number sent to TMPV2.audit. Mdb. ICU no audits of special project so no data should go TMPV2 audit.
ICU_111	STBSICU	Joyce	25_Nov_2009	HSC_MICU	YES (sicu)		NA	NA	Yes -in MICU
Med_111	HSCB3	Pat	25_Nov_2009	HSC_H4	NO	None. no move so Ok	yes	yes	YES in B3
Med_111	HSCH4	Gail	23_Nov_2009	HSC_A4	No	YES	yes	yes	YES
Med_111	GRA_N5	Marylou	24_Nov_2009	GRA_N5 should be GRA_N3	YES_N5	missing	missing	missing	Yes in N3 because of location error	ML sent audit 111 with regular csv

• Location used for audit number incorrect - 2 sites (STB x1 & GRA x1) (likely because set to default location and forgot to change for audit file.
• Audit file sent with regular CSV batch - 1 site (GRA N5)
• Pending.mdb - should not include any audit file numbers
• TmpV2_1.mdb - should not any include audit file numbers. 2 sites (GRA_N5 & HSC SICU). Grace - reason below.
• TASK-audit.mdb - missing data - one site. Reason: audit file was included and sent with regular CSV batch.
• TmpV2_1_audit.mdb - missing move - 1 site (GRA N5). Reason: audit file was included and sent with regular CSV batch.
• TmpV2_1_audit.mdb - should not include any NON audit serial numbers (STB_MICU).
  • --TOstryzniuk 19:54, 26 November 2009 (CST)