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