Model Electronic Data Exchange

Model Label : Banner Financial Aid Electronic Data Exchange Module

List of Objects

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

Model View

Table REBDRCT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBDRCT_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
P_PA_REBDRCT_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
REBDRCT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBDRCT_BATCH_INDEX	SQL Index	S10B80.FAISMGR	Rely On
REBDRCT_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBDRCT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:20:000	04/02/2008 10:35:22:000

Source Code Comments

EDE Directory Table

Columns Comments for REBDRCT_PELL_CAMP_CODE (# 7)

Source Code Comments

SCHOOL CODE: The school code for the school or campus.

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.

Columns Comments for REBDRCT_SCHOOL_BRANCH (# 28)

Source Code Comments

SCHOOL BRANCH: The branch number of the school or campus.

Table REBDSOA

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

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

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBDSOA_AIDY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBDSOA

Object Dates

Creation Date	Analysis Date
04/02/2008 10:31:02:000	04/02/2008 10:35:23:000

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

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 the adjustment batch reported to GAPS.

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.

Columns Comments for REBDSOA_ENTITY_ID (# 15)

Source Code Comments

Entity ID: The entity ID (Routing ID) associated with this statement of account record.

Columns Comments for REBDSOA_PROGRAM_TYPE (# 16)

Source Code Comments

PROGRAM TYPE: Code indicating the grant program type for the detailed statement of account record.

Table REBORIG

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
REBORIG_AIDY_CODE	VARCHAR2(4)	No	*	*
REBORIG_PIDM	NUMBER(8,0)	No	*
REBORIG_FUND_CODE	VARCHAR2(6)	No	*
REBORIG_INT_SEQ_NO	NUMBER(3,0)	No	*
REBORIG_AWARD_ID	VARCHAR2(21)	No
REBORIG_FED_FUND_ID	VARCHAR2(4)	No
REBORIG_GRANT_TYPE	VARCHAR2(2)	No
REBORIG_CAMP_PELL_ID	VARCHAR2(6)	No
REBORIG_INST_PELL_ID	VARCHAR2(6)	No
REBORIG_YR_IN_COLL	VARCHAR2(1)	No
REBORIG_SAR_TRAN_NO	VARCHAR2(2)	No
REBORIG_AWARD_AMOUNT	NUMBER(7,2)	No
REBORIG_ENROLLMENT_DATE	DATE	No
REBORIG_LOCK_IND	VARCHAR2(1)	No
REBORIG_CONCUR_ENROLL_FLAG	VARCHAR2(1)	No
REBORIG_USER_ID	VARCHAR2(30)	No
REBORIG_ACTIVITY_DATE	DATE	No
REBORIG_DATA_ORIGIN	VARCHAR2(30)	Yes
REBORIG_STATUS_CDE	VARCHAR2(1)	Yes
REBORIG_DATE_SENT	DATE	Yes
REBORIG_DOCUMENT_ID	VARCHAR2(30)	Yes
REBORIG_ATTENDING_ID	VARCHAR2(8)	Yes
REBORIG_REPORTING_ID	VARCHAR2(8)	Yes
REBORIG_SOURCE_ID	VARCHAR2(8)	Yes
REBORIG_INST_XREF	VARCHAR2(9)	Yes
REBORIG_PAY_REASON_CDE	VARCHAR2(2)	Yes
REBORIG_HS_PROGRAM_CODE	VARCHAR2(10)	Yes
REBORIG_CIP_CODE	VARCHAR2(6)	Yes
REBORIG_YTD_AMT_PAID	NUMBER(7,2)	Yes
REBORIG_NEG_PENDING_AMT	NUMBER(7,2)	Yes
REBORIG_ACPT_INT_SEQ_NO	NUMBER(3,0)	Yes
REBORIG_ACPT_YR_IN_COLL	VARCHAR2(1)	Yes
REBORIG_ACPT_SAR_TRAN_NO	VARCHAR2(2)	Yes
REBORIG_ACPT_ENROLLMENT_DATE	DATE	Yes
REBORIG_ACPT_AWARD_AMOUNT	NUMBER(7,2)	Yes
REBORIG_ACPT_PAY_REASON_CDE	VARCHAR2(2)	Yes
REBORIG_ACPT_HS_PROGRAM_CODE	VARCHAR2(10)	Yes
REBORIG_ACPT_CIP_CODE	VARCHAR2(6)	Yes
REBORIG_EDIT_REJ_1	VARCHAR2(3)	Yes
REBORIG_EDIT_REJ_2	VARCHAR2(3)	Yes
REBORIG_EDIT_REJ_3	VARCHAR2(3)	Yes
REBORIG_EDIT_REJ_4	VARCHAR2(3)	Yes
REBORIG_EDIT_REJ_5	VARCHAR2(3)	Yes
REBORIG_EDIT_FIELD_1	VARCHAR2(35)	Yes
REBORIG_EDIT_FIELD_2	VARCHAR2(35)	Yes
REBORIG_EDIT_FIELD_3	VARCHAR2(35)	Yes
REBORIG_EDIT_FIELD_4	VARCHAR2(35)	Yes
REBORIG_EDIT_FIELD_5	VARCHAR2(35)	Yes
REBORIG_EDIT_VALUE_1	VARCHAR2(150)	Yes
REBORIG_EDIT_VALUE_2	VARCHAR2(150)	Yes
REBORIG_EDIT_VALUE_3	VARCHAR2(150)	Yes
REBORIG_EDIT_VALUE_4	VARCHAR2(150)	Yes
REBORIG_EDIT_VALUE_5	VARCHAR2(150)	Yes
REBORIG_PERCENT_ELIG_USED	NUMBER(7,4)	Yes

Foreign Key information

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

Index

Index Name	Index Type	Column Name
PK_REBORIG	Unique	REBORIG_AIDY_CODE
PK_REBORIG	Unique	REBORIG_PIDM
PK_REBORIG	Unique	REBORIG_FUND_CODE
PK_REBORIG	Unique	REBORIG_INT_SEQ_NO
REBORIG_AWARD_ID_INDEX		REBORIG_AWARD_ID
REBORIG_DOCUMENT_ID_INDEX		REBORIG_DOCUMENT_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GRANT_DEFAULT_REC	Oracle Package Type	S10B80.BANINST1.REKORIG	Rely On
GRANT_ORIGINATION_REC	Oracle Package Type	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
P_CALC_GRANT_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_CALC_GRANT_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_CALC_GRANT_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
P_VALIDATE_GRANT_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_VALIDATE_GRANT_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_VALIDATE_GRANT_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
REBORIG_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI07	Rely On
REBORIG_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI08	Rely On
REBORIG_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI09	Rely On
F_ACCEPTED_ACG_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_ACCEPTED_SMART_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_AMOUNT_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Rely On
F_BUILD_REBORIG_REC	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_COUNT_RFRDEFD	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_COUNT_RFRDSCH	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_COUNT_RPRADSB	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_NEW_REC_MATCH	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_NEW_REC_MATCH	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_ORIGINATION_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_ORIGINATION_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_ORIGINATION_SENT	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_ORIGINATION_SENT	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_ORIGINATION_UNSENT	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_ORIGINATION_UNSENT	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_PELL_ORIG_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_PELL_ORIG_OVERRIDE	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_SAR_PGI_VALID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI07	Use (select)
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI08	Use (select)
F_SELECT_DISB_FUND	Oracle Package Function	S10B80.BANINST1.REKCI09	Use (select)
P_CALC_ACG_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_CALC_ACG_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_CALC_ACG_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_CALC_SMART_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_CALC_SMART_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_CALC_SMART_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_REBORIG	Use (delete)
P_GET_GRANT_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_HIGH_SCHOOL_DATA	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_REBORIG_ACCEPT	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_REBORIG_ACCEPT	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Use (select)
P_GET_REBORIG_CURRENT	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_REBORIG_CURRENT	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_REBORIG	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_REBORIG	Use (update)Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_ACG_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_ACG_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_ACG_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_SMART_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_SMART_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_SMART_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Rely On
P_VALIDATE_ACG_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_VALIDATE_ACG_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_VALIDATE_ACG_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_VALIDATE_SMART_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_VALIDATE_SMART_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_VALIDATE_SMART_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_GET_AWARD_SEQ_NO	Oracle Package Function	S10B80.BANINST1.REKORIG	Rely On
F_GET_AWARD_SEQ_NO	Oracle Package Function	S10B80.BANINST1.REKORIG	Use (select)
F_PARENT_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_ACG_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
REBORIG	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_REBORIG	SQL Index	S10B80.FAISMGR	Rely On
REBORIG_AWARD_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
REBORIG_DOCUMENT_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBORIG

Object Dates

Creation Date	Analysis Date
04/02/2008 10:31:57:000	04/02/2008 10:35:24:000

Source Code Comments

Federal Grant Origination Table

Columns Comments for REBORIG_AIDY_CODE (# 1)

Source Code Comments

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

Columns Comments for REBORIG_PIDM (# 2)

Source Code Comments

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

Columns Comments for REBORIG_FUND_CODE (# 3)

Source Code Comments

FUND CODE: The fund code associated with the origination.

Columns Comments for REBORIG_INT_SEQ_NO (# 4)

Source Code Comments

INSTITUTION INTERNAL SEQUENCE NUMBER: An internally generated sequence number which will allow the school to track the version of the origination record COD has on file.

Columns Comments for REBORIG_AWARD_ID (# 5)

Source Code Comments

AWARD ID: The award ID from the grant origination process used to match data from the origination to response and disbursement Records.

Columns Comments for REBORIG_FED_FUND_ID (# 6)

Source Code Comments

FEDERAL FUND ID: The federal fund id of the grant for this origination record.

Columns Comments for REBORIG_GRANT_TYPE (# 7)

Source Code Comments

GRANT TYPE: The grant type and level for this origination record.

Columns Comments for REBORIG_CAMP_PELL_ID (# 8)

Source Code Comments

CAMPUS PELL ID: Pell ID of the campus the student is attending. Can be different from the institution Pell ID for a branch campus or multi-campus institution.

Columns Comments for REBORIG_INST_PELL_ID (# 9)

Source Code Comments

INSTITUTION PELL ID: Pell ID for the institution.

Columns Comments for REBORIG_YR_IN_COLL (# 10)

Source Code Comments

YEAR IN COLLEGE: The student's year in college for this grant origination record. This value cannot be changed or corrected once the origination has been sent to COD.

Columns Comments for REBORIG_SAR_TRAN_NO (# 11)

Source Code Comments

SAR TRANSACTION NUMBER: The eligible SAR transaction number reported for the origination record.

Columns Comments for REBORIG_AWARD_AMOUNT (# 12)

Source Code Comments

AWARD AMOUNT: Student's award amount for the entire school year. This amount cannot exceed the total grant limit for the grade level and aid year.

Columns Comments for REBORIG_ENROLLMENT_DATE (# 13)

Source Code Comments

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

Columns Comments for REBORIG_LOCK_IND (# 14)

Source Code Comments

GRANT ORIGINATION RECORD LOCK INDICATOR: Indicates that the origination record should not be processed through the delete/replace logic when creating updated origination records.

Columns Comments for REBORIG_CONCUR_ENROLL_FLAG (# 15)

Source Code Comments

CONCURRENT ENROLLMENT FLAG: Indicates that this student has concurrent enrollment and may require correction.

Columns Comments for REBORIG_USER_ID (# 16)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record.

Columns Comments for REBORIG_ACTIVITY_DATE (# 17)

Source Code Comments

ACTIVITY DATE: Date of last activity.

Columns Comments for REBORIG_DATA_ORIGIN (# 18)

Source Code Comments

DATA ORIGIN: Source system that created or updated the data.

Columns Comments for REBORIG_STATUS_CDE (# 19)

Source Code Comments

STATUS CODE: The status of the grant origination record.

Columns Comments for REBORIG_DATE_SENT (# 20)

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 REBORIG_DOCUMENT_ID (# 21)

Source Code Comments

COD DOCUMENT ID FOR GRANT ORIGINATION RECORD: The document identification number associated with this grant origination record.

Columns Comments for REBORIG_ATTENDING_ID (# 22)

Source Code Comments

ATTENDING SCHOOL ENTITY ID: The Routing ID of the school or campus where the student is attending class as sent to COD for this grant origination record.

Columns Comments for REBORIG_REPORTING_ID (# 23)

Source Code Comments

REPORTING SCHOOL ENTITY ID: The Routing ID of the school that reported the grant origination data to COD.

Columns Comments for REBORIG_SOURCE_ID (# 24)

Source Code Comments

SOURCE ENTITY ID: The Routing ID of the school/organization that physically sent or transmitted the origination record to COD.

Columns Comments for REBORIG_INST_XREF (# 25)

Source Code Comments

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

Columns Comments for REBORIG_PAY_REASON_CDE (# 26)

Source Code Comments

PAYMENT REASON CODE: The rigorous high school payment reason code.

Columns Comments for REBORIG_HS_PROGRAM_CODE (# 27)

Source Code Comments

RIGOROUS HIGH SCHOOL PROGRAM CODE: The student's eligible rigorous high school program code.

Columns Comments for REBORIG_CIP_CODE (# 28)

Source Code Comments

CIP CODE: The student's eligible CIP code.

Columns Comments for REBORIG_YTD_AMT_PAID (# 29)

Source Code Comments

YEAR-TO-DATE AMOUNT PAID: Year to date amount paid for this origination as reported in the grant disbursement response record.

Columns Comments for REBORIG_NEG_PENDING_AMT (# 30)

Source Code Comments

NEGATIVE PENDING AMOUNT: The negative disbursement amount pending as determined by COD.

Columns Comments for REBORIG_ACPT_INT_SEQ_NO (# 31)

Source Code Comments

ACCEPTED INSTITUTION INTERNAL SEQUENCE NUMBER: An internally generated sequence number which will allow the school to track the version of the origination record.

Columns Comments for REBORIG_ACPT_YR_IN_COLL (# 32)

Source Code Comments

ACCEPTED YEAR IN COLLEGE: The year in college as acknowledged by COD.

Columns Comments for REBORIG_ACPT_SAR_TRAN_NO (# 33)

Source Code Comments

ACCEPTED SAR TRANSACTION NUMBER: The SAR transaction number as acknowledged by COD.

Columns Comments for REBORIG_ACPT_ENROLLMENT_DATE (# 34)

Source Code Comments

ACCEPTED ENROLLMENT DATE: The enrollment date as acknowledged by COD.

Columns Comments for REBORIG_ACPT_AWARD_AMOUNT (# 35)

Source Code Comments

ACCEPTED AWARD AMOUNT: The student's award amount for the grant for the specified aid year and grade level, as acknowledged by COD.

Columns Comments for REBORIG_ACPT_PAY_REASON_CDE (# 36)

Source Code Comments

ACCEPTED PAYMENT REASON CODE: The rigorous high school payment reason code as acknowledged by COD.

Columns Comments for REBORIG_ACPT_HS_PROGRAM_CODE (# 37)

Source Code Comments

ACCEPTED RIGOROUS HIGH SCHOOL PROGRAM CODE: The student's eligible rigorous high school program code as acknowledged by COD.

Columns Comments for REBORIG_ACPT_CIP_CODE (# 38)

Source Code Comments

ACCEPTED CIP CODE: The student's eligible CIP code as acknowledged by COD.

Columns Comments for REBORIG_EDIT_REJ_1 (# 39)

Source Code Comments

EDIT/REJECT CODE 1: Origination edit/reject code 1.

Columns Comments for REBORIG_EDIT_REJ_2 (# 40)

Source Code Comments

EDIT/REJECT CODE 2: Origination edit/reject code 2.

Columns Comments for REBORIG_EDIT_REJ_3 (# 41)

Source Code Comments

EDIT/REJECT CODE 3: Origination edit/reject code 3.

Columns Comments for REBORIG_EDIT_REJ_4 (# 42)

Source Code Comments

EDIT/REJECT CODE 4: Origination edit/reject code 4.

Columns Comments for REBORIG_EDIT_REJ_5 (# 43)

Source Code Comments

EDIT/REJECT CODE 5: Origination edit/reject code 5.

Columns Comments for REBORIG_EDIT_FIELD_1 (# 44)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT FIELD 1: The field (XML tag) associated with edit 1.

Columns Comments for REBORIG_EDIT_FIELD_2 (# 45)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT FIELD 2: The field (XML tag) associated with edit 2.

Columns Comments for REBORIG_EDIT_FIELD_3 (# 46)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT FIELD 3: The field (XML tag) associated with edit 3.

Columns Comments for REBORIG_EDIT_FIELD_4 (# 47)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT FIELD 4: The field (XML tag) associated with edit 4.

Columns Comments for REBORIG_EDIT_FIELD_5 (# 48)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT FIELD 5: The field (XML tag) associated with edit 5.

Columns Comments for REBORIG_EDIT_VALUE_1 (# 49)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT VALUE 1: The new value applied to response edit field 1 if a correction is applied.

Columns Comments for REBORIG_EDIT_VALUE_2 (# 50)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT VALUE 2: The new value applied to response edit field 2 if a correction is applied.

Columns Comments for REBORIG_EDIT_VALUE_3 (# 51)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT VALUE 3: The new value applied to response edit field 3 if a correction is applied.

Columns Comments for REBORIG_EDIT_VALUE_4 (# 52)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT VALUE 4: The new value applied to response edit field 4 if a correction is applied.

Columns Comments for REBORIG_EDIT_VALUE_5 (# 53)

Source Code Comments

GRANT ORIGINATION RESPONSE EDIT VALUE 5: The new value applied to response edit field 5 if a correction is applied.

Columns Comments for REBORIG_PERCENT_ELIG_USED (# 54)

Source Code Comments

ELIGIBILITY USED BY SCHEDULED AWARD: The percentage of the student's eligibility used by the institution for the scheduled award for the aid year.

Table REBPAYV

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

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

Foreign Key information

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

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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PELL_CURRENT_REC	Oracle Package Type	S10B80.BANINST1.REKORIG	Rely On
PELL_DEFAULT_REC	Oracle Package Type	S10B80.BANINST1.REKORIG	Rely On
PELL_ORIGINATIONS_REC	Oracle Package Type	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
P_UPDATEPELLDISB	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATEPELLDISB	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (update,select)Rely On
P_UPDATEPELLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATEPELLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (update,select)Rely On
P_VALIDATE_GRANT_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_VALIDATE_GRANT_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_VALIDATE_GRANT_ORIGINATION	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
REBPAYV_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
REBPAYV_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI05	Rely On
REBPAYV_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI06	Rely On
REBPAYV_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI07	Rely On
REBPAYV_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI08	Rely On
REBPAYV_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI09	Rely On
F_ACCEPTED_PELL_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_AMOUNT_VALID	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS_RULES	Rely On
F_BUILD_REBPAYV_REC	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_CAMP_PELL_ID_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION_RULES	Rely On
F_CAMP_PELL_ID_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS_RULES	Rely On
F_COUNT_RFRDEFD	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_COUNT_RFRDSCH	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_COUNT_RPRADSB	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_LOW_TUITION_COST_VALID	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS_RULES	Rely On
F_NEW_REC_MATCH	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_NEW_REC_MATCH	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_ORIGINATION_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_ORIGINATION_LOCKED	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_ORIGINATION_SENT	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_ORIGINATION_SENT	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_PELL_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_PELL_ORIG_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_GRANT_ORIGINATION	Use (select)
F_SAR_PGI_NULL	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_SAR_PGI_VALID	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_STUDENT_SAR_ID_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS_RULES	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_REBPAYV	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
P_GET_GRANT_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_PELL_DEFAULTS	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_REBPAYV_CURRENT	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Rely On
P_GET_REBPAYV_CURRENT	Oracle Package Procedure	S10B80.BANINST1.REKORIG	Use (select)
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_REBPAYV	Use (Insert)Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.RB_PELL_ORIGINATIONS_RULES	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_REBPAYV	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
P_UPDATE_PELL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_UPDATE_PELL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (update)
P_UPDATE_PELL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_UPDATE_PELL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_PELL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_PELL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_PELL_AWARD	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (update,select)Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_PELL_ORIGINATIONS_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_PELL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
REBPAYV	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBPAYV_DOCUMENT_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
REBPAYV_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On
REBPAYV_ORIG_BATCH_INDEX	SQL Index	S10B80.FAISMGR	Rely On
REBPAYV_ORIG_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
REBPAYV_SAR_INDEX	SQL Index	S10B80.FAISMGR	Rely On
ROBINST	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_REBPAYV_USER_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBPAYV

Object Dates

Creation Date	Analysis Date
04/02/2008 10:25:31:000	04/02/2008 10:35:18:000

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

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

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_08 (# 74)

Source Code Comments

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

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_09 (# 75)

Source Code Comments

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

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_10 (# 76)

Source Code Comments

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

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_11 (# 77)

Source Code Comments

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

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_12 (# 78)

Source Code Comments

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

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_13 (# 79)

Source Code Comments

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

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_14 (# 80)

Source Code Comments

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

Columns Comments for REBPAYV_ACPT_EST_DISB_DATE_15 (# 81)

Source Code Comments

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

Columns Comments for REBPAYV_ACPT_ENROLLMENT_DATE (# 82)

Source Code Comments

ACCEPTED ENROLLMENT DATE: The date accepted by the Department of Education as the date that the student is first enrolled in an eligible program for the aid year.

Columns Comments for REBPAYV_ACPT_LOW_COST_CDE (# 83)

Source Code Comments

ACCEPTED LOW COST CODE: Accepted value of flag to identify tuition ranges when the annual tuition is less than a set amount.

Columns Comments for REBPAYV_ACPT_VER_STATUS (# 84)

Source Code Comments

ACCEPTED VERIFICATION STATUS: The value accepted by the Department of Education for the status of verification of applicant data by the school.

Columns Comments for REBPAYV_ACPT_PRISON_IND (# 85)

Source Code Comments

ACCEPTED PRISON INDICATOR: The value accepted by the Department of Education for the Incarcerated Federal Pell Recipient Code.

Columns Comments for REBPAYV_ACPT_SAR_TRAN_NO (# 86)

Source Code Comments

ACCEPTED SAR TRANSACTION NUMBER: The value accepted by the Department of Education of the SAR transaction number.

Columns Comments for REBPAYV_ACPT_PGI (# 87)

Source Code Comments

ACCEPTED PELL EFC: The value of Pell Expected Family Contribution accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_SEC_PGI_USED (# 88)

Source Code Comments

ACCEPTED SECONDARY EFC USED CODE: The value of Secondary Expected Family Contribution Code accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_ACAD_CAL (# 89)

Source Code Comments

ACCEPTED ACADEMIC CALENDAR: Academic calendar accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_PAYMENT_METHOD (# 90)

Source Code Comments

ACCEPTED PAYMENT METHODOLOGY: Payment methodology used to calculate the student's Federal Pell Grant, as accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_ATTEND_COST (# 91)

Source Code Comments

ACCEPTED ATTENDANCE COST: Cost of Attendance accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_ENROLL_STATUS (# 92)

Source Code Comments

ACCEPTED ENROLLMENT STATUS: Enrollment status of the student accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_EXPECT_WKS (# 93)

Source Code Comments

ACCEPTED EXPECTED WEEKS: The weeks of instructional time in which the student is expected to be enrolled, accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_WKS_IN_YR (# 94)

Source Code Comments

ACCEPTED WEEKS IN YEAR: The number of weeks of instructional time in the program's academic year, accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_EXPECT_HRS (# 95)

Source Code Comments

ACCEPTED EXPECTED HOURS: The number of credit hours or clock hours in all pay periods expected to complete this school year, accepted by the Department of Education.

Columns Comments for REBPAYV_ACPT_HRS_IN_YR (# 96)

Source Code Comments

ACCEPTED HOURS IN YEAR: The number of credit hours or clock hours of instructional time in the program's academic year, accepted by the Department of Education.

Columns Comments for REBPAYV_SCH_PELL_GRANT (# 97)

Source Code Comments

ACCEPTED SCHEDULED PELL GRANT AMOUNT: The scheduled amount of Pell Grant for a full time student.

Columns Comments for REBPAYV_PREV_ACPT_SAR_TRAN_NO (# 98)

Source Code Comments

PREVIOUSLY ACCEPTED SAR TRAN NUMBER: The Transaction Number that was previously accepted and currently stored by COD for this student. This field will only be populated for rejected originations. It will be blank if Origination was not rejected.

Columns Comments for REBPAYV_PREV_ACPT_EFC (# 99)

Source Code Comments

PREVIOUSLY ACCEPTED EFC: The EFC that was previously accepted and currently stored by COD for this student. This field will only be populated for rejected originations. It will be blank if Origination was not rejected.

Columns Comments for REBPAYV_PREV_ACPT_SEC_EFC_CDE (# 100)

Source Code Comments

PREVIOUSLY ACCEPTED SECONDARY EFC CODE: Secondary EFC Code that was previously accepted and currently stored by COD for this student. It will be blank if Secondary EFC was not used or if Origination is not rejected.

Columns Comments for REBPAYV_PREV_ACPT_ATTEND_COST (# 101)

Source Code Comments

PREVIOUSLY ACCEPTED ATTENDANCE COST: Cost of Attendance previously accepted and currently stored by COD for this student. It will be blank if Origination was not rejected.

Columns Comments for REBPAYV_EDIT_REJ_01 (# 102)

Source Code Comments

EDIT/REJECT CODE 1: Origination Edit/Reject code 1.

Columns Comments for REBPAYV_EDIT_REJ_02 (# 103)

Source Code Comments

EDIT/REJECT CODE 2: Origination Edit/Reject code 2.

Columns Comments for REBPAYV_EDIT_REJ_03 (# 104)

Source Code Comments

EDIT/REJECT CODE 3: Origination Edit/Reject code 3.

Columns Comments for REBPAYV_EDIT_REJ_04 (# 105)

Source Code Comments

EDIT/REJECT CODE 4: Origination Edit/Reject code 4.

Columns Comments for REBPAYV_EDIT_REJ_05 (# 106)

Source Code Comments

EDIT/REJECT CODE 5: Origination Edit/Reject code 5.

Columns Comments for REBPAYV_EDIT_REJ_06 (# 107)

Source Code Comments

EDIT/REJECT CODE 6: Origination Edit/Reject code 6.

Columns Comments for REBPAYV_EDIT_REJ_07 (# 108)

Source Code Comments

EDIT/REJECT CODE 7: Origination Edit/Reject code 7.

Columns Comments for REBPAYV_EDIT_REJ_08 (# 109)

Source Code Comments

EDIT/REJECT CODE 8: Origination Edit/Reject code 8.

Columns Comments for REBPAYV_EDIT_REJ_09 (# 110)

Source Code Comments

EDIT/REJECT CODE 9: Origination Edit/Reject code 9.

Columns Comments for REBPAYV_EDIT_REJ_10 (# 111)

Source Code Comments

EDIT/REJECT CODE 10: Origination Edit/Reject code 10.

Columns Comments for REBPAYV_EDIT_REJ_11 (# 112)

Source Code Comments

EDIT/REJECT CODE 11: Origination Edit/Reject code 11.

Columns Comments for REBPAYV_EDIT_REJ_12 (# 113)

Source Code Comments

EDIT/REJECT CODE 12: Origination Edit/Reject code 12.

Columns Comments for REBPAYV_EDIT_REJ_13 (# 114)

Source Code Comments

EDIT/REJECT CODE 13: Origination Edit/Reject code 13.

Columns Comments for REBPAYV_EDIT_REJ_14 (# 115)

Source Code Comments

EDIT/REJECT CODE 14: Origination Edit/Reject code 14.

Columns Comments for REBPAYV_EDIT_REJ_15 (# 116)

Source Code Comments

EDIT/REJECT CODE 15: Origination Edit/Reject code 15.

Columns Comments for REBPAYV_EDIT_REJ_16 (# 117)

Source Code Comments

EDIT/REJECT CODE 16: Origination Edit/Reject code 16.

Columns Comments for REBPAYV_EDIT_REJ_17 (# 118)

Source Code Comments

EDIT/REJECT CODE 17: Origination Edit/Reject code 17.

Columns Comments for REBPAYV_EDIT_REJ_18 (# 119)

Source Code Comments

EDIT/REJECT CODE 18: Origination Edit/Reject code 18.

Columns Comments for REBPAYV_EDIT_REJ_19 (# 120)

Source Code Comments

EDIT/REJECT CODE 19: Origination Edit/Reject code 19.

Columns Comments for REBPAYV_EDIT_REJ_20 (# 121)

Source Code Comments

EDIT/REJECT CODE 20: Origination Edit/Reject code 20.

Columns Comments for REBPAYV_EDIT_REJ_21 (# 122)

Source Code Comments

EDIT/REJECT CODE 21: Origination Edit/Reject code 21.

Columns Comments for REBPAYV_EDIT_REJ_22 (# 123)

Source Code Comments

EDIT/REJECT CODE 22: Origination Edit/Reject code 22.

Columns Comments for REBPAYV_EDIT_REJ_23 (# 124)

Source Code Comments

EDIT/REJECT CODE 23: Origination Edit/Reject code 23.

Columns Comments for REBPAYV_EDIT_REJ_24 (# 125)

Source Code Comments

EDIT/REJECT CODE 24: Origination Edit/Reject code 24.

Columns Comments for REBPAYV_EDIT_REJ_25 (# 126)

Source Code Comments

EDIT/REJECT CODE 25: Origination Edit/Reject code 25.

Columns Comments for REBPAYV_SHARED_SAR_ID_FLAG (# 127)

Source Code Comments

SHARED SAR ID FLAG: Indicates that this student shares a SAR ID with another student, and requires correction.

Columns Comments for REBPAYV_VERIF_W_STATUS_FLAG (# 128)

Source Code Comments

VERIFICATION W STATUS FLAG: Indicates that this student has a verification W (Without Documentation) status, and requires correction.

Columns Comments for REBPAYV_CONCUR_ENROLL_FLAG (# 129)

Source Code Comments

CONCURRENT ENROLLMENT FLAG: Indicates that this student has concurrent enrollment, and may require correction.

Columns Comments for REBPAYV_POTENTIAL_OVERPMT_FLAG (# 130)

Source Code Comments

POTENTIAL OVERPAYMENT FLAG: Indicates that this student has a potential overpayment, and may require correction.

Columns Comments for REBPAYV_LOCK_IND (# 131)

Source Code Comments

PELL ORIGINATION RECORD LOCK INDICATOR: Indicates that the Origination record should not be processed through the delete/replace logic when creating updated Origination records.

Columns Comments for REBPAYV_LOW_TUITION_COST (# 132)

Source Code Comments

LOW TUITION AND FEES COST FOR PELL: The total amount of Tuition, Disability Expenses, and Dependent care costs that are calculated at the time the Pell process was last run.

Columns Comments for REBPAYV_INT_SEQ_NO (# 133)

Source Code Comments

INSTITUTION INTERNAL SEQUENCE NUMBER: An internally generated sequence number which will allow the school to track the version of the origination record COD has on file.

Columns Comments for REBPAYV_ACPT_INT_SEQ_NO (# 134)

Source Code Comments

ACCEPTED INSTITUTION INTERNAL SEQUENCE NUMBER: An internally generated sequence number which will allow the school to track the version of the origination record COD has on file, as acknowledged by COD.

Columns Comments for REBPAYV_CURRENT_SSN (# 135)

Source Code Comments

STUDENT'S CURRENT SSN: The student's current social security number for this CPS transaction.

Columns Comments for REBPAYV_CURRENT_BIRTH_DATE (# 136)

Source Code Comments

STUDENT'S CURRENT DATE OF BIRTH: The student's date of birth for this CPS transaction.

Columns Comments for REBPAYV_CURRENT_LAST_NAME (# 137)

Source Code Comments

STUDENT'S CURRENT LAST NAME: The student's last name for this CPS transaction.

Columns Comments for REBPAYV_CURRENT_FIRST_NAME (# 138)

Source Code Comments

STUDENT'S CURRENT FIRST NAME: The student's first name for this CPS transaction.

Columns Comments for REBPAYV_CURRENT_MI (# 139)

Source Code Comments

STUDENT'S CURRENT MIDDLE INITIAL: The student's middle initial for this CPS transaction.

Columns Comments for REBPAYV_NEG_PENDING_AMT (# 140)

Source Code Comments

NEGATIVE PENDING AMOUNT: The negative disbursement amount pending as determined by Pell.

Columns Comments for REBPAYV_SEC_EFC (# 141)

Source Code Comments

SECONDARY EFC: The secondary EFC calculated by CPS for this transaction, if any, as reported by Pell.

Columns Comments for REBPAYV_ACPT_CURRENT_SSN (# 142)

Source Code Comments

ACCEPTED CURRENT SSN: The student's current social security number for this CPS transaction, as reported by Pell.

Columns Comments for REBPAYV_ACPT_BIRTH_DATE (# 143)

Source Code Comments

ACCEPTED DATE OF BIRTH: The student's date of birth for this CPS transaction, as reported by Pell.

Columns Comments for REBPAYV_ACPT_LAST_NAME (# 144)

Source Code Comments

ACCEPTED LAST NAME: The student's last name for this CPS transaction, as reported by Pell.

Columns Comments for REBPAYV_ACPT_FIRST_NAME (# 145)

Source Code Comments

ACCEPTED FIRST NAME: The student's first name for this CPS transaction, as reported by Pell.

Columns Comments for REBPAYV_ACPT_MI (# 146)

Source Code Comments

ACCEPTED MIDDLE INITIAL: The student's middle initial for this CPS transaction, as reported by Pell.

Columns Comments for REBPAYV_DOCUMENT_ID (# 147)

Source Code Comments

COD DOCUMENT ID FOR PELL AWARD RECORD: The document identification number associated with the student's Pell award record.

Columns Comments for REBPAYV_USER_ID (# 148)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record in this table.

Columns Comments for REBPAYV_DATA_ORIGIN (# 149)

Source Code Comments

DATA ORIGIN: Source system that created or updated the data.

Columns Comments for REBPAYV_EDIT_FIELD_1 (# 150)

Source Code Comments

Pell Origination Response Edit Field 1: The field (XML tag) associated with edit 1.

Columns Comments for REBPAYV_EDIT_VALUE_1 (# 151)

Source Code Comments

Pell Origination Response Edit Value 1: The new value applied to the Response Edit Field 1 if a correction is applied.

Columns Comments for REBPAYV_EDIT_FIELD_2 (# 152)

Source Code Comments

Pell Origination Response Edit Field 2: The field (XML tag) associated with edit 2.

Columns Comments for REBPAYV_EDIT_VALUE_2 (# 153)

Source Code Comments

Pell Origination Response Edit Value 2: The new value applied to the Response Edit Field 2 if a correction is applied.

Columns Comments for REBPAYV_EDIT_FIELD_3 (# 154)

Source Code Comments

Pell Origination Response Edit Field 3: The field (XML tag) associated with edit 3.

Columns Comments for REBPAYV_EDIT_VALUE_3 (# 155)

Source Code Comments

Pell Origination Response Edit Value 3: The new value applied to the Response Edit Field 3 if a correction is applied.

Columns Comments for REBPAYV_EDIT_FIELD_4 (# 156)

Source Code Comments

Pell Origination Response Edit Field 4: The field (XML tag) associated with edit 4.

Columns Comments for REBPAYV_EDIT_VALUE_4 (# 157)

Source Code Comments

Pell Origination Response Edit Value 4: The new value applied to the Response Edit Field 4 if a correction is applied.

Columns Comments for REBPAYV_EDIT_FIELD_5 (# 158)

Source Code Comments

Pell Origination Response Edit Field 5: The field (XML tag) associated with edit 5.

Columns Comments for REBPAYV_EDIT_VALUE_5 (# 159)

Source Code Comments

Pell Origination Response Edit Value 5: The new value applied to the Response Edit Field 5 if a correction is applied.

Columns Comments for REBPAYV_PERCENT_ELIG_USED (# 160)

Source Code Comments

ELIGIBILITY USED BY SCHEDULED AWARD: The percentage of the student's eligibility used by the institution for the scheduled award for the aid year.

Table REBRDRQ

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
REBRDRQ_AIDY_CODE	VARCHAR2(4)	No
REBRDRQ_ACTIVITY_DATE	DATE	No
REBRDRQ_CAMP_PELL_ID	VARCHAR2(6)	No
REBRDRQ_REQUEST_TYPE	VARCHAR2(1)	No
REBRDRQ_BATCH_NO	VARCHAR2(26)	Yes
REBRDRQ_REPL_BATCH_NO	VARCHAR2(26)	Yes
REBRDRQ_MRR_CODE_1	VARCHAR2(1)	Yes
REBRDRQ_MRR_CODE_2	VARCHAR2(1)	Yes
REBRDRQ_MRR_SAR_SSN	VARCHAR2(9)	Yes
REBRDRQ_MRR_SAR_INIT	VARCHAR2(2)	Yes
REBRDRQ_MRR_INST_PELL_ID	VARCHAR2(6)	Yes
REBRDRQ_ACK_CAMP_PELL_ID	VARCHAR2(6)	Yes
REBRDRQ_ACK_REQUEST_TYPE	VARCHAR2(1)	Yes
REBRDRQ_ACK_REPL_BATCH_NO	VARCHAR2(26)	Yes
REBRDRQ_ACK_MRR_CODE_1	VARCHAR2(1)	Yes
REBRDRQ_ACK_MRR_CODE_2	VARCHAR2(1)	Yes
REBRDRQ_ACK_MRR_SAR_SSN	VARCHAR2(9)	Yes
REBRDRQ_ACK_MRR_SAR_INIT	VARCHAR2(2)	Yes
REBRDRQ_ACK_MRR_INST_PELL_ID	VARCHAR2(6)	Yes
REBRDRQ_ACTION_CODE	VARCHAR2(1)	Yes
REBRDRQ_DATE_SENT	DATE	Yes
REBRDRQ_EDIT_REJ_01	VARCHAR2(3)	Yes
REBRDRQ_EDIT_REJ_02	VARCHAR2(3)	Yes
REBRDRQ_EDIT_REJ_03	VARCHAR2(3)	Yes
REBRDRQ_EDIT_REJ_04	VARCHAR2(3)	Yes
REBRDRQ_EDIT_REJ_05	VARCHAR2(3)	Yes
REBRDRQ_EDIT_REJ_06	VARCHAR2(3)	Yes
REBRDRQ_EDIT_REJ_07	VARCHAR2(3)	Yes
REBRDRQ_EDIT_REJ_08	VARCHAR2(3)	Yes
REBRDRQ_ORIG_ID	VARCHAR2(23)	Yes
REBRDRQ_ACK_ORIG_ID	VARCHAR2(23)	Yes
REBRDRQ_CURRENT_SSN	VARCHAR2(9)	Yes
REBRDRQ_CURRENT_BIRTH_DATE	DATE	Yes
REBRDRQ_CURRENT_LAST_NAME	VARCHAR2(16)	Yes
REBRDRQ_CURRENT_FIRST_NAME	VARCHAR2(12)	Yes
REBRDRQ_CURRENT_MI	VARCHAR2(1)	Yes
REBRDRQ_ACK_CURRENT_SSN	VARCHAR2(9)	Yes
REBRDRQ_ACK_BIRTH_DATE	DATE	Yes
REBRDRQ_ACK_LAST_NAME	VARCHAR2(16)	Yes
REBRDRQ_ACK_FIRST_NAME	VARCHAR2(12)	Yes
REBRDRQ_ACK_MI	VARCHAR2(1)	Yes
REBRDRQ_PROGRAM_TYPE	VARCHAR2(2)	No
REBRDRQ_ACK_PROGRAM_TYPE	VARCHAR2(2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
REBRDRQ_AIDY_INDEX		REBRDRQ_AIDY_CODE
REBRDRQ_AIDY_INDEX		REBRDRQ_DATE_SENT

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBRDRQ_AIDY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBRDRQ

Object Dates

Creation Date	Analysis Date
04/02/2008 10:26:11:000	04/02/2008 10:35:19:000

Source Code Comments

Grant Data Request Table.

Columns Comments for REBRDRQ_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE FOR DATA REQUEST RECORDS: The aid year code for the request of data.

Columns Comments for REBRDRQ_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE FOR DATA REQUEST RECORDS: Activity date for the request of data.

Columns Comments for REBRDRQ_CAMP_PELL_ID (# 3)

Source Code Comments

REQUESTING ATTENDING CAMPUS PELL ID: Pell Campus ID.

Columns Comments for REBRDRQ_REQUEST_TYPE (# 4)

Source Code Comments

REQUEST TYPE: Code for data request type. Valid values are M - Multiple Reporting, R - Reconciliation, S - Statement of Account, and Y - Year to Date.

Columns Comments for REBRDRQ_BATCH_NO (# 5)

Source Code Comments

BATCH NUMBER: The Batch Number associated with the Data Request Record.

Columns Comments for REBRDRQ_REPL_BATCH_NO (# 6)

Source Code Comments

REPLACEMENT PELL BATCH NUMBER: Batch number requested to be replaced. Only used when Request Type is B.

Columns Comments for REBRDRQ_MRR_CODE_1 (# 7)

Source Code Comments

MULTIPLE REPORTING REQUEST CODE 1: Indicates the institution is requesting originated institutions or disbursed institutions. Valid values are (O) send originated institutions, (D) send disbursed institutions, blank. Only used when Request Type is M.

Columns Comments for REBRDRQ_MRR_CODE_2 (# 8)

Source Code Comments

MULTIPLE REPORTING REQUEST CODE 2: Indicates the inst. is requesting by selected student, selected institution, or all students. Valid values are (A)ll students, (S)elected students, (I)nstitutions listed, blank. Only used when Request Type is M.

Columns Comments for REBRDRQ_MRR_SAR_SSN (# 9)

Source Code Comments

MRR STUDENT ID: The Student SSN for which a MR is requested. Only required if MRR Code 2 is S.

Columns Comments for REBRDRQ_MRR_SAR_INIT (# 10)

Source Code Comments

MRR STUDENT NAME CODE: The name code for which a MR is requested. Only required if MRR Code 2 is S.

Columns Comments for REBRDRQ_MRR_INST_PELL_ID (# 11)

Source Code Comments

MRR INSTITUTION PELL ID: The institution code for which MR listings are requested. Only required if MRR Code 2 is I.

Columns Comments for REBRDRQ_ACK_CAMP_PELL_ID (# 12)

Source Code Comments

ACKNOWLEDGED REQUESTING ATTENDING CAMPUS PELL ID: Pell Campus ID.

Columns Comments for REBRDRQ_ACK_REQUEST_TYPE (# 13)

Source Code Comments

ACKNOWLEDGED REQUEST TYPE: Code for data request type. Valid values are (B) batch replacement, (M) multiple reporting, (S) Statement of Account, (Y) Year to Date

Columns Comments for REBRDRQ_ACK_REPL_BATCH_NO (# 14)

Source Code Comments

ACKNOWLEDGED REPLACEMENT PELL BATCH NUMBER: Batch number requested to be replaced. Only used when Request Type is B.

Columns Comments for REBRDRQ_ACK_MRR_CODE_1 (# 15)

Source Code Comments

ACKNOWLEDGED MULTIPLE REPORTING REQUEST CODE 1: Indicates the inst. is requesting originated institutions or disbursed institutions. Valid values are (O)riginated institutions, (D)isbursed institutions, blank. Only used when Request Type is M.

Columns Comments for REBRDRQ_ACK_MRR_CODE_2 (# 16)

Source Code Comments

ACKNOWLEDGED MULTIPLE REPORTING REQUEST CODE 2: Indicates what the inst. is requesting by. Valid values are (A)ll students, (S)elected students, (I)nstitutions listed, blank. Only used when Request Type is M.

Columns Comments for REBRDRQ_ACK_MRR_SAR_SSN (# 17)

Source Code Comments

ACKNOWLEDGED MRR STUDENT ID: The Student SSN for which a MR is requested. Only required if MRR Code 2 is S.

Columns Comments for REBRDRQ_ACK_MRR_SAR_INIT (# 18)

Source Code Comments

ACKNOWLEDGED MRR STUDENT NAME CODE: The name code for which a MR is requested. Only required if MRR Code 2 is S.

Columns Comments for REBRDRQ_ACK_MRR_INST_PELL_ID (# 19)

Source Code Comments

ACKNOWLEDGED MRR INSTITUTION PELL ID: The institution code for which MR listings are requested. Only required if MRR Code 2 is I.

Columns Comments for REBRDRQ_ACTION_CODE (# 20)

Source Code Comments

ACTION CODE: The COD processing status of the data request.

Columns Comments for REBRDRQ_DATE_SENT (# 21)

Source Code Comments

DATE EXTRACTED: This is the date that the data in this request record was extracted for submission to COD

Columns Comments for REBRDRQ_EDIT_REJ_01 (# 22)

Source Code Comments

EDIT/COMMENT CODES: Data Request Edit/Comment Code 1.

Columns Comments for REBRDRQ_EDIT_REJ_02 (# 23)

Source Code Comments

EDIT/COMMENT CODES: Data Request Edit/Comment Code 2.

Columns Comments for REBRDRQ_EDIT_REJ_03 (# 24)

Source Code Comments

EDIT/COMMENT CODES: Data Request Edit/Comment Code 3.

Columns Comments for REBRDRQ_EDIT_REJ_04 (# 25)

Source Code Comments

EDIT/COMMENT CODES: Data Request Edit/Comment Code 4.

Columns Comments for REBRDRQ_EDIT_REJ_05 (# 26)

Source Code Comments

EDIT/COMMENT CODES: Data Request Edit/Comment Code 5.

Columns Comments for REBRDRQ_EDIT_REJ_06 (# 27)

Source Code Comments

EDIT/COMMENT CODES: Data Request Edit/Comment Code 6.

Columns Comments for REBRDRQ_EDIT_REJ_07 (# 28)

Source Code Comments

EDIT/COMMENT CODES: Data Request Edit/Comment Code 7.

Columns Comments for REBRDRQ_EDIT_REJ_08 (# 29)

Source Code Comments

EDIT/COMMENT CODES: Data Request Edit/Comment Code 8.

Columns Comments for REBRDRQ_ORIG_ID (# 30)

Source Code Comments

ORIGINATION OR AWARD ID: The Origination ID (Pell) or Award ID (ACG or SMART) for which a Year to Date record is being requested.

Columns Comments for REBRDRQ_ACK_ORIG_ID (# 31)

Source Code Comments

ACKNOWLEDGED ORIGINATION OR AWARD ID: The Origination ID (Pell) or Award ID (ACG or SMART) for which a Year to Date record was requested and acknowledged.

Columns Comments for REBRDRQ_CURRENT_SSN (# 32)

Source Code Comments

STUDENT'S CURRENT SSN: The student's current social security number for this MRR request.

Columns Comments for REBRDRQ_CURRENT_BIRTH_DATE (# 33)

Source Code Comments

STUDENT'S CURRENT DATE OF BIRTH: The student's date of birth for this MRR request.

Columns Comments for REBRDRQ_CURRENT_LAST_NAME (# 34)

Source Code Comments

STUDENT'S CURRENT LAST NAME: The student's last name for this MRR request

Columns Comments for REBRDRQ_CURRENT_FIRST_NAME (# 35)

Source Code Comments

STUDENT'S CURRENT FIRST NAME: The student's first name for this MRR request.

Columns Comments for REBRDRQ_CURRENT_MI (# 36)

Source Code Comments

STUDENT'S CURRENT MIDDLE INITIAL: The student's middle initial for this MRR request.

Columns Comments for REBRDRQ_ACK_CURRENT_SSN (# 37)

Source Code Comments

ACKNOWLEDGED CURRENT SSN: The student's current social security number for this MRR request, as acknowledged by COD.

Columns Comments for REBRDRQ_ACK_BIRTH_DATE (# 38)

Source Code Comments

ACKNOWLEDGED DATE OF BIRTH: The student's date of birth for this MRR request, as acknowledged by COD.

Columns Comments for REBRDRQ_ACK_LAST_NAME (# 39)

Source Code Comments

ACKNOWLEDGED LAST NAME: The student's last name for this MRR request, as acknowledged by COD.

Columns Comments for REBRDRQ_ACK_FIRST_NAME (# 40)

Source Code Comments

ACKNOWLEDGED FIRST NAME: The student's first name for this MRR request, as acknowledged by COD.

Columns Comments for REBRDRQ_ACK_MI (# 41)

Source Code Comments

ACKNOWLEDGED MIDDLE INITIAL: The student's middle initial for this MRR request, as acknowledged by COD.

Columns Comments for REBRDRQ_PROGRAM_TYPE (# 42)

Source Code Comments

PROGRAM TYPE: Code indicating the grant program type for the data request.

Columns Comments for REBRDRQ_ACK_PROGRAM_TYPE (# 43)

Source Code Comments

ACKNOWLEDGED PROGRAM TYPE: Code indicating the program code for the data request as acknowledged by COD.

Table REBRMRR

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
REBRMRR_AIDY_CODE	VARCHAR2(4)	No
REBRMRR_ACTIVITY_DATE	DATE	No
REBRMRR_RECORD_TYPE	VARCHAR2(2)	No
REBRMRR_ORIG_SSN	VARCHAR2(9)	No
REBRMRR_ORIG_INIT	VARCHAR2(2)	Yes
REBRMRR_CAMP_PELL_ID	VARCHAR2(6)	Yes
REBRMRR_MRR_CODE_1	VARCHAR2(1)	Yes
REBRMRR_MRR_CODE_2	VARCHAR2(1)	Yes
REBRMRR_MRR_SAR_SSN	VARCHAR2(9)	Yes
REBRMRR_MRR_SAR_INIT	VARCHAR2(2)	Yes
REBRMRR_MRR_INST_PELL_ID	VARCHAR2(6)	Yes
REBRMRR_INST_PELL_ID	VARCHAR2(6)	Yes
REBRMRR_INST_NAME	VARCHAR2(70)	Yes
REBRMRR_LINE1_INST_FAA	VARCHAR2(35)	Yes
REBRMRR_LINE2_INST_FAA	VARCHAR2(35)	Yes
REBRMRR_CITY_INST_FAA	VARCHAR2(25)	Yes
REBRMRR_STAT_CODE_INST_FAA	VARCHAR2(2)	Yes
REBRMRR_ZIP_INST_FAA	VARCHAR2(9)	Yes
REBRMRR_FAA_ADMIN_NAME	VARCHAR2(30)	Yes
REBRMRR_FAA_PHONE_AREA	VARCHAR2(3)	Yes
REBRMRR_FAA_PHONE_NO	VARCHAR2(7)	Yes
REBRMRR_FAA_FAX_AREA	VARCHAR2(3)	Yes
REBRMRR_FAA_FAX_NO	VARCHAR2(7)	Yes
REBRMRR_FAA_EMAIL	VARCHAR2(50)	Yes
REBRMRR_SCHED_PELL_GRANT_AMT	NUMBER(7,2)	Yes
REBRMRR_ORIGINATION_AWARD_AMT	NUMBER(7,2)	Yes
REBRMRR_SAR_TRAN_NO	VARCHAR2(2)	Yes
REBRMRR_PGI	NUMBER(5,0)	Yes
REBRMRR_ENROLLMENT_DATE	DATE	Yes
REBRMRR_ORIG_CREATE_DATE	DATE	Yes
REBRMRR_TOT_DISB_ACCEPTED	NUMBER(7,2)	Yes
REBRMRR_LAST_ACTIVITY_DATE	DATE	Yes
REBRMRR_NEXT_EST_DISB_DATE	DATE	Yes
REBRMRR_PCT_ELIGIBILITY_USED	NUMBER(7,4)	Yes
REBRMRR_SHARED_SAR_ID_FLAG	VARCHAR2(1)	Yes
REBRMRR_VERIF_W_STATUS_FLAG	VARCHAR2(1)	Yes
REBRMRR_CONCUR_ENROLL_FLAG	VARCHAR2(1)	Yes
REBRMRR_POTENTIAL_OVERPMT_FLAG	VARCHAR2(1)	Yes
REBRMRR_BATCH_NO	VARCHAR2(26)	Yes
REBRMRR_LAST_NAME	VARCHAR2(16)	Yes
REBRMRR_FIRST_NAME	VARCHAR2(12)	Yes
REBRMRR_MI	VARCHAR2(1)	Yes
REBRMRR_BIRTH_DATE	DATE	Yes	*
REBRMRR_CURRENT_SSN	VARCHAR2(9)	Yes	*
REBRMRR_AWARD_ID	VARCHAR2(21)	Yes
REBRMRR_PROGRAM_TYPE	VARCHAR2(2)	No
REBRMRR_PERCENT_TOT_ELIG_USED	NUMBER(7,4)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
REBRMRR_CURRENT_SSN	RERSTID_SSN	RERSTID
REBRMRR_BIRTH_DATE	RERSTID_BIRTH_DATE	RERSTID

Index

Index Name	Index Type	Column Name
REBRMRR_AIDY_INDEX		REBRMRR_AIDY_CODE
REBRMRR_AIDY_INDEX		REBRMRR_ACTIVITY_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REVRMRR	SQL View	S10B80.BANINST1	Use (select)
REBRMRR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBRMRR_AIDY_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RERSTID	SQL Table	S10B80.FAISMGR	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBRMRR

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:14:000	04/02/2008 10:35:21:000

Source Code Comments

Grant Multiple Reporting Record Table.

Columns Comments for REBRMRR_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE FOR MULTIPLE REPORTING RECORDS: The aid year code for MRR records.

Columns Comments for REBRMRR_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE FOR MULTIPLE REPORTING RECORDS: Activity date for the MRR data.

Columns Comments for REBRMRR_RECORD_TYPE (# 3)

Source Code Comments

MRR RECORD TYPE: Code that indicates the reason the institution is receiving the record.

Columns Comments for REBRMRR_ORIG_SSN (# 4)

Source Code Comments

STUDENT ORIGINAL SSN: Student's original SSN from the Origination Record.

Columns Comments for REBRMRR_ORIG_INIT (# 5)

Source Code Comments

STUDENT ORIGINAL NAME CODE: Student's name code from the Origination record.

Columns Comments for REBRMRR_CAMP_PELL_ID (# 6)

Source Code Comments

REQUESTING INSTITUTION PELL ID: Pell ID of the requesting attending campus of the student. Will be blank for concurrent enrollment and potential over award records.

Columns Comments for REBRMRR_MRR_CODE_1 (# 7)

Source Code Comments

MULTIPLE REPORTING REQUEST CODE 1: Indicates the institution is requesting originated or disbursed institutions. Will be blank for concurrent enrollment and potential over award records. Valid values O = send originated, D = send disbursed, blank

Columns Comments for REBRMRR_MRR_CODE_2 (# 8)

Source Code Comments

MULTIPLE REPORTING REQUEST CODE 2: Indicates what the inst. is requesting by. Will be blank for concurrent enrollment and potential over award records. Valid values (A)ll students, (S)elected students, (I) for students at listed institutions, blank

Columns Comments for REBRMRR_MRR_SAR_SSN (# 9)

Source Code Comments

MRR STUDENT SSN: The student SSN for which an MR is requested. Will be blank for concurrent enrollment and potential over award records.

Columns Comments for REBRMRR_MRR_SAR_INIT (# 10)

Source Code Comments

MRR STUDENT NAME CODE: The name code for which an MR is requested. Will be blank for concurrent enrollment and potential over award records.

Columns Comments for REBRMRR_MRR_INST_PELL_ID (# 11)

Source Code Comments

MRR INSTITUTION PELL ID: The institution code for which MR are requested. Will be blank for concurrent enrollment and potential over award records.

Columns Comments for REBRMRR_INST_PELL_ID (# 12)

Source Code Comments

INSTITUTION PELL ID: Pell ID of the campus the student is attending.

Columns Comments for REBRMRR_INST_NAME (# 13)

Source Code Comments

INSTITUTION NAME: The name of the instititution.

Columns Comments for REBRMRR_LINE1_INST_FAA (# 14)

Source Code Comments

INSTITUTION STREET ADDRESS LINE 1: The street or post office box address of the institution.

Columns Comments for REBRMRR_LINE2_INST_FAA (# 15)

Source Code Comments

INSTITUTION STREET ADDRESS LINE 2: The street or post office box address of the institution.

Columns Comments for REBRMRR_CITY_INST_FAA (# 16)

Source Code Comments

INSTITUTION CITY: City in which the institution is located.

Columns Comments for REBRMRR_STAT_CODE_INST_FAA (# 17)

Source Code Comments

INSTITUTION STATE: The two character code assigned by the US Postal Service to the state or other entity in which the institution is located.

Columns Comments for REBRMRR_ZIP_INST_FAA (# 18)

Source Code Comments

ZIP CODE: The zip code of the institution.

Columns Comments for REBRMRR_FAA_ADMIN_NAME (# 19)

Source Code Comments

FINANCIAL AID ADMINISTRATOR NAME: The full name of the institutional administrator officially responsible for the accuracy and completeness of the data.

Columns Comments for REBRMRR_FAA_PHONE_AREA (# 20)

Source Code Comments

FAA AREA CODE: Area code for the person listed as the FAA.

Columns Comments for REBRMRR_FAA_PHONE_NO (# 21)

Source Code Comments

FAA TELEPHONE NUMBER: Telephone number for the person listed as the FAA.

Columns Comments for REBRMRR_FAA_FAX_AREA (# 22)

Source Code Comments

FAA FAX AREA CODE: Area code for the fax number for the person listed as the FAA.

Columns Comments for REBRMRR_FAA_FAX_NO (# 23)

Source Code Comments

FAA FAX NUMBER: Fax number for the person listed as the FAA.

Columns Comments for REBRMRR_FAA_EMAIL (# 24)

Source Code Comments

INTERNET ADDRESS: Internet address of an authorized official.

Columns Comments for REBRMRR_SCHED_PELL_GRANT_AMT (# 25)

Source Code Comments

SCHEDULED FEDERAL GRANT AMOUNT: Scheduled federal grant amount for the aid year.

Columns Comments for REBRMRR_ORIGINATION_AWARD_AMT (# 26)

Source Code Comments

ORIGINATION AWARD AMOUNT: Annual award amount supplied on the Origination record.

Columns Comments for REBRMRR_SAR_TRAN_NO (# 27)

Source Code Comments

TRANSACTION NUMBER: Transaction number from the eligible SAR used to calculate the award.

Columns Comments for REBRMRR_PGI (# 28)

Source Code Comments

EXPECTED FAMILY CONTRIBUTION: Amount of the students Expected Family Contribution from the SAR used to calculate the award.

Columns Comments for REBRMRR_ENROLLMENT_DATE (# 29)

Source Code Comments

ENROLLMENT DATE: First date the student was enrolled in an eligible program for the award year.

Columns Comments for REBRMRR_ORIG_CREATE_DATE (# 30)

Source Code Comments

CREATE DATE: Date the Origination was created at COD.

Columns Comments for REBRMRR_TOT_DISB_ACCEPTED (# 31)

Source Code Comments

TOTAL OF DISBURSEMENTS ACCEPTED: Total amount of all disbursements accepted by the Federal Pell Grant Program for the POP student.

Columns Comments for REBRMRR_LAST_ACTIVITY_DATE (# 32)

Source Code Comments

LAST ACTIVITY DATE: Date the last payment record was received from the institution.

Columns Comments for REBRMRR_NEXT_EST_DISB_DATE (# 33)

Source Code Comments

NEXT ESTIMATED DISBURSEMENT DATE: Date of the next estimated disbursement.

Columns Comments for REBRMRR_PCT_ELIGIBILITY_USED (# 34)

Source Code Comments

ELIGIBILITY USED BY SCHEDULED AWARD: The percentage of the student's eligibility used by the institution for the scheduled award for the aid year.

Columns Comments for REBRMRR_SHARED_SAR_ID_FLAG (# 35)

Source Code Comments

SHARED SAR ID FLAG: If Y, indicates that this student shares a SAR ID with another student, and requires correction.

Columns Comments for REBRMRR_VERIF_W_STATUS_FLAG (# 36)

Source Code Comments

VERIFICATION W STATUS FLAG: If Y, indicates that this student has a verification W (Without Documentation) status and requires correction.

Columns Comments for REBRMRR_CONCUR_ENROLL_FLAG (# 37)

Source Code Comments

CONCURRENT ENROLLMENT FLAG: If Y, indicates that this student has concurrent enrollment and may require correction.

Columns Comments for REBRMRR_POTENTIAL_OVERPMT_FLAG (# 38)

Source Code Comments

POTENTIAL OVERPAYMENT FLAG: If Y, indicates that this student has a potential overpayment and may require correction.

Columns Comments for REBRMRR_BATCH_NO (# 39)

Source Code Comments

BATCH NUMBER: The batch number associated with Multiple Reporting Record data received from COD.

Columns Comments for REBRMRR_LAST_NAME (# 40)

Source Code Comments

STUDENT LAST NAME: The last name, as reported to COD.

Columns Comments for REBRMRR_FIRST_NAME (# 41)

Source Code Comments

STUDENT FIRST NAME: The first name, as reported to COD.

Columns Comments for REBRMRR_MI (# 42)

Source Code Comments

STUDENT MIDDLE INITIAL: The middle initial, as reported to COD.

Columns Comments for REBRMRR_BIRTH_DATE (# 43)

Source Code Comments

STUDENT BIRTH DATE: The birth date, as reported to COD.

Columns Comments for REBRMRR_CURRENT_SSN (# 44)

Source Code Comments

STUDENT'S CURRENT SSN: as altered by the student through the CPS for the transaction number reported.

Columns Comments for REBRMRR_AWARD_ID (# 45)

Source Code Comments

AWARD ID: Award ID for the ACG or SMART grant as recorded at COD.

Columns Comments for REBRMRR_PROGRAM_TYPE (# 46)

Source Code Comments

PROGRAM TYPE: Code indicating the grant program type for the MRR record.

Columns Comments for REBRMRR_PERCENT_TOT_ELIG_USED (# 47)

Source Code Comments

ELIGIBILITY USED BY CLASS YEAR LEVEL: The percentage of the student's eligibility used by all institutions for the class level.

Table REBSSOA

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
REBSSOA_AIDY_CODE	VARCHAR2(4)	No
REBSSOA_ACTIVITY_DATE	DATE	No
REBSSOA_BATCH_NO	VARCHAR2(26)	No
REBSSOA_CAMP_PELL_ID	VARCHAR2(6)	Yes
REBSSOA_GRANTEE_DUNS_NO	VARCHAR2(11)	Yes
REBSSOA_PAYEE_DUNS_NO	VARCHAR2(11)	Yes
REBSSOA_GAPS_AWARD_NO	VARCHAR2(16)	Yes
REBSSOA_ACCT_SCHEDULE_NO	NUMBER(5,0)	Yes
REBSSOA_ACCT_SCHEDULE_DATE	DATE	Yes
REBSSOA_PREV_OBLIG_AMT	NUMBER(11,2)	Yes
REBSSOA_TOT_OBLIG_ADJ_AMT	NUMBER(11,2)	Yes
REBSSOA_CURRENT_OBLIG_AMT	NUMBER(11,2)	Yes
REBSSOA_PREV_PMT_AMT	NUMBER(11,2)	Yes
REBSSOA_TOT_PMT_ADJ_AMT	NUMBER(11,2)	Yes
REBSSOA_CURRENT_PMT_AMT	NUMBER(11,2)	Yes
REBSSOA_YTD_TOT_UNDUP_REC	NUMBER(7,0)	Yes
REBSSOA_YTD_ACPT_DISB_AMT	NUMBER(11,2)	Yes
REBSSOA_YTD_POSTED_DISB_AMT	NUMBER(11,2)	Yes
REBSSOA_YTD_ADMIN_COST_ALLOW	NUMBER(11,2)	Yes
REBSSOA_GAPS_EXPEND_AMT	NUMBER(13,2)	Yes
REBSSOA_GAPS_LAST_ACT_DATE	DATE	Yes
REBSSOA_PMT_CONTROL_NO	NUMBER(13,0)	Yes
REBSSOA_ENTITY_ID	VARCHAR2(8)	Yes
REBSSOA_PROGRAM_TYPE	VARCHAR2(2)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
REBSSOA_AIDY_INDEX		REBSSOA_AIDY_CODE
REBSSOA_AIDY_INDEX		REBSSOA_GAPS_LAST_ACT_DATE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBSSOA_AIDY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBSSOA

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:10:000	04/02/2008 10:35:22:000

Source Code Comments

Summary Statement of Account Table

Columns Comments for REBSSOA_AIDY_CODE (# 1)

Source Code Comments

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

Columns Comments for REBSSOA_ACTIVITY_DATE (# 2)

Source Code Comments

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

Columns Comments for REBSSOA_BATCH_NO (# 3)

Source Code Comments

SUMMARY STATEMENT OF ACCOUNT BATCH NUMBER: The Batch Number associated with the Summary Statement of Account.

Columns Comments for REBSSOA_CAMP_PELL_ID (# 4)

Source Code Comments

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

Columns Comments for REBSSOA_GRANTEE_DUNS_NO (# 5)

Source Code Comments

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

Columns Comments for REBSSOA_PAYEE_DUNS_NO (# 6)

Source Code Comments

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

Columns Comments for REBSSOA_GAPS_AWARD_NO (# 7)

Source Code Comments

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

Columns Comments for REBSSOA_ACCT_SCHEDULE_NO (# 8)

Source Code Comments

ACCOUNTING SEQUENCE NUMBER: Sequence Number assigned by COD to track accounting schedules.

Columns Comments for REBSSOA_ACCT_SCHEDULE_DATE (# 9)

Source Code Comments

ACCOUNTING SCHEDULE DATE: Date of Current Accounting schedule.

Columns Comments for REBSSOA_PREV_OBLIG_AMT (# 10)

Source Code Comments

PREVIOUS OBLIGATION AMOUNT: Amount of institution's previous obligation balance.

Columns Comments for REBSSOA_TOT_OBLIG_ADJ_AMT (# 11)

Source Code Comments

TOTAL OBLIGATION ADJUSTMENT AMOUNT: Total of all adjustments to obligations for the GAPS Award Number.

Columns Comments for REBSSOA_CURRENT_OBLIG_AMT (# 12)

Source Code Comments

CURRENT OBLIGATION AMOUNT: Amount of institutions current obligation balance.

Columns Comments for REBSSOA_PREV_PMT_AMT (# 13)

Source Code Comments

PREVIOUS PAYMENT AMOUNT: Amount of institutions previous payment balance. Not applicable for Advance Funding institutions.

Columns Comments for REBSSOA_TOT_PMT_ADJ_AMT (# 14)

Source Code Comments

TOTAL PAYMENT ADJUSTMENT AMOUNT: Total of all adjustments to payment for the GAPS Award Number. NA for Advance Funding Institutions.

Columns Comments for REBSSOA_CURRENT_PMT_AMT (# 15)

Source Code Comments

CURRENT PAYMENT AMOUNT: Amount of institutions current payment balance. NA for Advance Funding Institutions.

Columns Comments for REBSSOA_YTD_TOT_UNDUP_REC (# 16)

Source Code Comments

YTD TOTAL UNDUPLICATED RECIPIENTS: Year to date number of unduplicated recipients for institution.

Columns Comments for REBSSOA_YTD_ACPT_DISB_AMT (# 17)

Source Code Comments

YTD ACCEPTED DISBURSEMENT AMOUNT: YTD total of disbursements accepted by COD.

Columns Comments for REBSSOA_YTD_POSTED_DISB_AMT (# 18)

Source Code Comments

YTD POSTED DISBURSEMENT AMOUNT: YTD total of disbursements posted to COD.

Columns Comments for REBSSOA_YTD_ADMIN_COST_ALLOW (# 19)

Source Code Comments

YTD ADMINISTRATIVE COST ALLOWANCE: YTD amount of ACA paid to the institution.

Columns Comments for REBSSOA_GAPS_EXPEND_AMT (# 20)

Source Code Comments

GAPS EXPENDITURE AMOUNT: Current Expenditure amount in GAPS.

Columns Comments for REBSSOA_GAPS_LAST_ACT_DATE (# 21)

Source Code Comments

DATE OF LAST ACTIVITY IN GAPS: The date GAPS last posted a transaction for the GAPS Award number.

Columns Comments for REBSSOA_PMT_CONTROL_NO (# 22)

Source Code Comments

PAYMENT CONTROL NUMBER: The reference number for the last payment sent to the institution.

Columns Comments for REBSSOA_ENTITY_ID (# 23)

Source Code Comments

Entity ID: The entity ID (Routing ID) associated with this statement of account record.

Columns Comments for REBSSOA_PROGRAM_TYPE (# 24)

Source Code Comments

PROGRAM TYPE: Code indicating the grant program type for the summary statement of account record.

Table REBYTDD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
REBYTDD_AIDY_CODE	VARCHAR2(4)	No
REBYTDD_ACTIVITY_DATE	DATE	No
REBYTDD_BATCH_NO	VARCHAR2(26)	No
REBYTDD_PIDM	NUMBER(8,0)	Yes
REBYTDD_ORIG_ID	VARCHAR2(23)	Yes
REBYTDD_INST_XREF	VARCHAR2(13)	Yes
REBYTDD_DISB_ACTION_CODE	VARCHAR2(1)	Yes
REBYTDD_DISB_REF_NO	NUMBER(2,0)	Yes
REBYTDD_DISB_ACPT_AMT	NUMBER(7,2)	Yes
REBYTDD_DISB_ACPT_DEBIT_CR_IND	VARCHAR2(1)	Yes
REBYTDD_DISB_DATE	DATE	Yes
REBYTDD_PAY_PD_NUMBER	NUMBER(1,0)	Yes
REBYTDD_PAY_PD_START_DATE	DATE	Yes
REBYTDD_PAY_PD_END_DATE	DATE	Yes
REBYTDD_ACPT_NBR_MTHS_PAY	NUMBER(1,0)	Yes
REBYTDD_ACPT_PAY_PD_TOTAL	NUMBER(7,2)	Yes
REBYTDD_ACPT_PAY_PD_ACAD_CAL	VARCHAR2(1)	Yes
REBYTDD_ACPT_PAY_PD_PMT_METH	VARCHAR2(1)	Yes
REBYTDD_ACPT_PAY_PD_ATTEND_CST	NUMBER(7,2)	Yes
REBYTDD_ACPT_PAY_PD_ENRL_STAT	VARCHAR2(1)	Yes
REBYTDD_ACPT_PAY_PD_EXPECT_WKS	NUMBER(2,0)	Yes
REBYTDD_ACPT_WKS_IN_YR	NUMBER(2,0)	Yes
REBYTDD_ACPT_PAY_PD_EXPECT_HRS	NUMBER(4,0)	Yes
REBYTDD_ACPT_HRS_IN_YR	NUMBER(4,0)	Yes
REBYTDD_DISB_BATCH_NO	VARCHAR2(26)	Yes
REBYTDD_DISB_PROC_DATE	DATE	Yes
REBYTDD_ROUTING_ID	VARCHAR2(8)	Yes
REBYTDD_FIN_AWARD_YR	VARCHAR2(4)	Yes
REBYTDD_CAMPUS_PELL_ID	VARCHAR2(6)	Yes
REBYTDD_LAST_NAME	VARCHAR2(16)	Yes
REBYTDD_FIRST_NAME	VARCHAR2(12)	Yes
REBYTDD_MI	VARCHAR2(1)	Yes
REBYTDD_CURRENT_SSN	VARCHAR2(9)	Yes
REBYTDD_BIRTH_DATE	DATE	Yes
REBYTDD_DISB_SEQ_NO	NUMBER(2,0)	Yes
REBYTDD_DISB_RELEASE_IND	VARCHAR2(1)	Yes
REBYTDD_PREV_DISB_SEQ_NO	NUMBER(2,0)	Yes
REBYTDD_GRADE_LEVEL	VARCHAR2(1)	Yes
REBYTDD_AWARD_ID	VARCHAR2(21)	Yes
REBYTDD_PROGRAM_TYPE	VARCHAR2(2)	No
REBYTDD_PERCENT_ELIG_USED	NUMBER(7,4)	Yes
REBYTDD_PERCENT_TOT_ELIG_USED	NUMBER(7,4)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
REBYTDD_AIDY_INDEX		REBYTDD_AIDY_CODE
REBYTDD_AIDY_INDEX		REBYTDD_PIDM
REBYTDD_AIDY_INDEX		REBYTDD_ACTIVITY_DATE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBYTDD_AIDY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBYTDD

Object Dates

Creation Date	Analysis Date
04/02/2008 10:24:00:000	04/02/2008 10:35:18:000

Source Code Comments

Grant Year to Date Detail Disbursement Record Table.

Columns Comments for REBYTDD_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE FOR DETAIL DISBURSEMENT YTD RECORD: The aid year for the detail year to date Disbursement record.

Columns Comments for REBYTDD_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE FOR DETAIL YTD DISBURSEMENT RECORD: The activity date for the detail year to date Disbursement record.

Columns Comments for REBYTDD_BATCH_NO (# 3)

Source Code Comments

PELL YEAR TO DATE DISBURSEMENT DETAIL BATCH NUMBER: The batch number associated with the Detail Year to Date Disbursement record.

Columns Comments for REBYTDD_PIDM (# 4)

Source Code Comments

STUDENT INTERNAL IDENTIFICATION NUMBER: Number used to identify student internal to the Banner system.

Columns Comments for REBYTDD_ORIG_ID (# 5)

Source Code Comments

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

Columns Comments for REBYTDD_INST_XREF (# 6)

Source Code Comments

INSTITUTIONAL CROSS REFERENCE ID: The Institution defined identifier used to identify student records internally.

Columns Comments for REBYTDD_DISB_ACTION_CODE (# 7)

Source Code Comments

DISBURSEMENT ACTION CODE: The COD processing status of the disbursement.

Columns Comments for REBYTDD_DISB_REF_NO (# 8)

Source Code Comments

DISBURSEMENT REFERENCE NUMBER: The reference number (sequence number) of this disbursement.

Columns Comments for REBYTDD_DISB_ACPT_AMT (# 9)

Source Code Comments

ACCEPTED DISBURSEMENT AMOUNT: The amount of the disbursement for the student's payment period, as acknowledged by COD. 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 REBYTDD_DISB_ACPT_DEBIT_CR_IND (# 10)

Source Code Comments

ACCEPTED SIGN INDICATOR: The Debit/Credit indicator for this disbursement, as acknowledged by COD. Indicates if the disbursement is positive (P) or negative (N).

Columns Comments for REBYTDD_DISB_DATE (# 11)

Source Code Comments

DISBURSEMENT DATE: Date this payment was or will be made to the student.

Columns Comments for REBYTDD_PAY_PD_NUMBER (# 12)

Source Code Comments

PAYMENT PERIOD NUMBER: Number used to identify which Payment Period the record is referencing.

Columns Comments for REBYTDD_PAY_PD_START_DATE (# 13)

Source Code Comments

PAYMENT PERIOD START DATE: The start date of the Payment Period the record is referencing.

Columns Comments for REBYTDD_PAY_PD_END_DATE (# 14)

Source Code Comments

PAYMENT PERIOD END DATE: The end date of the Payment Period the record is referencing.

Columns Comments for REBYTDD_ACPT_NBR_MTHS_PAY (# 15)

Source Code Comments

ACCEPTED NUMBER OF TERMS OR PAYMENT PERIODS IN STUDENT'S SCHOOL YEAR: The number of terms or payment periods in the student's school year, as acknowledged by RFMS.

Columns Comments for REBYTDD_ACPT_PAY_PD_TOTAL (# 16)

Source Code Comments

ACCEPTED TOTAL PAYMENT FOR PAYMENT PERIOD: The total payment amount for this payment period, as acknowledged by COD.

Columns Comments for REBYTDD_ACPT_PAY_PD_ACAD_CAL (# 17)

Source Code Comments

ACCEPTED ACADEMIC CALENDAR: The Academic Calendar that applies to the payment period, as acknowledged by RFMS.

Columns Comments for REBYTDD_ACPT_PAY_PD_PMT_METH (# 18)

Source Code Comments

ACCEPTED PAYMENT METHODOLOGY: The payment method that applies to the payment period, as acknowledged by RFMS.

Columns Comments for REBYTDD_ACPT_PAY_PD_ATTEND_CST (# 19)

Source Code Comments

ACCEPTED COST OF ATTENDANCE FOR PAYMENT PERIOD: The applicable cost of attendance for the payment period, as acknowledged by COD.

Columns Comments for REBYTDD_ACPT_PAY_PD_ENRL_STAT (# 20)

Source Code Comments

ACCEPTED ENROLLMENT STATUS: The enrollment status for the student for the applicable payment period, as acknowledged by COD.

Columns Comments for REBYTDD_ACPT_PAY_PD_EXPECT_WKS (# 21)

Source Code Comments

ACCEPTED WEEKS ENROLLED: The number of weeks the student is enrolled for the applicable payment period, as acknowledged by RFMS.

Columns Comments for REBYTDD_ACPT_WKS_IN_YR (# 22)

Source Code Comments

ACCEPTED WEEKS IN PROGRAM: The number of weeks of instruction in the program year, as acknowledged by RFMS.

Columns Comments for REBYTDD_ACPT_PAY_PD_EXPECT_HRS (# 23)

Source Code Comments

ACCEPTED HOURS ENROLLED: The number of credit or clock hours the student is enrolled in for the applicable payment period, as acknowledged by RFMS.

Columns Comments for REBYTDD_ACPT_HRS_IN_YR (# 24)

Source Code Comments

ACCEPTED HOURS IN PROGRAM: The number of hours of instruction time in the program year, as acknowledged by RFMS.

Columns Comments for REBYTDD_DISB_BATCH_NO (# 25)

Source Code Comments

GRANT DISBURSEMENT BATCH NUMBER: The batch number produced by COD for the disbursement batch.

Columns Comments for REBYTDD_DISB_PROC_DATE (# 26)

Source Code Comments

DISBURSEMENT PROCESS DATE: Date Disbursement information was processed by the COD System.

Columns Comments for REBYTDD_ROUTING_ID (# 27)

Source Code Comments

ROUTING ID: School's Routing ID associated with the disbursement record.

Columns Comments for REBYTDD_FIN_AWARD_YR (# 28)

Source Code Comments

FINANCIAL AWARD YEAR: The last year in the two-year cycle of the award year for the disbursement.

Columns Comments for REBYTDD_CAMPUS_PELL_ID (# 29)

Source Code Comments

ATTENDED CAMPUS PELL ID: Pell ID of the attended campus for the disbursement.

Columns Comments for REBYTDD_LAST_NAME (# 30)

Source Code Comments

STUDENT'S LAST NAME: The last name of the student.

Columns Comments for REBYTDD_FIRST_NAME (# 31)

Source Code Comments

STUDENT'S FIRST NAME: The first name of the student.

Columns Comments for REBYTDD_MI (# 32)

Source Code Comments

STUDENT'S MIDDLE INITIAL: The middle initial of the student.

Columns Comments for REBYTDD_CURRENT_SSN (# 33)

Source Code Comments

STUDENT'S CURRENT SSN: Student's current SSN for the transaction number reported.

Columns Comments for REBYTDD_BIRTH_DATE (# 34)

Source Code Comments

STUDENT'S DATE OF BIRTH: Student's Date of Birth for the transaction number reported.

Columns Comments for REBYTDD_DISB_SEQ_NO (# 35)

Source Code Comments

DISBURSEMENT SEQUENCE NUMBER: The sequence number for the given disbursement.

Columns Comments for REBYTDD_DISB_RELEASE_IND (# 36)

Source Code Comments

DISBURSEMENT RELEASE INDICATOR: The value reported to indicate whether the disbursement is anticipated or actual.

Columns Comments for REBYTDD_PREV_DISB_SEQ_NO (# 37)

Source Code Comments

PREVIOUS DISBURSEMENT SEQUENCE NUMBER: The sequence number processed for this disbursement immediately before the disbursement sequence number reported on this record.

Columns Comments for REBYTDD_GRADE_LEVEL (# 38)

Source Code Comments

GRADE LEVEL: Grade Level for the ACG or SMART grant as recorded at COD.

Columns Comments for REBYTDD_AWARD_ID (# 39)

Source Code Comments

AWARD ID: Award ID for the ACG or SMART grant as recorded at COD.

Columns Comments for REBYTDD_PROGRAM_TYPE (# 40)

Source Code Comments

PROGRAM TYPE: Code indicating the grant program type for the YTD disbursement record.

Columns Comments for REBYTDD_PERCENT_ELIG_USED (# 41)

Source Code Comments

ELIGIBILITY USED BY SCHEDULED AWARD: The percentage of the student's eligibility used by the institution for the scheduled award for the aid year.

Columns Comments for REBYTDD_PERCENT_TOT_ELIG_USED (# 42)

Source Code Comments

ELIGIBILITY USED BY CLASS YEAR LEVEL: The percentage of the student's eligibility used by all institutions for the class level.

Table REBYTDO

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
REBYTDO_AIDY_CODE	VARCHAR2(4)	No
REBYTDO_ACTIVITY_DATE	DATE	No
REBYTDO_BATCH_NO	VARCHAR2(26)	No
REBYTDO_PIDM	NUMBER(8,0)	Yes
REBYTDO_ORIG_ID	VARCHAR2(23)	Yes
REBYTDO_SAR_SSN	VARCHAR2(9)	Yes
REBYTDO_SAR_INIT	VARCHAR2(2)	Yes
REBYTDO_CAMP_PELL_ID	VARCHAR2(6)	Yes
REBYTDO_INST_XREF	VARCHAR2(13)	Yes
REBYTDO_STATUS_CDE	VARCHAR2(1)	Yes
REBYTDO_ACPT_NBR_MTHS_PAY	NUMBER(1,0)	Yes
REBYTDO_ACPT_AMT_DUE	NUMBER(7,2)	Yes
REBYTDO_ACPT_EST_DISB_DATE_01	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_02	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_03	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_04	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_05	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_06	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_07	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_08	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_09	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_10	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_11	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_12	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_13	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_14	DATE	Yes
REBYTDO_ACPT_EST_DISB_DATE_15	DATE	Yes
REBYTDO_ACPT_ENROLLMENT_DATE	DATE	Yes
REBYTDO_ACPT_LOW_COST_CDE	VARCHAR2(1)	Yes
REBYTDO_ACPT_VER_STATUS	VARCHAR2(1)	Yes
REBYTDO_ACPT_PRISON_IND	VARCHAR2(1)	Yes
REBYTDO_ACPT_SAR_TRAN_NO	VARCHAR2(2)	Yes
REBYTDO_ACPT_PGI	NUMBER(5,0)	Yes
REBYTDO_ACPT_SEC_PGI_USED	VARCHAR2(1)	Yes
REBYTDO_ACPT_ACAD_CAL	VARCHAR2(1)	Yes
REBYTDO_ACPT_PAYMENT_METHOD	VARCHAR2(1)	Yes
REBYTDO_ACPT_ATTEND_COST	NUMBER(7,2)	Yes
REBYTDO_ACPT_ENROLL_STATUS	VARCHAR2(1)	Yes
REBYTDO_ACPT_EXPECT_WKS	NUMBER(2,0)	Yes
REBYTDO_ACPT_WKS_IN_YR	NUMBER(2,0)	Yes
REBYTDO_ACPT_EXPECT_HRS	NUMBER(4,0)	Yes
REBYTDO_ACPT_HRS_IN_YR	NUMBER(4,0)	Yes
REBYTDO_SCH_PELL_GRANT	NUMBER(7,2)	Yes
REBYTDO_LAST_NAME	VARCHAR2(16)	Yes
REBYTDO_FIRST_NAME	VARCHAR2(12)	Yes
REBYTDO_MI	VARCHAR2(1)	Yes
REBYTDO_CURRENT_SSN	VARCHAR2(9)	Yes
REBYTDO_BIRTH_DATE	DATE	Yes
REBYTDO_CPS_VER_SEL_CDE	VARCHAR2(1)	Yes
REBYTDO_YTD_DISB_AMT	NUMBER(7,2)	Yes
REBYTDO_PROCESS_DATE	DATE	Yes
REBYTDO_ACPT_INT_SEQ_NO	NUMBER(3,0)	Yes
REBYTDO_ORIG_BATCH_NO	VARCHAR2(26)	Yes
REBYTDO_GRADE_LEVEL	VARCHAR2(1)	Yes
REBYTDO_PAY_REASON_CDE	VARCHAR2(2)	Yes
REBYTDO_HS_PROGRAM_CODE	VARCHAR2(6)	Yes
REBYTDO_AWARD_ID	VARCHAR2(21)	Yes
REBYTDO_CIP_CODE	VARCHAR2(6)	Yes
REBYTDO_PROGRAM_TYPE	VARCHAR2(2)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
REBYTDO_AIDY_INDEX		REBYTDO_AIDY_CODE
REBYTDO_AIDY_INDEX		REBYTDO_PIDM
REBYTDO_AIDY_INDEX		REBYTDO_ACTIVITY_DATE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBYTDO_AIDY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBYTDO

Object Dates

Creation Date	Analysis Date
04/02/2008 10:24:02:000	04/02/2008 10:35:18:000

Source Code Comments

Grant Year to Date Detail Origination Record Table.

Columns Comments for REBYTDO_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE FOR DETAIL ORIGINATION YTD RECORD: The aid year for the detail year to date Origination record.

Columns Comments for REBYTDO_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE FOR DETAIL YTD ORIGINATION RECORD: The activity date of the year to date Origination record.

Columns Comments for REBYTDO_BATCH_NO (# 3)

Source Code Comments

BATCH NUMBER: The batch number associated with the Detail Year to Date Origination record.

Columns Comments for REBYTDO_PIDM (# 4)

Source Code Comments

STUDENT INTERNAL IDENTIFICATION NUMBER: Number used to identify student internal to the Banner system.

Columns Comments for REBYTDO_ORIG_ID (# 5)

Source Code Comments

ORIGINATION ID: The unique number used to identify an origination.

Columns Comments for REBYTDO_SAR_SSN (# 6)

Source Code Comments

ORIGINAL STUDENT SSN: The student's Social Security number from the original FAFSA for the aid year.

Columns Comments for REBYTDO_SAR_INIT (# 7)

Source Code Comments

ORIGINAL STUDENT NAME CODE: The student's name code from the original FAFSA for the aid year.

Columns Comments for REBYTDO_CAMP_PELL_ID (# 8)

Source Code Comments

PELL CAMPUS CODE: The Pell ID of the campus that the student is attending.

Columns Comments for REBYTDO_INST_XREF (# 9)

Source Code Comments

ORIGINATION CROSS REFERENCE ID: The Institution defined identifier used to identify student records internally.

Columns Comments for REBYTDO_STATUS_CDE (# 10)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_NBR_MTHS_PAY (# 11)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_AMT_DUE (# 12)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_01 (# 13)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_02 (# 14)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_03 (# 15)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_04 (# 16)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_05 (# 17)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_06 (# 18)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_07 (# 19)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_08 (# 20)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_09 (# 21)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_10 (# 22)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_11 (# 23)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_12 (# 24)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_13 (# 25)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_14 (# 26)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_EST_DISB_DATE_15 (# 27)

Source Code Comments

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

Columns Comments for REBYTDO_ACPT_ENROLLMENT_DATE (# 28)

Source Code Comments

ACCEPTED ENROLLMENT DATE: The date accepted by the Department of Education as the date that the student is first enrolled in an eligible program for the aid year.

Columns Comments for REBYTDO_ACPT_LOW_COST_CDE (# 29)

Source Code Comments

ACCEPTED LOW COST CODE: Accepted value of the flag to identify tuition ranges when the annual tuition is less than a set amount.

Columns Comments for REBYTDO_ACPT_VER_STATUS (# 30)

Source Code Comments

ACCEPTED VERIFICATION STATUS: The value accepted by the Department of Education for the status of verification of applicant data by the school.

Columns Comments for REBYTDO_ACPT_PRISON_IND (# 31)

Source Code Comments

ACCEPTED PRISON INDICATOR: The value accepted by the Department of Education for the Incarcerated Federal Pell Recipient Code.

Columns Comments for REBYTDO_ACPT_SAR_TRAN_NO (# 32)

Source Code Comments

ACCEPTED SAR TRANSACTION NUMBER: Value accepted by the Department of Education of the SAR transaction number.

Columns Comments for REBYTDO_ACPT_PGI (# 33)

Source Code Comments

ACCEPTED EFC (PGI): The value of the Expected Family Contribution accepted by the Department of Education.

Columns Comments for REBYTDO_ACPT_SEC_PGI_USED (# 34)

Source Code Comments

ACCEPTED SECONDARY EFC (PGI) USED INDICATOR: Value of the Secondary Expected Family Contribution Code accepted by the Department of Education.

Columns Comments for REBYTDO_ACPT_ACAD_CAL (# 35)

Source Code Comments

ACCEPTED PELL ACADEMIC CALENDAR: Academic calendar accepted by the Department of Education.

Columns Comments for REBYTDO_ACPT_PAYMENT_METHOD (# 36)

Source Code Comments

ACCEPTED PELL PAYMENT METHODOLOGY: Payment methodology used to calculate the student's Federal Pell Grant, as accept by the Department of Education.

Columns Comments for REBYTDO_ACPT_ATTEND_COST (# 37)

Source Code Comments

ACCEPTED ATTENDANCE COST: Cost of attendance accepted by the Department of Education.

Columns Comments for REBYTDO_ACPT_ENROLL_STATUS (# 38)

Source Code Comments

ACCEPTED ENROLLMENT STATUS: Expected enrollment status of the student for the aid year accepted by the Department of Education.

Columns Comments for REBYTDO_ACPT_EXPECT_WKS (# 39)

Source Code Comments

ACCEPTED EXPECTED WEEKS: The weeks of instructional time in which the student is expected to be enrolled, accepted by the Department of Education.

Columns Comments for REBYTDO_ACPT_WKS_IN_YR (# 40)

Source Code Comments

ACCEPTED WEEKS IN YEAR: The number of weeks of instructional time in the program's academic year, as accepted by the Department of Education.

Columns Comments for REBYTDO_ACPT_EXPECT_HRS (# 41)

Source Code Comments

ACCEPTED EXPECTED HOURS: The number of credit or clock hours in all pay periods expected to complete this school year, accepted by the Department of Education.

Columns Comments for REBYTDO_ACPT_HRS_IN_YR (# 42)

Source Code Comments

ACCEPTED HOURS IN YEAR: The number of credit or clock hours f instructional time in the program's academic year, accepted by the Department of Education.

Columns Comments for REBYTDO_SCH_PELL_GRANT (# 43)

Source Code Comments

ACCEPTED SCHEDULED GRANT AMOUNT: The scheduled amount of the grant for the aid year.

Columns Comments for REBYTDO_LAST_NAME (# 44)

Source Code Comments

STUDENT LAST NAME: The last name of student as reported to the CPS for the transaction number reported. Blank indicates this record could not be matched on Student ID and/or EFC during COD processing.

Columns Comments for REBYTDO_FIRST_NAME (# 45)

Source Code Comments

STUDENT FIRST NAME: The first name of student as reported to the CPS for the transaction number reported. Blank indicates this record could not be matched on Student ID and/or EFC during COD processing.

Columns Comments for REBYTDO_MI (# 46)

Source Code Comments

STUDENT MIDDLE INITIAL: Middle Initial of student as reported to the CPS for the transaction number reported.

Columns Comments for REBYTDO_CURRENT_SSN (# 47)

Source Code Comments

STUDENT CURRENT SSN: The Social Security Number of the student as reported to CPS for the transaction number reported. Blank indicates this record could not be matched on Student ID and/or EFC during COD processing.

Columns Comments for REBYTDO_BIRTH_DATE (# 48)

Source Code Comments

STUDENT DATE OF BIRTH: Date of birth of student.

Columns Comments for REBYTDO_CPS_VER_SEL_CDE (# 49)

Source Code Comments

CPS VERIFICATION SELECTION CODE: Designates whether CPS selected the student for institutional verification of applicant data as of the transaction number reported.

Columns Comments for REBYTDO_YTD_DISB_AMT (# 50)

Source Code Comments

YEAR TO DATE DISBURSEMENT AMOUNT: The total of processed disbursements by COD.

Columns Comments for REBYTDO_PROCESS_DATE (# 51)

Source Code Comments

YEAR TO DATE PROCESS DATE: The date this record was processed by COD.

Columns Comments for REBYTDO_ACPT_INT_SEQ_NO (# 52)

Source Code Comments

ACCEPTED INSTITUTION INTERNAL SEQUENCE NUMBER: An internally generated sequence number which will allow the school to track the version of the origination record RFMS has on file, acknowledged by RFMS.

Columns Comments for REBYTDO_ORIG_BATCH_NO (# 53)

Source Code Comments

PELL ORIGINATION BATCH NUMBER: The batch number in which the Student's Pell Origination Record was sent to RFMS, as recorded by RFMS.

Columns Comments for REBYTDO_GRADE_LEVEL (# 54)

Source Code Comments

GRADE LEVEL: Grade Level for the ACG or SMART grant as recorded at COD.

Columns Comments for REBYTDO_PAY_REASON_CDE (# 55)

Source Code Comments

PAYMENT REASON CODE: Payment Reason Code for the ACG grant as recorded at COD.

Columns Comments for REBYTDO_HS_PROGRAM_CODE (# 56)

Source Code Comments

HIGH SCHOOL PROGRAM CODE: High School Program Code for the ACG grant as recorded at COD.

Columns Comments for REBYTDO_AWARD_ID (# 57)

Source Code Comments

AWARD ID: Award ID for the ACG or SMART grant as recorded at COD.

Columns Comments for REBYTDO_CIP_CODE (# 58)

Source Code Comments

CIP CODE: CIP Code for the SMART grant as recorded at COD.

Columns Comments for REBYTDO_PROGRAM_TYPE (# 59)

Source Code Comments

PROGRAM TYPE: Code indicating the grant program type for the YTD origination record.

Table REBYTDS

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
REBYTDS_AIDY_CODE	VARCHAR2(4)	No
REBYTDS_ACTIVITY_DATE	DATE	No
REBYTDS_BATCH_NO	VARCHAR2(26)	No
REBYTDS_TOT_UNDUP_RECIPIENTS	NUMBER(7,0)	Yes
REBYTDS_TOT_ORIG	NUMBER(7,0)	Yes
REBYTDS_ORIG_ACCEPTED	NUMBER(7,0)	Yes
REBYTDS_ORIG_CORRECTED	NUMBER(7,0)	Yes
REBYTDS_ORIG_REJECTED	NUMBER(7,0)	Yes
REBYTDS_TOT_DISB	NUMBER(7,0)	Yes
REBYTDS_DISB_ACCEPTED	NUMBER(7,0)	Yes
REBYTDS_DISB_CORRECTED	NUMBER(7,0)	Yes
REBYTDS_DISB_REJECTED	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_01	NUMBER(3,0)	Yes
REBYTDS_COMMENT_01_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_02	NUMBER(3,0)	Yes
REBYTDS_COMMENT_02_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_03	NUMBER(3,0)	Yes
REBYTDS_COMMENT_03_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_04	NUMBER(3,0)	Yes
REBYTDS_COMMENT_04_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_05	NUMBER(3,0)	Yes
REBYTDS_COMMENT_05_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_06	NUMBER(3,0)	Yes
REBYTDS_COMMENT_06_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_07	NUMBER(3,0)	Yes
REBYTDS_COMMENT_07_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_08	NUMBER(3,0)	Yes
REBYTDS_COMMENT_08_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_09	NUMBER(3,0)	Yes
REBYTDS_COMMENT_09_COUNT	NUMBER(7,0)	Yes
REBYTDS_COMMENT_CODE_10	NUMBER(3,0)	Yes
REBYTDS_COMMENT_10_COUNT	NUMBER(7,0)	Yes
REBYTDS_PROGRAM_TYPE	VARCHAR2(2)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
REBYTDS_AIDY_INDEX		REBYTDS_AIDY_CODE
REBYTDS_AIDY_INDEX		REBYTDS_ACTIVITY_DATE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBYTDS_AIDY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.REBYTDS

Object Dates

Creation Date	Analysis Date
04/02/2008 10:24:04:000	04/02/2008 10:35:18:000

Source Code Comments

Grant Year to Date Summary Table

Columns Comments for REBYTDS_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE FOR YTD RECORDS: The aid year code for Year to date records.

Columns Comments for REBYTDS_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE FOR YTD RECORDS: Activity date for YTD summary records.

Columns Comments for REBYTDS_BATCH_NO (# 3)

Source Code Comments

PELL YEAR TO DATE SUMMARY BATCH NUMBER: The Batch Number associated with the Year to Date Summary.

Columns Comments for REBYTDS_TOT_UNDUP_RECIPIENTS (# 4)

Source Code Comments

TOTAL UNDUPLICATED RECIPIENTS: Year to date number of unduplicated recipients for the institution.

Columns Comments for REBYTDS_TOT_ORIG (# 5)

Source Code Comments

TOTAL ORIGINATIONS: Year to date number of originations received for the institution.

Columns Comments for REBYTDS_ORIG_ACCEPTED (# 6)

Source Code Comments

ORIGINATIONS ACCEPTED: Year to date number of originations received and accepted for the institution.

Columns Comments for REBYTDS_ORIG_CORRECTED (# 7)

Source Code Comments

ORIGINATIONS CORRECTED: Year to date number of originations received and corrected for the institution.

Columns Comments for REBYTDS_ORIG_REJECTED (# 8)

Source Code Comments

ORIGINATIONS REJECTED: Year to date number of originations received and rejected for the institution.

Columns Comments for REBYTDS_TOT_DISB (# 9)

Source Code Comments

TOTAL DISBURSEMENTS: Year to date number of disbursements and special disbursements received for the institution.

Columns Comments for REBYTDS_DISB_ACCEPTED (# 10)

Source Code Comments

DISBURSEMENTS ACCEPTED: Year to date number of Disbursements and special disbursements received and accepted for the institution.

Columns Comments for REBYTDS_DISB_CORRECTED (# 11)

Source Code Comments

DISBURSEMENTS CORRECTED: Year to date number of disbursements and special disbursements received and corrected for the institution.

Columns Comments for REBYTDS_DISB_REJECTED (# 12)

Source Code Comments

DISBURSEMENTS REJECTED: Year to date number of disbursements and special disbursements received and rejected for the institution.

Columns Comments for REBYTDS_COMMENT_CODE_01 (# 13)

Source Code Comments

COMMENT CODE 01: First Comment code number.

Columns Comments for REBYTDS_COMMENT_01_COUNT (# 14)

Source Code Comments

COMMENT CODE 01 COUNT: Year to date number of times comment code 01 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_02 (# 15)

Source Code Comments

COMMENT CODE 02: Second Comment code number.

Columns Comments for REBYTDS_COMMENT_02_COUNT (# 16)

Source Code Comments

COMMENT CODE 02 COUNT: Year to date number of times comment code 02 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_03 (# 17)

Source Code Comments

COMMENT CODE 03: Third Comment code number.

Columns Comments for REBYTDS_COMMENT_03_COUNT (# 18)

Source Code Comments

COMMENT CODE 03 COUNT: Year to date number of times comment code 03 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_04 (# 19)

Source Code Comments

COMMENT CODE 04: Fourth Comment code number.

Columns Comments for REBYTDS_COMMENT_04_COUNT (# 20)

Source Code Comments

COMMENT CODE 04 COUNT: Year to date number of times comment code 04 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_05 (# 21)

Source Code Comments

COMMENT CODE 05: Fifth Comment code number.

Columns Comments for REBYTDS_COMMENT_05_COUNT (# 22)

Source Code Comments

COMMENT CODE 05 COUNT: Year to date number of times comment code 05 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_06 (# 23)

Source Code Comments

COMMENT CODE 06: Sixth Comment code number.

Columns Comments for REBYTDS_COMMENT_06_COUNT (# 24)

Source Code Comments

COMMENT CODE 06 COUNT: Year to date number of times comment code 06 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_07 (# 25)

Source Code Comments

COMMENT CODE 07: Seventh Comment code number.

Columns Comments for REBYTDS_COMMENT_07_COUNT (# 26)

Source Code Comments

COMMENT CODE 07 COUNT: Year to date number of times comment code 07 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_08 (# 27)

Source Code Comments

COMMENT CODE 08: Eighth Comment code number.

Columns Comments for REBYTDS_COMMENT_08_COUNT (# 28)

Source Code Comments

COMMENT CODE 08 COUNT: Year to date number of times comment code 08 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_09 (# 29)

Source Code Comments

COMMENT CODE 09: Ninth Comment code number.

Columns Comments for REBYTDS_COMMENT_09_COUNT (# 30)

Source Code Comments

COMMENT CODE 09 COUNT: Year to date number of times comment code 09 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_COMMENT_CODE_10 (# 31)

Source Code Comments

COMMENT CODE 10: Tenth Comment code number.

Columns Comments for REBYTDS_COMMENT_10_COUNT (# 32)

Source Code Comments

COMMENT CODE 10 COUNT: Year to date number of times comment code 10 was returned to the institution on an acknowledgement.

Columns Comments for REBYTDS_PROGRAM_TYPE (# 33)

Source Code Comments

PROGRAM TYPE: Code indicating the grant program type for the summary record.

Table RERCODD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RERCODD_AIDY_CODE	VARCHAR2(4)	No
RERCODD_ACTIVITY_DATE	DATE	No
RERCODD_USER_ID	VARCHAR2(30)	No
RERCODD_DOCUMENT_ID	VARCHAR2(30)	No	*
RERCODD_DOC_ID_EXTRACT_DATE	DATE	Yes
RERCODD_DOC_ID_RCPT_PROC_DATE	DATE	Yes
RERCODD_DOC_ID_RESP_PROC_DATE	DATE	Yes
RERCODD_DOC_ID_RESP_STATUS	VARCHAR2(2)	Yes
RERCODD_DOC_ID_RECEIPT_STATUS	VARCHAR2(2)	Yes
RERCODD_DOCUMENT_TYPE	VARCHAR2(2)	Yes
RERCODD_DATA_ORIGIN	VARCHAR2(30)	Yes
RERCODD_EXTRACT_FILE	VARCHAR2(30)	Yes
RERCODD_RESENT_AS_DOC_ID	VARCHAR2(30)	Yes
RERCODD_ATTENDING_ID	VARCHAR2(8)	Yes
RERCODD_REPORTING_ID	VARCHAR2(8)	Yes
RERCODD_SOURCE_ID	VARCHAR2(8)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
RERCODD_KEY_INDEX	Unique	RERCODD_DOCUMENT_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
COD_DOCUMENT_REC	Oracle Package Type	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_INSERT_GENERATED_DOC_ID	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
GV_RESEND_DOC_ID	Oracle Package Variable	S10B80.BANINST1.REKCE07	Rely On
GV_RESEND_DOC_ID	Oracle Package Variable	S10B80.BANINST1.REKCE08	Rely On
GV_RESEND_DOC_ID	Oracle Package Variable	S10B80.BANINST1.REKCE09	Rely On
RERCODD_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
F_BUILD_RERCODD_REC	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_RERCODD	Use (Insert)Rely On
P_INSERT_COD_DOCUMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_INSERT_COD_DOCUMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_INSERT_COD_DOCUMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_INSERT_COD_DOCUMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_INSERT_COD_DOCUMENT	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_INSERT_COD_DOCUMENT	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_COD_DOCUMENT	Use (select)
P_PA_RERCODD_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PR_REREXXX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Rely On
P_PR_REREXXX_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PR_RPRDLPM_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PR_RPRPNPT_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.RB_COD_DOCUMENT_RULES	Rely On
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_SELECT_DOCUMENT_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_PERSON_INFO	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_RERCODD	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_RERCODD_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_RERCODD_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_RERCODD_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_RERCODD_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_RERCODD_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_RERCODD_RECEIPT	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_RERCODD_RESPONSE	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_COD_DOCUMENT_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_COD_DOCUMENT	Use (select)
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_DL_AWARDS	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_DL_CHANGES	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_SMART_ORIGINATIONS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
RERCODD	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RERCODD_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RERCODD

Object Dates

Creation Date	Analysis Date
04/02/2008 10:27:00:000	04/02/2008 10:35:20:000

Source Code Comments

COD Document Control Table

Columns Comments for RERCODD_AIDY_CODE (# 1)

Source Code Comments

COD AID YEAR CODE: The aid year for which the COD Document was extracted.

Columns Comments for RERCODD_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for RERCODD_USER_ID (# 3)

Source Code Comments

USER ID: The user id of the last person who updated this record.

Columns Comments for RERCODD_DOCUMENT_ID (# 4)

Source Code Comments

COD DOCUMENT ID: The document identification number associated with a common record sent to or received from COD.

Columns Comments for RERCODD_DOC_ID_EXTRACT_DATE (# 5)

Source Code Comments

DOCUMENT ID CREATE DATE: The date the file was extracted.

Columns Comments for RERCODD_DOC_ID_RCPT_PROC_DATE (# 6)

Source Code Comments

DOCUMENT ID RECEIPT RECEIVED DATE: The date the Document ID file was processed by COD.

Columns Comments for RERCODD_DOC_ID_RESP_PROC_DATE (# 7)

Source Code Comments

DOCUMENT ID RESPONSE RECEIVED DATE: The date the Document ID Response file was processed.

Columns Comments for RERCODD_DOC_ID_RESP_STATUS (# 8)

Source Code Comments

DOCUMENT ID RESPONSE STATUS: The status of the Document ID response file from COD.

Columns Comments for RERCODD_DOC_ID_RECEIPT_STATUS (# 9)

Source Code Comments

DOCUMENT ID RECEIPT STATUS: The status of the Document ID receipt file from COD.

Columns Comments for RERCODD_DOCUMENT_TYPE (# 10)

Source Code Comments

COD DOCUMENT TYPE: The response document type associated with the particular document id.

Columns Comments for RERCODD_DATA_ORIGIN (# 11)

Source Code Comments

DATA ORIGIN: The latest source for the data contained in this record.

Columns Comments for RERCODD_EXTRACT_FILE (# 12)

Source Code Comments

COD Extract File: The filename extracted for this document id. Includes message class, job sequence number and extension.

Columns Comments for RERCODD_RESENT_AS_DOC_ID (# 13)

Source Code Comments

Resent Document ID: The Document ID the original document was resent as.

Columns Comments for RERCODD_ATTENDING_ID (# 14)

Source Code Comments

ATTENDING SCHOOL ENTITY ID: The Routing ID of the school or campus where the student attends class for the records in this document.

Columns Comments for RERCODD_REPORTING_ID (# 15)

Source Code Comments

REPORTING SCHOOL ENTITY ID: The Routing ID of the school that reports the Common Record data for the Attending IDs in this document.

Columns Comments for RERCODD_SOURCE_ID (# 16)

Source Code Comments

SOURCE ENTITY ID: The Routing ID of the school/organization that physically sends or transmits the Common Record document.

Table RERRECN

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
RERRECN_AIDY_CODE	VARCHAR2(4)	No
RERRECN_ACTIVITY_DATE	DATE	No
RERRECN_USER_ID	VARCHAR2(30)	No
RERRECN_BATCH_NO	VARCHAR2(26)	No
RERRECN_PIDM	NUMBER(8,0)	Yes
RERRECN_PROCESS_DATE	DATE	Yes
RERRECN_LAST_NAME	VARCHAR2(16)	Yes
RERRECN_FIRST_NAME	VARCHAR2(12)	Yes
RERRECN_MI	VARCHAR2(1)	Yes
RERRECN_ORIG_ID	VARCHAR2(23)	Yes
RERRECN_CURRENT_SSN	VARCHAR2(9)	Yes
RERRECN_CAMP_PELL_ID	VARCHAR2(6)	Yes
RERRECN_SAR_TRAN_NO	VARCHAR2(2)	Yes
RERRECN_EFC	NUMBER(5,0)	Yes
RERRECN_AMT_DUE	NUMBER(7,2)	Yes
RERRECN_SCH_PELL_GRANT_AMT	NUMBER(7,2)	Yes
RERRECN_YTD_DISB_AMT	NUMBER(7,2)	Yes
RERRECN_VER_STATUS	VARCHAR2(1)	Yes
RERRECN_POTENTIAL_OVERPMT_FLAG	VARCHAR2(1)	Yes
RERRECN_GRADE_LEVEL	VARCHAR2(1)	Yes
RERRECN_PAY_REASON_CDE	VARCHAR2(2)	Yes
RERRECN_HS_PROGRAM_CODE	VARCHAR2(6)	Yes
RERRECN_AWARD_ID	VARCHAR2(21)	Yes
RERRECN_CIP_CODE	VARCHAR2(6)	Yes
RERRECN_PROGRAM_TYPE	VARCHAR2(2)	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
RERRECN_AIDY_INDEX		RERRECN_AIDY_CODE
RERRECN_AIDY_INDEX		RERRECN_PIDM
RERRECN_AIDY_INDEX		RERRECN_ACTIVITY_DATE

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RERRECN_AIDY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RERRECN

Object Dates

Creation Date	Analysis Date
04/02/2008 10:31:28:000	04/02/2008 10:35:23:000

Source Code Comments

Grant COD Reconciliation Table.

Columns Comments for RERRECN_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year of the reconciliation record.

Columns Comments for RERRECN_ACTIVITY_DATE (# 2)

Source Code Comments

ACTIVITY DATE: The date this record was last updated.

Columns Comments for RERRECN_USER_ID (# 3)

Source Code Comments

USER ID: The user ID of the user who last updated this record.

Columns Comments for RERRECN_BATCH_NO (# 4)

Source Code Comments

BATCH NUMBER: The batch number from the reconciliation batch header record.

Columns Comments for RERRECN_PIDM (# 5)

Source Code Comments

STUDENT INTERNAL IDENTIFICATION NUMBER: Number used to identify student internal to the Banner system.

Columns Comments for RERRECN_PROCESS_DATE (# 6)

Source Code Comments

PROCESS DATE: The date that the reconciliation record was processed by COD, from the reconciliation batch header record.

Columns Comments for RERRECN_LAST_NAME (# 7)

Source Code Comments

STUDENT LAST NAME: The last name of the student, as recorded in COD.

Columns Comments for RERRECN_FIRST_NAME (# 8)

Source Code Comments

STUDENT FIRST NAME: The first name of the student, as recorded in COD.

Columns Comments for RERRECN_MI (# 9)

Source Code Comments

STUDENT MIDDLE INITIAL: The middle initial of the student, as recorded in COD.

Columns Comments for RERRECN_ORIG_ID (# 10)

Source Code Comments

STUDENT ORIGINATION ID: The origination ID of the student, as recorded in RFMS.

Columns Comments for RERRECN_CURRENT_SSN (# 11)

Source Code Comments

STUDENT CURRENT SSN: The most recent SSN reported by the student through the CPS for the transaction number reported.

Columns Comments for RERRECN_CAMP_PELL_ID (# 12)

Source Code Comments

CAMPUS PELL ID: The Pell ID of the campus which the student attended.

Columns Comments for RERRECN_SAR_TRAN_NO (# 13)

Source Code Comments

SAR TRAN NUMBER: The transaction number from the eligible Student Aid Record used to calculate the award.

Columns Comments for RERRECN_EFC (# 14)

Source Code Comments

EXPECTED FAMILY CONTRIBUTION: The expected family contribution that corresponds to the SAR transaction number.

Columns Comments for RERRECN_AMT_DUE (# 15)

Source Code Comments

AWARD AMOUNT: The annual award amount for the student, supplied on the origination record

Columns Comments for RERRECN_SCH_PELL_GRANT_AMT (# 16)

Source Code Comments

SCHEDULED PELL GRANT AMOUNT: The scheduled Federal Pell Grant for a student with this expected family contribution and cost of attendance, for a student attending full-time for a full academic year.

Columns Comments for RERRECN_YTD_DISB_AMT (# 17)

Source Code Comments

YEAR-TO-DATE DISBURSEMENT AMOUNT: The total of all accepted disbursement amounts for the student for the award year.

Columns Comments for RERRECN_VER_STATUS (# 18)

Source Code Comments

VERIFICATION STATUS: This field indicates what the student verification status code was at the time the Origination record was created.

Columns Comments for RERRECN_POTENTIAL_OVERPMT_FLAG (# 19)

Source Code Comments

POTENTIAL OVERPAYMENT FLAG: Flag set in the origination record when the student is in a potential overpayment situation.

Columns Comments for RERRECN_GRADE_LEVEL (# 20)

Source Code Comments

GRADE LEVEL: Grade Level for the ACG or SMART grant as recorded at COD.

Columns Comments for RERRECN_PAY_REASON_CDE (# 21)

Source Code Comments

PAYMENT REASON CODE: Payment Reason Code for the ACG grant as recorded at COD.

Columns Comments for RERRECN_HS_PROGRAM_CODE (# 22)

Source Code Comments

HIGH SCHOOL PROGRAM CODE: High School Program Code for the ACG grant as recorded at COD.

Columns Comments for RERRECN_AWARD_ID (# 23)

Source Code Comments

AWARD ID: Award ID for the ACG or SMART grant as recorded at COD.

Columns Comments for RERRECN_CIP_CODE (# 24)

Source Code Comments

CIP CODE: CIP Code for the SMART grant as recorded at COD.

Columns Comments for RERRECN_PROGRAM_TYPE (# 25)

Source Code Comments

PROGRAM TYPE: Code indicating the grant program type for the reconciliation record.

Table RERSTID

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL
RERSTID_AIDY_CODE	VARCHAR2(4)	No
RERSTID_PIDM	NUMBER(8,0)	No
RERSTID_SEQ_NO	NUMBER(2,0)	No
RERSTID_IDENTIFIER_TYPE	VARCHAR2(1)	No
RERSTID_ACTIVITY_DATE	DATE	No
RERSTID_USER_ID	VARCHAR2(30)	No
RERSTID_DOCUMENT_ID	VARCHAR2(30)	Yes
RERSTID_SSN	VARCHAR2(9)	Yes
RERSTID_LAST_NAME	VARCHAR2(35)	Yes
RERSTID_BIRTH_DATE	DATE	Yes
RERSTID_STATUS_CDE	VARCHAR2(1)	Yes
RERSTID_PLUS_BORROWER_ID_NO	VARCHAR2(2)	Yes
RERSTID_REJECT_CODE_1	VARCHAR2(3)	Yes
RERSTID_REJECT_CODE_2	VARCHAR2(3)	Yes
RERSTID_REJECT_CODE_3	VARCHAR2(3)	Yes
RERSTID_REJECT_CODE_4	VARCHAR2(3)	Yes
RERSTID_REJECT_CODE_5	VARCHAR2(3)	Yes
RERSTID_DATA_ORIGIN	VARCHAR2(30)	Yes
RERSTID_EDIT_FIELD_1	VARCHAR2(35)	Yes
RERSTID_EDIT_FIELD_2	VARCHAR2(35)	Yes
RERSTID_EDIT_FIELD_3	VARCHAR2(35)	Yes
RERSTID_EDIT_FIELD_4	VARCHAR2(35)	Yes
RERSTID_EDIT_FIELD_5	VARCHAR2(35)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
RERSTID_DOCUMENT_ID_INDEX		RERSTID_DOCUMENT_ID
RERSTID_KEY2_INDEX		RERSTID_SSN
RERSTID_KEY2_INDEX		RERSTID_BIRTH_DATE
RERSTID_KEY3_INDEX		RERSTID_IDENTIFIER_TYPE
RERSTID_KEY3_INDEX		RERSTID_STATUS_CDE
RERSTID_KEY_INDEX	Unique	RERSTID_PIDM
RERSTID_KEY_INDEX	Unique	RERSTID_AIDY_CODE
RERSTID_KEY_INDEX	Unique	RERSTID_SEQ_NO
RERSTID_KEY_INDEX	Unique	RERSTID_IDENTIFIER_TYPE
RERSTID_KEY_INDEX	Unique	RERSTID_PLUS_BORROWER_ID_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
REBRMRR	SQL Table	S10B80.FAISMGR	Join
SPRIDEN	SQL Table	S10B80.SATURN	Join
REVRMRR	SQL View	S10B80.BANINST1	Use (select)
COD_IDENTIFIER_REC	Oracle Package Type	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
P_COMPARE_RCRAPP1_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_COMPARE_RCRAPP1_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_COMPARE_RCRAPP1_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_COMPARE_RCRAPP1_DATA	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_DELETE_VALIDATE_CONTEXT	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
P_INSERT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_INSERT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_INSERT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_INSERT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_INSERT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_INSERT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_INSERT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_INSERT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_OVERLAY_VALIDATION_REC	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
P_UPDATEDLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATEDLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (update,select)Rely On
P_UPDATEPARENTID	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATEPARENTID	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (update,select)Rely On
P_UPDATEPELLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATEPELLORIG	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (update,select)Rely On
P_UPDATESTUDENTID	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Rely On
P_UPDATESTUDENTID	Oracle Package Procedure	S10B80.BANINST1.REKCI04	Use (update,select)Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PARENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Use (select)
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Use (select)
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Use (select)
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Use (select)
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_STUDENT_IDENTIFIERS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Use (select)
RERSTID_PAR_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
RERSTID_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI04	Rely On
RERSTID_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI05	Rely On
RERSTID_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI06	Rely On
RERSTID_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI07	Rely On
RERSTID_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI08	Rely On
RERSTID_ROW	Oracle Package Variable	S10B80.BANINST1.REKCI09	Rely On
F_BUILD_RERSTID_REC	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI05	Rely On
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI05	Use (select)
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI06	Rely On
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI06	Use (select)
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI07	Rely On
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI07	Use (select)
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI08	Rely On
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI08	Use (select)
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI09	Rely On
F_CURRENT_PIDM	Oracle Package Function	S10B80.BANINST1.REKCI09	Use (select)
F_CURRENT_PIDM_BY_SSN	Oracle Package Function	S10B80.BANINST1.REKCI06	Rely On
F_CURRENT_PIDM_BY_SSN	Oracle Package Function	S10B80.BANINST1.REKCI06	Use (select)
F_CURRENT_PIDM_BY_SSN	Oracle Package Function	S10B80.BANINST1.REKCI07	Rely On
F_CURRENT_PIDM_BY_SSN	Oracle Package Function	S10B80.BANINST1.REKCI07	Use (select)
F_CURRENT_PIDM_BY_SSN	Oracle Package Function	S10B80.BANINST1.REKCI08	Rely On
F_CURRENT_PIDM_BY_SSN	Oracle Package Function	S10B80.BANINST1.REKCI08	Use (select)
F_CURRENT_PIDM_BY_SSN	Oracle Package Function	S10B80.BANINST1.REKCI09	Rely On
F_CURRENT_PIDM_BY_SSN	Oracle Package Function	S10B80.BANINST1.REKCI09	Use (select)
F_GETPIDM	Oracle Package Function	S10B80.BANINST1.REKCI04	Use (select)
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_NEXT_BOR_ID_NO	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_RERSTID	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_RERSTID	Use (Insert)Rely On
P_INSERT_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_INSERT_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_INSERT_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_INSERT_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_INSERT_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_INSERT_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
P_LOCK	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER	Use (select)
P_REGISTER_ENTITY	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER_RULES	Rely On
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_SELECT_BORROWER_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)Rely On
P_SELECT_IDENTIFIER_CHANGES	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Use (select)
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Use (select)
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Use (select)
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Use (select)
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Use (select)
P_SELECT_STUDENT_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_RERSTID	Use (update)Rely On
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_ACG_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_ACG_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE05	Rely On
P_UPDATE_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE06	Rely On
P_UPDATE_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE07	Rely On
P_UPDATE_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE08	Rely On
P_UPDATE_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCE09	Rely On
P_UPDATE_COD_IDENTIFIER	Oracle Package Procedure	S10B80.BANINST1.REKCEXX	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_DLUNSUB_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_GPLUS_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI05	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI06	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_PELL_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCIXX	Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_SMART_DISBURSEMENTS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI07	Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI08	Rely On
P_UPDATE_SMART_ORIGINATIONS	Oracle Package Procedure	S10B80.BANINST1.REKCI09	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.RB_COD_IDENTIFIER_RULES	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
F_EXISTS	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Use (select)
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
F_QUERY_ALL	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Use (select)
F_QUERY_BY_ROWID	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Use (select)
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
F_QUERY_ONE	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Use (select)
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Rely On
F_QUERY_ONE_LOCK	Oracle Package Function	S10B80.BANINST1.RB_COD_IDENTIFIER	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
RERSTID	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RERSTID_DOCUMENT_ID_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RERSTID_KEY2_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RERSTID_KEY3_INDEX	SQL Index	S10B80.FAISMGR	Rely On
RERSTID_KEY_INDEX	SQL Index	S10B80.FAISMGR	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RERSTID

Object Dates

Creation Date	Analysis Date
04/02/2008 10:26:14:000	04/02/2008 10:35:19:000

Source Code Comments

COD Identifier Table

Columns Comments for RERSTID_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year this Student Identifier record was created or the aid year for the PLUS Borrower Identifier record. The Student Identifier can be used across multiple aid years regardless of which aid year it was created. The PLUS Borrower Identifier record is aid year specific.

Columns Comments for RERSTID_PIDM (# 2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RERSTID_SEQ_NO (# 3)

Source Code Comments

STUDENT IDENTIFIER SEQUENCE NUMBER: The sequence number associated with the COD student identifier.

Columns Comments for RERSTID_IDENTIFIER_TYPE (# 4)

Source Code Comments

IDENTIFIER TYPE: The type for this particular identifier.

Columns Comments for RERSTID_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for RERSTID_USER_ID (# 6)

Source Code Comments

USER ID: The user ID of the last person who updated this record.

Columns Comments for RERSTID_DOCUMENT_ID (# 7)

Source Code Comments

COD DOCUMENT ID FOR STUDENT IDENTIFIER RECORD: The document identification number associated with the creation of or change to the COD Student Identifier for the student.

Columns Comments for RERSTID_SSN (# 8)

Source Code Comments

STUDENT IDENTIFIER SOCIAL SECURITY NUMBER: The social security number of the student.

Columns Comments for RERSTID_LAST_NAME (# 9)

Source Code Comments

STUDENT IDENTIFIER LAST NAME: The last name of the student.

Columns Comments for RERSTID_BIRTH_DATE (# 10)

Source Code Comments

STUDENT IDENTIFIER DATE OF BIRTH: The date of birth of the student.

Columns Comments for RERSTID_STATUS_CDE (# 11)

Source Code Comments

STUDENT IDENTIFIER STATUS CODE: The status of this student identifier record.

Columns Comments for RERSTID_PLUS_BORROWER_ID_NO (# 12)

Source Code Comments

PLUS BORROWER NUMBER: The number assigned to this PLUS Borrower that is included on the PLUS loan record.

Columns Comments for RERSTID_REJECT_CODE_1 (# 13)

Source Code Comments

IDENTIFIER REJECT CODE 1: The first identifier block reject code sent for this identifier record.

Columns Comments for RERSTID_REJECT_CODE_2 (# 14)

Source Code Comments

IDENTIFIER REJECT CODE 2: The second identifier block reject code sent for this identifier record.

Columns Comments for RERSTID_REJECT_CODE_3 (# 15)

Source Code Comments

IDENTIFIER REJECT CODE 3: The third identifier block reject code sent for this identifier record.

Columns Comments for RERSTID_REJECT_CODE_4 (# 16)

Source Code Comments

IDENTIFIER REJECT CODE 4: The fourth identifier block reject code sent for this identifier record.

Columns Comments for RERSTID_REJECT_CODE_5 (# 17)

Source Code Comments

IDENTIFIER REJECT CODE 5: The fifth identifier block reject code sent for this identifier record.

Columns Comments for RERSTID_DATA_ORIGIN (# 18)

Source Code Comments

DATA ORIGIN: The latest source for the data contained in this record.

Columns Comments for RERSTID_EDIT_FIELD_1 (# 19)

Source Code Comments

Identifier Response Edit Field 1: The field (XML tag) associated with edit 1.

Columns Comments for RERSTID_EDIT_FIELD_2 (# 20)

Source Code Comments

Identifier Response Edit Field 2: The field (XML tag) associated with edit 2.

Columns Comments for RERSTID_EDIT_FIELD_3 (# 21)

Source Code Comments

Identifier Response Edit Field 3: The field (XML tag) associated with edit 3.

Columns Comments for RERSTID_EDIT_FIELD_4 (# 22)

Source Code Comments

Identifier Response Edit Field 4: The field (XML tag) associated with edit 4.

Columns Comments for RERSTID_EDIT_FIELD_5 (# 23)

Source Code Comments

Identifier Response Edit Field 5: The field (XML tag) associated with edit 5.

Link between REBRMRR and RERSTID

Join Information

Objects list
schema-view : S10B80.BANINST1.REVRMRR

Link List

Link Type	Link	Project
Join	Link Between REBRMRR and RERSTID	FAISMGR

List of Real links

Link type	Between	And
Join	REBRMRR	RERSTID