| Name |
Type |
Discontinued? |
|
1 |
SPECIMEN_ID |
VARCHAR |
No |
|
|
|
The unique ID of the specimen record |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The line number for the information associated with this record. Multiple pieces of information can be associated with this record. |
|
|
3 |
TASK_TEST_ID_TEST_NAME |
VARCHAR |
No |
|
|
|
The name of the test record. |
|
|
4 |
TASK_C_NAME |
VARCHAR |
No |
|
|
|
The task category number for the specimen |
May contain organization-specific values: Yes |
|
|
5 |
TASK_ACTION_C_NAME |
VARCHAR |
No |
|
|
|
The task action category number for the corresponding task. |
May contain organization-specific values: No |
Category Entries: |
Aliquot Creation |
Block Creation |
Slide Creation |
Media Plate Creation |
|
|
6 |
TASK_PARAMS |
VARCHAR |
No |
|
|
|
Stores the parameters for the action associated with task on the corresponding line. For instance, this column may store the media type of the created container. |
|
|
7 |
TASK_INSTANT |
DATETIME (Local) |
No |
|
|
|
The instant when the task was completed. |
|
|
8 |
TASK_PERSON_ID |
VARCHAR |
No |
|
|
|
The unique employee identifier of the person completing the task. |
|
|
9 |
TASK_PERSON_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
10 |
TASK_LAB_ID_LAB_NAME |
VARCHAR |
No |
|
|
|
The name of the lab record. |
|
|
11 |
TASK_INST |
DATETIME (Local) |
No |
|
|
|
The user-editable instant when the task was completed. |
|
|
12 |
TASK_LINKED_CTNR_ID |
VARCHAR |
No |
|
|
|
The unique container identifier that might be created if the action associated with the task on the corresponding line is to create a media plate, a block or a slide that is related to a block. |
|
|
13 |
TASK_GROUP |
VARCHAR |
No |
|
|
|
This item is used to group tasks together. This feature is most commonly used to link multiple slides to a block. |
|
|
14 |
TASK_ACTION_QTY |
INTEGER |
No |
|
|
|
Stores the number of times the action associated with this task must be performed. |
|
|
15 |
TASK_CHARGE_ID_PROC_NAME |
VARCHAR |
No |
|
|
|
The name of each procedure. |
|
|
16 |
TASK_CHARGE_QTY |
INTEGER |
No |
|
|
|
Stores the number of times the billing code associated with this task must be charged. |
|
|
17 |
TASK_INT_LAB_ID_LAB_NAME |
VARCHAR |
No |
|
|
|
The name of the lab record. |
|
|
18 |
TASK_LEVEL |
INTEGER |
No |
|
| |
|
19 |
TASK_BLOCK_START_TM |
DATETIME (Local) |
No |
|
|
|
Stores the block fixation start time. |
|
|
20 |
TASK_BLOCK_END_TM |
DATETIME (Local) |
No |
|
|
|
Stores the block fixation end time. |
|
|
21 |
TASK_NOTES |
VARCHAR |
No |
|
|
|
Stores any free text notes describing the task. |
|
|
22 |
TASK_DELETED_YN |
VARCHAR |
No |
|
|
|
Indicates whether the related task has been soft-deleted. "Y" indicates that the task has been soft-deleted. "N" or an empty value indicates that the task has not been soft-deleted. |
May contain organization-specific values: No |
Category Entries: |
No |
Yes |
|
|
23 |
TASK_AP_PART_ID |
VARCHAR |
No |
|
|
|
Returns the part ID for this anatomic pathology task, such as "A1". |
|
|
24 |
TASK_PROTOCOL_ID_TEST_NAME |
VARCHAR |
No |
|
|
|
The name of the test record. |
|
|
25 |
TASK_COMP_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
The instant that the user indicated the task was completed in UTC. |
|
|
26 |
TASK_CHG_TR_STAT_C_NAME |
VARCHAR |
No |
|
|
|
The charge trigger status category ID for the task. |
May contain organization-specific values: No |
Category Entries: |
Tech/No type charges have been triggered |
Professional charges have been triggered |
All types of charges have been triggered |
|
|
27 |
TASK_UPD_LINE |
INTEGER |
No |
|
|
|
The line in the tasks related table (SI 51310) that the current line is created to restore for when task was updated. |
|
|
28 |
TASK_UPD_ALERT_ID |
NUMERIC |
No |
|
|
|
The unique alert record identifier created when the task was updated. |
|
|
29 |
TEST_LINE |
INTEGER |
No |
|
|
|
The line number of the associated test on the specimen. Together with SPECIMEN_ID, this forms the foreign key to the SPEC_TEST_REL table. |
|
|
30 |
CHARGE_SS_PROC_ID_PROC_NAME |
VARCHAR |
No |
|
|
|
The name of each procedure. |
|
|
31 |
CHARGE_QTY_SS |
INTEGER |
No |
|
|
|
The quantity for the last dropped charge for the associated specimen task. |
|
|