Used to define the maximum length of a textual field. Definition of a valid text field pattern where a true response is given when a value passes all <a> <> TEXT(150). conditions. TEXT() Means the maximum number of characters Usage: TEXT(<a>) allowable within field <a> is 150. Where <a> = Maximum number of characters TRUE if the tested field is less than or equal to length <a> (Refer also: LENGTH) Used to signify that the element (in brackets) is a TUPLE(addressdetails2.xx.xx:AddressDetails) tuple a that Means the fields that have been defined as – ‘container’ TUPLE may contain a group of two belonging to the or more related data module. ‘addressdetails2.xx.xx:AddressDetails’ elements. A date that conforms to the IF CONVERT_TO_DATE <> VALID DATE VALID DATE xbrli:dateItemType Means if the converted date is not a valid date. datatype. Indicates that the rule WHERE execution is dependent on Refer WHERE IN CONTEXT, WHERE IN TUPLE (tuple/context/set) the tuple, context or set and WHERE…IN SET. existence. Used to validate data elements which are logically grouped within a WHERE IN CONTEXT(RP) context. IF <B> = NULLORBLANK Rule is executed within the (Where <B> is a fact in the RP context). bounds of each WHERE IN occurrence of a particular CONTEXT Means if the value of <B> within the RP context is context. null or blank. In this example the rule will only trigger if the RP context exists and if <B> (in the Usage: RP context) is null or blank. WHERE IN CONTEXT(<A>) IF <B>….
TEXT() Used to define the maximum length of a textual field. Definition of a valid text field pattern where a true response is given when a value passes all conditions. Usage: TEXT(<a>) Where <a> = Maximum number of characters TRUE if the tested field is less than or equal to length <a> (Refer also: LENGTH) <a> <> TEXT(150). Means the maximum number of characters allowable within field <a> is 150. TUPLE Used to signify that the element (in brackets) is a tuple – a ‘container’ that may contain a group of two or more related data elements. TUPLE(addressdetails2.xx.xx:AddressDetails) Means the fields that have been defined as belonging to the ‘addressdetails2.xx.xx:AddressDetails’ module. VALID DATE A date that conforms to the xbrli:dateItemType datatype. IF CONVERT_TO_DATE <> VALID DATE Means if the converted date is not a valid date. WHERE (tuple/context/set) Indicates that the rule execution is dependent on the tuple, context or set existence. Refer WHERE IN CONTEXT, WHERE IN TUPLE and WHERE…IN SET. WHERE IN CONTEXT Used to validate data elements which are logically grouped within a context. Rule is executed within the bounds of each occurrence of a particular context. Usage: WHERE IN CONTEXT(<A>) IF <B>…. WHERE IN CONTEXT(RP) IF <B> = NULLORBLANK (Where <B> is a fact in the RP context). Means if the value of <B> within the RP context is null or blank. In this example the rule will only trigger if the RP context exists and if <B> (in the RP context) is null or blank.
ATO-Validation-Rule-Expression.docx