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

SGHE Banner Operational Data Store
Reporting View Target: ENCUMBRANCE_ACCOUNTING

Description Contains encumbrance document number, item, sequence number, accounting distirbution, 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACCOUNT Code representing an account, such as revenue, labor, expenditure or transfer.    

FGBENCD

FGBENCD_ACCT_CODE

 
ACCOUNT_DESC Account code description or title.    

FUNCTION

F_GET_FINANCE_DESC

 
ACCOUNT_STATUS Current status of the associated account.    

FUNCTION

F_GET_FINANCE_STATUS

 
ACTIVITY Code used to identify accounting data by activity.    

FGBENCD

FGBENCD_ACTV_CODE

 
ACTIVITY_DESC Activity code title or description.    

FTVACTV

FTVACTV_TITLE

 
ACTIVITY_STATUS Current status of the associated activity.    

FUNCTION

F_GET_FINANCE_STATUS

 
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment.    

FGBENCD

FGBENCD_COAS_CODE

 
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title.    

FUNCTION

F_GET_FINANCE_DESC

 
CHART_OF_ACCOUNTS_STATUS Current status of the associated chart of accounts.    

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_DIST_PCT

 
DOCUMENT_ENCUMBRANCE_STATUS Deciphers encumbrance document as open or closed.    

CALCULATION

DECODE(FGBENCH_STATUS_IND)

 
ENCUMBRANCE_NUMBER Unique encumbrance code of a document.    

FGBENCD

FGBENCD_NUM

 
ENCUMBRANCE_STATUS Deciphers encumbrance accounting line as open or closed.    

CALCULATION

DECODE(FGBENCD_STATUS)

 
FISCAL_PERIOD Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.    

FGBENCD

FGBENCD_POSTING_PERIOD

 
FISCAL_YEAR Unique identifier or code for the fiscal year.    

FUNCTION

FOFYCNV

 
FUND Unique fiscal entity code.    

FGBENCD

FGBENCD_FUND_CODE

 
FUND_DESC Description or title of the associated fund.    

FUNCTION

F_GET_FINANCE_DESC

 
FUND_STATUS Current status of the associated fund.    

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_ITEM

 
LOCATION Identification accounting code of the physical location of the financial manager.    

FGBENCD

FGBENCD_LOCN_CODE

 
LOCATION_DESC Description or title of the associated location.    

FUNCTION

F_GET_FINANCE_DESC

 
LOCATION_STATUS Current status of the associated location.    

FUNCTION

F_GET_FINANCE_STATUS

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
ORGANIZATION_CODE Identification accounting code used for the department.    

FGBENCD

FGBENCD_ORGN_CODE

 
ORGANIZATION_DESC Description or title associated with the organization code.    

FUNCTION

F_GET_FINANCE_DESC

 
ORGANIZATION_STATUS Current status of the associated organization.    

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_PEND_AMT

 
POSTABLE_IND Deciphers encumbrance accounting line as postable, error or not checked.    

CALCULATION

DECODE(FGBENCD_STATUS_IND)

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
PROGRAM Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems.    

FGBENCD

FGBENCD_PROG_CODE

 
PROGRAM_DESC Description or title of the associated program.    

FUNCTION

F_GET_FINANCE_DESC

 
PROGRAM_STATUS Current status of the associated program.    

FUNCTION

F_GET_FINANCE_STATUS

 
PROJECT Work order code used within cost accounting module.    

FGBENCD

FGBENCD_PRJD_CODE

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

FGBENCD

FGBENCD_SEQ_NUM

 


Ver: 8.3