Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Academic period representing the accounts receivable term for disbursement.	VARCHAR2(63)	RPRADSB	RPRADSB_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACCEPTED_PAY_PERIOD_START_DATE	Start date of the payment period the record is referencing, as acknowledged by COD.	DATE	RPRADSB	RPRADSB_ACPT_PAY_PD_START_DATE	NO	NO
ACTIVITY_DATE	Date that information in this record was entered or last updated.	DATE	RPRADSB	RPRADSB_ACTIVITY_DATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AID_ENROLLMENT_PERIOD	Aid enrollment period associated with the award schedule. This period can span multiple student terms.	VARCHAR2(63)	RPRADSB	RPRADSB_PERIOD	NO	NO
AID_ENROLLMENT_PERIOD_DESC	Aid enrollment period description.	VARCHAR2(255)	ROBPRDS	ROBPRDS_DESC	NO	NO
AID_PERIOD	Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc.	VARCHAR2(63)	FUNCTION	MRKFUNC.F_GET_AID_PERIOD	NO	NO
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(255)	FUNCTION	MRKFUNC.F_GET_AID_PERIOD	NO	NO
AID_YEAR	Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.	VARCHAR2(63)	RPRADSB	RPRADSB_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ALTERNATE_PELL_PAY_SCHED_IND	Indicates whether Alternate Federal Pell Grant Schedules were used to calculate the disbursement amount on this record. Otherwise, Federal Pell Grant Program Regular Payment Schedules were used to calculate the disbursement amount. After the 2007-2008 aid year alternate pell is no longer used.	VARCHAR2(1)	CALCULATION	DECODE(RPRADSB_ALTERNATE_PELL_IND,'N')	NO	NO
COD_CONCURRENT_ENROLLMENT_IND	Indicates that applicant has concurrent enrollment, and may require correction.	VARCHAR2(1)	CALCULATION	DECODE(RPRADSB_CONCUR_ENROLL_FLAG)	NO	NO
COD_DEBIT_CREDIT	Debit/credit indicator for this disbursement, as acknowledged by COD. Indicates if the disbursement is positive (P) or negative (N).	VARCHAR2(63)	RPRADSB	RPRADSB_DISB_ACPT_DEBIT_CR_IND	NO	NO
COD_DEBIT_CREDIT_DESC	Description of the debit/credit indicators.	VARCHAR2(255)	CALCULATION	DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND)	NO	NO
COD_DISBURSED_DATE	Date this disbursement is made as acknowledged by COD.	DATE	RPRADSB	RPRADSB_DISB_ACPT_DATE	NO	NO
COD_DISBURSEMENT_ACTION	COD processing status of the disbursement. A=accepted disbursement amount, C=corrected disbursement amount, E=rejected disbursement amount.	VARCHAR2(63)	RPRADSB	RPRADSB_DISB_ACTION_CODE	NO	NO
COD_DISBURSEMENT_ACTION_DESC	Description of the COD processing status.	VARCHAR2(255)	CALCULATION	DECODE(RPRADSB_DISB_ACTION_CODE)	NO	NO
COD_DISBURSEMENT_CROSS_REF	Institution defined identifier used to identify student records internally.	VARCHAR2(63)	RPRADSB	RPRADSB_INST_XREF	NO	NO
COD_DISBURSEMENT_DATE	Actual date of disbursement of the payment or if not yet disbursed, the scheduled disbursement date.	DATE	RPRADSB	RPRADSB_DISB_DATE	NO	NO
COD_DISBURSEMENT_LOCK_IND	Indicates that the disbursement record should not be resubmitted to COD.	VARCHAR2(1)	CALCULATION	NVL(RPRADSB_DISB_LOCK_IND,'N')	NO	NO
COD_DISBURSEMENT_NUMBER	Sequence number associated with the disbursement. Valid values are 01 - 99.	NUMBER	RPRADSB	RPRADSB_ACPT_DISB_SEQ_NO	NO	NO
COD_DISBURSEMENT_SENT_DATE	Date the disbursement record was extracted for submission to COD.	DATE	RPRADSB	RPRADSB_DISB_DATE_SENT	NO	NO
COD_DISB_EDIT_FIELD1	Field (XML tag) associated with edit 1.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_FIELD_1	NO	NO
COD_DISB_EDIT_FIELD2	Field (XML tag) associated with edit 2.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_FIELD_2	NO	NO
COD_DISB_EDIT_FIELD3	Field (XML tag) associated with edit 3.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_FIELD_3	NO	NO
COD_DISB_EDIT_FIELD4	Field (XML tag) associated with edit 4.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_FIELD_4	NO	NO
COD_DISB_EDIT_FIELD5	Field (XML tag) associated with edit 5.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_FIELD_5	NO	NO
COD_DISB_EDIT_REJECT_CODE1	Disbursement Edit/Reject/Comment code 1.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_01	NO	NO
COD_DISB_EDIT_REJECT_CODE10	Disbursement Edit/Reject/Comment code 10.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_10	NO	NO
COD_DISB_EDIT_REJECT_CODE2	Disbursement Edit/Reject/Comment code 2.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_02	NO	NO
COD_DISB_EDIT_REJECT_CODE3	Disbursement Edit/Reject/Comment code 3.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_03	NO	NO
COD_DISB_EDIT_REJECT_CODE4	Disbursement Edit/Reject/Comment code 4.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_04	NO	NO
COD_DISB_EDIT_REJECT_CODE5	Disbursement Edit/Reject/Comment code 5.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_05	NO	NO
COD_DISB_EDIT_REJECT_CODE6	Disbursement Edit/Reject/Comment code 6.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_06	NO	NO
COD_DISB_EDIT_REJECT_CODE7	Disbursement Edit/Reject/Comment code 7.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_07	NO	NO
COD_DISB_EDIT_REJECT_CODE8	Disbursement Edit/Reject/Comment code 8.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_08	NO	NO
COD_DISB_EDIT_REJECT_CODE9	Disbursement Edit/Reject/Comment code 9.	VARCHAR2(63)	RPRADSB	RPRADSB_EDIT_REJ_09	NO	NO
COD_DISB_EDIT_REJECT_DESC1	Disbursement Edit Reject Code Description 1.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC10	Disbursement Edit Reject Code Description 10.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC2	Disbursement Edit Reject Code Description 2.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC3	Disbursement Edit Reject Code Description 3.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC4	Disbursement Edit Reject Code Description 4.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC5	Disbursement Edit Reject Code Description 5.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC6	Disbursement Edit Reject Code Description t 6.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC7	Disbursement Edit Reject Code Description 7.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC8	Disbursement Edit Reject Code Description 8.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_REJECT_DESC9	Disbursement Edit Reject Code Description 9.	VARCHAR2(255)	RTVRJCT	RTVRJCT_DESC	NO	NO
COD_DISB_EDIT_VALUE1	New value applied to response edit field 1 if a correction is applied.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_VALUE_1	NO	NO
COD_DISB_EDIT_VALUE2	New value applied to response edit field 2 if a correction is applied.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_VALUE_2	NO	NO
COD_DISB_EDIT_VALUE3	New value applied to response edit field 3 if a correction is applied.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_VALUE_3	NO	NO
COD_DISB_EDIT_VALUE4	New value applied to response edit field 4 if a correction is applied.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_VALUE_4	NO	NO
COD_DISB_EDIT_VALUE5	New value applied to response edit field 5 if a correction is applied.	VARCHAR2(255)	RPRADSB	RPRADSB_EDIT_VALUE_5	NO	NO
COD_NET_AMOUNT_EXCLUSION_IND	Indicates that this locked record should not be included in the calculation of net amount for the disbursement.	VARCHAR2(1)	CALCULATION	NVL(RPRADSB_EXCL_FROM_NET_AMT,'N')	NO	NO
COD_ORIGINATION_IDENTIFIER	Origination ID from the origination process used to match data from the origination to acknowledgement and disbursement records.	VARCHAR2(63)	RPRADSB	RPRADSB_ORIG_ID	NO	NO
COD_POTENTIAL_OVERPAYMENT_IND	Indicates that applicant has a potential overpayment, and may require correction.	VARCHAR2(1)	CALCULATION	DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG)	NO	NO
COD_PREVIOUS_DISB_SEQUENCE_NO	Previous disbursement sequence number on the COD database for the disbursement number.	NUMBER	RPRADSB	RPRADSB_ACPT_PREV_DISB_SEQ_NO	NO	NO
COD_REFERENCE_NUMBER	Reference number (sequence number) of this disbursement sent back on acknowledgement from COD. If COD is generating the disbursement, 91 through 99 is used.	NUMBER	RPRADSB	RPRADSB_DISB_ACK_REF_NO	NO	NO
COD_SHARED_SAR_IDENTIFIER_IND	Indicates that this student shares a SAR ID with another student, and requires correction.	VARCHAR2(1)	CALCULATION	DECODE(RPRADSB_SHARED_SAR_ID_FLAG)	NO	NO
COD_UNSIGNED_DISBURSED_AMOUNT	Amount of the disbursement, as acknowledged by COD. This always a positive amount. Negative payments will be sent as a positive amount with a debit/credit indicator of n.	NUMBER	RPRADSB	RPRADSB_DISB_ACPT_AMT	NO	NO
COD_YTD_AMOUNT_PAID	Year-to-date amount that has been disbursed to the student for this award year, as reported by COD.	NUMBER	RPRADSB	RPRADSB_YTD_AMT_PAID	NO	NO
CPS_VERIFICATION_IND	Indicates that the student was selected for verification but the school has not reported a valid verification status.	VARCHAR2(1)	CALCULATION	NVL(RPRADSB_CPS_VER_IND,'N')	NO	NO
DEBIT_CREDIT	Determines a debit or credit effect on the ledgers; plus or minus, debit or credit.	VARCHAR2(63)	RPRADSB	RPRADSB_DEBIT_CR_IND	NO	NO
DEBIT_CREDIT_DESC	Description of the debit/credit indicators.	VARCHAR2(255)	CALCULATION	DECODE(RPRADSB_DEBIT_CREDIT_IND)	NO	NO
DISBURSED_AMOUNT	Financial aid award sum disbursed for the time frame with a fund source type indicator equal to federal, and a fund type indicator equal to grant.	NUMBER	RPRADSB	RPRADSB_DISBURSE_AMT	NO	NO
DISBURSED_DATE	Date the disbursed amount was taken from the financial aid fund indicated.	DATE	RPRADSB	RPRADSB_DISBURSE_DATE	NO	NO
DISBURSED_PERCENTAGE	Percentage of the financial aid fund that has been disbursed.	NUMBER	RPRADSB	RPRADSB_DISBURSE_PCT	NO	NO
DISBURSEMENT_CHANGE_DATE_IND	Indicates whether this disbursement sequence is changing the Pell Advance Pay Reported Disbursement Date at COD to reflect the date paid in Banner.	VARCHAR2(1)	RPRADSB	RPRADSB_DATE_CHANGE_IND	NO	NO
DISBURSEMENT_LOAD	Displays the enrollment credits of the student at the time of the disbursement.	VARCHAR2(63)	RPRADSB	RPRADSB_DISBURSE_LOAD	NO	NO
DISBURSEMENT_LOAD_DESC	Disbursement load description.	VARCHAR2(255)	CALCULATION	DECODE(RPRADSB_DISBURSE_LOAD)	NO	NO
DISBURSEMENT_LOAD_OPT	Column to track disbursement enrollment option.	VARCHAR2(63)	RPRADSB	RPRADSB_DISBURSE_LOAD_OPT	NO	NO
DISBURSEMENT_LOAD_OPT_DESC	Description of the disbursement enrollment option.	VARCHAR2(255)	CALCULATION	DECODE(RPRADSB_DISBURSE_LOAD_OPT)	NO	NO
DISBURSEMENT_NUMBER	Reference number (sequence number) of this disbursement.	NUMBER	RPRADSB	RPRADSB_DISB_SEQ_NO	NO	NO
DOCUMENT_ID	Document number associated with the student's Pell disbursement record.	VARCHAR2(63)	RPRADSB	RPRADSB_DOCUMENT_ID	NO	NO
ELIG_SCHEDULE_USED_PERCENT	Percent of student's eligibility used by the institution for the scheduled award in the aid year.	NUMBER	RPRADSB	RPRADSB_PERCENT_ELIG_USED	NO	NO
ENROLLMENT_INSTITUTION	Government code (OPEID and Branch Code) representing the institution where the student is physically enrolled for this disbursement.	VARCHAR2(63)	RPRADSB	RPRADSB_ENROLLMENT_SCHOOL_CDE	NO	NO
ENROLLMENT_STATUS	The student's enrollment status for this disbursement.	VARCHAR2(63)	RPRADSB	RPRADSB_ENROLLMENT_STATUS	NO	NO
ENROLLMENT_STATUS_DESC	Description of the student's enrollment status for this disbursement.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RPRADSB	RPRADSB_FUND_CODE	NO	NO
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE	NO	NO
HIGHEST_CPS_TRANSACTION_NO	Returned in disbursement response files if CPS has a transaction number higher than the one reported by the school.	VARCHAR2(2)	RPRADSB	RPRADSB_HIGHEST_CPS_TRAN_NO	NO	NO
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	NO	NO
INSTITUTIONAL_LOAN_FEED_IND	Represents that a Loan Management System feed transaction has been created for an institutional loan disbursement.	VARCHAR2(1)	RPRADSB	RPRADSB_LMS_FEED_IND	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NET_AMOUNT_DISBURSED	Net amount of a particular disbursement as of the most recent extraction for reporting to cod.	NUMBER	RPRADSB	RPRADSB_DISB_NET_AMT	NO	NO
PAYMENT_PERIOD_START_DATE	Start date of the payment period the record is referencing.	DATE	RPRADSB	RPRADSB_PAY_PD_START_DATE	NO	NO
PELL_BATCH_NUMBER	Batch number associated with the student's Pell disbursement record.	VARCHAR2(63)	RPRADSB	RPRADSB_DISB_BATCH_NO	NO	NO
PELL_CALCULATED_DISB_AMOUNT	Calculated amount of the Pell award for the student, as a result of the disbursement process, before the disbursement options are considered.	NUMBER	RPRADSB	RPRADSB_PELL_CALC_DISB_AMT	NO	NO
PELL_CALCULATED_DISB_LOAD	Calculated enrollment load for the applicant's Pell award, as a result of the disbursement process, before the disbursement options are considered.	VARCHAR2(63)	RPRADSB	RPRADSB_PELLC_DISB_LOAD	NO	NO
PELL_CALCULATED_DISB_LOAD_DESC	Pell calculated disbursement load description.	VARCHAR2(255)	CALCULATION	DECODE(RPRADSB_PELLC_DISB_LOAD)	NO	NO
PELL_CALC_DISB_LOAD_OPTION	Source of the calculated enrollment load for the applicant's Pell award, as a result of the disbursement process, before the disbursement options are considered.	VARCHAR2(63)	RPRADSB	RPRADSB_PELLC_DISB_LOAD_OPT	NO	NO
PELL_CALC_DISB_LOAD_OPT_DESC	Description of the calculated enrollment load for the applicant's Pell award, as a result of the disbursement process, before the disbursement options are considered.	VARCHAR2(255)	CALCULATION	DECODE(RPRADSB_PELLC_DISB_LOAD_OPT)	NO	NO
PELL_LIFETIME_ELIGIBILITY_USED	Lifetime eligibility amount used for Pell grants.	NUMBER	RPRADSB	RPRADSB_PELL_LEU	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRADSB	RPRADSB_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	RPRADSB	RPRADSB_CIP_CODE	NO	NO
PROGRAM_CLASSIFICATION_DESC	Description of the classification of instructional program code associated with the student's major at the time of disbursement as is validated during disbursement for SMART Grants.	VARCHAR2(255)	FUNCTION	F_GET_CIPC_DESC	NO	NO
REFERENCE_NUMBER	Reference number (sequence number) of this disbursement.	NUMBER	RPRADSB	RPRADSB_DISB_REF_NO	NO	NO
SCHEDULED_AMOUNT	Scheduled amount of the disbursement associated with the fund.	NUMBER	FUNCTION	NVL(RPRADSB_SCHEDULE_AMT,ROKODSF.F_GET_RPRADSB_SCHEDULE_AMT	NO	NO
SCHEDULED_DATE	Date the disbursement was scheduled.	DATE	RPRADSB	RPRADSB_SCHEDULE_DATE	NO	NO
STUDENT_ACADEMIC_PERIOD	Academic period representing the term to pull the student data used for the aid enrollment period. As an example, student classification, or student.	VARCHAR2(63)	RORPRDS	RORPRDS_TERM_CODE	NO	NO
STUDENT_ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
TOTAL_DISBURSED_AMOUNT	Displays the amount actually disbursed for this fund.	NUMBER	RPRADSB	RPRADSB_DISBURSE_AMT	NO	NO
TRANSACTION_NUMBER	Transaction number on the student's account receivable detail.	NUMBER	RPRADSB	RPRADSB_TRAN_NUMBER	NO	NO
UNSIGNED_DISBURSED_AMOUNT	Amount of the disbursement as sent to RFMS. This always a positive amount. Negative payments will be sent as a positive amount with a debit/credit indicator of n.	NUMBER	RPRADSB	RPRADSB_DISB_AMT	NO	NO
USER_ID	Unique ID of the user who inserted or last updated this record.	VARCHAR2(63)	RPRADSB	RPRADSB_USER_ID	NO	NO
VERIFICATION_CORRECTION_IND	Indicates that this student has a verification W (Without Documentation) status, and requires correction and is for Pell only.	VARCHAR2(1)	RPRADSB	RPRADSB_VERIF_W_STATUS_FLAG	NO	NO

Ver: 9.2