Default value columns for rule books

Sheet Field Optional Default value
RuleBook RuleBook Name No
Description Yes
Expiry No Never Expires
Expiration Date No: If the Expiry column has the value 'Expires'.
Status No Enabled
CreatedBy Yes The logged in user in IRC who is a rule book 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
ConnectionName Yes All

RBAdditionalInfo

RuleBook Name No
Rule Owner/Rule BPO No
ProfileName
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 hasexpirationdate.
Priority Yes Informational
Status Yes Enabled
RuleAdditionalInfo RuleBook Name No
Rule Name No
RBO/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 Rule Actions Yes
Rulebook Name Yes
Rule Name Yes
Action ID Yes
Name Yes
Description Yes
Additional Info Schema Yes
RuleDetails RuleBook Name No
Rule Name No
ALL/ANY
Note: For more details on how these operators function while creating a rule, see User Guide.
No Any
Side No LHS
Responsibility Object Yes
Responsibility Description Yes
Responsibility Friendly Name Yes
Responsibility Application Name Yes
Responsibility Operating Unit. Yes
Responsibility Set of Books Yes
Menu Operator Yes
Menu Prompt Name Yes
Menu Prompt Operator Yes
Menu Objects Yes
Menu Description Yes
Menu Friendly Name Yes
Function Operator Yes
Function Prompt Operator Yes
Function Objects Yes
Function Friendly Name Yes
Function Type Yes
Function Form Name Yes
Function Parameters Yes
Function Prompt Name Yes
Read-Only Functions Yes
Sub Function Name Yes
Sub Function Friendly Name Yes
Sub Function Type Yes
Sub Function Form Name Yes
Sub Function Parameters Yes
Sub Function Prompt Name Yes
Read-Only Sub-Functions Yes
Sub Function Operator Yes
Sub Function Prompt Operator Yes
Concurrent Program Objects Yes
Concurrent Program Friendly Name Yes
Concurrent Program Description Yes
Concurrent Program Application Name Yes
Profile Option Operator No ANY
Profile Option Name Yes
Profile Option Friendly Name Yes
Profile Option Description Yes
Profile Option Value Operator Yes
Profile Option Value No, if Profile Option Value Name is provided.
Treat Option Value as Parameter No NO
Exclusions RuleBook Name No
Rule Name No
Users Yes
Responsibility Yes
Display Name Yes
Attribute Name Yes
Expiration Date Yes
Operator Yes
Attribute Value Yes
Responsibility Parameter Yes
User Parameter Yes
Attribute Parameter Yes
Parameter Attribute Name Yes
Parameter Operator Yes
Parameter Attribute Value Yes
Parameter Name Yes
Documentation Yes
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