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
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
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_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.			TBRACCT	TBRACCT_A_ACCI_CODE
A_ACCOUNT_INDEX_DESC	Banner finance account index 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_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.			TBRACCT	TBRACCT_B_ACCI_CODE
B_ACCOUNT_INDEX_DESC	Banner finance account index 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
DESIGNATOR	Academic period-based designator.			TBRACCT	TBRACCT_TBDS_CODE
DESIGNATOR_DESC	Academic period-based designator description.			CALCULATION	CASE WHEN DESIGNATOR_TYPE = 'T' THEN DESIGNATOR_DESC = SUBSTR ( (SELECT VALUE_DESCRIPTION FROM MGT_VALIDATION WHERE TABLE_NAME = 'TTVTBDS' AND VALUE = A.DESIGNATOR), 1, 255) ELSE WHEN DESIGNATOR_TYPE = 'Y THEN DESIGNATOR_DESC = SUBSTR ( (SELECT VALUE_DES
DESIGNATOR_IND	Indicates whether the academic period-based designator is to be used.			TBBEACT	TBBEACT_TBDC_IND
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.			CALCULATION	CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE = 'T' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE = 'A' ELSE DESIGNATOR_TYPE = 'N' END CASE;
DESIGNATOR_TYPE_DESC	Designator type description.			CALCULATION	CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE_DESC = 'ACADEMIC PERIOD-BASED' ELSE WHEN TBBDETC_ABDC_IND = 'Y' THEN DESIGNATOR_TYPE_DESC = 'AID YEAR-BASED' ELSE DESIGNATOR_TYPE_DESC = 'NO DESIGNATOR' END CASE;
DETAIL_CODE	Code defining type of transaction in accounts receivable.			TBRACCT	TBRACCT_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_TYPE_IND
EFFECTIVE_DATE	Date the transaction becomes effective. As of this date, the transaction is calculated into amount due and is eligible to be fed to accounting.			TBBEACT	TBBEACT_EFF_DATE
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description 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
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3