Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_ENCUMBRANCE_ACCOUNTING

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

FGBENCD

FGBENCD_ACCT_CODE

ACCOUNT_DESC Account code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_INDEX   VARCHAR2(6)    
ACCOUNT_INDEX_DESC   VARCHAR2(35)    
ACCOUNT_INDEX_STATUS   VARCHAR2(1)    
ACCOUNT_STATUS Current status of the associated account. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_ACTV_CODE

ACTIVITY_DESC Activity code title or description. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

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

FUNCTION

F_GET_FINANCE_STATUS

AVAILABLE_BALANCE_OVERRIDE_IND   VARCHAR2(1)    
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

FGBENCD

FGBENCD_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

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

FUNCTION

F_GET_FINANCE_STATUS

COMMITMENT_PERCENT   NUMBER    
COMMITMENT_TYPE   VARCHAR2(1)    
COMMITMENT_TYPE_DESC   VARCHAR2(11)    
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

FGBENCD

FGBENCD_DIST_PCT

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

FGBENCD

FGBENCD_NUM

ENCUMBRANCE_STATUS Indicates the status of the encumbrance; Whether it is closed or open. VARCHAR2(30)

CALCULATION

DECODE(FGBENCD_STATUS)

ENC_ACCOUNTING_ACTIVITY_DATE   DATE    
ENC_ACCOUNTING_CREATE_DATE   DATE    
ENC_ACCOUNTING_CREATE_SOURCE   VARCHAR2(30)    
ENC_ACCOUNTING_CREATE_USER   VARCHAR2(30)    
ENC_ACCOUNTING_DATA_ORIGIN   VARCHAR2(30)    
ENC_ACCOUNTING_USER_ID   VARCHAR2(30)    
FIELD_CODE   VARCHAR2(2)    
FIELD_CODE_DESC   VARCHAR2(18)    
FISCAL_PERIOD Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14. VARCHAR2(2)

FGBENCD

FGBENCD_POSTING_PERIOD

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

FUNCTION

FOFYCNV

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

FGBENCD

FGBENCD_FUND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

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(6)

FGBENCD

FGBENCD_LOCN_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FUNCTION

F_GET_FINANCE_STATUS

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

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

FGBENCD

FGBENCD_ORGN_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

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

CALCULATION

DECODE(FGBENCD_STATUS_IND)

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(6)

FGBENCD

FGBENCD_PROG_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

FUNCTION

F_GET_FINANCE_STATUS

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

FGBENCD

FGBENCD_PRJD_CODE

RULE_CLASS   VARCHAR2(4)    
RULE_CLASS_DESC   VARCHAR2(35)    
SEQUENCE_NUMBER System-generated one-up number to support split accounting within a document. NUMBER

FGBENCD

FGBENCD_SEQ_NUM

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

NA

NA



Ver: