OR_LOG_2

Description:

The OR_LOG_2 table contains OR management system log records.

Primary Key

Column Name	Ordinal Position
LOG_ID	1

Column Information

	Name	Type	Discontinued?
1	LOG_ID	VARCHAR	No
	The unique ID of the surgical log record.
2	SURGICAL_RISK_C_NAME	VARCHAR	No
	This column contains the category level of the surgical risk in the log record. May contain organization-specific values: Yes No Entries Defined
3	POTENTL_BLOODLOSS_C_NAME	VARCHAR	No
	This column contains the category level of the potential blood loss in the log record. May contain organization-specific values: Yes No Entries Defined
4	AWARENESS_DT	DATETIME	No
	This column contains the date the patient was made aware of the surgery in the log record.
5	VIDEO_PIC_TAKEN_YN	VARCHAR	No
	Indicates whether a video or picture was taken for this log. Y indicates that a video or picture was taken, and N indicates that a video or picture was not taken. May contain organization-specific values: No Category Entries: No Yes
6	VIDEO_PIC_DISP_C_NAME	VARCHAR	No
	The disposition category number for the picture or video taken in the log. May contain organization-specific values: Yes No Entries Defined
7	OB_CSECT_TYPE_C_NAME	VARCHAR	No
	The category number for the c-section type as recorded in the surgical log. May contain organization-specific values: Yes
8	PREOP_HOLD_LOC_C_NAME	VARCHAR	No
	Stores the location where the patient is being held in preop holding. May contain organization-specific values: Yes No Entries Defined
9	NO_COUNT_NEEDED_YN	VARCHAR	No
	This item marks the log/procedure as a no counts needed log. May contain organization-specific values: No Category Entries: Counts not needed Counts needed
10	INTRAOP_XRAYS_CMT	VARCHAR	No
	This column displays the comment about intraop x-ray needs.
11	IOP_XRAYS_C_NAME	VARCHAR	No
	The intraop x-rays needed category ID for the log record. May contain organization-specific values: Yes Category Entries: Yes No
12	ARE_PROPH_AB_REQ_C_NAME	VARCHAR	No
	The prophylactic antibiotics required category ID for the log record. May contain organization-specific values: Yes Category Entries: Yes No
13	CHARGE_BILL_AREA_ID	NUMERIC	No
	The bill area with which log charges should be associated. This is used for cost center routing.
14	CHARGE_BILL_AREA_ID_BILL_AREA_NAME	VARCHAR	No
	The record name of this bill area, financial subdivision, or financial division.
15	RSN_RETURN_OR_C_NAME	VARCHAR	No
	The reason a patient is returned to the OR. May contain organization-specific values: Yes No Entries Defined
16	NHSN_SPINAL_LEVEL_C_NAME	VARCHAR	No
	Stores the NHSN spinal level. The category list is the standard list of spinal levels released by NHSN. May contain organization-specific values: Yes Category Entries: A - Atlas-axis AC - Atlas-axis/Cervical C - Cervical CD - Cervical/Dorsal/Dorsolumbar D – Dorsal/Dorsolumbar L – Lumbar/Lumbosacral
17	HOLDING_BED_ID	VARCHAR	No
	Stores the bed record for the patient when in the Holding phase.
18	HOLDING_BED_ID_BED_LABEL	VARCHAR	No
	The name of the bed.
19	SPEC_NOT_REQUIRED_YN	VARCHAR	No
	Specimens were not required for this procedure. The category values for this column were already listed for column: VIDEO_PIC_TAKEN_YN
