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

SGHE Banner Operational Data Store
Reporting View Target: FOAPAL_NO_ATTRIBUTES

Description Contains a list of all accounting distribution elements that are not associated with a set code, or an attribute type, and/or an attribute value. This is used for exception reporting to assist in attaching reporting attributes to the various accounting distribution elements.
Key & Frequency One row per chart of accounts per accounting distribution element.
Recommended Search Columns CHART_OF_ACCOUNTS

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP 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 Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

FTVACCT

FTVATYP

FTVFTYP

FTVFUND

FTVLOCN

FTVORGN

FTVPROG

FTVACCT_ACCT_CODE

FTVATYP_COAS_CODE

FTVFTYP_COAS_CODE

FTVFUND_FUND_CODE

FTVLOCN_COAS_CODE

FTVORGN_COAS_CODE

FTVPROG_COAS_CODE

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

FTVCOAS

FTVCOAS_TITLE

CHART_OF_ACCOUNTS_STATUS Chart Of Account Status Status of the chart of account. VARCHAR2(63)  

FTVCOAS

FTVCOAS_STATUS_IND

FOAPAL_ELEMENT Foapal Element Account distribution code which has no attributes. VARCHAR2(63)  

FTVACCT

FTVATYP

FTVFTYP

FTVFUND

FTVLOCN

FTVORGN

FTVPROG

FTVACCT_ACCT_CODE

FTVATYP_ATYP_CODE

FTVFTYP_FTYP_CODE

FTVFUND_FUND_CODE

FTVLOCN_LOCN_CODE

FTVORGN_ORGN_CODE

FTVPROG_PROG_CODE

FOAPAL_ELEMENT_DESC Foapal Element Description Description of the account distribution code without attributes. VARCHAR2(255)  

FTVACCT

FTVFUND

FTVLOCN

FTVORGN

FTVPROG

FTVACCT_TITLE

FTVFUND_TITLE

FTVLOCN_TITLE

FTVORGN_TITLE

FTVPROG_TITLE

FOAPAL_ELEMENT_STATUS FOAPAL Status Status of the FOAPAL. VARCHAR2(63)  

FTVACCT

FTVACTV

FTVFUND

FTVLOCN

FTVORGN

FTVPROG

FTVACCT_STATUS_IND

FTVACTV_STATUS_IND

FTVFUND_STATUS_IND

FTVLOCN_STATUS_IND

FTVORGN_STATUS_IND

FTVPROG_STATUS_IND

FOAPAL_ELEMENT_TYPE Foapal Element Type Code that represents which account distribution code that does not have an attribute assigned to it. VARCHAR2(8)  

CONSTANT

CONSTANT

CONSTANT

CONSTANT

CONSTANT

CONSTANT

CONSTANT

'ACCOUNT'

'ATYP'

'FTYP'

'FUND'

'LOCATION'

'ORGN'

'PROGRAM'

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

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

NA

NA



Ver: 9.0