|
Name |
Type |
Discontinued? |
|
1 |
LOG_ID |
VARCHAR |
No |
|
|
|
The unique ID of the surgical log the surgeons/staff/resources refers to. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The number of the line of the surgeon/staff/resource in the surgical log. |
|
|
3 |
SRG_STF_RES_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. |
|
|
4 |
REQUIRED_YN |
VARCHAR |
No |
|
|
|
Yes/no flag which indicates if the surgeon/staff/resource is required in the surgical log. |
May contain organization-specific values: No |
Category Entries: |
Yes |
No |
|
|
5 |
SURG_REC_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The category value indicating the surgical record type for the surgeon/staff/resource. |
May contain organization-specific values: No |
Category Entries: |
Surgeon/Performing Physician |
Anesthesia Staff |
Room |
Staff |
Equipment |
Anesthesia Equipment |
Instrument |
Deactivated Category 1 |
Deactivated Category 2 |
Positioning Device |
Implant Trays |
Admission Planning |
|
|
6 |
RESOURCE_TYPE_C |
VARCHAR |
No |
|
|
|
The category value indicating the surgical resource type for the staff/resource. |
|
|
7 |
BATCH_ASSIGN_YN |
VARCHAR |
No |
|
|
|
Yes/no flag which indicates if the Surgeon/Staff/Resource was batch assigned in the surgical log. |
The category values for this column were already listed for column: REQUIRED_YN |
|
|