20	RAD_DAP_UNIT_C_NAME	VARCHAR	No
	Documents the unit for Dose Area Product (DAP) in the radiation tracking event for the current log. May contain organization-specific values: Yes Category Entries: mL L mg g Units mmol mEq mcg % Int'l Units Million Units kcal ng mg PE milli-units pg KBq MBq GBq mcL mL/min L/min mg/min g/min Units/min mmol/min mEq/min mcg/min kJ/min Int'l Units/min Million Units/min kcal/min ng/min mg PE/min milli-units/min pg/min KBq/min MBq/min GBq/min mcL/min mL/hr L/hr mg/hr g/hr Units/hr mmol/hr mEq/hr mcg/hr kJ/hr Int'l Units/hr Million Units/hr kcal/hr ng/hr mg PE/hr milli-units/hr pg/hr KBq/hr MBq/hr GBq/hr mcL/hr mL/day L/day mg/day g/day Units/day mmol/day mEq/day mcg/day kJ/day Int'l Units/day Million Units/day kcal/day ng/day mg PE/day milli-units/day pg/day Inch/day KBq/day MBq/day GBq/day mcL/day IR/day BAU/day PFU/day Million PFU/day Million Int'l Units/day Kilo Int'l Units/day EIN/day Million EIN/day mL/kg L/kg mg/kg g/kg Units/kg mmol/kg mEq/kg mcg/kg kJ/kg Int'l Units/kg Million Units/kg kcal/kg ng/kg mg PE/kg milli-units/kg pg/kg mg/kg (Actual) Each/kg Puff/kg Package/kg Drop/kg Inch/kg KBq/kg MBq/kg GBq/kg mcL/kg IR/kg BAU/kg Million Int'l Units/kg mcmol/kg 1e12 Vector Genomes/kg Vector Genomes/kg Dose/kg mcg DFE/kg Kilo Int'l Units/kg 1e11 Vector Genomes/kg 1e13 Vector Genomes/kg 1e14 Vector Genomes/kg 1e15 Vector Genomes/kg EIN/kg IR/min BAU/min Million Int'l Units/min Kilo Int'l Units/min IR/hr BAU/hr Million Int'l Units/hr Kilo Int'l Units/hr mL/mL L/mL mg/mL g/mL Units/mL mmol/mL mEq/mL mcg/mL kJ/mL Int'l Units/mL Million Units/mL kcal/mL ng/mL mg PE/mL milli-units/mL pg/mL KBq/mL MBq/mL GBq/mL mcL/mL IR/mL BAU/mL PFU/mL Million PFU/mL Million Int'l Units/mL mcmol/mL 1e12 Vector Genomes/mL Vector Genomes/mL Kilo Int'l Units/mL 1e11 Vector Genomes/mL 1e13 Vector Genomes/mL 1e14 Vector Genomes/mL 1e15 Vector Genomes/mL millicurie/mL mL/L L/L mg/L g/L Units/L mmol/L mEq/L mcg/L kJ/L Int'l Units/L Million Units/L kcal/L ng/L mg PE/L milli-units/L pg/L KBq/L MBq/L GBq/L mcL/L IR/L BAU/L Million Int'l Units/L Kilo Int'l Units/L mL/m2 L/m2 mg/m2 g/m2 Units/m2 mmol/m2 mEq/m2 mcg/m2 kJ/m2 Int'l Units/m2 Million Units/m2 kcal/m2 ng/m2 mg PE/m2 milli-units/m2 pg/m2 mg/m2 (Actual) Each/m2 Puff/m2 Package/m2 Drop/m2 KBq/m2 MBq/m2 GBq/m2 mcL/m2 IR/m2 BAU/m2 Million Int'l Units/m2 mcmol/m2 1e12 Vector Genomes/m2 Vector Genomes/m2 Kilo Int'l Units/m2 1e11 Vector Genomes/m2 1e13 Vector Genomes/m2 1e14 Vector Genomes/m2 1e15 Vector Genomes/m2 mL/1.7m2 L/1.7m2 mg/1.7m2 g/1.7m2 Units/1.7m2 mmol/1.7m2 mEq/1.7m2 mcg/1.7m2 kJ/1.7m2 Int'l Units/1.7m2 Million Units/1.7m2 kcal/1.7m2 ng/1.7m2 mg PE/1.7m2 milli-units/1.7m2 pg/1.7m2 Each/1.7m2 KBq/1.7m2 MBq/1.7m2 GBq/1.7m2 mcL/1.7m2 IR/1.7m2 BAU/1.7m2 Million Int'l Units/1.7m2 Kilo Int'l Units/1.7m2 mL/kg (IDL) L/kg (IDL) mg/kg (IDL) g/kg (IDL) Units/kg (IDL) mmol/kg (IDL) mEq/kg (IDL) mcg/kg (IDL) Int'l Units/kg (IDL) Million Units/kg (IDL) Kcal/kg (IDL) ng/kg (IDL) mg PE/kg (IDL) milli-units/kg (IDL) pg/kg (IDL) mg/m2 (IDL) mL/kg (ADJ) L/kg (ADJ) mg/kg (ADJ) g/kg (ADJ) Units/kg (ADJ) mmol/kg (ADJ) mEq/kg (ADJ) mcg/kg (ADJ) Int'l Units/kg (ADJ) Million Units/kg (ADJ) Kcal/kg (ADJ) ng/kg (ADJ) mg PE/kg (ADJ) milli-units/kg (ADJ) pg/kg (ADJ) mg/m2 (ADJ) mL/100 mL L/100 mL mg/100 mL g/100 mL Units/100 mL mmol/100 mL mEq/100 mL mcg/100 mL kJ/100 mL Int'l Units/100 mL Million Units/100 mL kcal/100 mL ng/100 mL mg PE/100 mL milli-units/100 mL pg/100 mL KBq/100 mL MBq/100 mL GBq/100 mL mcL/100 mL IR/100 mL BAU/100 mL Million Int'l Units/100 mL Kilo Int'l Units/100 mL mL/oz L/oz mg/oz g/oz Units/oz mmol/oz mEq/oz mcg/oz kJ/oz Int'l Units/oz Million Units/oz kcal/oz ng/oz mg PE/oz milli-units/oz pg/oz KBq/oz MBq/oz GBq/oz mcL/oz IR/oz BAU/oz Million Int'l Units/oz Kilo Int'l Units/oz mL/kg/min L/kg/min mg/kg/min g/kg/min Units/kg/min mmol/kg/min mEq/kg/min mcg/kg/min kJ/kg/min Int'l Units/kg/min Million Units/kg/min kcal/kg/min ng/kg/min mg PE/kg/min milli-units/kg/min pg/kg/min KBq/kg/min MBq/kg/min GBq/kg/min mcL/kg/min mL/kg/min (IDL) L/kg/min (IDL) mg/kg/min (IDL) g/kg/min (IDL) Units/kg/min (IDL) mmol/kg/min (IDL) mEq/kg/min (IDL) mcg/kg/min (IDL) Int'l Units/kg/min (IDL) Million Units/kg/min (IDL) Kcal/kg/min (IDL) ng/kg/min (IDL) mg PE/kg/min (IDL) milli-units/kg/min (IDL) pg/kg/min (IDL) mL/kg/min (ADJ) L/kg/min (ADJ) mg/kg/min (ADJ) g/kg/min (ADJ) Units/kg/min (ADJ) mmol/kg/min (ADJ) mEq/kg/min (ADJ) mcg/kg/min (ADJ) Int'l Units/kg/min (ADJ) Million Units/kg/min (ADJ) Kcal/kg/min (ADJ) ng/kg/min (ADJ) mg PE/kg/min (ADJ) milli-units/kg/min (ADJ) pg/kg/min (ADJ) IR/kg/min BAU/kg/min Million Int'l Units/kg/min Kilo Int'l Units/kg/min mL/m2/min L/m2/min mg/m2/min g/m2/min Units/m2/min mmol/m2/min mEq/m2/min mcg/m2/min kJ/m2/min Int'l Units/m2/min Million Units/m2/min kcal/m2/min ng/m2/min mg PE/m2/min milli-units/m2/min pg/m2/min KBq/m2/min MBq/m2/min GBq/m2/min mcL/m2/min mL/1.7m2/min L/1.7m2/min mg/1.7m2/min g/1.7m2/min Units/1.7m2/min mmol/1.7m2/min mEq/1.7m2/min mcg/1.7m2/min kJ/1.7m2/min Int'l Units/1.7m2/min Million Units/1.7m2/min kcal/1.7m2/min ng/1.7m2/min mg PE/1.7m2/min milli-units/1.7m2/min pg/1.7m2/min KBq/1.7m2/min MBq/1.7m2/min GBq/1.7m2/min mSv mGy mcL/1.7m2/min mcSv Sv mcGy cGy Gy mRAD RAD mg of pseudoephedrine mg of ephedrine IR/m2/min BAU/m2/min Million Int'l Units/m2/min Kilo Int'l Units/m2/min IR/1.7m2/min BAU/1.7m2/min Million Int'l Units/1.7m2/min Kilo Int'l Units/1.7m2/min mL/kg/hr L/kg/hr mg/kg/hr g/kg/hr Units/kg/hr mmol/kg/hr mEq/kg/hr mcg/kg/hr kJ/kg/hr Int'l Units/kg/hr Million Units/kg/hr kcal/kg/hr ng/kg/hr mg PE/kg/hr milli-units/kg/hr pg/kg/hr KBq/kg/hr MBq/kg/hr GBq/kg/hr mcL/kg/hr mL/kg/hr (IDL) L/kg/hr (IDL) mg/kg/hr (IDL) g/kg/hr (IDL) Units/kg/hr (IDL) mmol/kg/hr (IDL) mEq/kg/hr (IDL) mcg/kg/hr (IDL) Int'l Units/kg/hr (IDL) Million Units/kg/hr (IDL) Kcal/kg/hr (IDL) ng/kg/hr (IDL) mg PE/kg/hr (IDL) milli-units/kg/hr (IDL) pg/kg/hr (IDL) mL/kg/hr (ADJ) L/kg/hr (ADJ) mg/kg/hr (ADJ) g/kg/hr (ADJ) Units/kg/hr (ADJ) mmol/kg/hr (ADJ) mEq/kg/hr (ADJ) mcg/kg/hr (ADJ) Int'l Units/kg/hr (ADJ) Million Units/kg/hr (ADJ) Kcal/kg/hr (ADJ) ng/kg/hr (ADJ) mg PE/kg/hr (ADJ) milli-units/kg/hr (ADJ) pg/kg/hr (ADJ) IR/kg/hr BAU/kg/hr Million Int'l Units/kg/hr Kilo Int'l Units/kg/hr mL/m2/hr L/m2/hr mg/m2/hr g/m2/hr Units/m2/hr mmol/m2/hr mEq/m2/hr mcg/m2/hr kJ/m2/hr Int'l Units/m2/hr Million Units/m2/hr kcal/m2/hr ng/m2/hr mg PE/m2/hr milli-units/m2/hr pg/m2/hr KBq/m2/hr MBq/m2/hr GBq/m2/hr mcL/m2/hr mL/1.7m2/hr L/1.7m2/hr mg/1.7m2/hr g/1.7m2/hr Units/1.7m2/hr mmol/1.7m2/hr mEq/1.7m2/hr mcg/1.7m2/hr kJ/1.7m2/hr Int'l Units/1.7m2/hr Million Units/1.7m2/hr kcal/1.7m2/hr ng/1.7m2/hr mg PE/1.7m2/hr milli-units/1.7m2/hr pg/1.7m2/hr KBq/1.7m2/hr MBq/1.7m2/hr GBq/1.7m2/hr mcL/1.7m2/hr IR/1.7m2/hr BAU/1.7m2/hr Million Int'l Units/1.7m2/hr Kilo Int'l Units/1.7m2/hr IR/m2/hr BAU/m2/hr Million Int'l Units/m2/hr Kilo Int'l Units/m2/hr mL/kg/day L/kg/day mg/kg/day g/kg/day Units/kg/day mmol/kg/day mEq/kg/day mcg/kg/day kJ/kg/day Int'l Units/kg/day Million Units/kg/day kcal/kg/day ng/kg/day mg PE/kg/day milli-units/kg/day pg/kg/day Inch/kg/day KBq/kg/day MBq/kg/day GBq/kg/day mL/kg/day (IDL) L/kg/day (IDL) mg/kg/day (IDL) g/kg/day (IDL) Units/kg/day (IDL) mmol/kg/day (IDL) mEq/kg/day (IDL) mcg/kg/day (IDL) Int'l Units/kg/day (IDL) Million Units/kg/day (IDL) Kcal/kg/day (IDL) ng/kg/day (IDL) mg PE/kg/day (IDL) milli-units/kg/day (IDL) pg/kg/day (IDL) mL/kg/day (ADJ) L/kg/day (ADJ) mg/kg/day (ADJ) g/kg/day (ADJ) Units/kg/day (ADJ) mmol/kg/day (ADJ) mEq/kg/day (ADJ) mcg/kg/day (ADJ) Int'l Units/kg/day (ADJ) Million Units/kg/day (ADJ) Kcal/kg/day (ADJ) ng/kg/day (ADJ) mg PE/kg/day (ADJ) milli-units/kg/day (ADJ) pg/kg/day (ADJ) mcL/kg/day IR/kg/day BAU/kg/day Million Int'l Units/kg/day mL/m2/day L/m2/day mg/m2/day g/m2/day Units/m2/day mmol/m2/day mEq/m2/day mcg/m2/day kJ/m2/day Int'l Units/m2/day Million Units/m2/day kcal/m2/day ng/m2/day mg PE/m2/day milli-units/m2/day pg/m2/day KBq/m2/day MBq/m2/day GBq/m2/day mcL/m2/day mL/1.7m2/day L/1.7m2/day mg/1.7m2/day g/1.7m2/day Units/1.7m2/day mmol/1.7m2/day mEq/1.7m2/day mcg/1.7m2/day kJ/1.7m2/day Int'l Units/1.7m2/day Million Units/1.7m2/day kcal/1.7m2/day ng/1.7m2/day mg PE/1.7m2/day milli-units/1.7m2/day pg/1.7m2/day KBq/1.7m2/day MBq/1.7m2/day GBq/1.7m2/day mcL/1.7m2/day mL/oz/day L/oz/day mg/oz/day g/oz/day Units/oz/day mmol/oz/day mEq/oz/day mcg/oz/day kJ/oz/day Int'l Units/oz/day Million Units/oz/day kcal/oz/day ng/oz/day mg PE/oz/day milli-units/oz/day pg/oz/day KBq/oz/day MBq/oz/day GBq/oz/day mcL/oz/day IR/m2/day BAU/m2/day Million Int'l Units/m2/day Kilo Int'l Units/m2/day IR/1.7m2/day BAU/1.7m2/day Million Int'l Units/1.7m2/day Kilo Int'l Units/1.7m2/day IR/oz/day BAU/oz/day Million Int'l Units/oz/day Kilo Int'l Units/oz/day kJ/30 mL kcal/30 mL Gy-cm2 mcGy-cm2 mGy-cm2 cGy-cm2 dGy-cm2 mcGy-m2 mGy-m2 cGy-m2 dGy-m2 Gy-m2 mRAD-cm2 RAD-cm2 mL/cm2 mg/cm2 mOsmol each tablet capsule drop tsp puff suppository spray Squirt inch patch Act ampule Bar Bottle Can Device enema Gallon Inhaler kit lb lozenge oz packet Stick strip Tbsp Tube vial Wafer Container Syringe Package applicator cm Applicatorful Troche millicurie Intra Uterine Device Part m Film Million Cells Dose mm IR BAU kg cm2 Imperial Gallon kJ PFU Piece Million PFU Doses/Fill Cartridge Thousand Units Lipoprotein Lipase Releasing Unit Scoop Million Int'l Units mm2 Pump fluid ounce Product Bag mcmol 1e12 Vector Genomes Vector Genomes millicurie/kg millicurie/m2 millicurie/1.7m2 microcurie microcurie/kg microcurie/m2 microcurie/1.7m2 Canister mcg DFE Billion Cells Application Box Capful Inhalation Lancet Needle Pad Pen Piece of gum Ring Swab Sachet Implant Insert Pools Kilo Int'l Units Kilo Int'l Units/kg/day 1e11 Vector Genomes 1e13 Vector Genomes 1e14 Vector Genomes 1e15 Vector Genomes Cells EIN Million EIN EIN/kg/day mGy-cm cGy-cm dGy-cm Gy-cm mGy-m cGy-m dGy-m Gy-m Hounsfield Units None / Other
