Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT_A		Actual account number from a finance system associated with this detail code.	VARCHAR2(60)		TBRACCT	TBRACCT_ACCOUNT_A
ACCOUNT_B		Actual account number from a finance system associated with this detail code.	VARCHAR2(60)		TBRACCT	TBRACCT_ACCOUNT_B
A_ACCOUNT		Banner finance account code for account a.	VARCHAR2(6)		TBRACCT	TBRACCT_A_ACCT_CODE
A_ACCOUNT_DESC		Banner finance account description for account a.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_ACCOUNT_INDEX	A Account Index	Banner finance account index for account a is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)		TBRACCT	TBRACCT_A_ACCI_CODE
A_ACCOUNT_INDEX_DESC	A Account Index Description	Banner finance account index description for account a.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_ACTIVITY		Banner finance activity code for account a.	VARCHAR2(6)		TBRACCT	TBRACCT_A_ACTV_CODE
A_ACTIVITY_DESC		Banner finance activity description for account a.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_CHART_OF_ACCOUNTS		Banner finance chart of accounts code for account a.	VARCHAR2(1)		TBRACCT	TBRACCT_A_COAS_CODE
A_CHART_OF_ACCOUNTS_DESC		Banner finance chart of accounts description for account a.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_FUND		Banner finance fund code for account a.	VARCHAR2(6)		TBRACCT	TBRACCT_A_FUND_CODE
A_FUND_DESC		Banner finance fund description for account a.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_LOCATION		Banner finance location code for account a.	VARCHAR2(6)		TBRACCT	TBRACCT_A_LOCN_CODE
A_LOCATION_DESC		Banner finance location description for account a.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_ORGANIZATION		Banner finance organization code for account a.	VARCHAR2(6)		TBRACCT	TBRACCT_A_ORGN_CODE
A_ORGANIZATION_DESC		Banner finance organization description for account a.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_PROGRAM		Banner finance program code for account a.	VARCHAR2(6)		TBRACCT	TBRACCT_A_PROG_CODE
A_PROGRAM_DESC		Banner finance program description for account a.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_RULE_CLASS1		First accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		TBRACCT	TBRACCT_A_RUCL_CODE1
A_RULE_CLASS2		Second accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		TBRACCT	TBRACCT_A_RUCL_CODE2
A_RULE_CLASS3		Third accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		TBRACCT	TBRACCT_A_RUCL_CODE3
A_RULE_CLASS_DESC1		First rule class description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_RULE_CLASS_DESC2		Second rule class description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
A_RULE_CLASS_DESC3		Third rule class description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_ACCOUNT		Banner finance account code for account b.	VARCHAR2(6)		TBRACCT	TBRACCT_B_ACCT_CODE
B_ACCOUNT_DESC		Banner finance account description for account b.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_ACCOUNT_INDEX	B Account Index	Banner finance account index for account b is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)		TBRACCT	TBRACCT_B_ACCI_CODE
B_ACCOUNT_INDEX_DESC	B Account Index Description	Banner finance account index description for account b.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_ACTIVITY		Banner finance activity code for account b.	VARCHAR2(6)		TBRACCT	TBRACCT_B_ACTV_CODE
B_ACTIVITY_DESC		Banner finance activity description for account b.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_CHART_OF_ACCOUNTS		Banner finance chart of accounts code for account b.	VARCHAR2(1)		TBRACCT	TBRACCT_B_COAS_CODE
B_CHART_OF_ACCOUNTS_DESC		Banner finance chart of accounts description for account b.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_FUND		Banner finance fund code for account b.	VARCHAR2(6)		TBRACCT	TBRACCT_B_FUND_CODE
B_FUND_DESC		Banner finance fund description for account b.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_LOCATION		Banner finance location code for account b.	VARCHAR2(6)		TBRACCT	TBRACCT_B_LOCN_CODE
B_LOCATION_DESC		Banner finance location description for account b.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_ORGANIZATION		Banner finance organization code for account b.	VARCHAR2(6)		TBRACCT	TBRACCT_B_ORGN_CODE
B_ORGANIZATION_DESC		Banner finance organization description for account b.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_PROGRAM		Banner finance program code for account b.	VARCHAR2(6)		TBRACCT	TBRACCT_B_PROG_CODE
B_PROGRAM_DESC		Banner finance program description for account b.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_RULE_CLASS1		First accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		TBRACCT	TBRACCT_B_RUCL_CODE1
B_RULE_CLASS2		Second accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		TBRACCT	TBRACCT_B_RUCL_CODE2
B_RULE_CLASS3		Third accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		TBRACCT	TBRACCT_B_RUCL_CODE3
B_RULE_CLASS_DESC1		First rule class description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_RULE_CLASS_DESC2		Second rule class description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
B_RULE_CLASS_DESC3		Third rule class description.	VARCHAR2(35)		FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DESIGNATOR	Designator	Academic period-based or financial aid year-based designator.	VARCHAR2(2)
DESIGNATOR_IND		Indicates whether the academic period-based or finanical aid year-based designator is used.	CHAR(1)
DESIGNATOR_TYPE	Designator Type	Indicates if the designator used to extract the finance accounting line was an academic period-based designator or a financial aid year-based designator.	CHAR(1)
DESIGNATOR_TYPE_DESC	Designator Type Description	Designator type description.	VARCHAR2(21)
DETAIL_CODE		Code defining type of transaction in accounts receivable.	VARCHAR2(4)		TBBDETC	TBBDETC_DETAIL_CODE
DETAIL_CODE_DESC		Transaction type description.	VARCHAR2(30)		TBBDETC	TBBDETC_DESC
DETAIL_CODE_TYPE		Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)		TBBDETC	TBBDETC_DESC
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EFFECTIVE_DATE		Record effective date.	DATE		TBBEACT	TBBEACT_EFF_DATE
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
NEXT_CHANGE_DATE		Date at which this information changes.	DATE		TBBEACT	TBBEACT_NCHG_DATE
PERCENT		Percentage of the amount associated with the detail that would be posted with this accounting distribution.	NUMBER(8, 5)		TBRACCT	TBRACCT_PERCENT
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: