Page 17 of 76. Showing 757 results (0.019 seconds)
WORKPLACE Table
The WORKPLACE table is organized by project and contains all the information needed to store and access workplace items. There is one table per project. WORKPLACE TABLE COLUMN NAME DATA TYPE DESCRIPTION PK C_INDEX VARCHAR(255) Unique indexPM_GLOBAL_PARAMS Table
The PM_GLOBAL_PARAMS table is commonly used in a production system to specify the default values for various users. These parameters are not specific to a hive or project. There is one table per Project Management cell. PM_GLOBAL_PARAMETERS PK ID int343. Import DB Table
, you added the Staging Server https://community.i2b2.org/wiki/x/pYGN. To start the DB Table Import, right click the project in the Import Browser https://community.i2b2.org/wiki/x/Z4KN you want to upload data to and select Import Data -> Import DB Table. SQL_Import_2.png A window opens, where you can select the DBMODIFIER_DIMENSION Table
The MODIFIER_DIMENSION table contains one row for each modifier. The modifier has the similar hierarchical organization as the concept type. The Ontology cell … children. The MODIFIER_DIMENSION table has three REQUIRED columns. MODIFIER_PATH A path that delineates the modifier's hierarchyPROVIDER_DIMENSION Table
Each record in the PROVIDER_DIMENSION table represents a physician or provider at an institution. The PROVIDER_PATH is the path that describes how the provider fits into the institutional hierarchy. Institution, department, provider name and a code may be included in the path. PROVIDER_DIMENSIONPM_USER_DATA Table
The PM_USER_DATA table contains general information about the user. There is one row per user; data with special tags can occur once per user is also in that row. The USER_ID is associated with a humanly legible name in the format that the user prefers. The PASSWORD is the MD5 has for the user's passwordPM_CELL_PARAMS Table
The PM_CELL_PARAMS table contains cell specific parameters. Follows the same rules for the return of specific cell-associated name-value pairs. Commonly used in a production system to specify default values for various users. PM_CELL_PARAMS PK ID intPATIENT_MAPPING Table
The PATIENT_MAPPING table maps the i2b2 PATIENT_NUM to an encrypted number, PATIENT_IDE, from the source system (the 'e' in "ide" is for encrypted). The PATIENT_IDE_SOURCE contains the name of the source system. The PATIENT_IDE_STATUS gives the status of the patient number in the source system. For exampleENCOUNTER_MAPPING Table
The ENCOUNTER_MAPPING table maps the i2b2 ENCOUNTER_NUM to an encrypted number, ENCOUNTER_IDE, from the source system (the 'e' in "ide" is for encrypted). The ENCOUNTER_IDE_SOURCE contains the name of the source system. The ENCOUNTER_IDE_STATUS gives the status of the patient number in the source systemPM_CELL_DATA Table
The PM_CELL_DATA table contains general information about the cells. There is one row for each CELL_ID. A hive may have several cells of the same type, but they will be distributed to the projects according to their PROJECT_PATH. In version 1.x of the Hive software, the XML will only return the cell which