Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACQUISITION_DATE	Date the asset was purchased within or outside of purchasing.	DATE	FFBMAST	FFBMAST_ACQD_DATE
ACTUAL_USEFUL_LIFE_YEARS	Estimated actual life of the asset used for depreciation.	NUMBER	FFBMAST	FFBMAST_EST_LIFE_YEARS
ADDITIONAL_SERIAL_NUMBER	Additional part serial number or vehicle identification number (VIN) for the fixed asset.	VARCHAR2(40)	FFBMAST	FFBMAST_PART_NUM_VEHICLE_TAG
ASSET_DESC	Fixed asset description.	VARCHAR2(60)	FFBMAST	FFBMAST_ASSET_DESC
ASSET_GIFT_IND	Indicates whether this asset was acquired as a gift.	VARCHAR2(1)	FFBMAST	FFBMAST_GIFT_IND
ASSET_STATUS	Indicates the current system maintained status for the fixed asset.	VARCHAR2(1)	FFBMAST	FFBMAST_SYSTEM_STATUS_CODE
ASSET_STATUS_DESC	Retrieved description for asset system status.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
ASSET_TYPE	Describes an asset category for depreciation purposes.	VARCHAR2(2)	FFBMAST	FFBMAST_ASTY_CODE
ASSET_TYPE_DESC	Asset type description.	VARCHAR2(35)	FTVASTY	FTVASTY_TITLE
BARCODE_NUMBER	Barcode number for the fixed asset.	VARCHAR2(12)	FFBMAST	FFBMAST_BARCODE_NUM
BOOK_VALUE_AMOUNT	User entered book value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_BOOK_AMT
CAPITALIZATION_DATE	Date the asset was declared for capitalization value.	DATE	FFBMAST	FFBMAST_CAP_DATE
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FFBMAST	FFBMAST_COAS_CODE_RESP
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
COMMODITY	User-defined code associated with this commodity.	VARCHAR2(10)	FFBMAST	FFBMAST_COMM_CODE
COMMODITY_DESC	Commodity description or title.	VARCHAR2(50)	FTVCOMM	FTVCOMM_DESC
CONDITION	Code used to define the asset condition.	VARCHAR2(3)	FFBMAST	FFBMAST_ACON_CODE
CONDITION_DESC	Condition description for the asset.	VARCHAR2(35)	FFVACON	FFVACON_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DEPRECIATION_FREQUENCY	Defined frequency (monthly, annually, semi-annually, quarterly) for the calculation of depreciation for this asset.	VARCHAR2(1)	FFBMAST	FFBMAST_DEPR_FREQ
DEPRECIATION_METHOD	Method of depreciation to be used for this fixed asset. Might include values like First Half All/Second Year None, Full Year, Take Half and Proportional.	VARCHAR2(2)	FFBMAST	FFBMAST_DEPR_CODE
DEPRECIATION_METHOD_DESC	Instructions as to how to handle the depreciation for an asset.	VARCHAR2(35)	FTVDEPR	FTVDEPR_TITLE
DEPRECIATION_START_DATE	Date on which the asset starts to depreciate.	DATE	FFBMAST	FFBMAST_DEPR_START_DATE
DISPOSAL_DATE	Date on which this asset was disposed.	DATE	FFBMAST	FFBMAST_DISP_DATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
EXTERNAL_REFERENCE_NUMBER	Externally assigned reference number for the fixed asset when available.	VARCHAR2(35)	FFBMAST	FFBMAST_EXT_REF_NUM
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(9)	FFBMAST	FFBMAST_GRNT_CODE
GRANT_LONG_TITLE	Grant description or title.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE
GRANT_TITLE	Shortened name or title for the grant.	VARCHAR2(35)	FRBGRNT	FRBGRNT_TITLE
INSURANCE_AMOUNT	User defined amount that is reported to the insurance company in the event of total loss.	NUMBER	FFBMAST	FFBMAST_INS_AMT
INVOICE	Invoice document number on which this fixed asset was paid.	VARCHAR2(8)	FFBMAST	FFBMAST_INVH_CODE
INVOICE_DATE	Date of the invoice.	DATE	FFBMAST	FFBMAST_INVH_DATE
INVOICE_ITEM	Invoice item number on which this fixed asset was ordered.	NUMBER	FFBMAST	FFBMAST_INVC_ITEM
IN_SERVICE_DATE	Date on which this asset was placed in service.	DATE	FFBMAST	FFBMAST_IN_SERV_DATE
LAST_ADJUSTMENT_DATE	Date the fixed asset value was last adjusted for any reason (capitalization, depreciation or any other adjustment).	DATE	FFBMAST	FFBMAST_ADJ_DATE
LAST_DEPRECIATION_DATE	Date on which the depreciation calculation was last performed.	DATE	FFBMAST	FFBMAST_LAST_DEPR_DATE
LAST_INVENTORY_DATE	Date on which this asset was last inventoried.	DATE	FFBMAST	FFBMAST_LAST_INVENTORY_DATE
LOCATION	Identification code of the physical location for the asset.	VARCHAR2(6)	FFBMAST	FFBMAST_LOCN_CODE_RESP
LOCATION_DESC	Extracted description or title of the associated location.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
MAKE	Make for the fixed asset usually associated with a car.	VARCHAR2(35)	FFBMAST	FFBMAST_MAKE
MANUFACTURER	Name of the manufacturer for the fixed asset.	VARCHAR2(35)	FFBMAST	FFBMAST_MANUFACTURER
MARKET_VALUE_AMOUNT	Market value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_MARKET_AMT
METHOD_OF_ACQUISITION	Code used to indicate the method used to acquire the asset.	VARCHAR2(2)	FFBMAST	FFBMAST_ACQM_CODE
METHOD_OF_ACQUISITION_DESC	Description of the method used to acquire the asset.	VARCHAR2(35)	FFVACQM	FFVACQM_DESC
METHOD_OF_DISPOSAL	Code used to define method of disposal associated with this fixed asset.	VARCHAR2(2)	FFBMAST	FFBMAST_DISP_CODE
METHOD_OF_DISPOSAL_DESC	Disposal method description.	VARCHAR2(35)	FFVDISP	FFVDISP_DESC
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
MODEL	Model number for the fixed asset.	VARCHAR2(30)	FFBMAST	FFBMAST_MODEL
NET_BOOK_VALUE_AMOUNT	Net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset not including attachment costs.	NUMBER	FUNCTION	FOKODSF.F_NET_BOOK_AMT
NORMAL_USEFUL_LIFE	Normal usable life expected for the asset.	NUMBER	FTVASTY	FTVASTY_STD_LIFE
ORGANIZATION_CODE	Identification accounting code used for the responsible department.	VARCHAR2(6)	FFBMAST	FFBMAST_ORGN_CODE_RESP
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC
ORIGINAL_CAPITALIZED_AMOUNT	Calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset including attachment costs.	NUMBER	FUNCTION	FOKODSF.F_CAPITALIZED_AMT
ORIGINAL_COST_AMOUNT	Calculated as the original cost of the asset excluding attachment costs.	NUMBER	FUNCTION	FOKODSF.F_COST_AMT
ORIGINATION_TAG_CANCEL_DATE	Date the new system tag number is assigned and the old tag number retired.	DATE	FFBMAST	FFBMAST_OTAG_CANCEL_DATE
ORIGINATION_TAG_NUMBER	System generated tag number assigned when the asset is acquired.	VARCHAR2(9)	FFBMAST	FFBMAST_OTAG_CODE
ORIGINATION_TAG_NUMBER_DATE	Date the system tag number is assigned.	DATE	FFBMAST	FFBMAST_OTAG_DATE
ORIGINATION_TAG_NUMBER_OLD	Old tag number when a new system tag number is assigned.	VARCHAR2(9)	FFBMAST	FFBMAST_OTAG_CODE_OLD
ORIGINATION_TAG_NUMBER_PRIMARY	System tag number for the primary fixed asset when multiple assets are linked together.	VARCHAR2(9)	FFBMAST	FFBMAST_OTAG_CODE_PRIMARY
PERMANENT_TAG_NUMBER	Unique user defined or system generated one-up number for this asset.	VARCHAR2(9)	FFBMAST	FFBMAST_PTAG_CODE
PERMANENT_TAG_NUMBER_DATE	Date the permanent tag number is assigned to the fixed asset.	DATE	FFBMAST	FFBMAST_PTAG_DATE
PERSON_MANAGER_UID	System internally generated identification number to uniquely identify the equipment manager responsible for this fixed asset.	NUMBER	FFBMAST	FFBMAST_EQUIP_MGR_PIDM
PERSON_UID	System generated unique internal identification number assigned to custodian assigned to this asset.	NUMBER	FFBMAST	FFBMAST_CUSTODIAN_PIDM
PRIOR_LAST_DEPRECIATION_DATE	Next to last date on which the depreciation calculation was last performed.	DATE	FFBMAST	FFBMAST_OLD_LAST_DEPR_DATE
PURCHASE_ORDER	Purchase order number on which this fixed asset was ordered.	VARCHAR2(8)	FFBMAST	FFBMAST_POHD_CODE
PURCHASE_ORDER_ITEM	Purchase order item number on which this fixed asset was ordered.	NUMBER	FFBMAST	FFBMAST_PODT_ITEM
RECEIVED_DATE	Date the purchase order item was received.	DATE	FFBMAST	FFBMAST_RCHD_DATE
RECEIVER	Unique number for the receiving document associated with the asset created in receiving.	VARCHAR2(8)	FFBMAST	FFBMAST_RCHD_CODE
REMAINING_LIFE_MONTHS	Calculated as months as the depreciation frequency being used is defined as monthly for the remaining life of the asset. This is null if the depreciation frequency is not monthly.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE
REMAINING_LIFE_QUARTERS	Calculated as quarters as the depreciation frequency being used is defined as quarterly for the remaining life of the asset. This is null if the depreciation frequency is not quarterly.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE
REMAINING_LIFE_SEMI_ANNUAL	Calculated as number of half years as the depreciation frequency being used is defined as semi-annual for the remaining life of the asset. This is null if the depreciation frequency is not semi-annual.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE
REMAINING_LIFE_YEARS	Calculated as years as the depreciation frequency being used is defined as annual for remaining life of the asset. This is null if the depreciation frequency is not annual.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE
REPLACEMENT_VALUE_AMOUNT	User-defined replacement value amount for this fixed asset.	NUMBER	FFBMAST	FFBMAST_REPL_AMT
SALVAGE_AMOUNT	Amount below which this fixed asset cannot be depreciated.	NUMBER	FFBMAST	FFBMAST_SALVAGE_AMT
SERIAL_NUMBER	Serial number or vehicle identification number (VIN) for the fixed asset.	VARCHAR2(40)	FFBMAST	FFBMAST_SERIAL_NUM_VIN
SOURCE_DOCUMENT	Document number for the source document outside of fixed assets used to track the asset when the origination tag number was created.	VARCHAR2(8)	FFBMAST	FFBMAST_OTHER_SRC_DOC_CODE
SOURCE_DOCUMENT_DATE	Date that the source document was created.	DATE	FFBMAST	FFBMAST_DTAG_ACTIVITY_DATE
SOURCE_DOCUMENT_SEQ_NUMBER	Document system assigned sequence number to the accounting line for the source document used for the fixed asset.	NUMBER	FFBMAST	FFBMAST_OTHER_SRC_SEQ_NUM
SOURCE_DOCUMENT_SUB_NUMBER	Document submission number for the source document used for fixed assets. Like an auto submission for a journal voucher.	NUMBER	FFBMAST	FFBMAST_OTHER_SRC_SUB_NUM
SOURCE_DOCUMENT_TYPE	Document type sequence number for the source document used for the fixed asset.	NUMBER	FFBMAST	FFBMAST_OTHER_SRC_DTYP_NUM
SUBORDINATE_TYPE	When the fixed asset is not the primary, indicates how the subordinate fixed asset is linked. It can either be linked to depreciate with the primary as an asset or linked and depreciated separately as a component.	VARCHAR2(1)	FFBMAST	FFBMAST_SUBORDINATE_TYPE
SUBORDINATE_TYPE_DESC	Subordinate type will indicated whether this is a component of or attached to when this is not the origination tag number that is primary.	VARCHAR2(30)	CALCULATION	DECODE(FFBMAST_SUBORDINATE_TYPE)
TITLED_TO	Represents the title-to designation at the institution.	VARCHAR2(2)	FFBMAST	FFBMAST_TTST_CODE
TITLED_TO_DESC	Name from the titled-to designation.	VARCHAR2(35)	FFVTTST	FFVTTST_DESC
TOTAL_NET_BOOK_VALUE_AMOUNT	Total net book value calculated as original cost plus or minus any adjustments minus accumulated depreciation for the asset including attachment costs.	NUMBER	FUNCTION	FOKODSF.F_TOTAL_BOOK_AMT
TOTAL_ORIGINAL_COST_AMOUNT	Sum of original cost of the asset and attachment costs.	NUMBER	FUNCTION	FOKODSF.F_TOTAL_COST_AMT
TRANSFER_DATE	Date on which the asset was last transferred.	DATE	FFBMAST	FFBMAST_TRANSFER_DATE
USER_STATUS	Indicates the current user assigned status of the fixed asset.	VARCHAR2(1)	FFBMAST	FFBMAST_USER_STATUS_CODE
USER_STATUS_DESC	Retrieves description for asset user status.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
VENDOR_UID	System generated unique internal identification number used to access the vendor.	NUMBER	FFBMAST	FFBMAST_VEND_PIDM
WORK_IN_PROGRESS_IND	For assets such as buildings, defines if work is in progress.	VARCHAR2(1)	FFBMAST	FFBMAST_WORK_IN_PROG_IND
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: