Page History
...
Example Export files (all data are fake)
2 sets of files are generated for each data export.
Defintion file: has the variable names and data types for the data file
| 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 | Reeta_DEM_6_27 | demoManager | SQLServerLarge | 0 | sex_cd | patient_dimension | Gender | @ | @ | @ | @ | @ | Value | 37:14.3 | ||||||
| 7 | Reeta_DEM_6_27 | demoManager | SQLServerLarge | 1 | age_in_years_num | patient_dimension | Age | @ | @ | @ | @ | @ | Value | 37:14.3 | ||||||
| 7 | Reeta_DEM_6_27 | demoManager | SQLServerLarge | 2 | race_cd | patient_dimension | Race | @ | @ | @ | @ | @ | Value | 37:14.3 | ||||||
| 7 | Reeta_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 | Reeta_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: has the values for the variables
| 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 Demographics
1969_Definition_For_Demographics_8_5_25.csv
1969_Demographics_8_5_25_08052025.csv
User-created
...
Labs
Data Export Configuration
...
