We wanted to be able to bulk-load diversity sets into MSS. While the documentation has several additional fields in the CIRCUIT table that claim to be updated when a circuit is a member of a diversity set (SPECIAL_ROUTING_CODE_IO_FAC, SPECIAL_ROUTING_CODE_SECLOC, and SPECIAL_ROUTING_CODE_TYPE), I’ve found these fields to remain NULL when sets are created through the MSS GUI.

To create a diversity set, an API call will be made. The following values would be used for each interaction with the API.

Adding circuits to the newly created diversity set requires the Oracle-generated sequence, DS_DVRSTY_SET_ID, which is created by the previous call. To add circuits to the diversity set, an API call will be made. The following values would be used for each interaction with the API.

Parameter	Description	Required?	Field	Table	Action
iDiversitySetID	Diversity Set ID from asap.ds_dvrsty_set	YES	DS_DVRSTY_SET_ID	ds_dvrsty_set_circuit	INSERT
iDiversitySetSequence	Circuit sequence number within diversity set	YES	DS_DVRSTY_SET_SEQ	ds_dvrsty_set_circuit	INSERT
iCircuitDesignID	Unique identifier for circuit	YES	CIRCUIT_DESIGN_ID	ds_dvrsty_set_circuit	INSERT
charPrimaryRouteIndicator	Indicates if the circuit is the primary route circuit. Valid values are ‘Y’ and ‘N’	YES	DS_PRIMARY_ROUTE_IND	ds_dvrsty_set_circuit	INSERT
charExcludeIndicator	Indicates whether this circuit within the Diversity Set is excluded from the diversity requirement	YES	DS_EXCLUDE_IND	ds_dvrsty_set_circuit	INSERT
n/a	The user account that made the most recent change to the row. This will always be g9953576.	n/a	LAST_MODIFIED_USERID	ds_dvrsty_set_circuit	INSERT
n/a	The timestamp when the last change to the row occurred	n/a	LAST_MODIFIED_DATE	ds_dvrsty_set_circuit	INSERT
n/a	Indicates circuit belongs to a diversity set. This value will always be ‘Y’	n/a	DS_DIVERSITY_IND	circuit	UPDATE