Default value columns for rules template
| Worksheet | Field | Optional | Default value |
|---|---|---|---|
| RuleBook | RuleBook Name | No | |
| Description | Yes | ||
| Expiry | No | Never Expires | |
| ExpirationDate | No: If the Expiry column has the value ‘Expires’. | ||
| Status | No | Enabled | |
| CreatedBy | Yes | The logged in User in IRC who is a creator. | |
| CreatedOn | Yes | Default date picked up from IRC. | |
| LastUpdatedOn | Yes | Current Date | |
| Infor Risk & Compliance Insights
Note: Ensure that you do not make any changes to the template
files and that you maintain a default value of -1.
|
Yes: Enter '1' for Authorizations Insight and '2' for Process Insight. | ||
| LockStatus | No | Unlocked | |
| ConnectionID | Yes | -1 | |
| Connection Name | Yes | All | |
| RBAdditionalInfo | RuleBook Name | No | |
| RBO/BPO | No | ||
| Profile Name
Note: If this mandatory field is empty, the signed-in user will
be considered the rule book owner.
|
No | ||
| First Name | Yes | ||
| Last Name | Yes | ||
| Additional Status | Yes | ||
| Supporting Documentation Name | Yes | ||
| Supporting Documentation Link | No, if supporting documentation name is provided. | ||
| Rule Book Actions | RuleBook Name | Yes | |
| Action ID | Yes | ||
| Name | Yes | ||
| Description | Yes | ||
| Additional Info Schema | Yes
Note: This field is hidden in the template and must be edited by
advanced users only. Values entered in this field must be well formed XML
strings.
|
||
| Additional Info | Yes
Note: This field is hidden in the template and must be edited by
advanced users only. Values entered in this field must be well formed XML
strings.
|
||
| Rules | RuleBook Name | No | |
| Rule Name | No | ||
| Type | No | ||
| Description | Yes | ||
| Control Objectives | Yes | ||
| Documentation | Yes | ||
| Expiry | No | Never Expires | |
| Expiration Date | No: If the Expiry column has the value has expiration date. | ||
| Priority | Yes | Informational | |
| Status | Yes | Enabled | |
| RuleAdditionalInfo | RuleBook Name | No | |
| Rule Name | No | ||
| Rule Owner/Rule BPO | Yes | ||
| Profile Name | Yes | ||
| First Name
Note: If this field is empty, the signed-in user will be
considered the rule book owner.
|
No | ||
| Last Name
Note: If this field is empty, the signed-in user will be
considered the rule book owner.
|
Yes | ||
| Additional Status | Yes | ||
| Category | Yes | ||
| Control Number | Yes | ||
| Parameter List | Yes | ||
| Supporting Documentation Name | Yes | ||
| Supporting Documentation Link | No, if supporting documentation name is provided. | ||
| Rule Actions | Rulebook Name | Yes | |
| Rule Name | Yes | ||
| Action ID | Yes | ||
| Name | Yes | ||
| Description | Yes | ||
| Additional Info Schema
Note: This filed is hidden in the template. it must be edited by
advanced users only. Values entered must be well formed XML strings.
|
Yes | ||
| Rule Details | RuleBook Name | No | |
| Rule Name | No | ||
| ALL/ANY
Note: For more details on how these operators function while
creating a rule, refer see the
User Guide.
|
No | Any | |
| Side | No | ||
| TxnObjects | Yes | ||
| TxnObjectDescription | Yes | ||
| Sequence
Note: In case of multiple excel rule books, the output files can
be zipped and uploaded to IRC.
|
Yes | ||
| AuthObject | Yes | ||
| Appl
Note: In case of multiple excel rule books, the output files can
be zipped and uploaded to IRC.
|
No | SAP | |
| AuthObj Description | Yes | ||
| Attribute Name | Yes | ||
| Attribute Description | Yes | ||
| Attribute Operator | Yes | ||
| Attribute Value | Yes | ||
| Attribute Value Description | Yes | ||
| Treat * as a Literal | No | No | |
| Treat Attribute value as a Parameter | No | No | |
| Exclusions | RuleBookName | No | |
| Rule Name | No | ||
| Expiration Date | No | ||
| Users | Yes | ||
| Roles | Yes | ||
| Display Name
Note: The display name includes the attribute name, operator and
attribute value.
|
Yes | ||
| Attribute Name | Yes | ||
| Operator | Yes | ||
| Attribute Value | Yes | ||
| Role Parameter | Yes | ||
| UserParameter | Yes | ||
| Attribute Parameter | Yes | ||
| Parameter Attribute Name | Yes | ||
| Parameter Operator | Yes | ||
| Parameter Attribute Value | Yes | ||
| Parameter Name | Yes | ||
| Documentation | |||
| CCs | Yes | ||
| ParameterID | Yes | ||
| ParameterValue | Yes | ||
| ParameterListName | Yes | ||
| ParameterListID | Yes | ||
| Compensating Controls | Rulebook Name | No | |
| Rule Name | No | ||
| CCs | Yes | ||
| Control Text | Yes | ||
| Status | Yes | ||
| Valid From | Yes | ||
| Expiration Flag | Yes | ||
| Expiration Date | Yes | ||
| Last Updated By | Yes | ||
| Last Updated On | Yes | ||
| Created By | Yes | ||
| Created On | Yes | ||
| Param List ID | Yes | ||
| Param List Name | Yes | ||
| Assignment Expiry | Yes | ||
| Keywords | Rule Name | No | |
| Name | No | ||
| Description | Yes |