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