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_lot_normal_ranges contains fields identifying lot normal ranges and ordinals of result within test.
Relationships:
1. cdr_lot_parent has multiple cdr_lot_normal_ranges.
2. cdr_lab_order_table has multiple cdr_lot_normal_ranges.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lot_item_number | Test Number | int | Owned Key |
| lot_test_id | Test ID | numeric (18) | Owned Key |
| lp_parent_test_id | Parent Test ID | int | Owned Key |
| lnr_ordinal_number | Ordinal (Component number of test result) | int | Owned Key |
| lnr_lo_age_days | Low Age In Days range applies. | int | Owned Key |
| lnr_hi_age_days | Hi Age In Days range applies. | int | Owned Key |
| lnr_sex | Sex/Gender range applies. | char(1) | Owned Key |
| lnr_normal_lo | Normal Low | decimal(9,4) | Owned Non-key |
| lnr_normal_hi | Normal High | decimal(9,4) | Owned Non-key |
| lnr_last_date_modified | Date of last modification. | datetime | Owned Non-key |
| lnr_rule_strength | Rule Strength for Normal. Used to evaluate normal for test given a specific patient. O indicates no age/gender conditions, 1 indicates gender conditions, 2 indicates age conditions, and 3 indicates both age and gender conditions. | tinyint | Owned Non-key |
Description: cdr_lot_parent contains fields identifying the parent test of the lot.
Relationships:
1. cdr_lot_parent has multiple cdr_lot_normal_ranges.
2. cdr_lot_parent has multiple cdr_lot_departments.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| lp_parent_test_id | Parent Test ID | int | Owned Key |
| ld_department_code | Department Code For Test (Internal section with in Lab). | char(1) | Owned Non-key |
| lp_active_flag | Active Flag of Test | char(1) | Owned Non-key |
| lp_parent_name | Parent Test Name | varchar(40) | Owned Non-key |
| lp_abbrev_name | Parent Test Abbreviated Name | varchar(40) | Owned Non-key |
| lp_creation_datetime | Date Test was initiated | datetime | Owned Non-key |
| lp_last_date_modified | Date Test was last modified. | datetime | Owned Non-key |
Description: cdr_lot_department identifies the internal section within the lab in which the test is performed.
Relationships:
1. cdr_lot_parent has multiple cdr_lot_departments.
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| ld_department_code | Department Code for lab section | char(1) | Owned Key |
| ld_department_desc | Department Description for lab section | char(1) | Owned Key |
Description: ciutest contains fields related to the test. Currently being used by RAP.
Relationships: None
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| tstid | Test ID | numeric(18) | Owned Key |
| tstnumber | Test number | int | Owned Key |
| tstname | Name of test | varchar(40) | Owned Non-key |
| tstunit | Test units | varchar(40) | Owned Non-key |
| tsttype | Type of test | char(1) | Owned Non-key |
Description: chmgroup contains fields related to the grouping of test. Currently being used by RAP.
Relationships: None
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| grpid | Group ID | smallint | Owned Key |
| grpdescription | Test description | varchar(30) | Owned Key |
Description: chmgroup contains fields related to the grouping of test. Currently being used by RAP.
Relationships: None
| Base Name | Attribute Definition | Column Datatype | Attribute Type |
| grpid | Group ID | smallint | Owned Key |
| tstid | Test ID | numeric(18) | Owned Key |
| tstname | Test name | varchar(30) | Owned Key |
Last modified 7/1/97