Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(4)		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	Book Value Amount	User entered book value amount for this fixed asset.	NUMBER(17,2)		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	Insurance Amount	User defined amount that is reported to the insurance company in the event of total loss.	NUMBER(17,2)		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(4)		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	Market value amount for this fixed asset.	NUMBER(17,2)		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(4)		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(8)		FFBMAST	FFBMAST_EQUIP_MGR_PIDM
PERSON_UID		System generated unique internal identification number assigned to custodian assigned to this asset.	NUMBER(8)		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(4)		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(4)		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	Replacement Value Amount	User-defined replacement value amount for this fixed asset.	NUMBER(17,2)		FFBMAST	FFBMAST_REPL_AMT
SALVAGE_AMOUNT	Salvage Amount	Amount below which this fixed asset cannot be depreciated.	NUMBER(17,2)		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(4)		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(2)		FFBMAST	FFBMAST_OTHER_SRC_SUB_NUM
SOURCE_DOCUMENT_TYPE		Document type sequence number for the source document used for the fixed asset.	NUMBER(2)		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(8)		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: