Page History
...
Status will change as the Data File is processed. from Submitted to File in Progress to File Available.
| Data Request Status | Data column Value |
|---|---|
| Submitted | Submitted |
| Withdrawn | Cancelled |
| Denied | Incomplete |
| File in Progress | Queued |
| File available | File available |
Example Export files (all data are fake)
...
1969_Definition_For_Demographics_8_5_25.csv
| 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 | patient_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
| 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:
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 table stores the default data table parameters
- HIVE_CELL_PARAMS has new parameters for global and email configurations and the data file generation location (currently on local drive)
- QT_RESULT_TYPE table has logs new entries for data table definition breakdown types
- QT_BREAKDOWN_PATH modified to log logs the data table definition and the data export execution details.
- QT_XML_RESULT logs XML documents containing data request status and e-mail details.
User Roles and Actions
...
