Reporting View Target: ACCOUNT_ADDL_INFO

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

SGHE Banner Operational Data Store
Reporting View Target: ACCOUNT_ADDL_INFO_KSU

Description Contains additional information for Accounts including entity category
Key & Frequency One row per pidm
Recommended Search Columns PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column

ENTITY_CODE Category of the entity, valid in TTVECAT VARCHAR2(8)
TBBCPRF

TBBCPRF_ECAT_CODE

ENTITY_CODE_DESC Description of the entity category code VARCHAR2(4000)
TTVECAT

TTVECAT_DESC

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER
TBBCPRF

TBBCPRF_PIDM

Ver: 8.4.1

Description	Contains additional information for Accounts including entity category
Key & Frequency	One row per pidm
Recommended Search Columns	PERSON_UID

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ENTITY_CODE	Category of the entity, valid in TTVECAT	VARCHAR2(8)	TBBCPRF	TBBCPRF_ECAT_CODE
ENTITY_CODE_DESC	Description of the entity category code	VARCHAR2(4000)	TTVECAT	TTVECAT_DESC
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	TBBCPRF	TBBCPRF_PIDM