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)
|
RLRDLDD RPRLADB
|
RLRDLDD_AR_TERM_CODE RPRLADB_TERM_CODE
|
NO NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
RLRDLDD RPRLADB
|
RLRDLDD_ACTIVITY_DATE RPRLADB_ACTIVITY_DATE
|
NO 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)
|
RLRDLDD RPRLADB
|
RLRDLDD_PERIOD RPRLADB_PERIOD
|
NO NO
|
NO
|
AID_ENROLLMENT_PERIOD_DESC
|
Aid enrollment period description.
|
VARCHAR2(255)
|
ROBPRDS
|
ROBPRDS_DESC
|
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)
|
FUNCTION RLRDLDD RPRLADB
|
ROKODSF.F_GET_FINAID_PROC_YEAR RLRDLDD_AIDY_CODE RPRLADB_AIDY_CODE
|
NO NO NO
|
NO
|
AID_YEAR_DESC
|
Aid year description.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
APPLICATION_NUMBER
|
System assigned number is assigned when the application is added.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_LOAN_NO RPRLADB_APPL_NO
|
NO NO
|
NO
|
APPROVED_AMOUNT
|
The approved loan amount for this particular academic period.
|
NUMBER
|
RPRDLPS RPRLATR
|
RPRDLPS_LOAN_AMT RPRLATR_APPROVE_AMT
|
NO NO
|
NO
|
AUTHORIZED_IND
|
Indicates whether disbursement is authorized for payment by the disbursement process.
|
VARCHAR2(1)
|
RLRDLDD RPRLADB
|
RLRDLDD_AUTHORIZED_IND RPRLADB_DL_AUTHORIZED_IND
|
NO NO
|
NO
|
BORROWER_DIRECT_CHECK_AMOUNT
|
Direct disbursement amount received by borrower enrolled in a study-abroad program.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_EL_DIRECT_CHECK_AMT
|
NO NO
|
NO
|
BORROWER_DIRECT_DISBURSE_IND
|
Requests the direct disbursement of funds to borrower or to indicate receipt of funds for borrowers enrolled in a study-abroad program.
|
VARCHAR2(1)
|
NA RPRLADB
|
NULL RPRLADB_EL_BOR_DIRECT_DISB_IND
|
NO NO
|
NO
|
CALC_EXPECTED_DISBURSEMENT_AMT
|
For Electronic and Manual Loans, the calculated net amount of the disbursement using the Round Schedule indicator from the Fund Management form and is based on the approved amount if it exists, else the certified (expected) amount if it exists, else the requested amount. The last disbursement of the loan is adjusted so the sum of all the disbursements equals the total amount for the loan. For Direct Loans, the net amount of the disbursement based on the gross disbursement amount, the fee and rebate percent for the loan.
|
NUMBER
|
FUNCTION RLRDLDD
|
ROKODSF.F_GET_CALC_DISBURSE_AMT RLRDLDD_NET_AMOUNT
|
NO NO
|
NO
|
CANCEL_DATE
|
Displays the date the cancel indicator field was checked to cancel a pending disbursement. No longer used after Financial Aid release 8.22.1.
|
DATE
|
NA RPRLADB
|
NULL RPRLADB_CANCEL_DATE
|
NO NO
|
NO
|
CANCEL_IND
|
Check to cancel a pending disbursement or uncheck to reinstate the disbursement amount. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_CANCEL_IND
|
NO
|
NO
|
CERTIFIED_CREDIT_HOURS
|
Displays the loan application credit hours for loan eligibility. No longer used.
|
NUMBER
|
NA RPRLATR
|
NULL RPRLATR_CERT_HR
|
NO NO
|
NO
|
CHECK_DATE_RECEIVED
|
Indicates the date the check amount was received. No longer used after Financial Aid release 8.22.1.
|
DATE
|
RPRLADB
|
RPRLADB_CHECK_DATE
|
NO
|
NO
|
CHECK_RETURNED_LENDER_DATE
|
The date that the original unsigned/unprocessed loan check was returned to the lender by the school.
|
DATE
|
NA RPRLADB
|
NULL RPRLADB_RET_LNDR_DATE
|
NO NO
|
NO
|
CHECK_RETURN_AMOUNT
|
Amount of the loan that was returned during an adjustment. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
RPRLADB
|
RPRLADB_CHECK_RETURN_AMT
|
NO
|
NO
|
CHECK_RETURN_DATE
|
The date that the adjusted loan amount was returned. No longer used after Financial Aid release 8.22.1.
|
DATE
|
RPRLADB
|
RPRLADB_CHECK_RETURN_DATE
|
NO
|
NO
|
CITY
|
Address city, town or municipality.
|
VARCHAR2(63)
|
RERCODA RPRLAPP
|
RERCODA_CITY RPRLAPP_CITY
|
NO NO
|
NO
|
COLLEGE
|
First level of the institution organization structure that owns the student or the academic instruction for a student course.
|
VARCHAR2(63)
|
RLRDDAS RPRLADB
|
RLRDDAS_SCHOOL_CODE RPRLADB_SCHOOL_CODE
|
NO NO
|
NO
|
CONFIRMATION_IND
|
Indicates that the student has authorized the disbursement of Direct Loan funds under the Master Promissory Note or the borrower has confirmed the loan disbursement for CommonLine processing. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_AFFIRM_FLAG
|
NO
|
NO
|
DEFAULT_IND
|
Loan default status.
|
VARCHAR2(63)
|
RLRDLOR RPRLAPP
|
RLRDLOR_IN_DEFAULT RPRLAPP_IN_DEFAULT
|
NO NO
|
NO
|
DEFAULT_IND_DESC
|
Description of the loan default status.
|
VARCHAR2(255)
|
FUNCTION
|
ROKODSF.F_GET_RORMVAL_DESC
|
NO
|
NO
|
DIRECT_DISBURSEMENT_NUMBER
|
Direct loan disbursement number.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_DISB_NO RPRLADB_DL_DISB_NO
|
NO NO
|
NO
|
DIRECT_LOAN_BATCH_NUMBER
|
Batch number related to the disbursement acknowledgement file for this individual disbursement. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(63)
|
NA RPRLADB
|
NULL RPRLADB_BATCH_NO
|
NO NO
|
NO
|
DIRECT_LOAN_COD_ADJUSTED_NET
|
The net disbursement adjustment amount recorded in the Account Statement with COD. The value in this field may be either positive or negative reflecting the net amount of the adjustment processed for this individual disbursement.
|
NUMBER
|
RLRDDAS RPRLADB
|
RLRDDAS_NET_ADJ_AMT RPRLADB_SERV_NET_ADJ_AMT
|
NO NO
|
NO
|
DIRECT_LOAN_COD_BOOK_DATE
|
Date the individual disbursement is booked at COD.
|
DATE
|
RLRDDAS RPRLADB
|
RLRDDAS_DISB_BOOKED_DATE RPRLADB_SERV_BOOKED_DATE
|
NO NO
|
NO
|
DIRECT_LOAN_COD_GROSS_AMOUNT
|
The gross amount recorded in the Account Statement with COD.
|
NUMBER
|
RLRDDAS RPRLADB
|
RLRDDAS_GROSS_AMT RPRLADB_SERV_GROSS_AMT
|
NO NO
|
NO
|
DIRECT_LOAN_COD_NET_AMOUNT
|
The net disbursement amount recorded in the Account Statement with COD.
|
NUMBER
|
RLRDDAS RPRLADB
|
RLRDDAS_NET_AMT RPRLADB_SERV_NET_AMT
|
NO NO
|
NO
|
DIRECT_LOAN_COD_REBATE_AMOUNT
|
The rebate Amount recorded in the Account Statement with COD.
|
NUMBER
|
RLRDDAS RPRLADB
|
RLRDDAS_REBATE_AMT RPRLADB_SERV_REBATE_AMT
|
NO NO
|
NO
|
DIRECT_LOAN_COD_RECEIPT_DATE
|
The actual date COD acknowledged receipt of this disbursement record. No longer used after Financial Aid release 8.22.1.
|
DATE
|
NA RPRLADB
|
NULL RPRLADB_DL_ACKN_DATE
|
NO NO
|
NO
|
DIRECT_LOAN_DOCUMENT_ID
|
Associated with the student's Direct Loan award record and indicates the document in which the origination record was initially extracted and sent to COD.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_DOCUMENT_ID RPRLADB_DOCUMENT_ID
|
NO NO
|
NO
|
DIRECT_LOAN_FEE_AMOUNT
|
Amount of Direct Loan fees.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_FEE_AMT RPRLADB_DL_FEE_AMT
|
NO NO
|
NO
|
DIRECT_LOAN_GROSS_AMOUNT
|
Gross Amount of Direct Loan disbursement .
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_GROSS_AMT RPRLADB_DL_GROSS_AMT
|
NO NO
|
NO
|
DIRECT_LOAN_ID
|
Identifies a specific loan application.
|
VARCHAR2(63)
|
RLRDLOR RPRLAPP
|
RLRDLOR_LOAN_ID RPRLAPP_DL_LOAN_ID
|
NO NO
|
NO
|
DIRECT_LOAN_MONTH_END_DATE
|
The month end date of the Direct Loan School Account Statement for the month in which this loan disbursement booked.
|
DATE
|
RLRDDAS RPRLADB
|
RLRDDAS_SAS_END_DATE RPRLADB_SAS_END_DATE
|
NO NO
|
NO
|
DIRECT_LOAN_MONTH_PROCESS_DATE
|
The month process date of the Direct Loan School Account Statement for the month in which this loan disbursement booked.
|
DATE
|
RLRDDAS RPRLADB
|
RLRDDAS_SAS_PROCESS_DATE RPRLADB_SAS_PROCESS_DATE
|
NO NO
|
NO
|
DIRECT_LOAN_MONTH_START_DATE
|
Start date of the school account statement for which this loan disbursement booked.
|
DATE
|
RLRDDAS RPRLADB
|
RLRDDAS_SAS_START_DATE RPRLADB_SAS_START_DATE
|
NO NO
|
NO
|
DIRECT_LOAN_REBATE_AMOUNT
|
The Direct Loan interest rebate amount calculated for this disbursement.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_REBATE_AMT RPRLADB_DL_REBATE_AMT
|
NO NO
|
NO
|
DIRECT_LOAN_RECORD_COUNT_NO
|
Record number assigned in the School Account Statement with COD for this loan detail record. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
RPRLADB
|
RPRLADB_SAS_RECORD_COUNT_SEQ
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE1
|
The first reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(63)
|
RERCDED RPRLADB
|
RERCDED_RJCT_CODE RPRLADB_DL_REJECT_CODE_1
|
NO NO
|
NO
|
DIRECT_LOAN_REJECT_CODE1_DESC
|
Description for the first reject code sent from LOC / COD.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE2
|
The second reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(63)
|
RERCDED RPRLADB
|
RERCDED_RJCT_CODE RPRLADB_DL_REJECT_CODE_2
|
NO NO
|
NO
|
DIRECT_LOAN_REJECT_CODE2_DESC
|
Description for the second reject code sent from LOC / COD.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE3
|
The third reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(63)
|
RERCDED RPRLADB
|
RERCDED_RJCT_CODE RPRLADB_DL_REJECT_CODE_3
|
NO NO
|
NO
|
DIRECT_LOAN_REJECT_CODE3_DESC
|
Description for the third reject code sent from LOC / COD.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE4
|
The fourth reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(63)
|
RERCDED RPRLADB
|
RERCDED_RJCT_CODE RPRLADB_DL_REJECT_CODE_4
|
NO NO
|
NO
|
DIRECT_LOAN_REJECT_CODE4_DESC
|
Description for the fourth reject code sent from LOC / COD.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE5
|
The fifth reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(63)
|
RERCDED RPRLADB
|
RERCDED_RJCT_CODE RPRLADB_DL_REJECT_CODE_5
|
NO NO
|
NO
|
DIRECT_LOAN_REJECT_CODE5_DESC
|
Description for the fifth reject code sent from LOC / COD.
|
VARCHAR2(255)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_SEQUENCE_NUMBER
|
Starts at one for each scheduled loan disbursement, and is incremented by one each time an adjustment is made to the disbursement. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_DL_SEQ_NO
|
NO NO
|
NO
|
DIRECT_LOAN_SERVICE_FEE_AMOUNT
|
The fees amount recorded in the Account Statement with COD.
|
NUMBER
|
RLRDDAS RPRLADB
|
RLRDDAS_FEE_AMT RPRLADB_SERV_FEE_AMT
|
NO NO
|
NO
|
DISBURSEMENT_BYPASS_IND
|
Indicates lender transactions are to be bypassed for a payment during disbursement. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_DISB_BYPASS
|
NO
|
NO
|
DISBURSEMENT_COMMENT
|
Contains any special processing comments or instructions entered by the user.
|
VARCHAR2(4000)
|
RLRDLDD RPRLADB
|
RLRDLDD_COMMENT RPRLADB_COMMENT
|
NO NO
|
NO
|
DISBURSEMENT_DATA_ORIGIN
|
Source system that last created or updated the data.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_DATA_ORIGIN RPRLADB_DATA_ORIGIN
|
NO NO
|
NO
|
DISBURSEMENT_DAYS_OFFSET
|
Number of days prior to or after the first class start date of the student to schedule the disbursement.
|
NUMBER
|
NA RLRDLDD
|
NULL RLRDLDD_DISB_SCHED_NO_DAYS
|
NO NO
|
NO
|
DISBURSEMENT_FEED
|
Displays whether disbursement should be fed to accounts receivable.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_FEED_IND RPRLADB_FEED_IND
|
NO NO
|
NO
|
DISBURSEMENT_FEED_DATE
|
Indicates the date the disbursement was fed to the student's account's receivable account.
|
DATE
|
RLRDLDD RPRLADB
|
RLRDLDD_FEED_DATE RPRLADB_FEED_DATE
|
NO NO
|
NO
|
DISBURSEMENT_FEED_DESC
|
Indicates whether disbursement should be fed to accounts receivable.
|
VARCHAR2(255)
|
CALCULATION CALCULATION
|
DECODE(RLRDLDD_FEED_IND) DECODE(RPRLADB_FEED_IND)
|
NO NO
|
NO
|
DISBURSEMENT_PROCESSING_STATUS
|
The processing status of the disbursement.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_DISB_STATUS RPRLADB_DISB_STATUS
|
NO NO
|
NO
|
DISBURSEMENT_PROC_STATUS_DESC
|
Disbursement processing status description.
|
VARCHAR2(255)
|
FUNCTION
|
ROKODSF.F_GET_RORMVAL_DESC
|
NO
|
NO
|
DISBURSEMENT_SEQUENCE_NUMBER
|
Starts at one for each scheduled loan disbursement, and is incremented by one each time an adjustment is made to the disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_SEQ_NO
|
NO
|
NO
|
ELECTRONIC_DISBURSEMENT_NUMBER
|
Disbursement number associated with this electronic loan disbursement record.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_EL_DISB_NO
|
NO NO
|
NO
|
ELECTRONIC_REFERENCE_ID
|
The check number or electronic batch number of the financial aid payment. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(63)
|
NA RPRLADB
|
NULL RPRLADB_REF_ID
|
NO NO
|
NO
|
ELECTRONIC_SERVICE_NET_AMOUNT
|
The net disbursement amount that has been scheduled by the lender-servicer at the time of guarantee for this disbursement. This amount is uploaded from the CommonLine Response File.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_EL_SERV_NET_AMT
|
NO NO
|
NO
|
ELECTRONIC_TRANSFER_IND
|
Indicates when an electronic disbursement is received, rather than a paper check.
|
VARCHAR2(1)
|
NA RPRLADB
|
NULL RPRLADB_EFT_IND
|
NO NO
|
NO
|
EL_LOAN_ID
|
Loan identification number used by electronic loan processing (common line).
|
VARCHAR2(63)
|
NA RPRLAPP
|
NULL RPRLAPP_EL_LOAN_ID
|
NO NO
|
NO
|
ENROLLMENT_LOAD
|
Displays the student's enrollment load calculated at the time of disbursement.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_LOAD RPRLADB_DISBURSE_LOAD
|
NO NO
|
NO
|
ENROLLMENT_LOAD_DESC
|
Enrollment Load Description.
|
VARCHAR2(255)
|
CALCULATION CALCULATION
|
DECODE(RLRDLDD_LOAD) DECODE(RPRLADB_DISBURSE_LOAD)
|
NO NO
|
NO
|
ENROLLMENT_LOAD_OPTION
|
Financial Aid calculates a student's enrollment option used for the disbursement load.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_LOAD_OPT RPRLADB_DISBURSE_LOAD_OPT
|
NO NO
|
NO
|
ENROLLMENT_LOAD_OPTION_DESC
|
Displays the enrollment load option used for the disbursement.
|
VARCHAR2(255)
|
FUNCTION
|
ROKODSF.F_GET_RORMVAL_DESC
|
NO
|
NO
|
ENROLLMENT_SCHOOL_CODE
|
8 digit OPEID and Branch Code where the student is physically enrolled for this loan disbursement.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_ENROLLMENT_SCHOOL_CDE RPRLADB_ENROLLMENT_SCHOOL_CDE
|
NO NO
|
NO
|
ENROLLMENT_STATUS
|
Student's enrollment status.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_ENROLLMENT_STATUS RPRLADB_ENROLLMENT_STATUS
|
NO NO
|
NO
|
ENROLLMENT_STATUS_DESC
|
Enrollment status description.
|
VARCHAR2(255)
|
FUNCTION
|
ROKODSF.F_GET_RORMVAL_DESC
|
NO
|
NO
|
EXCLUDE_EXCEPTION_REPORT_IND
|
Indicates that the exception report should not display a line for this loan and term, even if there was a discrepancy in the amounts. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(1)
|
RPRLATR
|
RPRLATR_EXCLUDE_LNEX_FLAG
|
NO
|
NO
|
EXPECTED_LOAN_AMOUNT
|
Expected loan amount associated with the application scheduled by academic periods. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
NA RPRLATR
|
NULL RPRLATR_EXPECT_AMT
|
NO NO
|
NO
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_FUND_CODE RPRLADB_FUND_CODE
|
NO NO
|
NO
|
FUND_TITLE
|
Full title of the financial aid fund code.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GUARANTEE_FEE_AMOUNT
|
Amount of the guarantee fee charged for this disbursement.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_EL_SERV_GUAR_FEE
|
NO NO
|
NO
|
HOLD_RELEASE_DATE
|
The most recent date the Hold / Release status was sent or acknowledged.
|
DATE
|
NA RPRLADB
|
NULL RPRLADB_EL_HOLD_REL_DATE
|
NO NO
|
NO
|
HOLD_RELEASE_STATUS
|
A code indicating the status of the school's requested disbursement hold or release.
|
VARCHAR2(63)
|
NA RPRLADB
|
NULL RPRLADB_HOLD_REL_STATUS
|
NO NO
|
NO
|
HOLD_RELEASE_STATUS_DESC
|
Hold / Release status description.
|
VARCHAR2(255)
|
CALCULATION NA
|
DECODE(RPRLADB_HOLD_REL_STATUS) NULL
|
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
|
LOAN_BOOK_DATE
|
Date the loan is booked at COD.
|
DATE
|
NA RLRDDAS
|
NULL RLRDDAS_LOAN_BOOKED_DATE
|
NO NO
|
NO
|
LOAN_NUMBER
|
System generated loan number for the student.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_LOAN_NO RPRLADB_APPL_NO
|
NO NO
|
NO
|
LOAN_PERCENTAGE_ACAD_PERIOD
|
Represents the percentage of the loan that is scheduled for the associated academic period. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
RPRLATR
|
RPRLATR_LOAN_PCT
|
NO
|
NO
|
LOAN_PERCENTAGE_DISBURSEMENT
|
The percentage of total loan that this disbursement represents. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
RPRLADB
|
RPRLADB_LOAN_PCT
|
NO
|
NO
|
LOAN_PERIOD
|
Period covered by the loan. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(63)
|
NA RPRLAPP
|
NULL RPRLAPP_LOAN_PERIOD
|
NO NO
|
NO
|
LOAN_PERIOD_DESC
|
Loan period description. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(255)
|
NA RPBLPRD
|
NULL RPBLPRD_DESC
|
NO NO
|
NO
|
LOAN_SERVICER
|
Loan servicer name.
|
VARCHAR2(255)
|
RLRDDAS RPRLADB
|
RLRDDAS_SERVICER RPRLADB_SERVICER
|
NO NO
|
NO
|
LOAN_SOURCE
|
Identifies the fund's packaging rule source as either a direct loan, electronic loan, manual loan or other type of loan.
|
VARCHAR2(63)
|
CALCULATION
|
CASE WHEN RFRASPC_DIRECT_LOAN_IND
|
NO
|
NO
|
LOAN_SOURCE_DESC
|
Loan source description.
|
VARCHAR2(255)
|
CALCULATION
|
CASE WHEN RFRASPC_DIRECT_LOAN_IND
|
NO
|
NO
|
LOAN_STATUS
|
Status of the common line application process for this record.
|
VARCHAR2(63)
|
RLRDLOR RPRLAPP
|
RLRDLOR_LNST_CODE RPRLAPP_LNST_CODE
|
NO NO
|
NO
|
LOAN_STATUS_DESC
|
Common line process status description.
|
VARCHAR2(255)
|
RTVLNST
|
RTVLNST_DESC
|
NO
|
NO
|
MEMO_EXPIRATION_DAYS
|
The number of days until the memo expires. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
RPRLADB
|
RPRLADB_MEMO_EXP_DAYS
|
NO
|
NO
|
MPN_DISBURSEMENT_DATE
|
Disbursement Date printed on the Promissory Note. No longer required for MPN processing. No longer used after Financial Aid release 8.22.1.
|
DATE
|
NA RPRLADB
|
NULL RPRLADB_PN_DISB_DATE
|
NO NO
|
NO
|
MULTI_SOURCE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (LFMI).
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
NET_CHECK_AMOUNT
|
The net amount of this particular disbursement.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_NET_AMT RPRLADB_CHECK_AMT
|
NO NO
|
NO
|
ORIGINATION_FEE_AMOUNT
|
Amount of the origination fee charged for this disbursement.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_EL_SERV_ORIG_FEE
|
NO NO
|
NO
|
OVERRIDE_IND
|
Allows the override of the disbursement edit for loans that prevents disbursement when sum of the loan term disbursements is greater than the sum of the loan term expected amount. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_DISB_OVERRIDE_IND
|
NO
|
NO
|
PARENT_CITY
|
City of the parent when a direct loan is of a parent type.
|
VARCHAR2(63)
|
RLRDBOR RPRLAPP
|
RLRDBOR_PERM_CITY RPRLAPP_PAR_CITY
|
NO NO
|
NO
|
PARENT_PHONE_NUMBER_COMBINED
|
Phone number of the parent when a direct loan is of a parent type.
|
VARCHAR2(63)
|
RLRDBOR RPRLAPP
|
RLRDBOR_PHONE_NO RPRLAPP_PAR_PHONE_NO
|
NO NO
|
NO
|
PARENT_POSTAL_CODE
|
Postal code of the parent when a direct loan is of a parent type.
|
VARCHAR2(63)
|
RLRDBOR RPRLAPP
|
RLRDBOR_PERM_ZIP RPRLAPP_PAR_ZIP
|
NO NO
|
NO
|
PARENT_STATE_PROVINCE
|
State/province of the parent when a direct loan is of a parent type.
|
VARCHAR2(63)
|
RLRDBOR RPRLAPP
|
RLRDBOR_PERM_CDST_CODE RPRLAPP_PAR_STATE
|
NO NO
|
NO
|
PARENT_STATE_PROVINCE_DESC
|
Name of the state/province of the parent when a direct loan is of a parent type.
|
VARCHAR2(255)
|
FUNCTION STVSTAT
|
GOKODSF.F_GET_DESC STVSTAT_DESC
|
NO NO
|
NO
|
PARENT_STREET_LINE1
|
Address of the parent when a direct loan is of a parent type.
|
VARCHAR2(255)
|
RLRDBOR RPRLAPP
|
RLRDBOR_PERM_ADDRESS RPRLAPP_PAR_ADDRESS
|
NO NO
|
NO
|
PARENT_STREET_LINE2
|
Second line of parent's permanent street address.
|
VARCHAR2(255)
|
RLRDBOR RPRLAPP
|
RLRDBOR_PERM_ADDR_LINE2 RPRLAPP_PAR_ADDR_LINE2
|
NO NO
|
NO
|
PARENT_STREET_LINE3
|
Third line of parent's permanent street address.
|
VARCHAR2(255)
|
RLRDBOR RPRLAPP
|
RLRDBOR_PERM_ADDR_LINE3 RPRLAPP_PAR_ADDR_LINE3
|
NO NO
|
NO
|
PARENT_STREET_LINE4
|
Fourth line of parent's permanent street address.
|
VARCHAR2(255)
|
NA
|
NULL
|
NO
|
NO
|
PAYMENT_PERIOD_START_DATE
|
Disbursement payment period start date.
|
DATE
|
RLRDLDD RPRLADB
|
RLRDLDD_PAY_PD_START_DATE RPRLADB_PAY_PD_START_DATE
|
NO NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_PIDM RPRLADB_PIDM
|
NO NO
|
NO
|
PHONE_NUMBER_COMBINED
|
All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.
|
VARCHAR2(63)
|
RERCODS RPRLAPP
|
RERCODS_PHONE_NO RPRLAPP_PHONE_NO
|
NO NO
|
NO
|
POSTAL_CODE
|
Postal code in the address of the borrower of a direct loan.
|
VARCHAR2(63)
|
RERCODA RPRLAPP
|
RERCODA_ZIP RPRLAPP_ZIP
|
NO NO
|
NO
|
PREVIOUS_DISBURSEMENT_NUMBER
|
The previous disbursement sequence number on the COD database for the disbursement number.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_PREV_DISB_SEQ_NO RPRLADB_PREV_DISB_SEQ_NO
|
NO NO
|
NO
|
PRIOR_DISBURSEMENT_DATE
|
Prior Disbursement Date when the scheduled disbursement date is manually changed. After the change information is sent to the Lender or Lender's Agent, this date is set to null.
|
DATE
|
NA RPRLADB
|
NULL RPRLADB_PRIOR_DISB_DATE
|
NO NO
|
NO
|
PROCESS_GROUP
|
The institution value of the process-oriented identifier for the record used to determine access authorization to this record.
|
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)
|
RLRDBOR RPRLADB
|
RLRDLDD_CIP_CODE RPRLADB_CIP_CODE
|
NO NO
|
NO
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(255)
|
FUNCTION
|
ROKODSF.F_GET_CIPC_DESC
|
NO
|
NO
|
PROGRAM_SEQUENCE_LOCK_IND
|
Indicates if the student program information sequence is locked for the loan disbursement record.
|
VARCHAR2(1)
|
RLRDLDD
|
RLRDLDD_SPGM_LOCK_IND
|
NO
|
NO
|
PROGRAM_SEQUENCE_NUMBER
|
Sequence of the program information record used on this disbursement.
|
NUMBER
|
RLRDLDD
|
RLRDLDD_SPGM_SEQ_NO
|
NO
|
NO
|
RECOMMENDED_AMOUNT
|
Recommended amount of the loan associated with the loan application scheduled by academic period. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
NA RPRLATR
|
NULL RPRLATR_RECOMMEND_AMT
|
NO NO
|
NO
|
RECONCILIATION_BATCH_NUMBER
|
Cash reconciliation batch number in which this direct loan disbursement was included.
|
VARCHAR2(63)
|
RLRDDAS RPRLADB
|
RLRDDAS_SAS_BATCH_NO RPRLADB_RECON_BATCH_NO
|
NO NO
|
NO
|
REPORTED_DATE
|
Disbursement date reported to COD as of this sequence.
|
DATE
|
RLRDLDD RPRLADB
|
RLRDLDD_REPORTED_DATE RPRLADB_REPT_DISB_DATE
|
NO NO
|
NO
|
REQUESTED_AMOUNT
|
Amount of requested loan for this particular academic period. No longer used after Financial Aid release 8.22.1.
|
NUMBER
|
NA RPRLATR
|
NULL RPRLATR_REQUEST_AMT
|
NO NO
|
NO
|
RETURN_ID
|
Person's or organization's current identification number.
|
VARCHAR2(63)
|
FUNCTION NA
|
MGKFUNC.F_GET_PERSON_INFO NULL
|
NO NO
|
NO
|
RETURN_NAME
|
Name of the person (LFMI) or organization.
|
VARCHAR2(255)
|
FUNCTION NA
|
MGKFUNC.F_GET_PERSON_INFO NULL
|
NO NO
|
NO
|
RETURN_UID
|
Loan ID of the Guarantor or Lender.
|
NUMBER
|
NA RPRLAPP
|
NULL RPRLAPP_RETURN_PIDM
|
NO NO
|
NO
|
REVISED_GROSS_AMOUNT
|
The revised gross disbursement amount for this EL disbursement record.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_EL_REV_GROSS_AMT
|
NO NO
|
NO
|
REVISED_NET_AMOUNT
|
The revised disbursement amount excluding all fees retained by the lender (i.e. net amount).
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_REV_DISB_AMT
|
NO NO
|
NO
|
SAS_REGION
|
Region code of the school received in the statement of account.
|
VARCHAR2(63)
|
RLRDDAS RPRLADB
|
RLRDDAS_REGION_CDE RPRLADB_REGION_CD
|
NO NO
|
NO
|
SAS_STATE_PROVINCE
|
State or province associated with this institution.
|
VARCHAR2(63)
|
RLRDDAS RPRLADB
|
RLRDDAS_SCHOOL_STAT_CODE RPRLADB_SCHOOL_STAT_CODE
|
NO NO
|
NO
|
SAS_STATE_PROVINCE_DESC
|
State or province name.
|
VARCHAR2(255)
|
STVSTAT
|
STVSTAT_DESC
|
NO
|
NO
|
SCHEDULED_DATE
|
Used by the disbursement process as the first date on which this disbursement may occur.
|
DATE
|
RLRDLDD RPRLADB
|
RLRDLDD_SCHED_DATE RPRLADB_DISBURSE_DATE
|
NO NO
|
NO
|
SERVICER_DISBURSEMENT_DATE
|
The disbursement date scheduled by the guarantor/servicer for this disbursement.
|
DATE
|
NA RPRLADB
|
NULL RPRLADB_EL_SERV_DISB_DATE
|
NO NO
|
NO
|
SERVICER_DISBURSEMENT_GROSS
|
The amount guaranteed by the guarantor/servicer for this disbursement including all applicable fees and minus any cancellations.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_EL_SERV_GROSS_AMT
|
NO NO
|
NO
|
STATE_PROVINCE
|
State or province associated with this address.
|
VARCHAR2(63)
|
RERCODA RPRLAPP
|
RERCODA_CDST_CODE RPRLAPP_STATE
|
NO NO
|
NO
|
STATE_PROVINCE_DESC
|
State/province name.
|
VARCHAR2(255)
|
FUNCTION STVSTAT
|
GOKODSF.F_GET_DESC STVSTAT_DESC
|
NO NO
|
NO
|
STREET_LINE1
|
First line of the address.
|
VARCHAR2(255)
|
RERCODA RPRLAPP
|
RERCODA_ADDR_LINE1 RPRLAPP_ADDRESS
|
NO NO
|
NO
|
STREET_LINE2
|
Second line of the address.
|
VARCHAR2(255)
|
RERCODA RPRLAPP
|
RERCODA_ADDR_LINE2 RPRLAPP_ADDR_LINE2
|
NO NO
|
NO
|
STREET_LINE3
|
Third line of the address.
|
VARCHAR2(255)
|
RERCODA RPRLAPP
|
RERCODA_ADDR_LINE3 RPRLAPP_ADDR_LINE3
|
NO NO
|
NO
|
STREET_LINE4
|
Fourth line of the address.
|
VARCHAR2(255)
|
NA
|
NULL
|
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
|
STUDENT_RECEIVE_DATE
|
The date the loan proceeds were delivered to the student. No longer used after Financial Aid release 8.22.1.
|
DATE
|
NA RPRLADB
|
NULL RPRLADB_STU_RECEIVE_DATE
|
NO NO
|
NO
|
SUBSIDIZED_FEES_PAID
|
Total amount of fees subsidized by the guarantor or lender on behalf of the borrower for the disbursement.
|
NUMBER
|
NA RPRLADB
|
NULL RPRLADB_FEES_PAID
|
NO NO
|
NO
|
TOTAL_FEE_AMOUNT
|
Sum of actual fee amounts for the loan as calculated by COD.
|
NUMBER
|
NA RLRDDAS
|
NULL RLRDDAS_TOTAL_FEE_AMT
|
NO NO
|
NO
|
TOTAL_GROSS_AMOUNT
|
Sum of actual gross amounts for the loan as calculated by COD.
|
NUMBER
|
NA RLRDDAS
|
NULL RLRDDAS_TOTAL_GROSS_AMT
|
NO NO
|
NO
|
TOTAL_NET_AMOUNT
|
Sum of actual net amounts for the loan as calculated by COD.
|
NUMBER
|
NA RLRDDAS
|
NULL RLRDDAS_TOTAL_NET_AMT
|
NO NO
|
NO
|
TOTAL_NET_CHECK_AMOUNT
|
Summary of all disbursement net check amounts for the loan.
|
NUMBER
|
NA RLRDLDB
|
NULL RLRDLDB_TOTAL_NET_AMOUNT
|
NO NO
|
NO
|
TOTAL_REBATE_AMOUNT
|
Actual rebate amount for this disbursement as calculated by COD.
|
NUMBER
|
NA RLRDDAS
|
NULL RLRDDAS_TOTAL_REBATE_AMT
|
NO NO
|
NO
|
TRANSACTION_DATE
|
Transaction date.
|
DATE
|
NA RLRDDAS
|
NULL RLRDDAS_TRANSACTION_DATE
|
NO NO
|
NO
|
TRANSACTION_NUMBER
|
Displays the number on the student's account's receivable account where the disbursement was applied.
|
NUMBER
|
RLRDLDD RPRLADB
|
RLRDLDD_AR_TRAN_NUMBER RPRLADB_TRAN_NUMBER
|
NO NO
|
NO
|
TRANSACTION_TYPE
|
This is the type of transaction record found for the disbursement.
|
VARCHAR2(63)
|
RLRDDAS RPRLADB
|
RLRDDAS_TRANS_TYPE RPRLADB_SERV_TRANS_TYPE
|
NO NO
|
NO
|
TRANSACTION_TYPE_DESC
|
Transaction record description.
|
VARCHAR2(255)
|
CALCULATION CALCULATION
|
DECODE(RLRDDAS_TRANS_TYPE) DECODE(RPRLADB_SERV_TRANS_TYPE)
|
NO NO
|
NO
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
RLRDLDD RPRLADB
|
RLRDLDD_USER_ID RPRLADB_USER_ID
|
NO NO
|
NO
|
XREF_LOAN_ID
|
Identification number of the loan with which this loan was combined when producing an electronic loan extract file or direct loan promissory note. No longer used after Financial Aid release 8.22.1.
|
VARCHAR2(63)
|
NA RPRLAPP
|
NULL RPRLAPP_XREF_LOAN_ID
|
NO NO
|
NO
|