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

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 Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-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)

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

FTVCOAS

FTVCOAS_TITLE

CHART_OF_ACCOUNTS_STATUS Status of the chart of account. VARCHAR2(63)

FTVCOAS

FTVCOAS_STATUS_IND

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 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 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 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 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

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

NA

NA



Ver: 9.1