Reporting View Target: FIXED_ASSET

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

SGHE Banner Operational Data Store
Reporting View Target: FIXED_ASSET_ADJUSTMENT

Description Contains all asset adjustments information by adjustment document number. This includes the type of adjustment, depreciation adjustment date, transaction date, disposal, net book value amount, fiscal year, fiscal period, transaction amount, distribution percent, transaction amount, and transaction amount adjusted.
Key & Frequency One row per adjustment document number per item number per sequence number per accounting sequence number.
Recommended Search Columns DOCUMENT, ACCOUNT_ITEM, SEQUENCE_NUMBER, ACCOUNTING_SEQUENCE_NUMBER
ORIGINATION_TAG_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column

ACCOUNTING_SEQUENCE_NUMBER System-generated one-up number associated with an asset accounting record. NUMBER
FFRADJA

FFRADJA_MASA_SEQ_NUM

ACCOUNT_ITEM System-generated one-up number associated with an asset being adjusted in the document. NUMBER
FFRADJA

FFRADJA_ITEM

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

NA

APPROVAL_IND Indicates the document has met final approval. VARCHAR2(63)
FFBADJH

FFBADJH_APPR_IND

ASSET_AMOUNT Amount entered by the user to determine the sale price of an asset or an adjustment. NUMBER
FFRADJD

FFRADJD_AMT

COMPLETED_IND Indicates the fixed asset adjustment document is complete. VARCHAR2(63)
FFBADJH

FFBADJH_COMPLETE_IND

DEPRECIATION_ADJUSTMENT_DATE Depreciation adjustment date defaults from the adjustment transaction date for every function processed. DATE
FFBADJH

FFBADJH_DEPR_ADJ_DATE

DISPOSAL Code used to define method of disposal of an asset. VARCHAR2(63)
FFRADJD

FFRADJD_DISP_CODE

DISPOSAL_DESC Disposal method description. VARCHAR2(255)
FFVDISP

FFVDISP_DESC

DISTRIBUTION_PERCENT Percentage of the of the transaction total amount assigned to this accounting distribution. NUMBER
FFRADJA

FFRADJA_PCT

DOCUMENT User-defined or system generated document number. VARCHAR2(63)
FFRADJA

FFRADJA_ADJH_CODE

DOCUMENT_REFERENCE_NUMBER User-defined identification number further identifying this document and linking it to an external reference number. VARCHAR2(63)
FFBADJH

FFBADJH_DOC_REF_NUM

EQUITY_ACCOUNT Account code to record asset equity. VARCHAR2(63)
FFRADJA

FFRADJA_ACCT_CODE_CAP_EQUITY

EQUITY_ACCOUNT_DESC Extracted description or title of the associated account. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

EQUITY_ACCOUNT_STATUS Extracted current status of the associated account. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

FISCAL_PERIOD Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14. VARCHAR2(63)
FFRADJA

FFRADJA_PERIOD

FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(63)
FUNCTION

FOFYCNV

FUNCTION_TYPE Function code of the adjustment action used on the asset in the document. VARCHAR2(63)
FFBADJH

FFBADJH_FUNCTION_CODE

METHOD_OF_ACQUISITION Code used to indicate the method used to acquire the asset. VARCHAR2(63)
FFRADJD

FFRADJD_ACQM_CODE

METHOD_OF_ACQUISITION_DESC Description of the method used to acquire the asset. VARCHAR2(255)
FFVACQM

FFVACQM_DESC

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

NA

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

NA

NET_BOOK_VALUE_AMOUNT Net book value of the asset calculated by the system as asset cost less depreciation plus or minus any asset adjustments. This amount is used to determine any gain or loss on the asset when it is sold. NUMBER
FFRADJD

FFRADJD_NET_BOOK_VALUE_AMT

ORIGINATION_TAG_NUMBER System generated tag number assigned when the asset is acquired. VARCHAR2(63)
FFRADJD

FFRADJD_OTAG_CODE

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

FFBMAST_PTAG_CODE

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

NA

SEQUENCE_NUMBER System-generated one-up number to support split accounting within a document. NUMBER
FFRADJA

FFRADJA_SEQ_NUM

TRANSACTION_AMOUNT Amount of the transaction associated with this particular account distribution. NUMBER
FFRADJA

FFRADJA_AMT

TRANSACTION_AMOUNT_ADJUSTED Actual adjustment amount used with functions for Write-Offs and Sales of Assets. NUMBER
FFRADJA

FFRADJA_ADJ_AMT

TRANSACTION_DATE Date used by the finance system to control posting to the ledgers. DATE
FFBADJH

FFBADJH_TRANS_DATE

TRANSACTION_DESC Accounting transaction description. VARCHAR2(255)
FFBADJH

FFBADJH_DESC

Ver: 8.5

Description	Contains all asset adjustments information by adjustment document number. This includes the type of adjustment, depreciation adjustment date, transaction date, disposal, net book value amount, fiscal year, fiscal period, transaction amount, distribution percent, transaction amount, and transaction amount adjusted.
Key & Frequency	One row per adjustment document number per item number per sequence number per accounting sequence number.
Recommended Search Columns	DOCUMENT, ACCOUNT_ITEM, SEQUENCE_NUMBER, ACCOUNTING_SEQUENCE_NUMBER ORIGINATION_TAG_NUMBER

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNTING_SEQUENCE_NUMBER	System-generated one-up number associated with an asset accounting record.	NUMBER	FFRADJA	FFRADJA_MASA_SEQ_NUM
ACCOUNT_ITEM	System-generated one-up number associated with an asset being adjusted in the document.	NUMBER	FFRADJA	FFRADJA_ITEM
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
APPROVAL_IND	Indicates the document has met final approval.	VARCHAR2(63)	FFBADJH	FFBADJH_APPR_IND
ASSET_AMOUNT	Amount entered by the user to determine the sale price of an asset or an adjustment.	NUMBER	FFRADJD	FFRADJD_AMT
COMPLETED_IND	Indicates the fixed asset adjustment document is complete.	VARCHAR2(63)	FFBADJH	FFBADJH_COMPLETE_IND
DEPRECIATION_ADJUSTMENT_DATE	Depreciation adjustment date defaults from the adjustment transaction date for every function processed.	DATE	FFBADJH	FFBADJH_DEPR_ADJ_DATE
DISPOSAL	Code used to define method of disposal of an asset.	VARCHAR2(63)	FFRADJD	FFRADJD_DISP_CODE
DISPOSAL_DESC	Disposal method description.	VARCHAR2(255)	FFVDISP	FFVDISP_DESC
DISTRIBUTION_PERCENT	Percentage of the of the transaction total amount assigned to this accounting distribution.	NUMBER	FFRADJA	FFRADJA_PCT
DOCUMENT	User-defined or system generated document number.	VARCHAR2(63)	FFRADJA	FFRADJA_ADJH_CODE
DOCUMENT_REFERENCE_NUMBER	User-defined identification number further identifying this document and linking it to an external reference number.	VARCHAR2(63)	FFBADJH	FFBADJH_DOC_REF_NUM
EQUITY_ACCOUNT	Account code to record asset equity.	VARCHAR2(63)	FFRADJA	FFRADJA_ACCT_CODE_CAP_EQUITY
EQUITY_ACCOUNT_DESC	Extracted description or title of the associated account.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
EQUITY_ACCOUNT_STATUS	Extracted current status of the associated account.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
FISCAL_PERIOD	Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.	VARCHAR2(63)	FFRADJA	FFRADJA_PERIOD
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(63)	FUNCTION	FOFYCNV
FUNCTION_TYPE	Function code of the adjustment action used on the asset in the document.	VARCHAR2(63)	FFBADJH	FFBADJH_FUNCTION_CODE
METHOD_OF_ACQUISITION	Code used to indicate the method used to acquire the asset.	VARCHAR2(63)	FFRADJD	FFRADJD_ACQM_CODE
METHOD_OF_ACQUISITION_DESC	Description of the method used to acquire the asset.	VARCHAR2(255)	FFVACQM	FFVACQM_DESC
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NET_BOOK_VALUE_AMOUNT	Net book value of the asset calculated by the system as asset cost less depreciation plus or minus any asset adjustments. This amount is used to determine any gain or loss on the asset when it is sold.	NUMBER	FFRADJD	FFRADJD_NET_BOOK_VALUE_AMT
ORIGINATION_TAG_NUMBER	System generated tag number assigned when the asset is acquired.	VARCHAR2(63)	FFRADJD	FFRADJD_OTAG_CODE
PERMANENT_TAG_NUMBER	Unique user defined or system generated one-up number for this asset.	VARCHAR2(63)	FFBMAST	FFBMAST_PTAG_CODE
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
SEQUENCE_NUMBER	System-generated one-up number to support split accounting within a document.	NUMBER	FFRADJA	FFRADJA_SEQ_NUM
TRANSACTION_AMOUNT	Amount of the transaction associated with this particular account distribution.	NUMBER	FFRADJA	FFRADJA_AMT
TRANSACTION_AMOUNT_ADJUSTED	Actual adjustment amount used with functions for Write-Offs and Sales of Assets.	NUMBER	FFRADJA	FFRADJA_ADJ_AMT
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	FFBADJH	FFBADJH_TRANS_DATE
TRANSACTION_DESC	Accounting transaction description.	VARCHAR2(255)	FFBADJH	FFBADJH_DESC