RULE-7459

Tier	2.0
Tier Description	Relational error
Error Category	E2001
Error Category Message	Values inconsistently specified (single record type, single record)
Rule Type	One Record Type (Single Record)
File Segment Number	ELG00012
Data Element Name	WAIVER-PARTICIPATION.WAIVER-ID
Validation Logic	'if WAIVER-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM and WAIVER-PARTICIPATION.WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '32', '33', then substr(WAIVER-PARTICIPATION.WAIVER-ID, 1, 2) must be in (A-Z/a-z) and substr(WAIVER-PARTICIPATION.WAIVER-ID, 3, 1) must be equal to '.' and (substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 4) must be equal to 0-9 digits or substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 5) must be equal to 0-9 digits or substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 2) must be equal to 0-9 digits)'
Rule Definition	If a segment is a waiver participation segment from an ELG file, and the MSIS ID is populated, and the waiver participation segment has a waiver type value equal to '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '32', '33', then the waiver id is in the core waiver id format.
Denominator Logic	# of WAIVER-PARTICIPATION segments and with WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08','09', '10', '11', '12', '13', '14', '15', '16', '17', '18','19', '20', '32', '33'

Published Date	Data Guide Version	Validation Rule	Action	Field	Before	After
04/30/2021	3.0.0	RULE-7459	ADD	Data Dictionary - Validation Rules	N/A	if WAIVER-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM and WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08','09', '10', '11, '12', '13', '14', '15', '16', '17', '18','19', '20', '32', '33' then substr(WAIVER-PARTICIPATION.WAIVER-ID, 1, 2) must be in (A-Z/a-z) and substr(WAIVER-PARTICIPATION.WAIVER-ID, 3, 1) must be equal to '.' and substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 7) must be equal to 0-9 digits)
06/11/2021	3.0.0	RULE-7459	UPDATE	Data Dictionary - Validation Rules	if WAIVER-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM and WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08','09', '10', '11, '12', '13', '14', '15', '16', '17', '18','19', '20', '32', '33' then substr(WAIVER-PARTICIPATION.WAIVER-ID, 1, 2) must be in (A-Z/a-z) and substr(WAIVER-PARTICIPATION.WAIVER-ID, 3, 1) must be equal to '.' and substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 7) must be equal to 0-9 digits)	if WAIVER-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM and WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08','09', '10', '11, '12', '13', '14', '15', '16', '17', '18','19', '20', '32', '33' then substr(WAIVER-PARTICIPATION.WAIVER-ID, 1, 2) must be in (A-Z/a-z) and substr(WAIVER-PARTICIPATION.WAIVER-ID, 3, 1) must be equal to '.' and substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 4) must be equal to 0-9 digits)
09/03/2021	3.0.0	RULE-7459	UPDATE	Data Dictionary - Validation Rules	if WAIVER-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM and WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08','09', '10', '11, '12', '13', '14', '15', '16', '17', '18','19', '20', '32', '33' then substr(WAIVER-PARTICIPATION.WAIVER-ID, 1, 2) must be in (A-Z/a-z) and substr(WAIVER-PARTICIPATION.WAIVER-ID, 3, 1) must be equal to '.' and substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 4) must be equal to 0-9 digits)	if WAIVER-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM and WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08','09', '10', '11, '12', '13', '14', '15', '16', '17', '18','19', '20', '32', '33' then substr(WAIVER-PARTICIPATION.WAIVER-ID, 1, 2) must be in (A-Z/a-z) and substr(WAIVER-PARTICIPATION.WAIVER-ID, 3, 1) must be equal to '.' and (substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 4) must be equal to 0-9 digits or substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 5) must be equal to 0-9 digits)
11/05/2021	3.0.0	RULE-7459	UPDATE	Data Dictionary - Validation Rules	if WAIVER-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUMand WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08','09', '10', '11, '12', '13', '14', '15', '16', '17', '18','19', '20', '32', '33' then substr(WAIVER-PARTICIPATION.WAIVER-ID, 1, 2) must be in (A-Z/a-z) and substr(WAIVER-PARTICIPATION.WAIVER-ID, 3, 1) must be equal to '.' and (substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 4) must be equal to 0-9 digits or substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 5) must be equal to 0-9 digits)	if WAIVER-PARTICIPATION has a non-null value for MSIS-IDENTIFICATION-NUM and WAIVER-TYPE is equal to one of the following: '02', '03', '04', '05', '06', '07', '08','09', '10', '11, '12', '13', '14', '15', '16', '17', '18','19', '20', '32', '33' then substr(WAIVER-PARTICIPATION.WAIVER-ID, 1, 2) must be in (A-Z/a-z) and substr(WAIVER-PARTICIPATION.WAIVER-ID, 3, 1) must be equal to '.' and (substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 4) must be equal to 0-9 digits or substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 5) must be equal to 0-9 digits) or substr(WAIVER-PARTICIPATION.WAIVER-ID, 4, 2) must be equal to 0-9 digits)