REBDRCT REBDSOA REBPAYV REBRDRQ REBRMRR REBSSOA REBYTDD REBYTDO REBYTDS RERCODD RERRECN RERSTID

Model Electronic Data Exchange


Model Label : Banner Financial Aid EDE Module
Path : Default Folder/B70/finaid/EDE_ERD

List of Objects

Object Name Object Type Layer Name
REBDRCT TABLE Default
REBDSOA TABLE Default
REBPAYV TABLE Default
REBRDRQ TABLE Default
REBRMRR TABLE Default
REBSSOA TABLE Default
REBYTDD TABLE Default
REBYTDO TABLE Default
REBYTDS TABLE Default
RERCODD TABLE Default
RERRECN TABLE Default
RERSTID TABLE Default

Comments

Model View

''

Table REBDRCT

Schema Name FAISMGR
Label REBDRCT
Server name S4B70
Creation Date 09/29/2003 12:14:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
REBDRCT_AIDY_CODE REBDRCT_AIDY_CODE VARCHAR2(4) No *
REBDRCT_TYPE_IND REBDRCT_TYPE_IND VARCHAR2(1) No
REBDRCT_NO_REC REBDRCT_NO_REC NUMBER(6,0) No
REBDRCT_ACTIVITY_DATE REBDRCT_ACTIVITY_DATE DATE No
REBDRCT_BATCH_ID REBDRCT_BATCH_ID VARCHAR2(8) Yes
REBDRCT_PROC_DATE REBDRCT_PROC_DATE DATE Yes
REBDRCT_PELL_CAMP_CODE REBDRCT_PELL_CAMP_CODE VARCHAR2(6) Yes
REBDRCT_DLBT_CODE REBDRCT_DLBT_CODE VARCHAR2(1) Yes
REBDRCT_BATCH_NO REBDRCT_BATCH_NO VARCHAR2(26) Yes
REBDRCT_CONF_DATE REBDRCT_CONF_DATE DATE Yes
REBDRCT_END_DATE REBDRCT_END_DATE DATE Yes
REBDRCT_REJECT_CD REBDRCT_REJECT_CD VARCHAR2(3) Yes
REBDRCT_ACCEPT_REC_NO REBDRCT_ACCEPT_REC_NO NUMBER(6,0) Yes
REBDRCT_REJECT_REC_NO REBDRCT_REJECT_REC_NO NUMBER(5,0) Yes
REBDRCT_PEND_REC_NO REBDRCT_PEND_REC_NO NUMBER(5,0) Yes
REBDRCT_REJECT_CD_2 REBDRCT_REJECT_CD_2 VARCHAR2(3) Yes
REBDRCT_REJECT_CD_3 REBDRCT_REJECT_CD_3 VARCHAR2(3) Yes
REBDRCT_REJECT_CD_4 REBDRCT_REJECT_CD_4 VARCHAR2(3) Yes
REBDRCT_REJECT_CD_5 REBDRCT_REJECT_CD_5 VARCHAR2(3) Yes
REBDRCT_REJECT_CD_6 REBDRCT_REJECT_CD_6 VARCHAR2(3) Yes
REBDRCT_REJECT_CD_7 REBDRCT_REJECT_CD_7 VARCHAR2(3) Yes
REBDRCT_REJECT_CD_8 REBDRCT_REJECT_CD_8 VARCHAR2(3) Yes
REBDRCT_BATCH_AMOUNT REBDRCT_BATCH_AMOUNT NUMBER(11,2) Yes
REBDRCT_DEBIT_CR_IND REBDRCT_DEBIT_CR_IND VARCHAR2(1) Yes
REBDRCT_ACPT_BATCH_AMOUNT REBDRCT_ACPT_BATCH_AMOUNT NUMBER(11,2) Yes
REBDRCT_ACPT_DEBIT_CR_IND REBDRCT_ACPT_DEBIT_CR_IND VARCHAR2(1) Yes
REBDRCT_DUP_REC_NO REBDRCT_DUP_REC_NO VARCHAR2(6) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
REBDRCT_AIDY_CODE ROBINST_AIDY_CODE ROBINST

Index

Index Name Index Type Column Name
REBDRCT_BATCH_INDEX REBDRCT_BATCH_NO
REBDRCT_KEY_INDEX Unique REBDRCT_AIDY_CODE
REBDRCT_KEY_INDEX Unique REBDRCT_TYPE_IND
REBDRCT_KEY_INDEX Unique REBDRCT_ACTIVITY_DATE
REBDRCT_KEY_INDEX Unique REBDRCT_BATCH_NO

Comments

Source Code Comments

EDE Directory Table

Columns Comments for REBDRCT_BATCH_NO (9)

Source Code Comments

The batch number associated with each file of records sent or received from the servicer.

Columns Comments for REBDRCT_CONF_DATE (10)

Source Code Comments

This is the date that the batch was received and confirmed by the servicer.

Columns Comments for REBDRCT_END_DATE (11)

Source Code Comments

STATEMENT END DATE: If the batch ID is for a Direct Loan School Account Statement, the date for which the statement was run (should always be the last day of the month).

