Reporting View Target: FOAPAL_NO

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

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