Used to validate data elements which are logically grouped within a set. WHERE ForeignCountry = IN SET ’us’ Rule is executed within the (RP{ForeignCountry}) bounds of each WHERE SET …IN Means execute the rule if the ForeignCountry occurrence of a set. dimension value is in the ForeignCountry ‘us’ dimension within the RP context. WHERE <A> IN SET(<B>). Refer also: {x}. (RP:pyde.xx.xx:AddressDetails.Line1.Text WHERE(TUPLE ELEMENT Address Usage = IN TUPLE(address2)) = NULLORBLANK. “BUS”) Means Line 1 of the business address of the The WHERE and IN Reporting Party is not present. TUPLE keywords are used when tuple element Rule will trigger if: WHERE…. IN explicits are required. TUPLE RP context is not present, or (element definition) The element including the address2 tuple is not present, or definition is to be considered as a whole. address2 tuple with Address Usage = is not ‘BUS’ present, or in the address2 tuple with Address Usage = is not present. ‘BUS’ Used to validate data elements which are logically grouped within a tuple. WHERE IN TUPLE(<A>) Rule is executed within the IF <B> = NULLORBLANK bounds of each (Where <B> is a fact in tuple <A>) occurrence of a tuple. WHERE IN TUPLE Means if the value of <B> within the tuple <A> is nullorblank. In this example the rule will only WHERE IN TUPLE (<A>) trigger if tuple <A> exists and if <B> (in <A>) is IF <B>…. null or blank. (Refer also IN TUPLE. The keyword is ‘WHERE’ optional). is used to denote the ‘xbrli’ IN TUPLE reporting taxonomy root. Indicates a given tuple or element is not nested Means in the tuple within another tuple. (\element This is used to differentiate definition) that is not within another tuple. elements that are repeated In this example, the implication is that the at different levels of the reporting taxonomy within tuple also exists under another tuple within the a given business product. collaboration.
WHERE …IN SET Used to validate data elements which are logically grouped within a set. Rule is executed within the bounds of each occurrence of a set. WHERE <A> IN SET(<B>). Refer also: {x}. WHERE ForeignCountry = ’us’ IN SET (RP{ForeignCountry}) Means execute the rule if the ForeignCountry dimension value is ‘us’ in the ForeignCountry dimension within the RP context. WHERE…. IN TUPLE (element definition) The WHERE and IN TUPLE keywords are used when tuple element explicits are required. The element including the definition is to be considered as a whole. (RP:pyde.xx.xx:AddressDetails.Line1.Text WHERE(TUPLE ELEMENT Address Usage = “BUS”) IN TUPLE(address2)) = NULLORBLANK. Means Line 1 of the business address of the Reporting Party is not present. Rule will trigger if: RP context is not present, or address2 tuple is not present, or address2 tuple with Address Usage = ‘BUS’ is not present, or in the address2 tuple with Address Usage = ‘BUS’ is not present. WHERE IN TUPLE Used to validate data elements which are logically grouped within a tuple. Rule is executed within the bounds of each occurrence of a tuple. WHERE IN TUPLE (<A>) IF <B>…. (Refer also IN TUPLE. The ‘WHERE’ keyword is optional). WHERE IN TUPLE(<A>) IF <B> = NULLORBLANK (Where <B> is a fact in tuple <A>) Means if the value of <B> within the tuple <A> is nullorblank. In this example the rule will only trigger if tuple <A> exists and if <B> (in <A>) is null or blank. (\element definition) ‘xbrli’ is used to denote the reporting taxonomy root. Indicates a given tuple or element is not nested within another tuple. This is used to differentiate elements that are repeated at different levels of the reporting taxonomy within a given business collaboration. IN TUPLE Means in the tuple that is not within another tuple. In this example, the implication is that the tuple also exists under another tuple within the product.
ATO-Validation-Rule-Expression.docx