Page History
...
| 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 | ||||||
| 7 | DEM_6_27 | demoManager | SQLServerLarge | 0 | sex_cd | patient_dimension | Gender | @ | @ | @ | @ | @ | Value | 37:14.3 | ||||||||||||
| 7 | DEM_6_27 | demoManager | SQLServerLarge | 1 | age_in_years_num | patient_dimension | Age | @ | @ | @ | @ | @ | Value | 37:14.3 | ||||||||||||
| 7 | DEM_6_27 | demoManager | SQLServerLarge | 2 | race_cd | patient_dimension | Race | @ | @ | @ | @ | @ | Value | 37:14.3 | ||||||||||||
| 7 | DEM_6_27 | demoManager | SQLServerLarge | 3 | patient_num | patient_dimension | (children) < 18 years old | \\ACT_DEMO\ACT\Demographics\Age\< 18 years old\ | birth_date | N | > | dateadd(YY, -18, GETDATE()) | Exists | 37:14.3 | 7 | DEM_6_27 | demoManager | SQLServerLarge | 4 | patient_num |
Data file:
1969_Demographics_8_5_25_08052025.cs
| patient_num | Gender | Age | Race | (children) < 18 years oldpatient_dimension | 75-84 years old | \\ACT_DEMO\ACT\Demographics\Age\75-84 years old\ | birth_date | N | BETWEEN | dateadd(YY, -85, dateadd(dd, +1,getdate())) AND dateadd(YY, -74, getdate()) | Exists | 37:14.3 | 7 | Reeta_DEM_6_27 | demoManager | SQLServerLarge | 5 | patient_num | patient_dimension | >= 65 years old | \\ACT_DEMO\ACT\Demographics\Age\>= 65 years old\ | birth_date | N | <= | dateadd(YY, -65, GETDATE()) | Exists | 37:14.3 |
Data file:
1969_Demographics_8_5_25_08052025.cs
| >= 65 years old | ||||||
| 26 | M | 72 | @ | No | Yes | Yes |
| 53 | F | 55 | WHITE | No | No | No |
| 87 | F | 59 | WHITE | No | No | No |
| 92 | F | 88 | DECLINED | No | No | Yes |
| 94 | F | 67 | ASIAN | No | No | Yes |
| 153 | M | 77 | ||||
| patient_num | Gender | Age | Race | (children) < 18 years old | 75-84 years old | >= 65 years old |
| 26 | M | 72 | @ | No | Yes | Yes |
| 53 | F | 55 | WHITE | No | No | No |
| 87 | F | 59 | WHITE | No | No | No |
| 92 | F | 88 | DECLINED | No | No | Yes |
| 94 | F | 67 | ASIAN | No | No | Yes |
| 96 | F | 29 | WHITE | No | No | No |
| 128 | F | 62 | WHITE | No | No | Yes |
| 153 | M | 77 | @ | No | Yes | Yes |
User-created Labs
Definition file:
...
User-created Labs
Definition file:
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 | |||||||||||||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||
| 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 | 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 0 | sex_cd | patient_dimension | Gender | @ | @ | @ | @ | @ | Value | 25:57.3 | ||||||||||||||||||||||
| 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 14 | age_in_years_num | patient_dimension | Age | @ | @ | @ | @ | @ | Value | 25:57.3 | 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 | 310 | LAB_TESTS_HUGEPT_AGGOPTIONS | act | NODE9 | 2 | race_cd | patient_dimension | Race | @ | @ | @ | @ | @ | Value | 25:57.3310 | ||||||
Data file:
2282_LAB_TESTS_HUGEPT_AGGOPTIONS
...
_08122025
| patient_num | Gender | Age | Race | Ethnicity | Cholesterol (Group:CHOL) |
| 9 | M | 49 | white | white | 1 |
| 89 | F | 57 | white | white | 1 |
| 13 | F | 53 | white | white | 1 |
| 21 | F | 72 | white | white | 7 |
| 77 | F | 80 | white | white | 1 |
...
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
...
