Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period associated with the disbursement information in this record.	VARCHAR2(6)		RPRADSB	RPRADSB_TERM_CODE
ACADEMIC_PERIOD_DESC		Academic period description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ACCEPTED_PAY_PERIOD_START_DATE	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
ACTIVITY_DATE	Activity Date	Date that information in this record was entered or last updated.	DATE		RPRADSB	RPRADSB_ACTIVITY_DATE
AID_ENROLLMENT_PERIOD	Financial Aid Enrollment Period		VARCHAR2(15)
AID_YEAR		Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)		RPRADSB	RPRADSB_AIDY_CODE
AID_YEAR_DESC		Financial aid year name.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ALTERNATE_PELL_PAY_SCHED_IND	Alternate Pell Pay Sched Indicator	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	NVL(RPRADSB_ALTERNATE_PELL_IND,'N')
COD_CONCURRENT_ENROLLMENT_IND	Cod Concurrent Enrollment Indicator	Indicates that applicant has concurrent enrollment, and may require correction.	VARCHAR2(1)		CALCULATION	DECODE(RPRADSB_CONCUR_ENROLL_FLAG)
COD_DEBIT_CREDIT	Cod Debit Credit	Debit/credit indicator for this disbursement, as acknowledged by COD. Indicates if the disbursement is positive (P) or negative (N).	VARCHAR2(1)		RPRADSB	RPRADSB_DISB_ACPT_DEBIT_CR_IND
COD_DEBIT_CREDIT_DESC	Cod Debit Credit Description	Description of the debit/credit indicators.	VARCHAR2(10)		CALCULATION	DECODE(RPRADSB_DISB_ACPT_DEBIT_CR_IND)
COD_DISBURSED_DATE	Cod Disbursed Date	Date this disbursement is made as acknowledged by COD.	DATE		RPRADSB	RPRADSB_DISB_ACPT_DATE
COD_DISBURSEMENT_ACTION	Cod Disbursement Action	COD processing status of the disbursement. A=accepted disbursement amount, C=corrected disbursement amount, E=rejected disbursement amount.	VARCHAR2(1)		RPRADSB	RPRADSB_DISB_ACTION_CODE
COD_DISBURSEMENT_ACTION_DESC	Cod Disbursement Action Description	Description of the COD processing status.	VARCHAR2(30)		CALCULATION	DECODE(RPRADSB_DISB_ACTION_CODE)
COD_DISBURSEMENT_CROSS_REF	Cod Disbursement Cross Reference	Institution defined identifier used to identify student records internally.	VARCHAR2(9)		RPRADSB	RPRADSB_INST_XREF
COD_DISBURSEMENT_DATE	Cod Disbursement Date	Actual date of disbursement of the payment or if not yet disbursed, the scheduled disbursement date.	DATE		RPRADSB	RPRADSB_DISB_DATE
COD_DISBURSEMENT_LOCK_IND	Cod Disbursement Lock Indicator	Indicates that the disbursement record should not be resubmitted to COD.	VARCHAR2(1)		CALCULATION	NVL(RPRADSB_DISB_LOCK_IND,'N')
COD_DISBURSEMENT_NUMBER	Cod Disbursement Number	Sequence number associated with the disbursement. Valid values are 01 - 99.	NUMBER(2)		RPRADSB	RPRADSB_ACPT_DISB_SEQ_NO
COD_DISBURSEMENT_SENT_DATE	Cod Disbursement Sent Date	Date the disbursement record was extracted for submission to COD.	DATE		RPRADSB	RPRADSB_DISB_DATE_SENT
COD_DISB_EDIT_FIELD1	Cod Disb Edit Field 1	Field (XML tag) associated with edit 1.	VARCHAR2(200)		RPRADSB	RPRADSB_EDIT_FIELD_1
COD_DISB_EDIT_FIELD2	Cod Disb Edit Field 2	Field (XML tag) associated with edit 2.	VARCHAR2(200)		RPRADSB	RPRADSB_EDIT_FIELD_2
COD_DISB_EDIT_FIELD3	Cod Disb Edit Field 3	Field (XML tag) associated with edit 3.	VARCHAR2(200)		RPRADSB	RPRADSB_EDIT_FIELD_3
COD_DISB_EDIT_FIELD4	Cod Disb Edit Field 4	Field (XML tag) associated with edit 4.	VARCHAR2(200)		RPRADSB	RPRADSB_EDIT_FIELD_4
COD_DISB_EDIT_FIELD5	Cod Disb Edit Field 5	Field (XML tag) associated with edit 5.	VARCHAR2(200)		RPRADSB	RPRADSB_EDIT_FIELD_5
COD_DISB_EDIT_REJECT_CODE1	Cod Disb Edit Rejection Code 1	Disbursement Edit/Reject/Comment code 1.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_01
COD_DISB_EDIT_REJECT_CODE10	Cod Disb Edit Rejection Code 10	Disbursement Edit/Reject/Comment code 10.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_10
COD_DISB_EDIT_REJECT_CODE2	Cod Disb Edit Rejection Code 2	Disbursement Edit/Reject/Comment code 2.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_02
COD_DISB_EDIT_REJECT_CODE3	Cod Disb Edit Rejection Code 3	Disbursement Edit/Reject/Comment code 3.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_03
COD_DISB_EDIT_REJECT_CODE4	Cod Disb Edit Rejection Code 4	Disbursement Edit/Reject/Comment code 4.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_04
COD_DISB_EDIT_REJECT_CODE5	Cod Disb Edit Rejection Code 5	Disbursement Edit/Reject/Comment code 5.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_05
COD_DISB_EDIT_REJECT_CODE6	Cod Disb Edit Rejection Code 6	Disbursement Edit/Reject/Comment code 6.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_06
COD_DISB_EDIT_REJECT_CODE7	Cod Disb Edit Rejection Code 7	Disbursement Edit/Reject/Comment code 7.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_07
COD_DISB_EDIT_REJECT_CODE8	Cod Disb Edit Rejection Code 8	Disbursement Edit/Reject/Comment code 8.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_08
COD_DISB_EDIT_REJECT_CODE9	Cod Disb Edit Rejection Code 9	Disbursement Edit/Reject/Comment code 9.	VARCHAR2(3)		RPRADSB	RPRADSB_EDIT_REJ_09
COD_DISB_EDIT_REJECT_DESC1	Cod Disb Edit Rejection Description 1	Disbursement Edit Reject Code Description 1.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC10	Cod Disb Edit Rejection Description 10	Disbursement Edit Reject Code Description 10.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC2	Cod Disb Edit Rejection Description 2	Disbursement Edit Reject Code Description 2.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC3	Cod Disb Edit Rejection Description 3	Disbursement Edit Reject Code Description 3.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC4	Cod Disb Edit Rejection Description 4	Disbursement Edit Reject Code Description 4.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC5	Cod Disb Edit Rejection Description 5	Disbursement Edit Reject Code Description 5.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC6	Cod Disb Edit Rejection Description 6	Disbursement Edit Reject Code Description t 6.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC7	Cod Disb Edit Rejection Description 7	Disbursement Edit Reject Code Description 7.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC8	Cod Disb Edit Rejection Description 8	Disbursement Edit Reject Code Description 8.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_REJECT_DESC9	Cod Disb Edit Rejection Description 9	Disbursement Edit Reject Code Description 9.	VARCHAR2(65)		RTVRJCT	RTVRJCT_DESC
COD_DISB_EDIT_VALUE1	Cod Disb Edit Value 1	New value applied to response edit field 1 if a correction is applied.	VARCHAR2(150)		RPRADSB	RPRADSB_EDIT_VALUE_1
COD_DISB_EDIT_VALUE2	Cod Disb Edit Value 2	New value applied to response edit field 2 if a correction is applied.	VARCHAR2(150)		RPRADSB	RPRADSB_EDIT_VALUE_2
COD_DISB_EDIT_VALUE3	Cod Disb Edit Value 3	New value applied to response edit field 3 if a correction is applied.	VARCHAR2(150)		RPRADSB	RPRADSB_EDIT_VALUE_3
COD_DISB_EDIT_VALUE4	Cod Disb Edit Value 4	New value applied to response edit field 4 if a correction is applied.	VARCHAR2(150)		RPRADSB	RPRADSB_EDIT_VALUE_4
COD_DISB_EDIT_VALUE5	Cod Disb Edit Value 5	New value applied to response edit field 5 if a correction is applied.	VARCHAR2(150)		RPRADSB	RPRADSB_EDIT_VALUE_5
COD_NET_AMOUNT_EXCLUSION_IND	Cod Net Amount Exclusion Indicator	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')
COD_ORIGINATION_IDENTIFIER	Cod Origination Identifier	Origination ID from the origination process used to match data from the origination to acknowledgement and disbursement records.	VARCHAR2(23)		RPRADSB	RPRADSB_ORIG_ID
COD_POTENTIAL_OVERPAYMENT_IND	Cod Potential Overpayment Indicator	Indicates that applicant has a potential overpayment, and may require correction.	VARCHAR2(1)		CALCULATION	DECODE(RPRADSB_POTENTIAL_OVERPMT_FLAG)
COD_PREVIOUS_DISB_SEQUENCE_NO	Cod Previous Disb Sequence Number	Previous disbursement sequence number on the COD database for the disbursement number.	NUMBER(2)		RPRADSB	RPRADSB_ACPT_PREV_DISB_SEQ_NO
COD_REFERENCE_NUMBER	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(2)		RPRADSB	RPRADSB_DISB_ACK_REF_NO
COD_SHARED_SAR_IDENTIFIER_IND	Cod Shared SAR Identifier Indicator	Indicates that this student shares a SAR ID with another student, and requires correction.	VARCHAR2(1)		CALCULATION	DECODE(RPRADSB_SHARED_SAR_ID_FLAG)
COD_UNSIGNED_DISBURSED_AMOUNT	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(7,2)		RPRADSB	RPRADSB_DISB_ACPT_AMT
COD_YTD_AMOUNT_PAID	Cod Year to Date Amount Paid	Year-to-date amount that has been disbursed to the student for this award year, as reported by COD.	NUMBER(7,2)		RPRADSB	RPRADSB_YTD_AMT_PAID
CPS_VERIFICATION_IND	Cps Verification Indicator	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')
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DEBIT_CREDIT	Debit Credit	Determines a debit or credit effect on the ledgers; plus or minus, debit or credit.	VARCHAR2(1)		RPRADSB	RPRADSB_DEBIT_CR_IND
DEBIT_CREDIT_DESC	Debit Credit Description	Description of the debit/credit indicators.	VARCHAR2(10)		CALCULATION	DECODE(RPRADSB_DEBIT_CREDIT_IND)
DISBURSED_AMOUNT	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(11,2)		RPRADSB	RPRADSB_DISBURSE_AMT
DISBURSED_DATE		Date the disbursed amount was taken from the financial aid fund indicated.	DATE		RPRADSB	RPRADSB_DISBURSE_DATE
DISBURSED_PERCENTAGE		Percentage of the financial aid fund that has been disbursed.	NUMBER(6, 3)		RPRADSB	RPRADSB_DISBURSE_PCT
DISBURSEMENT_CHANGE_DATE_IND	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
DISBURSEMENT_LOAD		Displays the enrollment credits of the student at the time of the disbursement.	VARCHAR2(1)		RPRADSB	RPRADSB_DISBURSE_LOAD
DISBURSEMENT_LOAD_DESC	Disbursement Load Description	Disbursement load description.	VARCHAR2(15)		CALCULATION	DECODE(RPRADSB_DISBURSE_LOAD)
DISBURSEMENT_LOAD_OPT		Column to track disbursement enrollment option.	VARCHAR2(1)		RPRADSB	RPRADSB_DISBURSE_LOAD_OPT
DISBURSEMENT_LOAD_OPT_DESC	Disbursement Load Option Description	Description of the disbursement enrollment option.	VARCHAR2(40)		CALCULATION	DECODE(RPRADSB_DISBURSE_LOAD_OPT)
DISBURSEMENT_NUMBER		Reference number (sequence number) of this disbursement.	NUMBER(2)		RPRADSB	RPRADSB_DISB_SEQ_NO
DOCUMENT_ID		Document number associated with the student's Pell disbursement record.	VARCHAR2(30)		RPRADSB	RPRADSB_DOCUMENT_ID
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ELIG_SCHEDULE_USED_PERCENT	Eligible Schedule Used Percent		NUMBER
ENROLLMENT_INSTITUTION	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
FUND		Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)		RPRADSB	RPRADSB_FUND_CODE
FUND_TITLE		Full title of the financial aid fund code.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
HIGHEST_CPS_TRANSACTION_NO	Highest Cps Transaction Number	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
INSTITUTIONAL_LOAN_FEED_IND	Institutional Loan Feed Indicator	Represents that a Loan Management System feed transaction has been created for an institutional loan disbursement.	VARCHAR2(1)		RPRADSB	RPRADSB_LMS_FEED_IND
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
NET_AMOUNT_DISBURSED		Net amount of a particular disbursement as of the most recent extraction for reporting to cod.	NUMBER(7, 2)		RPRADSB	RPRADSB_DISB_NET_AMT
PAYMENT_PERIOD_START_DATE	Payment Period Start Date	Start date of the payment period the record is referencing.	DATE		RPRADSB	RPRADSB_PAY_PD_START_DATE
PELL_BATCH_NUMBER		Batch number associated with the student's Pell disbursement record.	VARCHAR2(26)		RPRADSB	RPRADSB_DISB_BATCH_NO
PELL_CALCULATED_DISB_AMOUNT	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(11,2)		RPRADSB	RPRADSB_PELL_CALC_DISB_AMT
PELL_CALCULATED_DISB_LOAD	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(1)		RPRADSB	RPRADSB_PELLC_DISB_LOAD
PELL_CALCULATED_DISB_LOAD_DESC	Pell Calculated Disb Load Description	Pell calculated disbursement load description.	VARCHAR2(15)		CALCULATION	DECODE(RPRADSB_PELLC_DISB_LOAD)
PELL_CALC_DISB_LOAD_OPTION	Pell Calculated Disbursement 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(1)		RPRADSB	RPRADSB_PELLC_DISB_LOAD_OPT
PELL_CALC_DISB_LOAD_OPT_DESC	Pell Calculated Disb Load Option Description	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(40)		CALCULATION	DECODE(RPRADSB_PELLC_DISB_LOAD_OPT)
PELL_LIFETIME_ELIGIBILITY_USED	Pell Lifetime Eligibility Used		NUMBER
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RPRADSB	RPRADSB_PIDM
PROGRAM_CLASSIFICATION	Program Classification	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(6)		RPRADSB	RPRADSB_CIP_CODE
PROGRAM_CLASSIFICATION_DESC	Program Classification Description	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(65)		FUNCTION	F_GET_CIPC_DESC
REFERENCE_NUMBER		Reference number (sequence number) of this disbursement.	NUMBER(2)		RPRADSB	RPRADSB_DISB_REF_NO
SCHEDULED_AMOUNT	Scheduled Amount	Scheduled amount of the disbursement associated with the fund.	NUMBER(11,2)		RPRADSB	RPRADSB_SCHEDULE_AMT
SCHEDULED_DATE		Date the disbursement was scheduled.	DATE		RPRADSB	RPRADSB_SCHEDULE_DATE
STUDENT_ACADEMIC_PERIOD	Student Academic Period		VARCHAR2(6)
STUDENT_ACADEMIC_PERIOD_DESC	Student Academic Period Description		VARCHAR2(30)
TOTAL_DISBURSED_AMOUNT	Total Disbursed Amount	Displays the amount actually disbursed for this fund.	NUMBER(11,2)		RPRADSB	RPRADSB_DISBURSE_AMT
TRANSACTION_NUMBER		Transaction number on the student's account receivable detail.	NUMBER(8)		RPRADSB	RPRADSB_TRAN_NUMBER
UNSIGNED_DISBURSED_AMOUNT		Amount of the disbursement as sent to RFMS. This is always a positive amount. Negative payments are sent as a positive amount with a debit/credit indicator of n.	NUMBER(7, 2)		RPRADSB	RPRADSB_DISB_AMT
USER_ID	User ID	Unique ID of the user who inserted or last updated this record.	VARCHAR2(30)		RPRADSB	RPRADSB_USER_ID
VERIFICATION_CORRECTION_IND	Verification Correction Indicator	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
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: