ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
APPROVER_TYPE	Defines whether the step record represents a recipient or a group of recipients.			FORCIRS	FORCIRS_TYPE
CIRCULATION_ACTIVE_IND	Indicates if the circulation is available for use.			FOBCIRH	FOBCIRH_ACTIVE_IND
CIRCULATION_ACTIVITY_DATE	The date when the information for the circulation record in this table was entered or last updated.			FOBCIRH	FOBCIRH_ACTIVITY_DATE
CIRCULATION_BEGIN_DATE	Actual date and time that the circulation was started.			FOBCIRH	FOBCIRH_START_DATE
CIRCULATION_COMPLETE_DATE	Actual date and time that the circulation was completed.			FOBCIRH	FOBCIRH_COMPLETION_DATE
CIRCULATION_DATA_ORIGIN	Source system that created or updated the circulation row.			FOBCIRH	FOBCIRH_DATA_ORIGIN
CIRCULATION_DESC	Circulation description.			FOBCIRH	FOBCIRH_DESC
CIRCULATION_HEADER_CHANGE_IND	Determines if you can create a copy of the template and make modifications to the circulation.			FOBCIRH	FOBCIRH_HEADER_CHANGE_IND
CIRCULATION_KEY	Unique internal identification number of the header record.			FOBCIRH	FOBCIRH_ID
CIRCULATION_LOCK_OBJECT_IND	Determines if the source circulation object is locked and cannot be changed.			FOBCIRH	FOBCIRH_LOCK_OBJECT_IND
CIRCULATION_NAME	User-entered or system-generated name of the circulation.			FOBCIRH	FOBCIRH_NAME
CIRCULATION_ORDER	The order of this step in the overall Circulation.			FORCIRS	FORCIRS_ORDER
CIRCULATION_OWNER_PIDM	Pidm of owner responsible for circulation.			FOBCIRH	FOBCIRH_OWNER_PIDM
CIRCULATION_ROUTING_CHANGE_IND	Determines if you can create a copy of the template and make modifications to the circulation routing.			FOBCIRH	FOBCIRH_ROUTING_CHANGE_IND
CIRCULATION_STATUS	Reflects the current status of the Circulation.			FOBCIRH	FOBCIRH_STATUS
CIRCULATION_STEP_KEY	Unique internal identification number of the step record.			FORCIRS	FORCIRS_ID
CIRCULATION_SUCCESS_STATUS	The Approval Status to which the object is moved when the circulation is successful. This means that there are no disapprovals encountered in the Circulation.			FOBCIRH	FOBCIRH_SUCCESS_STATUS
CIRCULATION_SUPL_EMAIL_TEXT	Additional email text to be included on all emails to recipients.			FOBCIRH	FOBCIRH_SUPL_EMAIL_TEXT
CIRCULATION_TEMPLATE_IND	Indicates the circulation is a template circulation or not.			FOBCIRH	FOBCIRH_TEMPLATE_IND
CIRCULATION_TRIGGER_TYPE	The type of event that starts the Circulation.			FOBCIRH	FOBCIRH_TRIGGER_TYPE
CIRCULATION_TRIGGER_VALUE	The intended string value for a triggerType that would cause the circulation to be run.			FOBCIRH	FOBCIRH_TRIGGER_VALUE
CIRCULATION_TYPE	Circulation object type.			FOBCIRH	FOBCIRH_TYPE
CIRCULATION_USER_ID	The unique identification code of the user who last touched this circulation record.			FOBCIRH	FOBCIRH_USER_ID
CIRC_ALL_ORGANIZATIONS_IND	Defines whether this circulation is related to one organization or a hierarchy of organizations.			FOBCIRH	FOBCIRH_ALL_ORGANIZATIONS_IND
CIRC_TRIGGER_ENABLED_IND	Indicates the circulation trigger is enabled or not.			FOBCIRH	FOBCIRH_TRIGGER_ENABLED_IND
CURRENT_DATE	This is a the system current date (sysdate).			NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.			NA	NA
FOBCIRH_ID	Unique internal identification number of the source circulation record.			FOBCIRH	FOBCIRH_FOBCIRH_ID
FORCIRS_ID	Unique internal identification number of the circulation parent record to support hierarchical processing.			FORCIRS	FORCIRS_FORCIRS_ID
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
STEP_ACTIVITY_DATE	The date when the information for the step record was entered or last updated.			FORCIRS	FORCIRS_ACTIVITY_DATE
STEP_COMPLETE_IND	Indicates if this routing step is complete or not.			FORCIRS	FORCIRS_COMPLETE_IND
STEP_DATA_ORIGIN	Source system that created or updated the step row.			FORCIRS	FORCIRS_DATA_ORIGIN
STEP_DUPLICATE_IND	Indicates if this routing step is a duplicate or not.			FORCIRS	FORCIRS_DUPLICATE_IND
STEP_RESPONSES_REQUIRED	Used to establish the number of routing recipient responses required in order to declare this step complete.			FORCIRS	FORCIRS_RESPONSES_REQUIRED
STEP_USER_ID	The unique identification code of the user who last touched the step record.			FORCIRS	FORCIRS_USER_ID
ZONE_VALUE	Zone column for future use, not currently populated.			NA	NA

Ver: 8.3