Map the PC variables

The next page of the wizard provides the ability to map source data columns to PC domain variables and other columns useful for the NCA for each source file selected in the previous page of the wizard. Previously stored mappings are automatically populated from the SQLite database associated with each user profile.

The first column in the top table lists the Standard PC domain variable names that can be mapped plus other essential variables. The variable names depend on whether SEND or SDTM was specified on the first page of the wizard.
An NCA button in a source data column cell indicates this variable is or can be designated as an NCA Sort variable.

Click to toggle between a selected Sort variable and , an unselected, but potential, Sort variable. If the button does not switch to unselected, it means the Sort variable is required and cannot be unselected (e.g., USUBJID, PCTEST, PCSPEC). Sometimes there are multiple variables that can be Sort variables, but they are mutually exclusive (e.g., VISITDY or PCDY can be used, but not both). In such cases, when one variable is selected as the Sort variable, the NCA button for the other variables changes to unselected.

The remaining columns in the Map PC Variables table list the source data column name for each data source selected in the previous page of the wizard, one column per selected data source. If the source data file does not have the mapping for the PC domain variable, the cell is empty. If the empty cell is a required field, it will be highlighted in red.
For variable or data source columns that have units, use the dropdown menu to select the unit.

The PC Result worksheet panel at the bottom of the page presents the contents of the Master PC worksheet based on the source data columns and the specified mappings. All required and expected SEND/SDTM columns (whether mapped or not) are displayed. Optional columns will be displayed only if they are mapped.