Page History
...
2282_Definition_For_LAB_TESTS_HUGEPT_AGGOPTIONS
| TABLE_INSTANCE_ID | TABLE_INSTANCE_NAME | USER_ID | GROUP_ID | SET_INDEX | C_FACTTABLECOLUMN | C_TABLENAME | COLUMN_NAME | C_FULLPATH | C_COLUMNNAME | C_COLUMNDATATYPE | C_OPERATOR | C_DIMCODE | AGG_TYPE | CONSTRAIN_BY_DATE_TO | CONSTRAIN_BY_DATE_FROM | CONSTRAIN_BY_VALUE_OPERATOR | CONSTRAIN_BY_VALUE_CONSTRAINT | CONSTRAIN_BY_VALUE_UNIT_OF_MEASURE | CONSTRAIN_BY_VALUE_TYPE | CREATE_DATE |
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 0 | sex_cd | patient_dimension | Gender | @ | @ | @ | @ | @ | Value | 25:57.3 | ||||||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 1 | age_in_years_num | patient_dimension | Age | @ | @ | @ | @ | @ | Value | 25:57.3 | ||||||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 2 | race_cd | patient_dimension | Race | @ | @ | @ | @ | @ | Value | 25:57.3 | ||||||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 3 | race_cd | patient_dimension | Ethnicity | @ | @ | @ | @ | @ | Value | 25:57.3 | ||||||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 4 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | NumFacts | 25:57.3 | ||||||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 5 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (1) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | NumEncounters | LIKE | L | FLAG | 25:57.3 | |||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 6 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (2) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | NumDates | LIKE | H | FLAG | 25:57.3 | |||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 7 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (3) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | MaxValue | LIKE | @ | FLAG | 25:57.3 | |||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 8 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (4) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | MinValue | LE | 10000 | mg/dl | NUMBER | 25:57.3 | ||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 9 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (5) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | NumConcepts | BETWEEN | 0 AND 1000 | mg/dl | NUMBER | 25:57.3 | ||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 10 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (6) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | NumFacts | GE | 100 | mg/dl | NUMBER | 25:57.3 | ||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 11 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (7) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | MinDate | EQ | 100 | mg/dl | NUMBER | 25:57.3 | ||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 12 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (8) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | MaxDate | LT | 1000 | mg/dl | NUMBER | 25:57.3 | ||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 13 | concept_cd | concept_dimension | Cholesterol (Group:CHOL) (9) | \\i2b2_LABS\i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | concept_path | N | like | \i2b2\Labtests\LAB\(LLB16) Chemistry\(LLB17) Lipid Tests\CHOL\ | Exists | GT | 0 | mg/dl | NUMBER | 25:57.3 | ||
Data file:
2282_LAB_TESTS_HUGEPT_AGGOPTIONS_08122025
| patient_num | Gender | Age | Race | Ethnicity | Cholesterol (Group:CHOL) | Cholesterol (Group:CHOL) (1) | Cholesterol (Group:CHOL) (2) | Cholesterol (Group:CHOL) (3) | Cholesterol (Group:CHOL) (4) | Cholesterol (Group:CHOL) (5) | Cholesterol (Group:CHOL) (6) | Cholesterol (Group:CHOL) (7) | Cholesterol (Group:CHOL) (8) | Cholesterol (Group:CHOL) (9) | ACT Medications Alphabetical | A00-B99 Certain Infectious And Parasitic Diseases (A00-B99) (2010AB-2022AB) | ACT Diagnoses ICD-9-CM | ACT Procedures ICD-10-PCS | Lipids | ACT Procedures ICD-9-Proc |
| 9 | M | 49 | white | white | 1 | 0 | 0 | 157.2 | 157.2 | 1 | 1 | 5/3/2020 | Yes | Yes | No | No | Yes | |||
| 89 | F | 57 | white | white | 1 | 0 | 0 | 183.9 | 183.9 | 1 | 1 | ######## | Yes | Yes | No | No | Yes | |||
| 13 | F | 53 | white | white | 1 | 0 | 0 | 177.1 | 177.1 | 1 | 1 | ######## | Yes | Yes | Yes | No | Yes | |||
| 21 | F | 72 | white | white | 7 | 0 | 0 | 238.5 | 209.9 | 1 | 7 | ######## | Yes | Yes | Yes | No | Yes | |||
| 77 | F | 80 | white | white | 1 | 0 | 0 | 168.7 | 168.7 | 1 | 1 | ######## | Yes | No | No | No | Yes | |||
| 14 | M | 58 | white | white | 1 | 0 | 0 | 178 | 178 | 1 | 1 | ######## | Yes | Yes | No | No | Yes | |||
| 33 | M | 39 | black | black | 1 | 0 | 0 | 189.7 | 189.7 | 1 | 1 | ######## | Yes | Yes | Yes | No | Yes | |||
| 90 | F | 88 | asian | asian | 1 | 0 | 0 | 156.1 | 156.1 | 1 | 1 | ######## | Yes | Yes | No | No | Yes | |||
| 47 | M | 60 | white | white | 1 | 0 | 0 | 172.4 | 172.4 | 1 | 1 | ######## | Yes | Yes | No | No | Yes | |||
| 19 | M | 47 | white | white | 1 | 0 | 0 | 198.5 | 198.5 | 1 | 1 | ######## | Yes | No | No | No | Yes | |||
| 49 | F | 47 | white | white | 1 | 0 | 0 | 194.8 | 194.8 | 1 | 1 | 4/4/2020 | Yes | Yes | Yes | No | Yes | |||
| 145 | F | 78 | black | black | 1 | 0 | 0 | 178.9 | 178.9 | 1 | 1 | ######## | Yes | Yes | No | No | Yes | |||
| 57 | F | 67 | black | black | 1 | 0 | 0 | 192 | 192 | 1 | 1 | ######## | Yes | Yes | No | No | Yes |
Data Export Configuration
...
| RPDO_TABLE_REQUEST PARAMETERS | DATA TABLE Values |
|---|---|
| TABLE_REQUEST_ID | auto generated incremental value, corresponding to each concept in the data table. Unique for each concept example: 1282,1283, 1284 |
| TABLE_INSTANCE_ID | unique for each Data table ( same value for all the concepts underneath) example: 17 |
| TABLE_INSTANCE_NAME | Data table definition name |
| USER_ID | logged in user |
| GROUP_ID | project id |
| SET_INDEX | auto incremented for each concept name for the table instance |
| C_FACTTABLECOLUMN | |
| C_TABLENAME | |
| COLUMN_NAME | |
| C_FULLPATH | |
| C_COLUMNNAME | |
| C_COLUMNDATATYPE | |
| C_OPERATOR | |
| C_DIMCODE | |
| AGG_TYPE | |
| CONSTRAIN_BY_DATE_TO | |
| CONSTRAIN_BY_DATE_TO | |
| CONSTRAIN_BY_DATE_FROM | |
| CONSTRAIN_BY_VALUE_OPERATOR | |
| CONSTRAIN_BY_VALUE_CONSTRAINT | |
| CONSTRAIN_BY_VALUE_UNIT_OF_MEASURE | |
| CONSTRAIN_BY_VALUE_TYPE | |
| CREATE_DATE | |
| SHARED | Y ( for project and system shared table definitions); N (User table definition) |
| DELETE_FLAG | Y or N |
| C_VISUALATTRIBUTES | values are LA or LH (based on visibiityin table definitons panel) |
QT_QUERY_RESULT_TYPE
The data table definitions are logged as breakdowns in the QT_QUERY_RESULT_TYPE table. The rows are inserted dynamically when the user saves the data table definition.
...
