| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACCOUNT_A
|
Account A
|
Actual account number from a finance system associated with this detail code.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_ACCOUNT_A
|
|
ACCOUNT_B
|
Account B
|
Actual account number from a finance system associated with this detail code.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_ACCOUNT_B
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
A_ACCOUNT
|
A Account
|
Banner finance account code for account a.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_ACCT_CODE
|
|
A_ACCOUNT_DESC
|
A Account Description
|
Banner finance account description for account a.
|
VARCHAR2(255)
|
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(63)
|
TBRACCT
|
TBRACCT_A_ACCI_CODE
|
|
A_ACCOUNT_INDEX_DESC
|
A Account Index Description.
|
Banner finance account index description for account a.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_ACTIVITY
|
A Activity
|
Banner finance activity code for account a.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_ACTV_CODE
|
|
A_ACTIVITY_DESC
|
A Activity Description
|
Banner finance activity description for account a.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_CHART_OF_ACCOUNTS
|
A Chart Of Accounts
|
Banner finance chart of accounts code for account a.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_COAS_CODE
|
|
A_CHART_OF_ACCOUNTS_DESC
|
A Chart Of Accounts Description
|
Banner finance chart of accounts description for account a.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_FUND
|
A Fund
|
Banner finance fund code for account a.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_FUND_CODE
|
|
A_FUND_DESC
|
A Fund Description
|
Banner finance fund description for account a.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_LOCATION
|
A Location
|
Banner finance location code for account a.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_LOCN_CODE
|
|
A_LOCATION_DESC
|
A Location Description
|
Banner finance location description for account a.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_ORGANIZATION
|
A Organization
|
Banner finance organization code for account a.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_ORGN_CODE
|
|
A_ORGANIZATION_DESC
|
A Organization Description
|
Banner finance organization description for account a.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_PROGRAM
|
A Program
|
Banner finance program code for account a.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_PROG_CODE
|
|
A_PROGRAM_DESC
|
A Program Description
|
Banner finance program description for account a.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_RULE_CLASS1
|
A Rule Class 1
|
First accounting transaction code defining rules used to control transaction updates to the ledgers.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_RUCL_CODE1
|
|
A_RULE_CLASS2
|
A Rule Class 2
|
Second accounting transaction code defining rules used to control transaction updates to the ledgers.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_RUCL_CODE2
|
|
A_RULE_CLASS3
|
A Rule Class 3
|
Third accounting transaction code defining rules used to control transaction updates to the ledgers.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_A_RUCL_CODE3
|
|
A_RULE_CLASS_DESC1
|
A Rule Class Description 1
|
First rule class description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_RULE_CLASS_DESC2
|
A Rule Class Description 2
|
Second rule class description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
A_RULE_CLASS_DESC3
|
A Rule Class Description 3
|
Third rule class description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_ACCOUNT
|
B Account
|
Banner finance account code for account b.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_ACCT_CODE
|
|
B_ACCOUNT_DESC
|
B Account Description
|
Banner finance account description for account b.
|
VARCHAR2(255)
|
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(63)
|
TBRACCT
|
TBRACCT_B_ACCI_CODE
|
|
B_ACCOUNT_INDEX_DESC
|
B Account Index Description
|
Banner finance account index description for account b.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_ACTIVITY
|
B Activity
|
Banner finance activity code for account b.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_ACTV_CODE
|
|
B_ACTIVITY_DESC
|
B Activity Description
|
Banner finance activity description for account b.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_CHART_OF_ACCOUNTS
|
B Chart Of Accounts
|
Banner finance chart of accounts code for account b.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_COAS_CODE
|
|
B_CHART_OF_ACCOUNTS_DESC
|
B Chart Of Accounts Description
|
Banner finance chart of accounts description for account b.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_FUND
|
B Fund
|
Banner finance fund code for account b.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_FUND_CODE
|
|
B_FUND_DESC
|
B Fund Description
|
Banner finance fund description for account b.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_LOCATION
|
B Location
|
Banner finance location code for account b.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_LOCN_CODE
|
|
B_LOCATION_DESC
|
B Location Description
|
Banner finance location description for account b.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_ORGANIZATION
|
B Organization
|
Banner finance organization code for account b.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_ORGN_CODE
|
|
B_ORGANIZATION_DESC
|
B Organization Description
|
Banner finance organization description for account b.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_PROGRAM
|
B Program
|
Banner finance program code for account b.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_PROG_CODE
|
|
B_PROGRAM_DESC
|
B Program Description
|
Banner finance program description for account b.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_RULE_CLASS1
|
B Rule Class 1
|
First accounting transaction code defining rules used to control transaction updates to the ledgers.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_RUCL_CODE1
|
|
B_RULE_CLASS2
|
B Rule Class 2
|
Second accounting transaction code defining rules used to control transaction updates to the ledgers.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_RUCL_CODE2
|
|
B_RULE_CLASS3
|
B Rule Class 3
|
Third accounting transaction code defining rules used to control transaction updates to the ledgers.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_B_RUCL_CODE3
|
|
B_RULE_CLASS_DESC1
|
B Rule Class Description 1
|
First rule class description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_RULE_CLASS_DESC2
|
B Rule Class Description 2
|
Second rule class description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
B_RULE_CLASS_DESC3
|
B Rule Class Description 3
|
Third rule class description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
DESIGNATOR
|
Designator
|
Academic period-based or financial aid year-based designator.
|
VARCHAR2(63)
|
CALCULATION
|
CASE WHEN NVL(TBBEACT_TBDC_IND, 'N')
|
|
DESIGNATOR_DESC
|
Designator Description
|
Academic period-based or financial aid year-based designator description.
|
VARCHAR2(255)
|
TTVABDS TTVTBDS
|
TTVABDS_DESC TTVTBDS_DESC
|
|
DESIGNATOR_IND
|
Designator Indicator
|
Indicates whether the academic period-based or finanical aid year-based designator is used.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN TBBEACT_TBDC_IND
|
|
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.
|
VARCHAR2(1)
|
CALCULATION
|
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE =
|
|
DESIGNATOR_TYPE_DESC
|
Designator Type Description
|
Designator type description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC =
|
|
DETAIL_CODE
|
Detail Code
|
Code defining type of transaction in accounts receivable.
|
VARCHAR2(63)
|
TBRACCT
|
TBRACCT_DETAIL_CODE
|
|
DETAIL_CODE_DESC
|
Detail Code Description
|
Transaction type description.
|
VARCHAR2(255)
|
TBBDETC
|
TBBDETC_DESC
|
|
DETAIL_CODE_TYPE
|
Detail Code Type
|
Determines if the detail code is being used as a charge or a payment.
|
VARCHAR2(1)
|
TBBDETC
|
TBBDETC_TYPE_IND
|
|
EFFECTIVE_DATE
|
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.
|
DATE
|
TBBEACT
|
TBBEACT_EFF_DATE
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
NEXT_CHANGE_DATE
|
Next Change Date
|
Date at which this information changes.
|
DATE
|
TBBEACT
|
TBBEACT_NCHG_DATE
|
|
PERCENT
|
Percent
|
Percentage of the amount associated with the detail that would be posted with this accounting distribution.
|
NUMBER
|
TBRACCT
|
TBRACCT_PERCENT
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|