Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Import Definition Rule Id |
The automatically generated primary key of the imp_defn_rule table. |
LONG |
Yes |
Import Definition Rule Column Index |
stores the index of the column (i.e in a csv file) or the name of the column (i.e database table) |
VARCHAR(255) |
Yes |
Import Definition Rule Text To Contain |
The text that will cause the rule to trigger a branch. |
VARCHAR(255) |
Yes |
Import Definition Rule Definition Id |
The reference for the item definition (currently for the CI type but want to be more general). |
LONG |
Yes |
Import Id |
FK to the import operation record in the existing import operation table. |
LONG |
No |
Import Definition Rule Status |
Status can be different based on the CI type, but will be a fk to the allowed values inside the defn table. |
LONG |
No |