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

Ver: