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 |