|
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 |
|
|
