|
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 |
VARCHAR |
No |
|
|
|
| The unique identifier of the test that the task on the corresponding line applies to. |
|
|
| 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 |
VARCHAR |
No |
|
|
|
| The unique identifier of the lab in which the task was completed. |
|
|
| 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 |
NUMERIC |
No |
|
|
|
| Stores a charge associated with this task. |
|
|
| 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 |
VARCHAR |
No |
|
|
|
| Used to indicate the lab tasks must be performed in. If a lab is listed in this item, the task will be added to the specimen only when the specimen (any container or test on the specimen) is received in the listed lab for the first time. |
|
|
| 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 |
VARCHAR |
No |
|
|
|
| The unique identifier of the test which populated the associated task. |
|
|
| 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 |
NUMERIC |
No |
|
|
|
| The unique ID of the last dropped charge for the associated specimen task. |
|
|
| 31 |
CHARGE_QTY_SS |
INTEGER |
No |
|
|
|
| The quantity for the last dropped charge for the associated specimen task. |
|
|
