Target Column	Business Definition	Database Data Type	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	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	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	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	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	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	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.	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	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: