SCRIPT table

Edit online

The SCRIPT¹ table stores predefined script rule parameters. Each row represents one parameter of a rule. A rule might consist of several rows that represent multiple attributes from the person schema to be concatenated. For example, the predefined rule, firstinitial+lastname, is a concatenation of two person attributes: givenname and sn.

Table 1. SCRIPT table
Column Name	Description	Data type
`TYPE`^*	A character that represents the type of policy to which this rule is applied. Primary key. Values include: A – Adoption rule I – Identity policy	Character (1)
`ID`^*	Unique identifier (key) of the rule. Primary key.	Character (50)
`JOIN_ORDER`^*	A number that represents the order for the attribute in concatenation. Primary key.	Numeric
`PERSON_ATTRIBUTE`^*	The person attribute where the value is obtained and concatenated; for example, `givenname`.	Character (100)
`FIRST_LAST`	A number that is used to get the substring of the person attribute. Values include: 0 – Use the whole value. -n (minus n) – Use the last n characters. n – Use the first n characters.	Numeric
`CONCATENATE_CHAR`	Concatenation character, which concatenates person attributes.	Character (10)

^* Indicates the column is required and not null.

¹ Indicates the column or the value is added in release 5.0.