Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic Period
|
Academic period representing the accounts receivable term for disbursement.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_TERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_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
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
AID_ENROLLMENT_PERIOD
|
Aid Enrollment Period
|
Aid enrollment period associated with the award schedule. This period can span multiple student terms.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_PERIOD
|
AID_ENROLLMENT_PERIOD_DESC
|
Aid Enrollment Period Description
|
Aid enrollment period description.
|
VARCHAR2(255)
|
ROBPRDS
|
ROBPRDS_DESC
|
AID_PERIOD
|
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
|
AID_PERIOD_DESC
|
Aid Period Description
|
Financial Aid period description.
|
VARCHAR2(255)
|
FUNCTION
|
MRKFUNC.F_GET_AID_PERIOD
|
AID_YEAR
|
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
|
AID_YEAR_DESC
|
Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
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
|
DECODE(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(63)
|
RPRADSB
|
RPRADSB_DISB_ACPT_DEBIT_CR_IND
|
COD_DEBIT_CREDIT_DESC
|
COD Debit Credit Description
|
Description of the debit/credit indicators.
|
VARCHAR2(255)
|
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(63)
|
RPRADSB
|
RPRADSB_DISB_ACTION_CODE
|
COD_DISBURSEMENT_ACTION_DESC
|
COD Disbursement Action Description
|
Description of the COD processing status.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RPRADSB_DISB_ACTION_CODE)
|
COD_DISBURSEMENT_CROSS_REF
|
Cod Disbursement Cross Reference
|
Institution defined identifier used to identify student records internally.
|
VARCHAR2(63)
|
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
|
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(255)
|
RPRADSB
|
RPRADSB_EDIT_FIELD_1
|
COD_DISB_EDIT_FIELD2
|
Cod Disb Edit Field 2
|
Field (XML tag) associated with edit 2.
|
VARCHAR2(255)
|
RPRADSB
|
RPRADSB_EDIT_FIELD_2
|
COD_DISB_EDIT_FIELD3
|
Cod Disb Edit Field 3
|
Field (XML tag) associated with edit 3.
|
VARCHAR2(255)
|
RPRADSB
|
RPRADSB_EDIT_FIELD_3
|
COD_DISB_EDIT_FIELD4
|
Cod Disb Edit Field 4
|
Field (XML tag) associated with edit 4.
|
VARCHAR2(255)
|
RPRADSB
|
RPRADSB_EDIT_FIELD_4
|
COD_DISB_EDIT_FIELD5
|
Cod Disb Edit Field 5
|
Field (XML tag) associated with edit 5.
|
VARCHAR2(255)
|
RPRADSB
|
RPRADSB_EDIT_FIELD_5
|
COD_DISB_EDIT_REJECT_CODE1
|
Cod Disb Edit Rejection Code 1
|
Disbursement Edit/Reject/Comment code 1.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_01
|
COD_DISB_EDIT_REJECT_CODE10
|
Cod Disb Edit Rejection Code 10
|
Disbursement Edit/Reject/Comment code 10.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_10
|
COD_DISB_EDIT_REJECT_CODE2
|
Cod Disb Edit Rejection Code 2
|
Disbursement Edit/Reject/Comment code 2.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_02
|
COD_DISB_EDIT_REJECT_CODE3
|
Cod Disb Edit Rejection Code 3
|
Disbursement Edit/Reject/Comment code 3.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_03
|
COD_DISB_EDIT_REJECT_CODE4
|
Cod Disb Edit Rejection Code 4
|
Disbursement Edit/Reject/Comment code 4.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_04
|
COD_DISB_EDIT_REJECT_CODE5
|
Cod Disb Edit Rejection Code 5
|
Disbursement Edit/Reject/Comment code 5.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_05
|
COD_DISB_EDIT_REJECT_CODE6
|
Cod Disb Edit Rejection Code 6
|
Disbursement Edit/Reject/Comment code 6.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_06
|
COD_DISB_EDIT_REJECT_CODE7
|
Cod Disb Edit Rejection Code 7
|
Disbursement Edit/Reject/Comment code 7.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_07
|
COD_DISB_EDIT_REJECT_CODE8
|
Cod Disb Edit Rejection Code 8
|
Disbursement Edit/Reject/Comment code 8.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_08
|
COD_DISB_EDIT_REJECT_CODE9
|
Cod Disb Edit Rejection Code 9
|
Disbursement Edit/Reject/Comment code 9.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_EDIT_REJ_09
|
COD_DISB_EDIT_REJECT_DESC1
|
Cod Disb Edit Rejection Description 1
|
Disbursement Edit Reject Code Description 1.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC10
|
Cod Disb Edit Rejection Description 10
|
Disbursement Edit Reject Code Description 10.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC2
|
Cod Disb Edit Rejection Description 2
|
Disbursement Edit Reject Code Description 2.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC3
|
Cod Disb Edit Rejection Description 3
|
Disbursement Edit Reject Code Description 3.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC4
|
Cod Disb Edit Rejection Description 4
|
Disbursement Edit Reject Code Description 4.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC5
|
Cod Disb Edit Rejection Description 5
|
Disbursement Edit Reject Code Description 5.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC6
|
Cod Disb Edit Rejection Description 6
|
Disbursement Edit Reject Code Description t 6.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC7
|
Cod Disb Edit Rejection Description 7
|
Disbursement Edit Reject Code Description 7.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC8
|
Cod Disb Edit Rejection Description 8
|
Disbursement Edit Reject Code Description 8.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
COD_DISB_EDIT_REJECT_DESC9
|
Cod Disb Edit Rejection Description 9
|
Disbursement Edit Reject Code Description 9.
|
VARCHAR2(255)
|
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(255)
|
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(255)
|
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(255)
|
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(255)
|
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(255)
|
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(63)
|
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
|
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
|
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
|
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
|
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')
|
DEBIT_CREDIT
|
Debit Credit
|
Determines a debit or credit effect on the ledgers; plus or minus, debit or credit.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_DEBIT_CR_IND
|
DEBIT_CREDIT_DESC
|
Debit Credit Description
|
Description of the debit/credit indicators.
|
VARCHAR2(255)
|
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
|
RPRADSB
|
RPRADSB_DISBURSE_AMT
|
DISBURSED_DATE
|
Disbursed Date
|
Date the disbursed amount was taken from the financial aid fund indicated.
|
DATE
|
RPRADSB
|
RPRADSB_DISBURSE_DATE
|
DISBURSED_PERCENTAGE
|
Disbursed Percentage
|
Percentage of the financial aid fund that has been disbursed.
|
NUMBER
|
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
|
Disbursement Load
|
Displays the enrollment credits of the student at the time of the disbursement.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_DISBURSE_LOAD
|
DISBURSEMENT_LOAD_DESC
|
Disbursement Load Description
|
Disbursement load description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RPRADSB_DISBURSE_LOAD)
|
DISBURSEMENT_LOAD_OPT
|
Disbursement Load Opt
|
Column to track disbursement enrollment option.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_DISBURSE_LOAD_OPT
|
DISBURSEMENT_LOAD_OPT_DESC
|
Disbursement Load Option Description
|
Description of the disbursement enrollment option.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RPRADSB_DISBURSE_LOAD_OPT)
|
DISBURSEMENT_NUMBER
|
Disbursement Number
|
Reference number (sequence number) of this disbursement.
|
NUMBER
|
RPRADSB
|
RPRADSB_DISB_SEQ_NO
|
DOCUMENT_ID
|
Document ID
|
Document number associated with the student's Pell disbursement record.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_DOCUMENT_ID
|
ELIG_SCHEDULE_USED_PERCENT
|
Eligible 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
|
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
|
ENROLLMENT_STATUS
|
Enrollment Status
|
The student's enrollment status for this disbursement.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_ENROLLMENT_STATUS
|
ENROLLMENT_STATUS_DESC
|
Enrollment Status Description
|
Description of the student's enrollment status for this disbursement.
|
VARCHAR2(255)
|
FUNCTION
|
ROKODSF.F_GET_RORMVAL_DESC
|
FUND
|
Fund
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
RPRADSB
|
RPRADSB_FUND_CODE
|
FUND_TITLE
|
Fund Title
|
Full title of the financial aid fund code.
|
VARCHAR2(255)
|
RFRBASE
|
RFRBASE_FUND_TITLE
|
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
|
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
|
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
|
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
|
NET_AMOUNT_DISBURSED
|
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
|
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
|
Pell Batch Number
|
Batch number associated with the student's Pell disbursement record.
|
VARCHAR2(63)
|
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
|
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(63)
|
RPRADSB
|
RPRADSB_PELLC_DISB_LOAD
|
PELL_CALCULATED_DISB_LOAD_DESC
|
Pell Calculated Disb Load Description
|
Pell calculated disbursement load description.
|
VARCHAR2(255)
|
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(63)
|
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(255)
|
CALCULATION
|
DECODE(RPRADSB_PELLC_DISB_LOAD_OPT)
|
PELL_LIFETIME_ELIGIBILITY_USED
|
Pell Lifetime Eligibility Used
|
Lifetime eligibility amount used for Pell grants.
|
NUMBER
|
RPRADSB
|
RPRADSB_PELL_LEU
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RPRADSB
|
RPRADSB_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
PROGRAM_CLASSIFICATION
|
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
|
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(255)
|
FUNCTION
|
F_GET_CIPC_DESC
|
REFERENCE_NUMBER
|
Reference Number
|
Reference number (sequence number) of this disbursement.
|
NUMBER
|
RPRADSB
|
RPRADSB_DISB_REF_NO
|
SCHEDULED_AMOUNT
|
Scheduled Amount
|
Scheduled amount of the disbursement associated with the fund.
|
NUMBER
|
FUNCTION
|
NVL(RPRADSB_SCHEDULE_AMT,ROKODSF.F_GET_RPRADSB_SCHEDULE_AMT
|
SCHEDULED_DATE
|
Scheduled Date
|
Date the disbursement was scheduled.
|
DATE
|
RPRADSB
|
RPRADSB_SCHEDULE_DATE
|
STUDENT_ACADEMIC_PERIOD
|
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
|
STUDENT_ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
TOTAL_DISBURSED_AMOUNT
|
Total Disbursed Amount
|
Displays the amount actually disbursed for this fund.
|
NUMBER
|
RPRADSB
|
RPRADSB_DISBURSE_AMT
|
TRANSACTION_NUMBER
|
Transaction Number
|
Transaction number on the student's account receivable detail.
|
NUMBER
|
RPRADSB
|
RPRADSB_TRAN_NUMBER
|
UNSIGNED_DISBURSED_AMOUNT
|
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
|
USER_ID
|
User ID
|
Unique ID of the user who inserted or last updated this record.
|
VARCHAR2(63)
|
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
|