Columns Comments for REBDRCT_REJECT_CD (12)

Source Code Comments

BATCH REJECT CODE 1: The first batch reject code for this batch, if applicable.

Columns Comments for REBDRCT_ACCEPT_REC_NO (13)

Source Code Comments

NUMBER OF ACCEPTED RECORDS: This field indicates the total number of records accepted by the Loan Origination Center (LOC) in this batch.

Columns Comments for REBDRCT_REJECT_REC_NO (14)

Source Code Comments

NUMBER OF REJECTED RECORDS: This field indicates the total number of records rejected by the Loan Origination Center (LOC) in this batch.

Columns Comments for REBDRCT_PEND_REC_NO (15)

Source Code Comments

NUMBER OF PENDING RECORDS: This field indicates the total number of records pending in a Promissory Note acknowledgement file.

Columns Comments for REBDRCT_REJECT_CD_2 (16)

Source Code Comments

BATCH REJECT CODE 2: The second batch reject code for this batch, if applicable.

Columns Comments for REBDRCT_REJECT_CD_3 (17)

Source Code Comments

BATCH REJECT CODE 3: The third batch reject code for this batch, if applicable.

Columns Comments for REBDRCT_REJECT_CD_4 (18)

Source Code Comments

BATCH REJECT CODE 4: The fourth batch reject code for this batch, if applicable.

Columns Comments for REBDRCT_REJECT_CD_5 (19)

Source Code Comments

BATCH REJECT CODE 5: The fifth batch reject code for this batch, if applicable.

Columns Comments for REBDRCT_REJECT_CD_6 (20)

Source Code Comments

BATCH REJECT CODE 6: The sixth batch reject code for this batch, if applicable.

Columns Comments for REBDRCT_REJECT_CD_7 (21)

Source Code Comments

BATCH REJECT CODE 7: The seventh batch reject code for this batch, if applicable.

Columns Comments for REBDRCT_REJECT_CD_8 (22)

Source Code Comments

BATCH REJECT CODE 8: The eighth batch reject code for this batch, if applicable.

Columns Comments for REBDRCT_BATCH_AMOUNT (23)

Source Code Comments

BATCH TOTAL AMOUNT: For Pell batches, the total amount of this batch. This will always be a positive amount. Negative payments will be sent as a positive amount with a debit/credit indicator of N.

Columns Comments for REBDRCT_DEBIT_CR_IND (24)

Source Code Comments

DEBIT/CREDIT INDICATOR: Debit/Credit indicator for this batch. Indicates if the total batch amount is positive (P) or negative (N).

Columns Comments for REBDRCT_ACPT_BATCH_AMOUNT (25)

Source Code Comments

ACCEPTED BATCH TOTAL AMOUNT: For Pell batches, the total amount of this batch, as acknowledged by RFMS. This will always be a positive amount. Negative payments will be sent as a positive amount with a debit/credit indicator of N.

Columns Comments for REBDRCT_ACPT_DEBIT_CR_IND (26)

Source Code Comments

ACCEPTED DEBIT/CREDIT INDICATOR: Debit/Credit indicator for this batch, as acknowledged by RFMS. Indicates if the total batch amount is positive (P) or negative (N).

Columns Comments for REBDRCT_DUP_REC_NO (27)

Source Code Comments

NUMBER OF DUPLICATE RECORDS: The number of data records that duplicate a previously accepted Origination or Disbursement record.

Table REBDSOA

Schema Name FAISMGR
Label REBDSOA
Server name S4B70
Creation Date 02/17/2004 14:39:09:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
REBDSOA_AIDY_CODE REBDSOA_AIDY_CODE VARCHAR2(4) No
REBDSOA_ACTIVITY_DATE REBDSOA_ACTIVITY_DATE DATE No
REBDSOA_BATCH_NO REBDSOA_BATCH_NO VARCHAR2(26) No
REBDSOA_CAMP_PELL_ID REBDSOA_CAMP_PELL_ID VARCHAR2(6) Yes
REBDSOA_GRANTEE_DUNS_NO REBDSOA_GRANTEE_DUNS_NO VARCHAR2(11) Yes
REBDSOA_PAYEE_DUNS_NO REBDSOA_PAYEE_DUNS_NO VARCHAR2(11) Yes
REBDSOA_GAPS_AWARD_NO REBDSOA_GAPS_AWARD_NO VARCHAR2(16) Yes
REBDSOA_ADJ_REPORT_DATE REBDSOA_ADJ_REPORT_DATE DATE Yes
REBDSOA_DEBIT_CR_IND REBDSOA_DEBIT_CR_IND VARCHAR2(1) Yes
REBDSOA_ADJ_AMOUNT REBDSOA_ADJ_AMOUNT NUMBER(11,2) Yes
REBDSOA_ADJ_PROCESS_DATE REBDSOA_ADJ_PROCESS_DATE DATE Yes
REBDSOA_ADJ_BATCH_NO REBDSOA_ADJ_BATCH_NO VARCHAR2(26) Yes
REBDSOA_ADJ_DESCRIPTION REBDSOA_ADJ_DESCRIPTION VARCHAR2(20) Yes
REBDSOA_ADJ_DOCUMENT_ID REBDSOA_ADJ_DOCUMENT_ID VARCHAR2(30) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
REBDSOA_AIDY_INDEX REBDSOA_AIDY_CODE
REBDSOA_AIDY_INDEX REBDSOA_ADJ_PROCESS_DATE

Comments

Source Code Comments

Detail Statement of Account Table

Columns Comments for REBDSOA_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE FOR DETAIL STATEMENT OF ACCOUNT: The aid year for the detail statement of account data.

Columns Comments for REBDSOA_ACTIVITY_DATE (2)

Source Code Comments

ACTIVITY DATE FOR DETAIL STATEMENT OF ACCOUNT: Activity date for the detail statement of account data.

Columns Comments for REBDSOA_BATCH_NO (3)

Source Code Comments

PELL DETAIL STATEMENT OF ACCOUNT BATCH NUMBER: The Batch Number associated with the Detail Statement of Account.

Columns Comments for REBDSOA_CAMP_PELL_ID (4)

Source Code Comments

CAMPUS PELL ID FOR DETAIL STATEMENT OF ACCOUNT: PELL ID of reporting campus.

Columns Comments for REBDSOA_GRANTEE_DUNS_NO (5)

Source Code Comments

GRANTEE DUNS NUMBER: DUNS number assigned to the reporting institution.

Columns Comments for REBDSOA_PAYEE_DUNS_NO (6)

Source Code Comments

PAYEE DUNS NUMBER: DUNS number assigned to the Payee institution.

Columns Comments for REBDSOA_GAPS_AWARD_NO (7)

Source Code Comments

GAPS AWARD NUMBER: Used to identify a unique funding for an institution.

Columns Comments for REBDSOA_ADJ_REPORT_DATE (8)

Source Code Comments

ADJUSTMENT REPORT DATE: Date of adjustment batch reported to ED CAPS.

Columns Comments for REBDSOA_DEBIT_CR_IND (9)

Source Code Comments

SIGN INDICATOR: Indicates if the Adjustment Amount is positive or negative. Valid values are (P)ositive and (N)egative.

Columns Comments for REBDSOA_ADJ_AMOUNT (10)

Source Code Comments

ADJUSTMENT AMOUNT: Amount of institutions adjustment batch.

Columns Comments for REBDSOA_ADJ_PROCESS_DATE (11)

Source Code Comments

ADJUSTMENT PROCESS DATE: The date GAPS processed adjustment batch.

Columns Comments for REBDSOA_ADJ_BATCH_NO (12)

Source Code Comments

ADJUSTMENT BATCH NUMBER: Batch number which generated the adjustment.

Columns Comments for REBDSOA_ADJ_DESCRIPTION (13)

Source Code Comments

ADJUSTMENT DESCRIPTION: Literal to describe the type of batch.

Columns Comments for REBDSOA_ADJ_DOCUMENT_ID (14)

Source Code Comments

ADJUSTMENT COD DOCUMENT ID: The document identification number that generated the adjustment.

Table REBPAYV

Schema Name FAISMGR
Label REBPAYV
Server name S4B70
Creation Date 08/02/2004 13:25:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
REBPAYV_AIDY_CODE REBPAYV_AIDY_CODE VARCHAR2(4) No *
REBPAYV_PIDM REBPAYV_PIDM NUMBER(8,0) No *
REBPAYV_ACTIVITY_DATE REBPAYV_ACTIVITY_DATE DATE No
REBPAYV_CAMP_PELL_ID REBPAYV_CAMP_PELL_ID VARCHAR2(6) Yes
REBPAYV_INST_PELL_ID REBPAYV_INST_PELL_ID VARCHAR2(6) Yes
REBPAYV_ACAD_CAL REBPAYV_ACAD_CAL VARCHAR2(1) Yes
REBPAYV_DATE_SENT REBPAYV_DATE_SENT DATE Yes
REBPAYV_ATTEND_COST REBPAYV_ATTEND_COST NUMBER(7,2) Yes
REBPAYV_ENROLL_STATUS REBPAYV_ENROLL_STATUS VARCHAR2(1) Yes
REBPAYV_EXPECT_HRS REBPAYV_EXPECT_HRS NUMBER(4,0) Yes
REBPAYV_HRS_IN_YR REBPAYV_HRS_IN_YR NUMBER(4,0) Yes
REBPAYV_AMT_PAID REBPAYV_AMT_PAID NUMBER(7,2) Yes
REBPAYV_AMT_DUE REBPAYV_AMT_DUE NUMBER(7,2) Yes
REBPAYV_RECOVERY_IND REBPAYV_RECOVERY_IND RAW(1) Yes
REBPAYV_NBR_MTHS_PAY REBPAYV_NBR_MTHS_PAY NUMBER(2,0) Yes
REBPAYV_JUL_PAY REBPAYV_JUL_PAY RAW(1) Yes
REBPAYV_AUG_PAY REBPAYV_AUG_PAY RAW(1) Yes
REBPAYV_SEP_PAY REBPAYV_SEP_PAY RAW(1) Yes
REBPAYV_OCT_PAY REBPAYV_OCT_PAY RAW(1) Yes
REBPAYV_NOV_PAY REBPAYV_NOV_PAY RAW(1) Yes
REBPAYV_DEC_PAY REBPAYV_DEC_PAY RAW(1) Yes
REBPAYV_JAN_PAY REBPAYV_JAN_PAY RAW(1) Yes
REBPAYV_FEB_PAY REBPAYV_FEB_PAY RAW(1) Yes
REBPAYV_MAR_PAY REBPAYV_MAR_PAY RAW(1) Yes
REBPAYV_APR_PAY REBPAYV_APR_PAY RAW(1) Yes
REBPAYV_MAY_PAY REBPAYV_MAY_PAY RAW(1) Yes
REBPAYV_JUN_PAY REBPAYV_JUN_PAY RAW(1) Yes
REBPAYV_WORKSHEET REBPAYV_WORKSHEET RAW(1) Yes
REBPAYV_ENROLL_DATE REBPAYV_ENROLL_DATE RAW(6) Yes
REBPAYV_INST_XREF REBPAYV_INST_XREF VARCHAR2(9) Yes
REBPAYV_ACTION_CODE REBPAYV_ACTION_CODE RAW(1) Yes
REBPAYV_SECONDARY_PGI_USED REBPAYV_SECONDARY_PGI_USED VARCHAR2(1) Yes
REBPAYV_PGI REBPAYV_PGI NUMBER(5,0) Yes
REBPAYV_PRISON_IND REBPAYV_PRISON_IND VARCHAR2(1) Yes
REBPAYV_PRISON_STATE REBPAYV_PRISON_STATE RAW(2) Yes
REBPAYV_PAY_AMT_CALC_IND REBPAYV_PAY_AMT_CALC_IND RAW(1) Yes
REBPAYV_VER_STATUS REBPAYV_VER_STATUS VARCHAR2(1) Yes
REBPAYV_SAR_SSN REBPAYV_SAR_SSN VARCHAR2(9) Yes *
REBPAYV_SAR_INIT REBPAYV_SAR_INIT VARCHAR2(2) Yes *
REBPAYV_SAR_TRAN_NO REBPAYV_SAR_TRAN_NO VARCHAR2(2) Yes
REBPAYV_PAYMENT_METHOD REBPAYV_PAYMENT_METHOD VARCHAR2(1) Yes
REBPAYV_EXPECT_WKS REBPAYV_EXPECT_WKS NUMBER(2,0) Yes
REBPAYV_WKS_IN_YR REBPAYV_WKS_IN_YR NUMBER(2,0) Yes
REBPAYV_CHANGE_DATE REBPAYV_CHANGE_DATE RAW(14) Yes
REBPAYV_ENROLLMENT_DATE REBPAYV_ENROLLMENT_DATE DATE Yes
REBPAYV_EST_DISB_DATE_01 REBPAYV_EST_DISB_DATE_01 DATE Yes
REBPAYV_EST_DISB_DATE_02 REBPAYV_EST_DISB_DATE_02 DATE Yes
REBPAYV_EST_DISB_DATE_03 REBPAYV_EST_DISB_DATE_03 DATE Yes
REBPAYV_EST_DISB_DATE_04 REBPAYV_EST_DISB_DATE_04 DATE Yes
REBPAYV_EST_DISB_DATE_05 REBPAYV_EST_DISB_DATE_05 DATE Yes
REBPAYV_EST_DISB_DATE_06 REBPAYV_EST_DISB_DATE_06 DATE Yes
REBPAYV_EST_DISB_DATE_07 REBPAYV_EST_DISB_DATE_07 DATE Yes
REBPAYV_EST_DISB_DATE_08 REBPAYV_EST_DISB_DATE_08 DATE Yes
REBPAYV_EST_DISB_DATE_09 REBPAYV_EST_DISB_DATE_09 DATE Yes
REBPAYV_EST_DISB_DATE_10 REBPAYV_EST_DISB_DATE_10 DATE Yes
REBPAYV_EST_DISB_DATE_11 REBPAYV_EST_DISB_DATE_11 DATE Yes
REBPAYV_EST_DISB_DATE_12 REBPAYV_EST_DISB_DATE_12 DATE Yes
REBPAYV_EST_DISB_DATE_13 REBPAYV_EST_DISB_DATE_13 DATE Yes
REBPAYV_EST_DISB_DATE_14 REBPAYV_EST_DISB_DATE_14 DATE Yes
REBPAYV_EST_DISB_DATE_15 REBPAYV_EST_DISB_DATE_15 DATE Yes
REBPAYV_LOW_COST_CDE REBPAYV_LOW_COST_CDE VARCHAR2(1) Yes
REBPAYV_ORIG_BATCH_NO REBPAYV_ORIG_BATCH_NO VARCHAR2(26) Yes
REBPAYV_ORIG_ID REBPAYV_ORIG_ID VARCHAR2(23) Yes
REBPAYV_STATUS_CDE REBPAYV_STATUS_CDE VARCHAR2(1) Yes
REBPAYV_ACPT_NBR_MTHS_PAY REBPAYV_ACPT_NBR_MTHS_PAY NUMBER(1,0) Yes
REBPAYV_ACPT_AMT_DUE REBPAYV_ACPT_AMT_DUE NUMBER(7,2) Yes
REBPAYV_ACPT_EST_DISB_DATE_01 REBPAYV_ACPT_EST_DISB_DATE_01 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_02 REBPAYV_ACPT_EST_DISB_DATE_02 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_03 REBPAYV_ACPT_EST_DISB_DATE_03 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_04 REBPAYV_ACPT_EST_DISB_DATE_04 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_05 REBPAYV_ACPT_EST_DISB_DATE_05 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_06 REBPAYV_ACPT_EST_DISB_DATE_06 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_07 REBPAYV_ACPT_EST_DISB_DATE_07 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_08 REBPAYV_ACPT_EST_DISB_DATE_08 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_09 REBPAYV_ACPT_EST_DISB_DATE_09 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_10 REBPAYV_ACPT_EST_DISB_DATE_10 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_11 REBPAYV_ACPT_EST_DISB_DATE_11 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_12 REBPAYV_ACPT_EST_DISB_DATE_12 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_13 REBPAYV_ACPT_EST_DISB_DATE_13 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_14 REBPAYV_ACPT_EST_DISB_DATE_14 DATE Yes
REBPAYV_ACPT_EST_DISB_DATE_15 REBPAYV_ACPT_EST_DISB_DATE_15 DATE Yes
REBPAYV_ACPT_ENROLLMENT_DATE REBPAYV_ACPT_ENROLLMENT_DATE DATE Yes
REBPAYV_ACPT_LOW_COST_CDE REBPAYV_ACPT_LOW_COST_CDE VARCHAR2(1) Yes
REBPAYV_ACPT_VER_STATUS REBPAYV_ACPT_VER_STATUS VARCHAR2(1) Yes
REBPAYV_ACPT_PRISON_IND REBPAYV_ACPT_PRISON_IND VARCHAR2(1) Yes
REBPAYV_ACPT_SAR_TRAN_NO REBPAYV_ACPT_SAR_TRAN_NO VARCHAR2(2) Yes
REBPAYV_ACPT_PGI REBPAYV_ACPT_PGI NUMBER(5,0) Yes
REBPAYV_ACPT_SEC_PGI_USED REBPAYV_ACPT_SEC_PGI_USED VARCHAR2(1) Yes
REBPAYV_ACPT_ACAD_CAL REBPAYV_ACPT_ACAD_CAL VARCHAR2(1) Yes
REBPAYV_ACPT_PAYMENT_METHOD REBPAYV_ACPT_PAYMENT_METHOD VARCHAR2(1) Yes
REBPAYV_ACPT_ATTEND_COST REBPAYV_ACPT_ATTEND_COST NUMBER(7,2) Yes
REBPAYV_ACPT_ENROLL_STATUS REBPAYV_ACPT_ENROLL_STATUS VARCHAR2(1) Yes
REBPAYV_ACPT_EXPECT_WKS REBPAYV_ACPT_EXPECT_WKS NUMBER(2,0) Yes
REBPAYV_ACPT_WKS_IN_YR REBPAYV_ACPT_WKS_IN_YR NUMBER(2,0) Yes
REBPAYV_ACPT_EXPECT_HRS REBPAYV_ACPT_EXPECT_HRS NUMBER(4,0) Yes
REBPAYV_ACPT_HRS_IN_YR REBPAYV_ACPT_HRS_IN_YR NUMBER(4,0) Yes
REBPAYV_SCH_PELL_GRANT REBPAYV_SCH_PELL_GRANT NUMBER(7,2) Yes
REBPAYV_PREV_ACPT_SAR_TRAN_NO REBPAYV_PREV_ACPT_SAR_TRAN_NO VARCHAR2(2) Yes
REBPAYV_PREV_ACPT_EFC REBPAYV_PREV_ACPT_EFC NUMBER(5,0) Yes
REBPAYV_PREV_ACPT_SEC_EFC_CDE REBPAYV_PREV_ACPT_SEC_EFC_CDE VARCHAR2(1) Yes
REBPAYV_PREV_ACPT_ATTEND_COST REBPAYV_PREV_ACPT_ATTEND_COST NUMBER(7,2) Yes
REBPAYV_EDIT_REJ_01 REBPAYV_EDIT_REJ_01 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_02 REBPAYV_EDIT_REJ_02 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_03 REBPAYV_EDIT_REJ_03 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_04 REBPAYV_EDIT_REJ_04 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_05 REBPAYV_EDIT_REJ_05 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_06 REBPAYV_EDIT_REJ_06 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_07 REBPAYV_EDIT_REJ_07 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_08 REBPAYV_EDIT_REJ_08 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_09 REBPAYV_EDIT_REJ_09 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_10 REBPAYV_EDIT_REJ_10 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_11 REBPAYV_EDIT_REJ_11 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_12 REBPAYV_EDIT_REJ_12 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_13 REBPAYV_EDIT_REJ_13 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_14 REBPAYV_EDIT_REJ_14 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_15 REBPAYV_EDIT_REJ_15 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_16 REBPAYV_EDIT_REJ_16 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_17 REBPAYV_EDIT_REJ_17 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_18 REBPAYV_EDIT_REJ_18 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_19 REBPAYV_EDIT_REJ_19 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_20 REBPAYV_EDIT_REJ_20 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_21 REBPAYV_EDIT_REJ_21 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_22 REBPAYV_EDIT_REJ_22 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_23 REBPAYV_EDIT_REJ_23 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_24 REBPAYV_EDIT_REJ_24 VARCHAR2(3) Yes
REBPAYV_EDIT_REJ_25 REBPAYV_EDIT_REJ_25 VARCHAR2(3) Yes
REBPAYV_SHARED_SAR_ID_FLAG REBPAYV_SHARED_SAR_ID_FLAG VARCHAR2(1) Yes
REBPAYV_VERIF_W_STATUS_FLAG REBPAYV_VERIF_W_STATUS_FLAG VARCHAR2(1) Yes
REBPAYV_CONCUR_ENROLL_FLAG REBPAYV_CONCUR_ENROLL_FLAG VARCHAR2(1) Yes
REBPAYV_POTENTIAL_OVERPMT_FLAG REBPAYV_POTENTIAL_OVERPMT_FLAG VARCHAR2(1) Yes
REBPAYV_LOCK_IND REBPAYV_LOCK_IND VARCHAR2(1) Yes
REBPAYV_LOW_TUITION_COST REBPAYV_LOW_TUITION_COST NUMBER(7,2) Yes
REBPAYV_INT_SEQ_NO REBPAYV_INT_SEQ_NO NUMBER(3,0) Yes
REBPAYV_ACPT_INT_SEQ_NO REBPAYV_ACPT_INT_SEQ_NO NUMBER(3,0) Yes
REBPAYV_CURRENT_SSN REBPAYV_CURRENT_SSN VARCHAR2(9) Yes
REBPAYV_CURRENT_BIRTH_DATE REBPAYV_CURRENT_BIRTH_DATE DATE Yes
REBPAYV_CURRENT_LAST_NAME REBPAYV_CURRENT_LAST_NAME VARCHAR2(16) Yes
REBPAYV_CURRENT_FIRST_NAME REBPAYV_CURRENT_FIRST_NAME VARCHAR2(12) Yes
REBPAYV_CURRENT_MI REBPAYV_CURRENT_MI VARCHAR2(1) Yes
REBPAYV_NEG_PENDING_AMT REBPAYV_NEG_PENDING_AMT NUMBER(7,2) Yes
REBPAYV_SEC_EFC REBPAYV_SEC_EFC NUMBER(5,0) Yes
REBPAYV_ACPT_CURRENT_SSN REBPAYV_ACPT_CURRENT_SSN VARCHAR2(9) Yes
REBPAYV_ACPT_BIRTH_DATE REBPAYV_ACPT_BIRTH_DATE DATE Yes
REBPAYV_ACPT_LAST_NAME REBPAYV_ACPT_LAST_NAME VARCHAR2(35) Yes
REBPAYV_ACPT_FIRST_NAME REBPAYV_ACPT_FIRST_NAME VARCHAR2(12) Yes
REBPAYV_ACPT_MI REBPAYV_ACPT_MI VARCHAR2(1) Yes
REBPAYV_DOCUMENT_ID REBPAYV_DOCUMENT_ID VARCHAR2(30) Yes
REBPAYV_USER_ID REBPAYV_USER_ID VARCHAR2(30) Yes
REBPAYV_DATA_ORIGIN REBPAYV_DATA_ORIGIN VARCHAR2(30) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
REBPAYV_AIDY_CODE ROBINST_AIDY_CODE ROBINST
REBPAYV_PIDM SPRIDEN_PIDM SPRIDEN
REBPAYV_AIDY_CODE REBRMRR_AIDY_CODE REBRMRR
REBPAYV_SAR_SSN REBRMRR_ORIG_SSN REBRMRR
REBPAYV_SAR_INIT REBRMRR_ORIG_INIT REBRMRR

Index

Index Name Index Type Column Name
REBPAYV_DOCUMENT_ID_INDEX REBPAYV_DOCUMENT_ID
REBPAYV_KEY_INDEX Unique REBPAYV_AIDY_CODE
REBPAYV_KEY_INDEX Unique REBPAYV_PIDM
REBPAYV_KEY_INDEX Unique REBPAYV_DATE_SENT
REBPAYV_ORIG_BATCH_INDEX REBPAYV_ORIG_BATCH_NO
REBPAYV_ORIG_ID_INDEX REBPAYV_ORIG_ID
REBPAYV_SAR_INDEX REBPAYV_SAR_SSN
REBPAYV_SAR_INDEX REBPAYV_SAR_INIT

Comments

Source Code Comments

Pell Origination Table

Columns Comments for REBPAYV_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year associated with the information in this record.

Columns Comments for REBPAYV_PIDM (2)

Source Code Comments

PIDM: Internal system-generated student identification number for the student in this record.

Columns Comments for REBPAYV_ACTIVITY_DATE (3)

Source Code Comments

ACTIVITY DATE: Date of last activity.

Columns Comments for REBPAYV_CAMP_PELL_ID (4)

Source Code Comments

CAMPUS PELL ID: Pell ID of the campus the student is attending. Can be different from Institution Pell ID if a branch campus or multicampus institution.

