Description: cdr_lab_order contains the fields necessary for making an order.
Relationships:
1. cdr_lab_order has a one to one relationship woth cdr_lab_results.
2. cdr_lab_order has multiple cdr_lab_results.
3. cdr_lab_order has a one relationship to cdr_lab_order_table.
4. cdr_lab_order has 0-multiple cdr_lab_accession_comement entries.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lo_order_number | Lab Order Number Format: NNNNN.NN Decimal place is used for the order number of an item perscribed daily. | decimal(7,2) | Owned Key |
| lac_accession_id | Lab Accession Number Format: CCNNNN | char(6) | Foreign Non-key |
| pv_visit_id | Visit Id Visit Id for a given patient. | int | Foreign Non-key |
| pi_master_pat_index | Patient Info Master Patient Index Algorithm produced a mpi from a patient's medical record number. | int | Owned Non-key |
| lp_parent_test_id | Parent Test ID | int | Owned Non-key |
| lo_ordering_physician | Ordering Physician | varchar(40) | Owned Non-key |
| lo_pdf_number | PDF Number System ID For Patient | char(5) | Owned Non-key |
Description: cdr_lab_order_table contains information related to the lab order test.
Relationships:
1. cdr_lab_order_table has multiple cdr_lab_results.
2. cdr_lab_order_table has multiple cdr_lot_normal_ranges.
3. cdr_lab_order_table has one cdr_lot_parent.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lot_test_number | Lab Order Test Test Number | int | Owned Key |
| lot_test_id | Lab Order Unique Test ID | numeric(18) | Owned Key |
| lp_parent_test_id | Parent Test ID | int | Owned Non-key |
| lot_name | Lab Order Table Name | varchar(50) | Owned Non-key |
| lot_test_units | Test Units | varchar(10) | Owned Non-key |
| lot_test_type | Test Type | varchar(10) | Owned Non-key |
Description: cdr_lab_results contains the main fields relating to a result for a test.
Relationships:
1. cdr_lab_results has one cdr_lab_order entry.
2. cdr_lab_results has one cdr_lab_results_history.
3. cdr_lab_results has one cdr_lab_order_table entry.
4. cdr_lab_results has one cdr_micro_sensitivity.
| Base Name | Attribute Definition | Column Datatype | Attribute Type | ||
| lr_id | Lab Result ID | numeric(18) | Owned Key | ||
| pi_master_pat_index | Master Patient Index |
int | Foreign Non-key | ||
| lo_order_number | Lab Order Number | decimal(7,2) | Foreign Non-key | ||
| lot_test_number | Lab Order Test ID | int | Foreign Non-key | ||
| lot_test_id | Unique Lab Number | numeric(18) | Foreign Non-key | ||
| lr_result | Lab Result | numeric(10,3) | Owned Non-key | ||
| lr_result_text | Lab Result Text | varchar(20) | Owned Non-key | ||
| lr_result_flag | Lab Result Flag | char(1) | Owned Non-key | ||
| lr_enumerated_type | Lab Result Enumerated Type | int | Owned Non-key | ||
| lr_corrected_flag | Lab Result Corrected Flag | char(1) | Owned Non-key | ||
| lp_parent_test_id | Lab Result Parent Test ID | int | Owned Non-key | ||
| lr_comment_flag | Lab Result Flag Comment | char(1) | Owned Non-key | ||
| lr_test_low_range | Lab Result Low Range | int | Owned Non-key | ||
| lr_test_high_range | Lab Test High Range | int | Owned Non-key | ||
| lr_yyyymm | Year/Month of data being loaded. | int | Owned Non-key | ||
| lr_cleansecode | Indication of data being cleansed. | smallint | Owned Non-key | ||
| lr_cleansedate | Indication of date data was cleansed. | datetime | Owned Non-key | ||
| lr_testdatetime | Indication of date test was performed. | datetime | Owned Non-key | ||
Description: cdr_lab_results_housekeeping contains additional fields identifying a test result.
Relationships:
1. cdr_lab_results_housekeeping has one cdr_lab_results entry.
2. cdr_lab_results_housekepping has 0-multiple cdr_lab_specimen.
3. cdr_lab_results_housekepping has 0-multiple cdr_lab_body_source.
4. cdr_lab_results_housekepping has 0-multiple cdr_lab_qual_dict.
5. cdr_lab_results_housekepping has 0-multiple cdr_lab_remark_comment.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lr_id | Lab Results Housekeeping Information Additional Information pertaining to lab results. | numeric(18) | Foreign Key |
| ls_id | Lab Speciment ID | numeric(5) | Foreign Non-key |
| lbs_id | Lab Body Source ID | numeric(5) | Foreign Non-key |
| lrc_id | Lab Remark Comment ID | numeric(18) | Foreign Non-key |
| lqd_id | Lab Quality Dictionary ID | numeric(18) | Foreign Non-key |
| lrh_resultstatus | Result Status | char(1) | Owned Non-key |
| lrh_serviceid | Service ID | char(2) | Owned Non-key |
| lac_accession_id | Lab Accession Comment ID | char(6) | Foreign Non-key |
Description: cdr_lab_accession_comment contains comment for an accession.
Relationships:
1. cdr_lab_order has 0-multiple cdr_lab_accession comments.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lac_accession_id | Accession ID for Test | char(6) | Owned Key |
| lac_desc | Accession Comment | varchar(255) | Owned Non-key |
Description: cdr_lab_body_source contains the lookup table for body sources.
Relationships:
1. cdr_lab_results_housekepping has 0-multiple cdr_lab_body_source.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lbs_id | Lab Body Source Body Source ID | numeric(5) | Owned Key |
| lbs_desc | Lab Body Source Description | varchar(20) | Owned Non-key |
Description: cdr_lab_qual_dict contains the lookup table for the quality dictionary.
Relationships:
1. cdr_lab_results_housekeeping has 0-multiple cdr_lab_qual_dict.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lqd_id | Lab Quality Dictionary ID | numeric(18) | Owned Key |
| lqd_result | Lab Quality Dictionary Result | varchar(60) | Owned Non-key |
Description: cdr_lab_remark_comment contains the lookup table for remarks/comments.
Relationships:
1. cdr_lab_results_housekepping has 0-multiple cdr_lab_remark_comment.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lrc_id | Lab Remark Comment ID | numeric(18) | Owned Key |
| lrc_comment1 | Lab Remark Comment Comment 1 | varchar(60) | Owned Non-key |
| lrc_comment2 | Lab Remark Comment Comment 2 | varchar(60) | Owned Non-key |
| lrc_comment3 | Lab Remark Comment Comment 3 | varchar(60) | Owned Non-key |
| lrc_modnote | Lab Remark Comment Modification Note | varchar(60) | Owned Non-key |
| lrc_shorttext | Lab Remark Comment Short Test | varchar(60) | Owned Non-key |
Description: cdr_lab_specimen contains the lookup table for specimens.
Relationships:
1. cdr_lab_results_housekepping has 0-multiple cdr_lab_specimen.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| ls_id | Lab Specimen ID | numeric(5) | Owned Key |
| ls_desc | Lab Specimen Description | varchar(20) | Owned Non-key |
Last modified 6/21/97