| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
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
|
Unique internal identification number of the approval history record.
|
NUMBER
|
FTRRACIR FTRRRCIR
|
ID ID
|
|
CIRCULATION_KEY
|
Unique internal identification number of the circulation header record.
|
NUMBER
|
FTRRACIR FTRRRCIR
|
FOBCIRH_ID FOBCIRH_ID
|
|
CURRENT_DATE
|
This is a the system current date (sysdate).
|
DATE
|
NA
|
SYSDATE
|
|
DOC_TYPE
|
Document type.
|
NUMBER
|
CONSTANT CONSTANT
|
85 86
|
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
|
REQUEST_KEY
|
Unique interanal identification number of the request record.
|
NUMBER
|
FTRRACIR FTRRRCIR
|
FTRBAUTH_ID FTRBREMB_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 column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|