USE oncochart

CREATE TABLE tblImpac_ImportStatus(
	lngImportStatusID int IDENTITY(1,1) NOT NULL,
	dteAdmDept_Attempt datetime NULL,
	blnAdmDept_Success bit NULL,
	dteAdmin_Attempt datetime NULL,
	blnAdmin_Success bit NULL,
	dteDose_Hst_Attempt datetime NULL,
	blnDose_Hst_Success bit NULL,
	dteFld_Hst_Attempt datetime NULL,
	blnFld_Hst_Success bit NULL,
	dtePatient_Attempt datetime NULL,
	blnPatient_Success bit NULL,
	dteIdent_Attempt datetime NULL,
	blnIdent_Success bit NULL,
	dteMachine_Attempt datetime NULL,
	blnMachine_Success bit NULL,
	dteStaff_Attempt datetime NULL,
	blnStaff_Success bit NULL,
	dteSite_Attempt datetime NULL,
	blnSite_Success bit NULL,
	dteTxField_Attempt datetime NULL,
	blnTxField_Success bit NULL,
	blnEmailSent bit NULL
)

