Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	The date when the information for the record in this table was entered or last updated.	DATE	FTRRACIR FTRRRCIR	ACTIVITY_DATE ACTIVITY_DATE	NO NO	NO
APPROVAL_HISTORY_KEY	Unique internal identification number of the approval history record.	NUMBER	FTRRACIR FTRRRCIR	ID ID	NO NO	NO
CIRCULATION_KEY	Unique internal identification number of the circulation header record.	NUMBER	FTRRACIR FTRRRCIR	FOBCIRH_ID FOBCIRH_ID	NO NO	NO
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE	NO	NO
DOC_TYPE	Document type.	NUMBER	CONSTANT CONSTANT	85 86	NO NO	NO
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
REQUEST_KEY	Unique interanal identification number of the request record.	NUMBER	FTRRACIR FTRRRCIR	FTRBAUTH_ID FTRBREMB_ID	NO NO	NO
USER_ID	The unique identification code of the user who last touched this record.	VARCHAR2(30)	FTRRACIR FTRRRCIR	USER_ID USER_ID	NO NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: