Research Article

Evaluation of the Effect of Comprehensive and Targeted Surveillance on Nosocomial Infections in Nephrology Patients

Table 2

Patient’s medical order information form.

Serial numberColumn nameType of dataLengthAllow emptyInstruction

1ZYIDVaechar50NOT NULLUnique ID number for hospitalization
2Patient idVaechar50NOT NULLHospital number
3Visit idInt8Number of hospitalizations
4nameVaechar50NOT NULLName
5FlagInt4Long testimony
6Start dateDatetime8Open date
7Stop dateDatetime8Date of suspension
8Order daysNumeric8Days of medication
9Order classVaechar50Medical order item classification name
10Order codeVaechar16NOT NULLOrder number
11Order nameVaechar200NOT NULLName of doctor’s order
12Order speciVaechar50Drug specifications
13YCJLNumeric8Dose
14Dosage unitsVaechar20unit
15YCSLNumeric8Quantity
16SYPCVaechar50Frequency of use
17UsemaediwayVaechar50Purpose of administration
18UspurposeVaechar50unit price
19YPDJNumeric8Remark
20Order memoVaechar100Times per day
21MRCSInt1Daily dosage
22Qty dayNumeric8Total amount
23Qty sumNumeric8Executive department number
24Execoffice codeVaechar20NOT NULLExecutive department name
25Execoffice nameVaechar50NOT NULLPrescribe doctor number
26Bdoctor codeVaechar20Name of prescribing doctor
27Bdoctor nameVaechar20Stop ordering doctor number
28Edoctor codeVaechar20Name of doctor who stopped advising
29Edoctor nameVaechar20Antibacterial drugs
30Flag kjywbit1Antibacterial drugs