Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
APPROVER_TYPE	Approver Type	Defines whether the step record represents a recipient or a group of recipients.	VARCHAR2(1)		FORCIRS	FORCIRS_TYPE
CIRCULATION_ACTIVE_IND	Circulation Active Indicator	Indicates if the circulation is available for use.	VARCHAR2(1)		FOBCIRH	FOBCIRH_ACTIVE_IND
CIRCULATION_ACTIVITY_DATE	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	Circulation Begin Date	Actual date and time that the circulation was started.	DATE		FOBCIRH	FOBCIRH_START_DATE
CIRCULATION_COMPLETE_DATE	Circulation Completion Date	Actual date and time that the circulation was completed.	DATE		FOBCIRH	FOBCIRH_COMPLETION_DATE
CIRCULATION_DATA_ORIGIN	Circulation Data Origin	Source system that created or updated the circulation row.	VARCHAR2(30)		FOBCIRH	FOBCIRH_DATA_ORIGIN
CIRCULATION_DESC	Circulation Description	Circulation description.	VARCHAR2(255)		FOBCIRH	FOBCIRH_DESC
CIRCULATION_HEADER_CHANGE_IND	Circulation Header Change Indicator	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	Circulation KEY	Unique internal identification number of the header record.	NUMBER(19)		FOBCIRH	FOBCIRH_ID
CIRCULATION_LOCK_OBJECT_IND	Circulation Lock Object Indicator	Determines if the source circulation object is locked and cannot be changed.	VARCHAR2(1)		FOBCIRH	FOBCIRH_LOCK_OBJECT_IND
CIRCULATION_NAME	Circulation Name	User-entered or system-generated name of the circulation.	VARCHAR2(60)		FOBCIRH	FOBCIRH_NAME
CIRCULATION_ORDER	Circulation Order	The order of this step in the overall Circulation.	NUMBER(8)		FORCIRS	FORCIRS_ORDER
CIRCULATION_OWNER_PIDM	Circulation Owner Pidm	Pidm of owner responsible for circulation.	NUMBER(8)		FOBCIRH	FOBCIRH_OWNER_PIDM
CIRCULATION_ROUTING_CHANGE_IND	Circulation Routing Change Indicator	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	Circulation Status	Reflects the current status of the Circulation.	VARCHAR2(50)		FOBCIRH	FOBCIRH_STATUS
CIRCULATION_STEP_KEY	Circulation Step KEY	Unique internal identification number of the step record.	NUMBER(19)		FORCIRS	FORCIRS_ID
CIRCULATION_SUCCESS_STATUS	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	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	Circulation Template Indicator	Indicates the circulation is a template circulation or not.	VARCHAR2(1)		FOBCIRH	FOBCIRH_TEMPLATE_IND
CIRCULATION_TRIGGER_TYPE	Circulation Trigger Type	The type of event that starts the Circulation.	VARCHAR2(50)		FOBCIRH	FOBCIRH_TRIGGER_TYPE
CIRCULATION_TRIGGER_VALUE	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 Type	Circulation object type.	VARCHAR2(50)		FOBCIRH	FOBCIRH_TYPE
CIRCULATION_USER_ID	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	Circ All Organizations Indicator	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	Circ Trigger Enabled Indicator	Indicates the circulation trigger is enabled or not.	VARCHAR2(1)		FOBCIRH	FOBCIRH_TRIGGER_ENABLED_IND
CURRENT_DATE	Current Date	This is a the system current date (sysdate).	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
FOBCIRH_ID	Fobcirh ID	Unique internal identification number of the source circulation record.	NUMBER(19)		FOBCIRH	FOBCIRH_FOBCIRH_ID
FORCIRS_ID	Forcirs ID	Unique internal identification number of the circulation parent record to support hierarchical processing.	NUMBER(19)		FORCIRS	FORCIRS_FORCIRS_ID
MIF_DESC	MIF Description	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	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	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	Step Completion Indicator	Indicates if this routing step is complete or not.	VARCHAR2(1)		FORCIRS	FORCIRS_COMPLETE_IND
STEP_DATA_ORIGIN	Step Data Origin	Source system that created or updated the step row.	VARCHAR2(30)		FORCIRS	FORCIRS_DATA_ORIGIN
STEP_DUPLICATE_IND	Step Duplicate Indicator	Indicates if this routing step is a duplicate or not.	VARCHAR2(1)		FORCIRS	FORCIRS_DUPLICATE_IND
STEP_RESPONSES_REQUIRED	Step Responses Required	Used to establish the number of routing recipient responses required in order to declare this step complete.	NUMBER(3)		FORCIRS	FORCIRS_RESPONSES_REQUIRED
STEP_USER_ID	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 Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: