Target Column	Business Definition	Database Data Type	Source Name	Source Column
APPROVER_TYPE	Defines whether the step record represents a recipient or a group of recipients.	VARCHAR2(1)	FORCIRS	FORCIRS_TYPE
CIRCULATION_ACTIVE_IND	Indicates if the circulation is available for use.	VARCHAR2(1)	FOBCIRH	FOBCIRH_ACTIVE_IND
CIRCULATION_ACTIVITY_DATE	The date when the information for the circulation record in this table was entered or last updated.	DATE	FOBCIRH	FOBCIRH_ACTIVITY_DATE
CIRCULATION_BEGIN_DATE	Actual date and time that the circulation was started.	DATE	FOBCIRH	FOBCIRH_START_DATE
CIRCULATION_COMPLETE_DATE	Actual date and time that the circulation was completed.	DATE	FOBCIRH	FOBCIRH_COMPLETION_DATE
CIRCULATION_DATA_ORIGIN	Source system that created or updated the circulation row.	VARCHAR2(30)	FOBCIRH	FOBCIRH_DATA_ORIGIN
CIRCULATION_DESC	Circulation description.	VARCHAR2(255)	FOBCIRH	FOBCIRH_DESC
CIRCULATION_HEADER_CHANGE_IND	Determines if you can create a copy of the template and make modifications to the circulation.	VARCHAR2(1)	FOBCIRH	FOBCIRH_HEADER_CHANGE_IND
CIRCULATION_KEY	Unique internal identification number of the header record.	NUMBER	FOBCIRH	FOBCIRH_ID
CIRCULATION_LOCK_OBJECT_IND	Determines if the source circulation object is locked and cannot be changed.	VARCHAR2(1)	FOBCIRH	FOBCIRH_LOCK_OBJECT_IND
CIRCULATION_NAME	User-entered or system-generated name of the circulation.	VARCHAR2(60)	FOBCIRH	FOBCIRH_NAME
CIRCULATION_ORDER	The order of this step in the overall Circulation.	NUMBER	FORCIRS	FORCIRS_ORDER
CIRCULATION_OWNER_PIDM	Pidm of owner responsible for circulation.	NUMBER	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.	VARCHAR2(1)	FOBCIRH	FOBCIRH_ROUTING_CHANGE_IND
CIRCULATION_STATUS	Reflects the current status of the Circulation.	VARCHAR2(50)	FOBCIRH	FOBCIRH_STATUS
CIRCULATION_STEP_KEY	Unique internal identification number of the step record.	NUMBER	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.	VARCHAR2(50)	FOBCIRH	FOBCIRH_SUCCESS_STATUS
CIRCULATION_SUPL_EMAIL_TEXT	Additional email text to be included on all emails to recipients.	VARCHAR2(4000)	FOBCIRH	FOBCIRH_SUPL_EMAIL_TEXT
CIRCULATION_TEMPLATE_IND	Indicates the circulation is a template circulation or not.	VARCHAR2(1)	FOBCIRH	FOBCIRH_TEMPLATE_IND
CIRCULATION_TRIGGER_TYPE	The type of event that starts the Circulation.	VARCHAR2(50)	FOBCIRH	FOBCIRH_TRIGGER_TYPE
CIRCULATION_TRIGGER_VALUE	The intended string value for a triggerType that would cause the circulation to be run.	VARCHAR2(50)	FOBCIRH	FOBCIRH_TRIGGER_VALUE
CIRCULATION_TYPE	Circulation object type.	VARCHAR2(50)	FOBCIRH	FOBCIRH_TYPE
CIRCULATION_USER_ID	The unique identification code of the user who last touched this circulation record.	VARCHAR2(30)	FOBCIRH	FOBCIRH_USER_ID
CIRC_ALL_ORGANIZATIONS_IND	Defines whether this circulation is related to one organization or a hierarchy of organizations.	VARCHAR2(1)	FOBCIRH	FOBCIRH_ALL_ORGANIZATIONS_IND
CIRC_TRIGGER_ENABLED_IND	Indicates the circulation trigger is enabled or not.	VARCHAR2(1)	FOBCIRH	FOBCIRH_TRIGGER_ENABLED_IND
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
FOBCIRH_ID	Unique internal identification number of the source circulation record.	NUMBER	FOBCIRH	FOBCIRH_FOBCIRH_ID
FORCIRS_ID	Unique internal identification number of the circulation parent record to support hierarchical processing.	NUMBER	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.	VARCHAR2(30)	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.	VARCHAR2(6)	NA	NA
STEP_ACTIVITY_DATE	The date when the information for the step record was entered or last updated.	DATE	FORCIRS	FORCIRS_ACTIVITY_DATE
STEP_COMPLETE_IND	Indicates if this routing step is complete or not.	VARCHAR2(1)	FORCIRS	FORCIRS_COMPLETE_IND
STEP_DATA_ORIGIN	Source system that created or updated the step row.	VARCHAR2(30)	FORCIRS	FORCIRS_DATA_ORIGIN
STEP_DUPLICATE_IND	Indicates if this routing step is a duplicate or not.	VARCHAR2(1)	FORCIRS	FORCIRS_DUPLICATE_IND
STEP_RESPONSES_REQUIRED	Used to establish the number of routing recipient responses required in order to declare this step complete.	NUMBER	FORCIRS	FORCIRS_RESPONSES_REQUIRED
STEP_USER_ID	The unique identification code of the user who last touched the step record.	VARCHAR2(30)	FORCIRS	FORCIRS_USER_ID
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: