Reporting View Target: ENCUMBRANCE

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

Banner Operational Data Store
Reporting View Target: ENCUMBRANCE_ACCOUNTING

Description Contains encumbrance document number, item, sequence number, accounting distribution, and encumbrance status for the financial commitment.
Key & Frequency One row per encumbrance document number per item per sequence number.
Recommended Search Columns ENCUMBRANCE_NUMBER, ITEM, SEQUENCE_NUMBER
CHART_OF_ACCOUNTS, FISCAL_YEAR, FUND, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, LOCATION

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

ACCOUNT Account Code representing an account, such as revenue, labor, expenditure or transfer. VARCHAR2(63)
FGBENCD

FGBENCD_ACCT_CODE

ACCOUNT_DESC Account Description Account code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_INDEX Account INDEX Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(63)
FGBENCD

FGBENCD_ACCI_CODE

ACCOUNT_INDEX_DESC Account INDEX Description Account index description. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_INDEX_STATUS Account INDEX Status Account index status. VARCHAR2(1)
FUNCTION

F_GET_FINANCE_STATUS

ACCOUNT_STATUS Account Status Current status of the associated account. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

ACTIVITY Activity Code used to identify accounting data by activity. VARCHAR2(63)
FGBENCD

FGBENCD_ACTV_CODE

ACTIVITY_DESC Activity Description Activity code title or description. VARCHAR2(255)
FTVACTV

FTVACTV_TITLE

ACTIVITY_STATUS Activity Status Current status of the associated activity. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

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

NA

AVAILABLE_BALANCE_OVERRIDE_IND Available Balance Override Indicator Determines whether the available balance of funds was overriden. VARCHAR2(1)
CALCULATION

NVL(FGBENCD_ABAL_OVERRIDE)

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)
FGBENCD

FGBENCD_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Current status of the associated chart of accounts. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

COMMITMENT_PERCENT Commitment Percent Percent of budget carried forward on a rolled encumbrance. NUMBER
FGBENCD

FGBENCD_CMT_PCT

COMMITMENT_TYPE Commitment Type Encumbrance commitment type description. VARCHAR2(63)
FGBENCD

FGBENCD_CMT_TYPE

COMMITMENT_TYPE_DESC Commitment Type Description Encumbrance commitment type description. VARCHAR2(255)
CALCULATION

CASE WHEN FGBENCD_CMT_TYPE

DISTRIBUTION_PERCENT Distribution Percent Percentage of the of the transaction total amount assigned to this accounting distribution. NUMBER
FGBENCD

FGBENCD_DIST_PCT

DOCUMENT_ENCUMBRANCE_STATUS Document Encumbrance Status Deciphers encumbrance document as open or closed. VARCHAR2(63)
CALCULATION

DECODE(FGBENCH_STATUS_IND)

ENCUMBRANCE_NUMBER Encumbrance Number Unique encumbrance code of a document. VARCHAR2(63)
FGBENCD

FGBENCD_NUM

ENCUMBRANCE_STATUS Encumbrance Status Deciphers encumbrance accounting line as open or closed. VARCHAR2(63)
CALCULATION

DECODE(FGBENCD_STATUS)

ENC_ACCOUNTING_ACTIVITY_DATE Enc Accounting Activity Date Date that information for this record in the table was entered or last updated. DATE
FGBENCD

FGBENCD_ACTIVITY_DATE

ENC_ACCOUNTING_CREATE_DATE Enc Accounting Create Date Date that information for this record in the table was entered. DATE
FGBENCD

FGBENCD_CREATE_DATE

ENC_ACCOUNTING_CREATE_SOURCE Enc Accounting Create Source Source system that created the new record. VARCHAR2(63)
FGBENCD

FGBENCD_CREATE_SOURCE

ENC_ACCOUNTING_CREATE_USER Enc Accounting Create User Unique identification code of the user who created the encumbrance encumbrance. VARCHAR2(63)
FGBENCD

FGBENCD_CREATE_USER

ENC_ACCOUNTING_DATA_ORIGIN Enc Accounting Data Origin Source system that created or updated the data. VARCHAR2(63)
FGBENCD

FGBENCD_DATA_ORIGIN

ENC_ACCOUNTING_USER_ID Enc Accounting User ID Unique identification code of the user who entered or last updated the encumbrance accounting. VARCHAR2(63)
FGBENCD

FGBENCD_USER_ID

FIELD_CODE Field Code Two-digit code that represents the specific operating ledger bucket amount updated. VARCHAR2(63)
FGBENCD

FGBENCD_OPAL_FIELD_CODE

FIELD_CODE_DESC Field Code Description Two-digit code that represents the specific operating ledger bucket amount updated. VARCHAR2(255)
CALCULATION

CASE WHEN FGBENCD_FIELD_CODE

FISCAL_PERIOD 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)
FGBENCD

FGBENCD_POSTING_PERIOD

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

FOFYCNV

FUND Fund Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)
FGBENCD

FGBENCD_FUND_CODE

FUND_DESC Fund Description Description or title of the associated fund. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

FUND_STATUS Fund Status Current status of the associated fund. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

HR_ENCUMBRANCE_IND HR Encumbrance Indicator Indicates whether the encumbrance is from Human Resources. VARCHAR2(1)
CALCULATION

CASE WHEN ENCUMBRANCE_NUMBER

HR_ENCUMBRANCE_PERIOD HR Encumbrance Period Determines whether Human Resources labor encumbrance item is current year or future year. VARCHAR2(63)
CALCULATION

CASE WHEN HR_ENCUMBRANCE_IND

HR_ENCUMBRANCE_PERIOD_DESC HR Encumbrance Period Description Humance Resources encumbrance period description. VARCHAR2(255)
CALCULATION

CASE WHEN HR_ENCUMBRANCE_IND

ITEM Item System-generated line item number that identifies each commodity line item for procurement documents. NUMBER
FGBENCD

FGBENCD_ITEM

LABOR_ITEM_TYPE Labor Item Type Human Resources labor item description. VARCHAR2(255)
CALCULATION

CASE WHEN HR_ENCUMBRANCE_IND

LEDGER_ENCUMBERED_AMOUNT Ledger Encumbered Amount Sum of original encumbrance amounts plus encumbrance adjustments for the accounting line for the maximum fiscal year. NUMBER
FUNCTION

MFKFUNC.F_GET_LEDGER_ENCUMBERED_AMOUNT

LEDGER_REMAINING_BALANCE Ledger Remaining Balance Encumbrance remaining balance. NUMBER
FUNCTION

MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE

LOCATION Location Identification accounting code of the physical location of the financial manager. VARCHAR2(63)
FGBENCD

FGBENCD_LOCN_CODE

LOCATION_DESC Location Description Description or title of the associated location. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

LOCATION_STATUS Location Status Current status of the associated location. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

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

MULTI_YEAR_ENCUMBRANCE_IND Multi Year Encumbrance Indicator Indicates whether multi-year labor encumbering is utilized with a fund/grant combination. VARCHAR2(1)
FRVFUND

FRVFUND_ENC_MULT_YEAR_IND

ORGANIZATION_CODE Organization Code Identification accounting code used for the department. VARCHAR2(63)
FGBENCD

FGBENCD_ORGN_CODE

ORGANIZATION_DESC Organization Description Description or title associated with the organization code. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

ORGANIZATION_STATUS Organization Status Current status of the associated organization. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

PENDING_AMOUNT Pending Amount Amount of the encumbrance being charged to this accounting distribution. NUMBER
FGBENCD

FGBENCD_PEND_AMT

POSTABLE_IND Postable Indicator Deciphers encumbrance accounting line as postable, error or not checked. VARCHAR2(63)
CALCULATION

DECODE(FGBENCD_STATUS_IND)

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

NA

PROGRAM Program Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(63)
FGBENCD

FGBENCD_PROG_CODE

PROGRAM_DESC Program Description Description or title of the associated program. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

PROGRAM_STATUS Program Status Current status of the associated program. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

PROJECT Project Work order code used within cost accounting module. VARCHAR2(63)
FGBENCD

FGBENCD_PRJD_CODE

RULE_CLASS Rule Class User defined rule class used to post the transaction. VARCHAR2(63)
FGBENCD

FGBENCD_RUCL_CODE

RULE_CLASS_DESC Rule Class Description Rule class description. VARCHAR2(255)
FTVRUCL

FTVRUCL_CLASS_TITLE

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

FGBENCD_SEQ_NUM

Ver: 9.2

Description	Contains encumbrance document number, item, sequence number, accounting distribution, and encumbrance status for the financial commitment.
Key & Frequency	One row per encumbrance document number per item per sequence number.
Recommended Search Columns	ENCUMBRANCE_NUMBER, ITEM, SEQUENCE_NUMBER CHART_OF_ACCOUNTS, FISCAL_YEAR, FUND, ORGANIZATION_CODE CHART_OF_ACCOUNTS, ORGANIZATION_CODE CHART_OF_ACCOUNTS, PROGRAM CHART_OF_ACCOUNTS, FUND CHART_OF_ACCOUNTS, ACCOUNT CHART_OF_ACCOUNTS, LOCATION

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT	Account	Code representing an account, such as revenue, labor, expenditure or transfer.	VARCHAR2(63)	FGBENCD	FGBENCD_ACCT_CODE
ACCOUNT_DESC	Account Description	Account code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_INDEX	Account INDEX	Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(63)	FGBENCD	FGBENCD_ACCI_CODE
ACCOUNT_INDEX_DESC	Account INDEX Description	Account index description.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_INDEX_STATUS	Account INDEX Status	Account index status.	VARCHAR2(1)	FUNCTION	F_GET_FINANCE_STATUS
ACCOUNT_STATUS	Account Status	Current status of the associated account.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ACTIVITY	Activity	Code used to identify accounting data by activity.	VARCHAR2(63)	FGBENCD	FGBENCD_ACTV_CODE
ACTIVITY_DESC	Activity Description	Activity code title or description.	VARCHAR2(255)	FTVACTV	FTVACTV_TITLE
ACTIVITY_STATUS	Activity Status	Current status of the associated activity.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AVAILABLE_BALANCE_OVERRIDE_IND	Available Balance Override Indicator	Determines whether the available balance of funds was overriden.	VARCHAR2(1)	CALCULATION	NVL(FGBENCD_ABAL_OVERRIDE)
CHART_OF_ACCOUNTS	Chart Of Accounts	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FGBENCD	FGBENCD_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart Of Accounts Description	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS	Chart Of Accounts Status	Current status of the associated chart of accounts.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
COMMITMENT_PERCENT	Commitment Percent	Percent of budget carried forward on a rolled encumbrance.	NUMBER	FGBENCD	FGBENCD_CMT_PCT
COMMITMENT_TYPE	Commitment Type	Encumbrance commitment type description.	VARCHAR2(63)	FGBENCD	FGBENCD_CMT_TYPE
COMMITMENT_TYPE_DESC	Commitment Type Description	Encumbrance commitment type description.	VARCHAR2(255)	CALCULATION	CASE WHEN FGBENCD_CMT_TYPE
DISTRIBUTION_PERCENT	Distribution Percent	Percentage of the of the transaction total amount assigned to this accounting distribution.	NUMBER	FGBENCD	FGBENCD_DIST_PCT
DOCUMENT_ENCUMBRANCE_STATUS	Document Encumbrance Status	Deciphers encumbrance document as open or closed.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCH_STATUS_IND)
ENCUMBRANCE_NUMBER	Encumbrance Number	Unique encumbrance code of a document.	VARCHAR2(63)	FGBENCD	FGBENCD_NUM
ENCUMBRANCE_STATUS	Encumbrance Status	Deciphers encumbrance accounting line as open or closed.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCD_STATUS)
ENC_ACCOUNTING_ACTIVITY_DATE	Enc Accounting Activity Date	Date that information for this record in the table was entered or last updated.	DATE	FGBENCD	FGBENCD_ACTIVITY_DATE
ENC_ACCOUNTING_CREATE_DATE	Enc Accounting Create Date	Date that information for this record in the table was entered.	DATE	FGBENCD	FGBENCD_CREATE_DATE
ENC_ACCOUNTING_CREATE_SOURCE	Enc Accounting Create Source	Source system that created the new record.	VARCHAR2(63)	FGBENCD	FGBENCD_CREATE_SOURCE
ENC_ACCOUNTING_CREATE_USER	Enc Accounting Create User	Unique identification code of the user who created the encumbrance encumbrance.	VARCHAR2(63)	FGBENCD	FGBENCD_CREATE_USER
ENC_ACCOUNTING_DATA_ORIGIN	Enc Accounting Data Origin	Source system that created or updated the data.	VARCHAR2(63)	FGBENCD	FGBENCD_DATA_ORIGIN
ENC_ACCOUNTING_USER_ID	Enc Accounting User ID	Unique identification code of the user who entered or last updated the encumbrance accounting.	VARCHAR2(63)	FGBENCD	FGBENCD_USER_ID
FIELD_CODE	Field Code	Two-digit code that represents the specific operating ledger bucket amount updated.	VARCHAR2(63)	FGBENCD	FGBENCD_OPAL_FIELD_CODE
FIELD_CODE_DESC	Field Code Description	Two-digit code that represents the specific operating ledger bucket amount updated.	VARCHAR2(255)	CALCULATION	CASE WHEN FGBENCD_FIELD_CODE
FISCAL_PERIOD	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)	FGBENCD	FGBENCD_POSTING_PERIOD
FISCAL_YEAR	Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)	FUNCTION	FOFYCNV
FUND	Fund	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	FGBENCD	FGBENCD_FUND_CODE
FUND_DESC	Fund Description	Description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
FUND_STATUS	Fund Status	Current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
HR_ENCUMBRANCE_IND	HR Encumbrance Indicator	Indicates whether the encumbrance is from Human Resources.	VARCHAR2(1)	CALCULATION	CASE WHEN ENCUMBRANCE_NUMBER
HR_ENCUMBRANCE_PERIOD	HR Encumbrance Period	Determines whether Human Resources labor encumbrance item is current year or future year.	VARCHAR2(63)	CALCULATION	CASE WHEN HR_ENCUMBRANCE_IND
HR_ENCUMBRANCE_PERIOD_DESC	HR Encumbrance Period Description	Humance Resources encumbrance period description.	VARCHAR2(255)	CALCULATION	CASE WHEN HR_ENCUMBRANCE_IND
ITEM	Item	System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER	FGBENCD	FGBENCD_ITEM
LABOR_ITEM_TYPE	Labor Item Type	Human Resources labor item description.	VARCHAR2(255)	CALCULATION	CASE WHEN HR_ENCUMBRANCE_IND
LEDGER_ENCUMBERED_AMOUNT	Ledger Encumbered Amount	Sum of original encumbrance amounts plus encumbrance adjustments for the accounting line for the maximum fiscal year.	NUMBER	FUNCTION	MFKFUNC.F_GET_LEDGER_ENCUMBERED_AMOUNT
LEDGER_REMAINING_BALANCE	Ledger Remaining Balance	Encumbrance remaining balance.	NUMBER	FUNCTION	MFKFUNC.F_GET_LEDGER_REMAINING_BALANCE
LOCATION	Location	Identification accounting code of the physical location of the financial manager.	VARCHAR2(63)	FGBENCD	FGBENCD_LOCN_CODE
LOCATION_DESC	Location Description	Description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
LOCATION_STATUS	Location Status	Current status of the associated location.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
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
MULTI_YEAR_ENCUMBRANCE_IND	Multi Year Encumbrance Indicator	Indicates whether multi-year labor encumbering is utilized with a fund/grant combination.	VARCHAR2(1)	FRVFUND	FRVFUND_ENC_MULT_YEAR_IND
ORGANIZATION_CODE	Organization Code	Identification accounting code used for the department.	VARCHAR2(63)	FGBENCD	FGBENCD_ORGN_CODE
ORGANIZATION_DESC	Organization Description	Description or title associated with the organization code.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_STATUS	Organization Status	Current status of the associated organization.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
PENDING_AMOUNT	Pending Amount	Amount of the encumbrance being charged to this accounting distribution.	NUMBER	FGBENCD	FGBENCD_PEND_AMT
POSTABLE_IND	Postable Indicator	Deciphers encumbrance accounting line as postable, error or not checked.	VARCHAR2(63)	CALCULATION	DECODE(FGBENCD_STATUS_IND)
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM	Program	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(63)	FGBENCD	FGBENCD_PROG_CODE
PROGRAM_DESC	Program Description	Description or title of the associated program.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
PROGRAM_STATUS	Program Status	Current status of the associated program.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
PROJECT	Project	Work order code used within cost accounting module.	VARCHAR2(63)	FGBENCD	FGBENCD_PRJD_CODE
RULE_CLASS	Rule Class	User defined rule class used to post the transaction.	VARCHAR2(63)	FGBENCD	FGBENCD_RUCL_CODE
RULE_CLASS_DESC	Rule Class Description	Rule class description.	VARCHAR2(255)	FTVRUCL	FTVRUCL_CLASS_TITLE
SEQUENCE_NUMBER	Sequence Number	System-generated one-up number to support split accounting within a document.	NUMBER	FGBENCD	FGBENCD_SEQ_NUM