Go To View:  RETURN TO REPORTING VIEW 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

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT Code representing an account, such as revenue, labor, expenditure or transfer. VARCHAR2(63)

FGBENCD

FGBENCD_ACCT_CODE

ACCOUNT_DESC Account code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

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

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_ACTV_CODE

ACTIVITY_DESC Activity code title or description. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ACTIVITY_STATUS Extracted current status of the associated activity. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

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

NA

NA

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 code description or title. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

CHART_OF_ACCOUNTS_STATUS Extracted current status of the associated chart of accounts. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_DIST_PCT

DOCUMENT_ENCUMBRANCE_STATUS Deciphers encumbrance document as open or closed. VARCHAR2(63)

CALCULATION

DECODE(FGBENCH_STATUS_IND)

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

FGBENCD

FGBENCD_NUM

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

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. VARCHAR2(63)

FGBENCD

FGBENCD_POSTING_PERIOD

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

FUNCTION

FOFYCNV

FUND Unique fiscal entity code. VARCHAR2(63)

FGBENCD

FGBENCD_FUND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

FUND_STATUS Extracted current status of the associated fund. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_ITEM

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

FGBENCD

FGBENCD_LOCN_CODE

LOCATION_DESC Extracted description or title of the associated location. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

LOCATION_STATUS Extracted current status of the associated location. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

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

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

FGBENCD

FGBENCD_ORGN_CODE

ORGANIZATION_DESC Extracted description or title associated with the organization code. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

ORGANIZATION_STATUS Extracted current status of the associated organization. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_PEND_AMT

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

CALCULATION

DECODE(FGBENCD_STATUS_IND)

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

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. VARCHAR2(63)

FGBENCD

FGBENCD_PROG_CODE

PROGRAM_DESC Extracted description or title of the associated program. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

PROGRAM_STATUS Extracted current status of the associated program. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_PRJD_CODE

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

FGBENCD

FGBENCD_SEQ_NUM



Ver: 8.0