Customizing Mass Changes Local Codelists

The Mass Changes Utility uses the local reference codelists described in the following table. You can modify them to suit your organization's needs. The affected tablename.columnname column indicates the database columns that are affected by or use each reference codelist. From the Admin menu, select Reference Codelists, then select Local Codelists and query the codelists named in the following table.

Table 4-1 Mass Changes Utility Reference Codelists

Name	Description	Affected Tablename.Columnname
MC CDS SORT ORDERFoot 1	Default sort order for viewing and applying the candidate data set (CDS); the columns you can order.	mass_changes.order_by_cols
MC COLUMNSFoot 2	The list of columns that can be used in LHS or RHS of criteria, such as RDCI.SITE	mass_change_criteria.col mass_change_criteria.value
DISC COLS2	Columns available for the LHS and RHS of the CDS Criteria form, regardless of the discrepancy type specified, such as DE.CREATION_TS	mass_change_criteria.col mass_change_criteria.value
UNI DISC COLS2	Columns available for the LHS and RHS of the CDS Criteria form, where the discrepancy type specified is UNIVARIATE, such as DE.DISCREPANCY_TYPE_CODE	mass_change_criteria.col mass_change_criteria.value
IND DISC COLS2	Columns available for the LHS and RHS of the CDS Criteria form, where the discrepancy type specified is INDICATOR	mass_change_criteria.col mass_change_criteria.value
MULTI DISC COLS2	Columns available for the LHS and RHS of the CDS Criteria form, where the discrepancy type specified is MULTIVARIATE, such as PROCEDURES.NAME	mass_change_criteria.col mass_change_criteria.value
MANHD DISC COLS2	Columns available for the LHS and RHS of the CDS Criteria form, where the discrepancy type specified is MANUAL HEADER	mass_change_criteria.col mass_change_criteria.value
FLD RXCMCMCD RDCI KEY	Candidate Data Set fields to be displayed on the Candidate Data Set form when called for RDCI KEY changes, their order of display, width, and prompt.	N/A
FLD RXCMCMCD RDCM KEY	Candidate Data Set fields to be displayed on the Candidate Data Set form when called for RDCM KEY changes, their order of display, width, and prompt	N/A
FLD RXCMCMCD RDCI DELETE	Candidate Data Set fields to be displayed on the Candidate Data Set form when called for RDCI DELETE changes, their order of display, width, and prompt	N/A
FLD RXCMCMCD RESPONSE	Candidate Data Set fields to be displayed on the Candidate Data Set form when called for Responses changes, their order of display, width, and prompt	N/A
OCL MC PREFSFoot 3	Sets the default maximum number of records to change in a Candidate Data Set. Its initial long value is 1000.	mass_changes.max_cds_records

^Footnote 1

Only the display sequence and whether the field should be sorted in ascending or descending order should be changed. New fields should not be added and existing ones should not be removed.

^Footnote 2

The values in this reference codelist determine the contents of the list of values for mass change criteria. Additional values may be added to the reference codelist but they must be from one of the existing tables already defined for values, and they must use the alias provided for the table. No validation occurs against the values in this codelist. If a value is not in the list of values it can still be added as a criterion for specifying the candidate data set.

^Footnote 3

OCL MC PREFS currently has one value, MAX_CDS_RECORDS, which controls the default maximum number of records to include in a Candidate Data Set.