Columns Comments for REBPAYV_INST_PELL_ID (5)

Source Code Comments

INSTITUTION PELL ID: Pell ID for the institution.

Columns Comments for REBPAYV_ACAD_CAL (6)

Source Code Comments

ACADEMIC CALENDAR: The federally defined value that identifies the academic calendar which applies to the student's educational program.

Columns Comments for REBPAYV_DATE_SENT (7)

Source Code Comments

DATE THE ORIGINATION RECORD WAS SENT: Date the Origination record was extracted to be sent to COD for processing.

Columns Comments for REBPAYV_ATTEND_COST (8)

Source Code Comments

COST OF ATTENDANCE: The cost of attendance for Pell. This must follow the COA guidelines defined by the Federal Pell Grant Payment regulations.

Columns Comments for REBPAYV_ENROLL_STATUS (9)

Source Code Comments

STUDENT'S ENROLLMENT STATUS: The student's expected enrollment status for the entire award year. The status '5' 'Other' is used when the student's enrollment is mixed or the student attends more than the number of terms in a full academic year.

Columns Comments for REBPAYV_EXPECT_HRS (10)

Source Code Comments

EXPECTED HOURS TO COMPLETE THIS SCHOOL YEAR: Total number of credit/clock hours the institution expects the student to complete during the current Pell Grant award year. Valid values depend on Payment Methodology and Academic Calendar.

Columns Comments for REBPAYV_HRS_IN_YR (11)

Source Code Comments

HOURS IN PROGRAM'S DEFINITION OF ACADEMIC YEAR: Total number of credit or clock hours in the institution's definition of a full academic year for the program of study.

Columns Comments for REBPAYV_AMT_PAID (12)

Source Code Comments

AMOUNT PAID STUDENT: Year to date amount paid as reported on the Pell Disbursement acknowledgement record.

Columns Comments for REBPAYV_AMT_DUE (13)

Source Code Comments

AMOUNT DUE STUDENT: Amount of award for student's entire school year. Cannot exceed Total Pell Grant full time award for the year.

Columns Comments for REBPAYV_RECOVERY_IND (14)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_NBR_MTHS_PAY (15)

Source Code Comments

NUMBER OF PAYMENT PERIODS IN THE STUDENT'S SCHOOL YEAR: The number of terms or payment periods in the student's school year.

Columns Comments for REBPAYV_JUL_PAY (16)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_AUG_PAY (17)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_SEP_PAY (18)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_OCT_PAY (19)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_NOV_PAY (20)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_DEC_PAY (21)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_JAN_PAY (22)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_FEB_PAY (23)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_MAR_PAY (24)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_APR_PAY (25)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_MAY_PAY (26)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_JUN_PAY (27)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_WORKSHEET (28)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_ENROLL_DATE (29)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_INST_XREF (30)

Source Code Comments

ORIGINATION CROSS REFERENCE: An optional field that allows for the cross-reference of the Pell ID to the ID used in Banner to identify a student.

Columns Comments for REBPAYV_ACTION_CODE (31)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_SECONDARY_PGI_USED (32)

Source Code Comments

SECONDARY EFC USED INDICATOR: Indicates whether a secondary EFC was sent to COD for processing to determine the award amount to be used for the Pell Grant. If blank, secondary EFC not used.

Columns Comments for REBPAYV_PGI (33)

Source Code Comments

PELL EXPECTED FAMILY CONTRIBUTION: The student's EFC that will be reported on the Pell Origination record.

Columns Comments for REBPAYV_PRISON_IND (34)

Source Code Comments

PRISON INDICATOR: Indicates that a student is incarcerated.

Columns Comments for REBPAYV_PRISON_STATE (35)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_PAY_AMT_CALC_IND (36)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_VER_STATUS (37)

Source Code Comments

VERIFICATION STATUS CODE: Indicates what the student verification status code is at the time the Pell Origination is created.

Columns Comments for REBPAYV_SAR_SSN (38)

Source Code Comments

SAR ID SSN: Part of SAR Record ID, student's Social Security Number.

Columns Comments for REBPAYV_SAR_INIT (39)

Source Code Comments

SAR ID INITIALS: Part of SAR Record ID, first two letters of student's last name.

Columns Comments for REBPAYV_SAR_TRAN_NO (40)

