ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACCOUNT_A	Actual account number from a finance system associated with this detail code.			TBRACCT	TBRACCT_ACCOUNT_A
ACCOUNT_B	Actual account number from a finance system associated with this detail code.			TBRACCT	TBRACCT_ACCOUNT_B
A_ACCOUNT	Banner finance account code for account a.			TBRACCT	TBRACCT_A_ACCT_CODE
A_ACCOUNT_DESC	Banner finance account description for account a.			FUNCTION	GOKODSF.F_GET_DESC
A_ACTIVITY	Banner finance activity code for account a.			TBRACCT	TBRACCT_A_ACTV_CODE
A_ACTIVITY_DESC	Banner finance activity description for account a.			FUNCTION	GOKODSF.F_GET_DESC
A_CHART_OF_ACCOUNTS	Banner finance chart of accounts code for account a.			TBRACCT	TBRACCT_A_COAS_CODE
A_CHART_OF_ACCOUNTS_DESC	Banner finance chart of accounts description for account a.			FUNCTION	GOKODSF.F_GET_DESC
A_FUND	Banner finance fund code for account a.			TBRACCT	TBRACCT_A_FUND_CODE
A_FUND_DESC	Banner finance fund description for account a.			FUNCTION	GOKODSF.F_GET_DESC
A_LOCATION	Banner finance location code for account a.			TBRACCT	TBRACCT_A_LOCN_CODE
A_LOCATION_DESC	Banner finance location description for account a.			FUNCTION	GOKODSF.F_GET_DESC
A_ORGANIZATION	Banner finance organization code for account a.			TBRACCT	TBRACCT_A_ORGN_CODE
A_ORGANIZATION_DESC	Banner finance organization description for account a.			FUNCTION	GOKODSF.F_GET_DESC
A_PROGRAM	Banner finance program code for account a.			TBRACCT	TBRACCT_A_PROG_CODE
A_PROGRAM_DESC	Banner finance program description for account a.			FUNCTION	GOKODSF.F_GET_DESC
A_RULE_CLASS1	First accounting transaction code defining rules used to control transaction updates to the ledgers.			TBRACCT	TBRACCT_A_RUCL_CODE1
A_RULE_CLASS2	Second accounting transaction code defining rules used to control transaction updates to the ledgers.			TBRACCT	TBRACCT_A_RUCL_CODE2
A_RULE_CLASS3	Third accounting transaction code defining rules used to control transaction updates to the ledgers.			TBRACCT	TBRACCT_A_RUCL_CODE3
A_RULE_CLASS_DESC1	First rule class description.			FUNCTION	GOKODSF.F_GET_DESC
A_RULE_CLASS_DESC2	Second rule class description.			FUNCTION	GOKODSF.F_GET_DESC
A_RULE_CLASS_DESC3	Third rule class description.			FUNCTION	GOKODSF.F_GET_DESC
B_ACCOUNT	Banner finance account code for account b.			TBRACCT	TBRACCT_B_ACCT_CODE
B_ACCOUNT_DESC	Banner finance account description for account b.			FUNCTION	GOKODSF.F_GET_DESC
B_ACTIVITY	Banner finance activity code for account b.			TBRACCT	TBRACCT_B_ACTV_CODE
B_ACTIVITY_DESC	Banner finance activity description for account b.			FUNCTION	GOKODSF.F_GET_DESC
B_CHART_OF_ACCOUNTS	Banner finance chart of accounts code for account b.			TBRACCT	TBRACCT_B_COAS_CODE
B_CHART_OF_ACCOUNTS_DESC	Banner finance chart of accounts description for account b.			FUNCTION	GOKODSF.F_GET_DESC
B_FUND	Banner finance fund code for account b.			TBRACCT	TBRACCT_B_FUND_CODE
B_FUND_DESC	Banner finance fund description for account b.			FUNCTION	GOKODSF.F_GET_DESC
B_LOCATION	Banner finance location code for account b.			TBRACCT	TBRACCT_B_LOCN_CODE
B_LOCATION_DESC	Banner finance location description for account b.			FUNCTION	GOKODSF.F_GET_DESC
B_ORGANIZATION	Banner finance organization code for account b.			TBRACCT	TBRACCT_B_ORGN_CODE
B_ORGANIZATION_DESC	Banner finance organization description for account b.			FUNCTION	GOKODSF.F_GET_DESC
B_PROGRAM	Banner finance program code for account b.			TBRACCT	TBRACCT_B_PROG_CODE
B_PROGRAM_DESC	Banner finance program description for account b.			FUNCTION	GOKODSF.F_GET_DESC
B_RULE_CLASS1	First accounting transaction code defining rules used to control transaction updates to the ledgers.			TBRACCT	TBRACCT_B_RUCL_CODE1
B_RULE_CLASS2	Second accounting transaction code defining rules used to control transaction updates to the ledgers.			TBRACCT	TBRACCT_B_RUCL_CODE2
B_RULE_CLASS3	Third accounting transaction code defining rules used to control transaction updates to the ledgers.			TBRACCT	TBRACCT_B_RUCL_CODE3
B_RULE_CLASS_DESC1	First rule class description.			FUNCTION	GOKODSF.F_GET_DESC
B_RULE_CLASS_DESC2	Second rule class description.			FUNCTION	GOKODSF.F_GET_DESC
B_RULE_CLASS_DESC3	Third rule class description.			FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
DESIGNATOR	Academic period-based designator.			TBRACCT	TBRACCT_TBDS_CODE
DESIGNATOR_IND	Indicates whether the academic period-based designator is to be used.			TBBEACT	TBBEACT_TBDC_IND
DETAIL_CODE	Code defining type of transaction in accounts receivable.			TBBDETC	TBBDETC_DETAIL_CODE
DETAIL_CODE_DESC	Transaction type description.			TBBDETC	TBBDETC_DESC
DETAIL_CODE_TYPE	Determines if the detail code is being used as a charge or a payment.			TBBDETC	TBBDETC_DESC
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
EFFECTIVE_DATE	Record effective date.			TBBEACT	TBBEACT_EFF_DATE
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
NEXT_CHANGE_DATE	Date at which this information changes.			TBBEACT	TBBEACT_NCHG_DATE
PERCENT	Percentage of the amount associated with the detail that would be posted with this accounting distribution.			TBRACCT	TBRACCT_PERCENT
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3