| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
AUTOMATED_CLEARING_HOUSE_IND
 | 
Automated Clearing House Indicator 
 | 
Indicates whether payment was made via direct deposit.
 | 
VARCHAR2(1)
 | 
 
 | 
 FABCHKS
 
 | 
 FABCHKS_ACH_IND
 
 | 
| 
BANK
 | 
Bank 
 | 
Code used to identify the bank account on all cash transactions.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABINCK
 
 | 
 FABINCK_BANK_CODE
 
 | 
| 
BANK_CHECK_AMOUNT
 | 
Bank Check Amount 
 | 
Bank check amount.
 | 
NUMBER
 | 
 
 | 
 FABBKTP
 
 | 
 FABBKTP_AMT
 
 | 
| 
BANK_DESC
 | 
Bank Description 
 | 
Name of the bank where the institution has accounts.
 | 
VARCHAR2(255)
 | 
 
 | 
 GXVBANK
 
 | 
 GXVBANK_ACCT_NAME
 
 | 
| 
BANK_ID
 | 
Bank ID 
 | 
ID of the bank where the Institution has accounts.
 | 
VARCHAR2(63)
 | 
 
 | 
 SPRIDEN
 
 | 
 SPRIDEN_ID
 
 | 
| 
BANK_NAME
 | 
Bank Name 
 | 
Official banking institution name.
 | 
VARCHAR2(63)
 | 
 
 | 
 GXVBANK SPRIDEN
 
 | 
 GXVBANK_ACCT_NAME SPRIDEN_LAST_NAME
 
 | 
| 
BANK_RECONCILIATION_IND
 | 
Bank Reconciliation Indicator 
 | 
Indicates whether a check has been reconciled against the bank in the check transaction table. (R)econciled or (F)inal reconciliation.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABBKTP
 
 | 
 FABBKTP_RECON_IND
 
 | 
| 
BANK_RECONCILIATION_IND_DESC
 | 
Bank Reconciliation Indicator Description 
 | 
Reconciliation indicator description.
 | 
VARCHAR2(255)
 | 
 
 | 
 CALCULATION
 
 | 
 CASE WHEN FABBKTP_RECON_IND
 
 | 
| 
BANK_TRANSACTION_COMMENT
 | 
Bank Transaction Comment 
 | 
Bank transaction comment.
 | 
VARCHAR2(255)
 | 
 
 | 
 FABBKTP
 
 | 
 FABBKTP_DESC
 
 | 
| 
BANK_TRANSACTION_DATE
 | 
Bank Transaction Date 
 | 
Date the bank processed the check.
 | 
DATE
 | 
 
 | 
 FABBKTP
 
 | 
 FABBKTP_TRANS_DATE
 
 | 
| 
BANK_UID
 | 
Bank UID 
 | 
Internal identification number of the bank where the institution has accounts.
 | 
NUMBER
 | 
 
 | 
 GXVBANK
 
 | 
 GXVBANK_BANK_CODE_PIDM
 
 | 
| 
CANCEL_DATE
 | 
Cancel Date 
 | 
Date the check was cancelled.
 | 
DATE
 | 
 
 | 
 FABINCK
 
 | 
 FABINCK_CANCEL_DATE
 
 | 
| 
CANCEL_IND
 | 
Cancel Indicator 
 | 
Indicates if the check was canceled.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABINCK
 
 | 
 FABINCK_CANCEL_IND
 
 | 
| 
CHECK_ACTIVITY_DATE
 | 
Check Activity Date
 | 
Date that information for this record in the table was entered or last updated.
 | 
DATE
 | 
 
 | 
 FABCHKS
 
 | 
 FABHCKS_ACTIVITY_DATE
 
 | 
| 
CHECK_DATE
 | 
Check Date 
 | 
Date of issue for a check.
 | 
DATE
 | 
 
 | 
 FABINCK
 
 | 
 FABINCK_CHECK_DATE
 
 | 
| 
CHECK_NUMBER
 | 
Check Number 
 | 
Printed check number.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABINCK
 
 | 
 FABINCK_CHECK_NUM
 
 | 
| 
CHECK_TYPE
 | 
Check Type 
 | 
Indicates how the check was produced.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABINCK
 
 | 
 FABINCK_CHECK_TYPE_IND
 
 | 
| 
CHECK_TYPE_DESC
 | 
Check Type Description 
 | 
Check type description.
 | 
VARCHAR2(255)
 | 
 
 | 
 CALCULATION
 
 | 
 CASE WHEN FABCHKS_CHECK_TYPE_IND
 
 | 
| 
CHECK_USER_ID
 | 
Check User ID
 | 
Unique identification code of the user who entered or last touched the record.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABCHKS
 
 | 
 FABCHKS_USER_ID
 
 | 
| 
INVOICE
 | 
Invoice 
 | 
Invoice document number.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABINCK
 
 | 
 FABINCK_INVH_CODE
 
 | 
| 
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
 
 | 
| 
NET_AMOUNT
 | 
Net Amount 
 | 
Net amount of an invoice.
 | 
NUMBER
 | 
 
 | 
 FABINCK
 
 | 
 FABINCK_NET_AMT
 
 | 
| 
PAY_TYPE
 | 
Pay Type
 | 
Payment type descriptor used for payments initiated in Banner Finance as checks and sent for disbursement from PayNetExchange.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABCHKS
 
 | 
 FABCHKS_PAY_TYPE
 
 | 
| 
PAY_TYPE_DESC
 | 
Pay Type Description
 | 
Payment type description.
 | 
VARCHAR2(255)
 | 
 
 | 
 CALCULATION
 
 | 
 CASE WHEN FABCHKS_PAY_TYPE
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
RECONCILIATION_IND
 | 
Reconciliation Indicator 
 | 
Indicates whether a check has been reconciled against the bank in the check transaction table. (R)econciled or (F)inal reconciliation.
 | 
VARCHAR2(63)
 | 
 
 | 
 FABCHKS
 
 | 
 FABCHKS_RECON_IND
 
 | 
| 
RECONCILIATION_IND_DESC
 | 
Reconciliation Indicator Description 
 | 
Reconciliation indicator description.
 | 
VARCHAR2(255)
 | 
 
 | 
 CALCULATION
 
 | 
 CASE WHEN FABCHKS_RECON_IND
 
 |