Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT_POSTING_STATUS	Account Posting Status	Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed.	VARCHAR2(63)	TBRAPPL	TBRAPPL_ACCT_FEED_IND
ACCOUNT_UID	Account UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRAPPL	TBRAPPL_PIDM
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
APPLIED_AMOUNT	Applied Amount	Amount of the payment that paid off the charge.	NUMBER	CALCULATION	(APPLIED_AMOUNT * (CLGR.PERCENT/100) * (PLGR.PERCENT/100))
APPLIED_DATE	Applied Date	Transaction number of a specific application of payment. This transaction was used to directly apply to the transaction number specified here.	DATE	CALCULATION	NVL(PAY.TRANSACTION_DATE,CHG.TRANSACTION_DATE)
APPL_OF_PAYMENT_ACTIVITY_DATE	Applicant Of Payment Activity Date	Date that information for this record in the table was entered or last updated.	DATE	TBRAPPL	TBRAPPL_ACTIVITY_DATE
APPL_OF_PAYMENT_USER_ID	Applicant Of Payment User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	TBRAPPL	TBRAPPL_USER
CHARGE_ACCOUNT	Charge Account	Banner finance account used for the charge.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_ACCT_CODE TBRACCT_B_ACCT_CODE
CHARGE_ACCOUNT_DESC	Charge Account Description	Account description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CHARGE_ACCOUNT_EXTERNAL	Charge Account External	Actual account number from a finance system associated with the pay transaction.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_ACCOUNT_A TBRACCT_ACCOUNT_B
CHARGE_ACTIVITY	Charge Activity	Banner finance activity used for the charge.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_ACTV_CODE TBRACCT_B_ACTV_CODE
CHARGE_ACTIVITY_DESC	Charge Activity Description	Activity description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CHARGE_CATEGORY	Charge category	Charge category.	VARCHAR2(63)	TBBDETC	TBBDETC_DCAT_CODE
CHARGE_CATEGORY_DESC	Charge category description	Charge category description.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
CHARGE_CHART_OF_ACCOUNTS	Charge Chart Of Accounts	Banner finance chart of accounts code used for the charge.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_COAS_CODE TBRACCT_B_COAS_CODE
CHARGE_CHART_OF_ACCOUNTS_DESC	Charge Chart Of Accounts Description	Chart of accounts description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CHARGE_DETAIL_CODE	Charge Detail Code	Code defining type of charge transaction in accounts receivable.	VARCHAR2(63)	TBRACCD	TBRACCD_DETAIL_CODE
CHARGE_DETAIL_CODE_DESC	Charge Detail Code Description	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
CHARGE_DETAIL_CODE_TYPE	Charge Detail Code Type	Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)	TBBDETC	TBBDETC_TYPE_IND
CHARGE_FUND	Charge Fund	Banner finance fund used for the charge.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_FUND_CODE TBRACCT_B_FUND_CODE
CHARGE_FUND_DESC	Charge Fund Description	Fund description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CHARGE_LOCATION	Charge Location	Banner finance location used for the charge.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_LOCN_CODE TBRACCT_B_LOCN_CODE
CHARGE_LOCATION_DESC	Charge Location Description	Location description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CHARGE_OPERATING_DESIGNATOR	Charge Operating Designator	Extracted academic period-based designator to be used for initial transactions.	VARCHAR2(63)	FUNCTION	TOKODSF.F_TERM_CODE_TBDS
CHARGE_ORGANIZATION	Charge Organization	Banner finance organization used for the charge.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_ORGN_CODE TBRACCT_B_ORGN_CODE
CHARGE_ORGANIZATION_DESC	Charge Organization Description	Organization description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CHARGE_PERCENT	Charge Percent	Percentage of the amount associated with the detail applied to the charge transaction.	NUMBER	TBRACCT	TBRACCT_PERCENT
CHARGE_PROGRAM	Charge Program	Banner finance program used for the charge.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_PROG_CODE TBRACCT_B_PROG_CODE
CHARGE_PROGRAM_DESC	Charge Program Description	Program description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CHARGE_RULE_CLASS	Charge Rule Class	Accounting transaction code defining rules used to control charge transaction updates to the ledgers.	VARCHAR2(63)	TBRACCT TBRACCT TBRACCT TBRACCT	TBRACCT_A_RUCL_CODE2 TBRACCT_A_RUCL_CODE3 TBRACCT_B_RUCL_CODE2 TBRACCT_B_RUCL_CODE3
CHARGE_RULE_CLASS_DESC	Charge Rule Class Description	Rule class description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
CHARGE_TRAN_NUMBER	Charge Transaction Number	Transaction number of the detail code used as the charge transaction in application of payments.	NUMBER	TBRAPPL	TBRAPPL_CHG_TRAN_NUMBER
CONTRACT_PAYMENT_TRANSACTION	Contract Payment Transaction	Contract payment transaction number, which together with the pay transaction number identifies the receivable account detail record on which the application of payment is based.	NUMBER	TBRAPPL	TBRAPPL_CPDT_TRAN_NUMBER
DIRECT_PAY_IND	Direct Pay Indicator	Indicates that the transaction was a direct application of payment specified when the transaction was entered on the account.	VARCHAR2(1)	TBRAPPL	TBRAPPL_DIRECT_PAY_IND
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAY_ACCOUNT	Pay Account	Banner finance account used for payment.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_ACCT_CODE TBRACCT_B_ACCT_CODE
PAY_ACCOUNT_DESC	Pay Account Description	Account description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAY_ACCOUNT_EXTERNAL	Pay Account External	Actual account number from a finance system associated with the pay transaction.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_ACCOUNT_A TBRACCT_ACCOUNT_B
PAY_ACTIVITY	Pay Activity	Banner finance activity used for payment.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_ACTV_CODE TBRACCT_B_ACTV_CODE
PAY_ACTIVITY_DESC	Pay Activity Description	Activity description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAY_CATEGORY	Pay category	Pay category	VARCHAR2(63)	TBBDETC	TBBDETC_DCAT_CODE
PAY_CATEGORY_DESC	Pay category description	Pay category description.	VARCHAR2(255)	TTVDCAT	TTVDCAT_DESC
PAY_CHART_OF_ACCOUNTS	Pay Chart Of Accounts	Banner finance chart of accounts code used for payment.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_COAS_CODE TBRACCT_B_COAS_CODE
PAY_CHART_OF_ACCOUNTS_DESC	Pay Chart Of Accounts Description	Chart of accounts description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAY_DETAIL_CODE	Pay Detail Code	Code defining type of payment transaction in accounts receivable.	VARCHAR2(63)	TBRACCD	TBRACCD_DETAIL_CODE
PAY_DETAIL_CODE_DESC	Pay Detail Code Description	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
PAY_DETAIL_CODE_TYPE	Pay Detail Code Type	Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)	TBBDETC	TBBDETC_TYPE_IND
PAY_FUND	Pay Fund	Banner finance fund used for payment.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_FUND_CODE TBRACCT_B_FUND_CODE
PAY_FUND_DESC	Pay Fund Description	Fund description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAY_LOCATION	Pay Location	Banner finance location used for payment.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_LOCN_CODE TBRACCT_B_LOCN_CODE
PAY_LOCATION_DESC	Pay Location Description	Location description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAY_OPERATING_DESIGNATOR	Pay Operating Designator	Extracted academic period-based designator to be used for initial transactions.	VARCHAR2(63)	FUNCTION	TOKODSF.F_TERM_CODE_TBDS
PAY_ORGANIZATION	Pay Organization	Banner finance organization used for payment.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_ORGN_CODE TBRACCT_B_ORGN_CODE
PAY_ORGANIZATION_DESC	Pay Organization Description	Organization description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAY_PERCENT	Pay Percent	Percentage of the amount associated with the detail applied to the pay transaction.	NUMBER	TBRACCT	TBRACCT_PERCENT
PAY_PROGRAM	Pay Program	Banner finance program used for payment.	VARCHAR2(63)	TBRACCT TBRACCT	TBRACCT_A_PROG_CODE TBRACCT_B_PROG_CODE
PAY_PROGRAM_DESC	Pay Program Description	Program description for pay transaction.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAY_RULE_CLASS	Pay Rule Class	Accounting transaction code defining rules used to control payment transaction updates to the ledgers.	VARCHAR2(63)	TBRACCT TBRACCT TBRACCT TBRACCT	TBRACCT_A_RUCL_CODE2 TBRACCT_A_RUCL_CODE3 TBRACCT_B_RUCL_CODE2 TBRACCT_B_RUCL_CODE3
PAY_RULE_CLASS_DESC	Pay Rule Class Description	Rule class description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAY_TRAN_NUMBER	Pay Transaction Number	Transaction number of the detail code used as the payment transaction in application of payments.	NUMBER	TBRAPPL	TBRAPPL_PAY_TRAN_NUMBER
POSTING_DATE	Posting Date	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TBRAPPL	TBRAPPL_FEED_DATE
POSTING_DOCUMENT	Posting Document	Document code generated to identify and feed this transaction to finance.	VARCHAR2(63)	TBRAPPL	TBRAPPL_FEED_DOC_CODE
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REAPPLICATION_IND	Reapplication Indicator	Indicates that this application of payment record was created because the un-application of payment process had been run for this account. Valid value is: Y - the record was created due to an un-application of payment being processed, or was an original record that was unapplied.	VARCHAR2(1)	TBRAPPL	TBRAPPL_REAPPL_IND

Ver: 9.2