Source Code Comments

SAR ID TRANSACTION NO: Part of SAR Record ID, Transaction Number on payment.

Columns Comments for REBPAYV_PAYMENT_METHOD (41)

Source Code Comments

PAYMENT METHOD: Indicates what student Payment Methodology is at the time Pell Origination is created.

Columns Comments for REBPAYV_EXPECT_WKS (42)

Source Code Comments

WEEKS ENROLLED: Indicates the number of weeks the student is enrolled in a year at the time Pell Origination is created.

Columns Comments for REBPAYV_WKS_IN_YR (43)

Source Code Comments

WEEKS IN PROGRAM: Indicates the number of weeks of instruction in the program year at the time Pell Origination is created.

Columns Comments for REBPAYV_CHANGE_DATE (44)

Source Code Comments

Obsolete; will be dropped from the table at a future date.

Columns Comments for REBPAYV_ENROLLMENT_DATE (45)

Source Code Comments

ENROLLMENT DATE: Date that student is first enrolled in eligible program for the aid year.

Columns Comments for REBPAYV_EST_DISB_DATE_01 (46)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 1: Estimated Disbursement Date 1.

Columns Comments for REBPAYV_EST_DISB_DATE_02 (47)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 2: Estimated Disbursement Date 2.

Columns Comments for REBPAYV_EST_DISB_DATE_03 (48)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 3: Estimated Disbursement Date 3.

Columns Comments for REBPAYV_EST_DISB_DATE_04 (49)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 4: Estimated Disbursement Date 4.

Columns Comments for REBPAYV_EST_DISB_DATE_05 (50)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 5: Estimated Disbursement Date 5.

Columns Comments for REBPAYV_EST_DISB_DATE_06 (51)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 6: Estimated Disbursement Date 6.

Columns Comments for REBPAYV_EST_DISB_DATE_07 (52)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 7: Estimated Disbursement Date 7.

Columns Comments for REBPAYV_EST_DISB_DATE_08 (53)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 8: Estimated Disbursement Date 8.

Columns Comments for REBPAYV_EST_DISB_DATE_09 (54)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 9: Estimated Disbursement Date 9.

Columns Comments for REBPAYV_EST_DISB_DATE_10 (55)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 10: Estimated Disbursement Date 10.

Columns Comments for REBPAYV_EST_DISB_DATE_11 (56)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 11: Estimated Disbursement Date 11.

Columns Comments for REBPAYV_EST_DISB_DATE_12 (57)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 12: Estimated Disbursement Date 12.

Columns Comments for REBPAYV_EST_DISB_DATE_13 (58)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 13: Estimated Disbursement Date 13.

Columns Comments for REBPAYV_EST_DISB_DATE_14 (59)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 14: Estimated Disbursement Date 14.

Columns Comments for REBPAYV_EST_DISB_DATE_15 (60)

Source Code Comments

ESTIMATED DISBURSEMENT DATE 15: Estimated Disbursement Date 15.

Columns Comments for REBPAYV_LOW_COST_CDE (61)

Source Code Comments

LOW COST CODE: Flag to identify tuition ranges when the annual tuition is less than a set amount.

Columns Comments for REBPAYV_ORIG_BATCH_NO (62)

Source Code Comments

PELL ORIGINATION BATCH NUMBER: The batch number associated with the Pell Origination Record.

Columns Comments for REBPAYV_ORIG_ID (63)

Source Code Comments

ORIGINATION ID: The Origination ID from the Pell Origination process used to match data from the Origination to Acknowledgement and Disbursement Records.

Columns Comments for REBPAYV_STATUS_CDE (64)

Source Code Comments

ACTION CODE: The response from (action taken by) the Department of Education for this Pell Origination record.

Columns Comments for REBPAYV_ACPT_NBR_MTHS_PAY (65)

Source Code Comments

ACCEPTED NUMBER OF PAYMENTS: Accepted number of payment periods in the student's school year.

Columns Comments for REBPAYV_ACPT_AMT_DUE (66)

Source Code Comments

ACCEPTED PELL AWARD AMOUNT: The Pell award amount due the student, accepted by the Department of Education for the entire school year.

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_01 (67)

Source Code Comments

ACCEPTED ESTIMATED DISBURSEMENT DATE 1: Estimated disbursement date 1 accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_02 (68)

Source Code Comments

ACCEPTED ESTIMATED DISBURSEMENT DATE 2: Estimated disbursement date 2 accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_03 (69)

Source Code Comments

ACCEPTED ESTIMATED DISBURSEMENT DATE 3: Estimated disbursement date 3 accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_04 (70)

Source Code Comments

ACCEPTED ESTIMATED DISBURSEMENT DATE 4: Estimated disbursement date 4 accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_05 (71)

Source Code Comments

ACCEPTED ESTIMATED DISBURSEMENT DATE 5: Estimated disbursement date 5 accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_06 (72)

Source Code Comments

ACCEPTED ESTIMATED DISBURSEMENT DATE 6: Estimated disbursement date 6 accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_07 (73)

Source Code Comments