Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACTIVITY_DATE	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
APPROVAL_HISTORY_KEY	Approval History KEY	Unique internal identification number of the approval history record.	NUMBER(19)		FTRRACIR FTRRRCIR	ID ID
CIRCULATION_KEY	Circulation KEY	Unique internal identification number of the circulation header record.	NUMBER(19)		FTRRACIR FTRRRCIR	FOBCIRH_ID FOBCIRH_ID
CURRENT_DATE	Current Date	This is a the system current date (sysdate).	DATE		NA	SYSDATE
DOC_TYPE	Document Type	Document type	NUMBER		CONSTANT CONSTANT	85 86
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
REQUEST_KEY	Request KEY	Unique interanal identification number of the request record.	NUMBER(19)		FTRRACIR FTRRRCIR	FTRBAUTH_ID FTRBREMB_ID
USER_ID	User ID	The unique identification code of the user who last touched this record.	VARCHAR2(30)		FTRRACIR FTRRRCIR	USER_ID USER_ID
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: