SA Parm Type

PARM_TYPE_ID is simply a number (up to 10 digits long) prefixed with the word PTYPE. The number is generated by an Oracle sequence.

Contains the name of the parameter type.

Used to avoid having active parameter types and deactivated types with the same PHYSICAL_NAME cause a unique key violation.

This is required for all user defined parameter types. There will be 5 predefined base types from which all other parameter types are derived: VARCHAR2, DATE, NUMBER, LONG and BOOLEAN. These will be uneditable and the only parameter types with NULL in the parent field.

Indicates whether the parameter is currently valid. Because of the complex interrelationships between parameters, exceptions, events, rules, etc., ARI uses an abandon in place strategy for dealing with obsolete data. Rather than deleting a parameter (or event or exception), ARI simply marks it as being no longer active. An inactive parameter is no longer available through the GUI. A parameter is deactivated when it is changed (the old version is deactivated and a new version takes its place) or when its realm is deactivated.