Reporting View Target: FIXED_ASSET_DEPRECIATED

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

Banner Operational Data Store
Reporting View Target: FIXED_ASSET_DEPRECIATED_ITEM

Description Contains asset depreciation controls and summarized information like depreciation start date, asset type, useful life, remaining useful life, depreciation method, depreciation frequency, last depreciation date, depreciation amounts (total, net, old), and salvage amount.
Key & Frequency One row per asset origination tag number.
Recommended Search Columns ORIGINATION_TAG_NUMBER

Target Column Business Name Business Definition Database Data Type Source Name Source Column

ACTUAL_USEFUL_LIFE_YEARS Actual Useful Life Years Estimated actual life of the asset used for depreciation. NUMBER
FFBMAST

FFBMAST_EST_LIFE_YEARS

ADJUSTED_AMOUNT Adjusted Amount Summarized amount for all accounting adjustments to the original value of the fixed asset. Uses the most current change sequence number. Represents the gain or loss amount when the asset is sold or written off or adjusted for any other reason. NUMBER
FFRMASA

FFRMASA_ADJ_AMT

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

ASSET_AMOUNT Asset Amount Current summarized original cost of asset including accounting adjustments. NUMBER
FFRMASA

FFRMASA_AMT

DEPRECIATION_FREQUENCY Depreciation Frequency Defined frequency (monthly, annually, semi-annually, quarterly) for the calculation of depreciation for this asset. VARCHAR2(63)
FFBMAST

FFBMAST_DEPR_FREQ

DEPRECIATION_METHOD 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(63)
FFBMAST

FFBMAST_DEPR_CODE

DEPRECIATION_METHOD_DESC Depreciation Method Description Instructions as to how to handle the depreciation for an asset. VARCHAR2(255)
FTVDEPR

FTVDEPR_TITLE

DEPRECIATION_START_DATE Depreciation Start Date Date on which the asset starts to depreciate. DATE
FFBMAST

FFBMAST_DEPR_START_DATE

LAST_DEPRECIATION_DATE Last Depreciation Date Date on which the depreciation calculation was last performed. DATE
FFBMAST

FFBMAST_LAST_DEPR_DATE

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NET_BOOK_VALUE_AMOUNT 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

NET_DEPRECIATION_AMOUNT Net Depreciation Amount Summarization of all current depreciation amounts used for depreciation. Uses the most current change sequence number. NUMBER
FFRMASA

FFRMASA_NEW_NET_DEPR_AMT

OLD_DEPRECIATION_AMOUNT Old Depreciation Amount Summarization of all the depreciation amounts used last time for depreciation. Uses the most current change sequence number. NUMBER
FFRMASA

FFRMASA_OLD_NET_DEPR_AMT

ORIGINATION_TAG_NUMBER Origination Tag Number System generated tag number assigned when the asset is acquired. VARCHAR2(63)
FFRMASA

FFRMASA_OTAG_CODE

PERMANENT_TAG_NUMBER Permanent Tag Number Unique user defined or system generated one-up number for this asset. VARCHAR2(63)
FFBMAST

FFBMAST_PTAG_CODE

PRIOR_LAST_DEPRECIATION_DATE Prior Last Depreciation Date Next to last date on which the depreciation calculation was last performed. DATE
FFBMAST

FFBMAST_OLD_LAST_DEPR_DATE

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

REMAINING_LIFE_MONTHS Remaining Life Months Calculated as months as the depreciation frequency being used is defined as monthly for remaining life of the asset. This is null if the depreciation frequency is not monthly. NUMBER
FUNCTION

FOKODSF.F_REMAINING_LIFE

REMAINING_LIFE_QUARTERS 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 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 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

SALVAGE_AMOUNT Salvage Amount Amount below which this fixed asset cannot be depreciated. NUMBER
FFBMAST

FFBMAST_SALVAGE_AMT

TOTAL_DEPRECIATION_AMOUNT Total Depreciation Amount Summarization of all accounting depreciation amounts taken during the life to date for this asset. Uses the most current change sequence number. NUMBER
FFRMASA

FFRMASA_DEPR_ACCUM_AMT

TOTAL_NET_BOOK_VALUE_AMOUNT 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

Ver: 9.2

Description	Contains asset depreciation controls and summarized information like depreciation start date, asset type, useful life, remaining useful life, depreciation method, depreciation frequency, last depreciation date, depreciation amounts (total, net, old), and salvage amount.
Key & Frequency	One row per asset origination tag number.
Recommended Search Columns	ORIGINATION_TAG_NUMBER

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTUAL_USEFUL_LIFE_YEARS	Actual Useful Life Years	Estimated actual life of the asset used for depreciation.	NUMBER	FFBMAST	FFBMAST_EST_LIFE_YEARS
ADJUSTED_AMOUNT	Adjusted Amount	Summarized amount for all accounting adjustments to the original value of the fixed asset. Uses the most current change sequence number. Represents the gain or loss amount when the asset is sold or written off or adjusted for any other reason.	NUMBER	FFRMASA	FFRMASA_ADJ_AMT
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
ASSET_AMOUNT	Asset Amount	Current summarized original cost of asset including accounting adjustments.	NUMBER	FFRMASA	FFRMASA_AMT
DEPRECIATION_FREQUENCY	Depreciation Frequency	Defined frequency (monthly, annually, semi-annually, quarterly) for the calculation of depreciation for this asset.	VARCHAR2(63)	FFBMAST	FFBMAST_DEPR_FREQ
DEPRECIATION_METHOD	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(63)	FFBMAST	FFBMAST_DEPR_CODE
DEPRECIATION_METHOD_DESC	Depreciation Method Description	Instructions as to how to handle the depreciation for an asset.	VARCHAR2(255)	FTVDEPR	FTVDEPR_TITLE
DEPRECIATION_START_DATE	Depreciation Start Date	Date on which the asset starts to depreciate.	DATE	FFBMAST	FFBMAST_DEPR_START_DATE
LAST_DEPRECIATION_DATE	Last Depreciation Date	Date on which the depreciation calculation was last performed.	DATE	FFBMAST	FFBMAST_LAST_DEPR_DATE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NET_BOOK_VALUE_AMOUNT	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
NET_DEPRECIATION_AMOUNT	Net Depreciation Amount	Summarization of all current depreciation amounts used for depreciation. Uses the most current change sequence number.	NUMBER	FFRMASA	FFRMASA_NEW_NET_DEPR_AMT
OLD_DEPRECIATION_AMOUNT	Old Depreciation Amount	Summarization of all the depreciation amounts used last time for depreciation. Uses the most current change sequence number.	NUMBER	FFRMASA	FFRMASA_OLD_NET_DEPR_AMT
ORIGINATION_TAG_NUMBER	Origination Tag Number	System generated tag number assigned when the asset is acquired.	VARCHAR2(63)	FFRMASA	FFRMASA_OTAG_CODE
PERMANENT_TAG_NUMBER	Permanent Tag Number	Unique user defined or system generated one-up number for this asset.	VARCHAR2(63)	FFBMAST	FFBMAST_PTAG_CODE
PRIOR_LAST_DEPRECIATION_DATE	Prior Last Depreciation Date	Next to last date on which the depreciation calculation was last performed.	DATE	FFBMAST	FFBMAST_OLD_LAST_DEPR_DATE
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REMAINING_LIFE_MONTHS	Remaining Life Months	Calculated as months as the depreciation frequency being used is defined as monthly for remaining life of the asset. This is null if the depreciation frequency is not monthly.	NUMBER	FUNCTION	FOKODSF.F_REMAINING_LIFE
REMAINING_LIFE_QUARTERS	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	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	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
SALVAGE_AMOUNT	Salvage Amount	Amount below which this fixed asset cannot be depreciated.	NUMBER	FFBMAST	FFBMAST_SALVAGE_AMT
TOTAL_DEPRECIATION_AMOUNT	Total Depreciation Amount	Summarization of all accounting depreciation amounts taken during the life to date for this asset. Uses the most current change sequence number.	NUMBER	FFRMASA	FFRMASA_DEPR_ACCUM_AMT
TOTAL_NET_BOOK_VALUE_AMOUNT	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