21	RETURN_TO_OR_TYPE_C_NAME	VARCHAR	No
	The category ID for the return to OR type. It indicates how the log relates to the past case. May contain organization-specific values: Yes Category Entries: Unrelated Case Planned Staged Return Planned Return Due to Complications Unplanned Return
22	RETURN_TO_OR_ORIGINAL_CASE_ID	VARCHAR	No
	The unique ID of the case which is responsible for this log's return to OR.
23	RETURN_TO_OR_REASON_C_NAME	VARCHAR	No
	The category ID for the return to OR reason. It further indicates how the log relates to the past case. May contain organization-specific values: Yes Category Entries: Follow up evaluation procedure Continuation of care Secondary procedure Continuing care of wound Support device maintenance/removal Anastomotic complication Complications post arthroplasty Complications post device/prosthetic placement Peritonitis Postoperative hemorrhage/hematoma evacuation Postoperative wound dehiscence Retrieval of retained surgical item Small bowel obstruction Vascular complication Wound complications or surgical site infection Other (comment)
24	RETURN_TO_OR_REASON_CMT	VARCHAR	No
	The comments specific to the return to OR reason. Entered by the user who documented the log as return to OR or a user who verified the return to OR documentation.
25	RETURN_TO_OR_VERIFIED_BY_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
26	RETURN_TO_OR_ADDL_CMT	VARCHAR	No
	Additional comments for the return to OR. Entered by the user who documented the log as return to OR or a user who verified the return to OR documentation.
27	RETURN_TO_OR_SUR_AGREE_YN	VARCHAR	No
	Indicates whether the surgeon of the original case agrees or disagrees with the return to OR documentation. The category values for this column were already listed for column: VIDEO_PIC_TAKEN_YN
28	RETURN_TO_OR_REV_STAT_C_NAME	VARCHAR	No
	The category ID for the return to OR review status. The status reflects the compliance from the original case's surgeon with reviewing the Return to OR documentation. May contain organization-specific values: No Category Entries: NOT MESSAGED MESSAGE SENT ESCALATION SENT AUTO AGREEMENT MANUAL AGREEMENT MANUAL DISAGREEMENT
29	CASE_CLASS_APPROPRIATE_C_NAME	VARCHAR	No
	This item stores whether or not the case classification is appropriate. May contain organization-specific values: Yes Category Entries: Yes No
30	REOPERATION_C_NAME	VARCHAR	No
	Indicates whether this surgical log is a re-operation. Y indicates that the surgical log is a re-operation. N or N/A indicates the surgical log is not a re-operation. May contain organization-specific values: No Category Entries: No (Old) Yes (Old) N/A (Old) Yes No N/A
31	PREVIOUS_OPERATION_DATE	DATETIME	No
	The date when a previous procedure associated with this surgical log was performed.
32	IMPLANT_APPROACH_C_NAME	VARCHAR	No
	The surgical approach category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
33	CEMENT_TECHNIQUE_C_NAME	VARCHAR	No
	The cement technique category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
34	CEMENT_MIX_C_NAME	VARCHAR	No
	The bone cement mix category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
35	BONE_GRAFT_C_NAME	VARCHAR	No
	The bone graft category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
36	DEGEN_GLENOHUMERAL_C_NAME	VARCHAR	No
	The category ID for the type of glenohumeral joint degeneration for the surgical log. May contain organization-specific values: Yes No Entries Defined
37	AP_CONGRUENCE_C_NAME	VARCHAR	No
	The anteposterior congruence category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
38	CENTRIC_JOINT_C_NAME	VARCHAR	No
	The centric joint category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
39	POST_ECCENTRIC_CAPUT_C_NAME	VARCHAR	No
	The posteriorly eccentric caput category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
40	ANT_ECCENTRIC_CAPUT_C_NAME	VARCHAR	No
	The anteriorly eccentric caput category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
41	CRANIO_CONGRUENCE_C_NAME	VARCHAR	No
	The joint craniocaudal congruence category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
42	SUP_ECCENTRIC_CAPUT_C_NAME	VARCHAR	No
	The superiorly eccentric caput category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
43	JOINT_CONGRUENCE_C_NAME	VARCHAR	No
	The joint congruence category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
44	GLENOID_COMPONENT_C_NAME	VARCHAR	No
	The glenoid component category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
45	HUMERAL_COMPONENT_C_NAME	VARCHAR	No
	The humeral component category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
46	HUMERUS_STATUS_C_NAME	VARCHAR	No
	The humerus status category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
47	GLENOID_STATUS_C_NAME	VARCHAR	No
	The glenoid status category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
48	PREVIOUS_OPERATION_LOCATION_ID_LOC_NAME	VARCHAR	No
	The name of the revenue location.
49	SUPPORT_NET_YN	VARCHAR	No
	Indicates whether a support net was used for the surgical log. Y indicates a support net was used. N or a null value indicates a support net was not used. The category values for this column were already listed for column: VIDEO_PIC_TAKEN_YN
50	OR_LOG_P_CATS_C_NAME	VARCHAR	No
	For each surgical case, Canadian pediatric organizations submit a Pediatric Canadian Access Targets for Surgery (P-CATS) code that corresponds to a diagnosis. This is extracted and sent to a database where the data is used to analyze wait times for procedures in relation to diagnoses May contain organization-specific values: Yes No Entries Defined
51	CLAVIEN_SCORE_PRIMARY_C_NAME	VARCHAR	No
	This item contains the documented Clavien score that defines complication severity for a procedure on a log. This item stores a single Clavien score. If multiple Clavien scores per log are needed, I ORL 4800 should be used. May contain organization-specific values: Yes Category Entries: No complication Grade I Grade II Grade III Grade IIIa Grade IIIb Grade IV Grade IVa Grade IVb Grade V Grade I d Grade II d Grade IIIa d Grade IIIb d Grade IVa d Grade IVb d
52	LOG_SERVICE_DATE	DATETIME	No
	This item stores the service date to be used when calculating charges for a log. This service date is calculated via case tracking events mapped in System and Location Definitions. It does not calculate based on Anesthesia or Patient events.
53	OPERATION_INTENTION_C_NAME	VARCHAR	No
	The operation intention category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
54	COMPLICATION_RSN_SURG_C_NAME	VARCHAR	No
	The complication as reason for surgery category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
55	PREOP_ANTIBIOTICS_C_NAME	VARCHAR	No
	The preoperative antibiotics category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
56	LAPAROSCOPY_C_NAME	VARCHAR	No
	The laparoscopy category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
57	TEACHING_ASSISTANCE_YN	VARCHAR	No
	Indicates whether the surgery was for teaching assistance. Y indicates the surgery was for teaching assistance. N or a null value indicates the surgery was not for teaching assistance. The category values for this column were already listed for column: VIDEO_PIC_TAKEN_YN
58	FIRST_ASSIST_CO_SURGEON_YN	VARCHAR	No
	Indicates whether the assistant was a co-surgeon for the surgical log. Y indicates the assistant was a co-surgeon. N or a null value indicates the assistant was not a co-surgeon. The category values for this column were already listed for column: VIDEO_PIC_TAKEN_YN
59	COMPLICAT_GRADE_INTRA_C_NAME	VARCHAR	No
	The intra-op complication grade category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
60	COMPLICAT_GRADE_POST_C_NAME	VARCHAR	No
	The post-op complication grade category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
61	ANATOMICAL_RESECTION_C_NAME	VARCHAR	No
	The anatomical resection category ID for the surgical log. May contain organization-specific values: Yes No Entries Defined
62	ACATS_CODE_C_NAME	VARCHAR	No
	For each surgical case, organizations in the Alberta province of Canada submit an Adult Coding Access Targets for Surgery (ACATS) code that corresponds to a diagnosis. This is extracted and sent to a database where the data is used to analyze wait times for procedures in relation to diagnoses. May contain organization-specific values: Yes No Entries Defined
63	PANEL1_NO_COUNT_NEEDED_C_NAME	VARCHAR	No
	This item stores the "No Counts Needed" status for Panel 1. The category values for this column were already listed for column: NO_COUNT_NEEDED_YN
64	PANEL2_NO_COUNT_NEEDED_C_NAME	VARCHAR	No
	This item stores the "No Counts Needed" status for Panel 2. The category values for this column were already listed for column: NO_COUNT_NEEDED_YN
65	PANEL3_NO_COUNT_NEEDED_C_NAME	VARCHAR	No
	This item stores the "No Counts Needed" status for Panel 3. The category values for this column were already listed for column: NO_COUNT_NEEDED_YN
66	PANEL4_NO_COUNT_NEEDED_C_NAME	VARCHAR	No
	This item stores the "No Counts Needed" status for Panel 4. The category values for this column were already listed for column: NO_COUNT_NEEDED_YN
67	PANEL5_NO_COUNT_NEEDED_C_NAME	VARCHAR	No
	This item stores the "No Counts Needed" status for Panel 5. The category values for this column were already listed for column: NO_COUNT_NEEDED_YN
68	COSMETIC_PROC_LENGTH	INTEGER	No
	The cosmetic procedure length in minutes to be billed.
69	NHSN_KNEE_PROSTHESIS_1_C_NAME	VARCHAR	No
	The type of knee prosthesis. Used for NHSN reporting. May contain organization-specific values: No Category Entries: Total: Total Primary Total: Total Revision Total: Partial Revision Hemi: Partial Primary Hemi: Total Revision Hemi: Partial Revision Resurfacing: Total Primary Resurfacing: Total Revision Resurfacing: Partial Primary Resurfacing: Partial Revision
70	NHSN_KNEE_PROSTHESIS_2_C_NAME	VARCHAR	No
	The type of knee prosthesis. Used for NHSN reporting. The category values for this column were already listed for column: NHSN_KNEE_PROSTHESIS_1_C_NAME
71	NHSN_HIP_PROSTHESIS_1_C_NAME	VARCHAR	No
	The type of hip prosthesis. Used for NHSN reporting. The category values for this column were already listed for column: NHSN_KNEE_PROSTHESIS_1_C_NAME
72	NHSN_HIP_PROSTHESIS_2_C_NAME	VARCHAR	No
	The type of hip prosthesis. Used for NHSN reporting. The category values for this column were already listed for column: NHSN_KNEE_PROSTHESIS_1_C_NAME
73	RTLS_STAFF_TRACKING_ST_C_NAME	VARCHAR	No
	The RTLS tracking status for the log. May contain organization-specific values: No Category Entries: No Staff RTLS Times Present Staff RTLS Turned Off Staff RTLS Times Present
74	PRE_OP_BED_ID	VARCHAR	No
	Pre-Op Bed
75	PRE_OP_BED_ID_BED_LABEL	VARCHAR	No
	The name of the bed.
76	PREOP_COND_C_NAME	VARCHAR	No
	Pre-Op Assessment May contain organization-specific values: Yes
77	POST_OP_BED_ID	VARCHAR	No
	Post-Op Bed
78	POST_OP_BED_ID_BED_LABEL	VARCHAR	No
	The name of the bed.
79	POST_OP_DEST_C_NAME	VARCHAR	No
	Post-Op Destination May contain organization-specific values: Yes
80	POSTOP_COND_C_NAME	VARCHAR	No
	Post-Op Condition May contain organization-specific values: Yes
81	PHASETWO_BED_ID	VARCHAR	No
	Phase II Bed
82	PHASETWO_BED_ID_BED_LABEL	VARCHAR	No
	The name of the bed.
83	LOG_PROC_LEVEL_C_NAME	VARCHAR	No
	Log Procedure Level used for billing May contain organization-specific values: Yes
84	CLIN_TRIAL_YN	VARCHAR	No
	Stores whether the log is a clinical trial log The category values for this column were already listed for column: VIDEO_PIC_TAKEN_YN
85	JNT_REVISION_YN	VARCHAR	No
	This item documents whether the log is for a revision of a joint procedure. It is used for Surgical Care Improvement Project (SCIP) reports. The category values for this column were already listed for column: VIDEO_PIC_TAKEN_YN
86	MISC_DEST	VARCHAR	No
	Destination
87	ASA_RATE_C_NAME	VARCHAR	No
	ASA Rating May contain organization-specific values: Yes
88	PRE_CONSCISNS_C_NAME	VARCHAR	No
	Pre-Op Level of Consciousness May contain organization-specific values: Yes
89	POST_CONSCISNS_C_NAME	VARCHAR	No
	Post-Op Level of Consciousness The category values for this column were already listed for column: PRE_CONSCISNS_C_NAME