SCRIPT table

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.

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 rul. I – Identity polic.	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 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.

Parent topic: Services tables