Model STVTERM

Model Label : Banner Financial Aid Support Table STVTERM

List of Objects

Object Name	Object Type	Layer Name
RCRTERM	TABLE	Default
RFRASCH	TABLE	Default
RFRDEFA	TABLE	Default
RFRDEFD	TABLE	Default
RFRDLCK	TABLE	Default
RFRDSCH	TABLE	Default
RJRPAYL	TABLE	Default
RORCRHR	TABLE	Default
RORENRL	TABLE	Default
RORSAPR	TABLE	Default
RORTPRD	TABLE	Default
RORVIEW	TABLE	Default
RPBLOPT	TABLE	Default
RPBOPTS	TABLE	Default
RPRADSB	TABLE	Default
RPRARSC	TABLE	Default
RPRATRM	TABLE	Default
RPRAUTH	TABLE	Default
RPRAWRD	TABLE	Default
RPRBAKO	TABLE	Default
RPRCONT	TABLE	Default
RPRDATE	TABLE	Default
RPREXPT	TABLE	Default
RPRLATR	TABLE	Default
RPRLDSB	TABLE	Default
RPRLTRM	TABLE	Default
RPRRSLT	TABLE	Default
STVTERM	TABLE	Default

Model View

Table RCRTERM

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RCRTERM

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RCRTERM_PRIORITY	RCRTERM_PRIORITY	NUMBER(4,0)	No	*
RCRTERM_AIDY_YEAR	RCRTERM_AIDY_YEAR	VARCHAR2(4)	No		*
RCRTERM_TERM_CODE_HOST	RCRTERM_TERM_CODE_HOST	VARCHAR2(6)	No		*
RCRTERM_YEAR	RCRTERM_YEAR	VARCHAR2(4)	No
RCRTERM_TERM_MSG_ID	RCRTERM_TERM_MSG_ID	NUMBER(6,0)	No
RCRTERM_TERM_MSG_ID_MENU	RCRTERM_TERM_MSG_ID_MENU	NUMBER(6,0)	No
RCRTERM_START_DATE_1	RCRTERM_START_DATE_1	DATE	No
RCRTERM_END_DATE_1	RCRTERM_END_DATE_1	DATE	No
RCRTERM_START_DATE_2	RCRTERM_START_DATE_2	DATE	Yes
RCRTERM_END_DATE_2	RCRTERM_END_DATE_2	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RCRTERM_TERM_CODE_HOST	STVTERM_CODE	STVTERM
RCRTERM_AIDY_YEAR	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
PK_RCRTERM	Unique	RCRTERM_PRIORITY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RCRTERM	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RCRTERM	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

Telephone Financial Aid Term Table defines the terms that are available within an award year, for giving students disbursement information in telephone financial aid.

Columns Comments for RCRTERM_PRIORITY (# 1)

Source Code Comments

Priority Sequence Number of Term in listing of terms for financial aid disbursement information.

Columns Comments for RCRTERM_AIDY_YEAR (# 2)

Source Code Comments

Award Year associated with term code to be spoken during telephone Financial Aid.

Columns Comments for RCRTERM_TERM_CODE_HOST (# 3)

Source Code Comments

Financial Aid Term Code.

Columns Comments for RCRTERM_YEAR (# 4)

Source Code Comments

Year to be spoken in association with the message id for the term.

Columns Comments for RCRTERM_TERM_MSG_ID (# 5)

Source Code Comments

VRU Message ID for the term to be spoken during telephone Financial Aid.

Columns Comments for RCRTERM_TERM_MSG_ID_MENU (# 6)

Source Code Comments

VRU Message ID for the term to be spoken when term is used in menus during telephone Financial Aid.

Columns Comments for RCRTERM_START_DATE_1 (# 7)

Source Code Comments

Beginning Date of the first telephone financial aid period in which term code may be used.

Columns Comments for RCRTERM_END_DATE_1 (# 8)

Source Code Comments

Ending Date of the first telephone financial aid period in which term code may be used.

Columns Comments for RCRTERM_START_DATE_2 (# 9)

Source Code Comments

Beginning Date of the second telephone financial aid period in which term code may be used.

Columns Comments for RCRTERM_END_DATE_2 (# 10)

Source Code Comments

Ending Date of the second telephone financial aid period in which term code may be used.

Table RFRASCH

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RFRASCH

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRASCH_AIDY_CODE	RFRASCH_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASCH_APRD_CODE	RFRASCH_APRD_CODE	VARCHAR2(6)	No	*	*
RFRASCH_FUND_CODE	RFRASCH_FUND_CODE	VARCHAR2(6)	No	*	*
RFRASCH_TERM_CODE	RFRASCH_TERM_CODE	VARCHAR2(6)	No	*	*
RFRASCH_AWARD_PCT	RFRASCH_AWARD_PCT	NUMBER(6,3)	No
RFRASCH_ACTIVITY_DATE	RFRASCH_ACTIVITY_DATE	DATE	No
RFRASCH_MEMO_EXP_DATE	RFRASCH_MEMO_EXP_DATE	DATE	Yes
RFRASCH_PELL_AWARD_PCT	RFRASCH_PELL_AWARD_PCT	NUMBER(6,3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRASCH_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RFRASCH_TERM_CODE	STVTERM_CODE	STVTERM
RFRASCH_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRASCH_AIDY_CODE	RFRDEFA_AIDY_CODE	RFRDEFA
RFRASCH_APRD_CODE	RFRDEFA_APRD_CODE	RFRDEFA
RFRASCH_TERM_CODE	RFRDEFA_TERM_CODE	RFRDEFA
RFRASCH_FUND_CODE	RFRBASE_FUND_CODE	RFRBASE

Index

Index Name	Index Type	Column Name
PK_RFRASCH	Unique	RFRASCH_AIDY_CODE
PK_RFRASCH	Unique	RFRASCH_APRD_CODE
PK_RFRASCH	Unique	RFRASCH_FUND_CODE
PK_RFRASCH	Unique	RFRASCH_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UAARTN	Cobol Program	F:\banner\cobol	Use (select)
OAA5-PELL	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OAA-AWARD-ONLY	Use
PAA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.PAA-AWARD-ELIGIBLE	Use
RAB2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.RAB-FINAL-ELIGIBLE	Use
UAA5	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAA-MAINTAIN-AWARD	Use (select)
UAA5	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAA-MAINTAIN-AWARD	Use (select)
UAA5	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAA-MAINTAIN-AWARD	Use (select)
UAA5	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAA-MAINTAIN-AWARD	Use (select)
UAH2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAH-UPDATE-AWARD-SCHEDULE	Use (select)
UAH2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAH-UPDATE-AWARD-SCHEDULE	Use (select)
UAH2	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAH-UPDATE-AWARD-SCHEDULE	Use (select)
UAH2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAH-UPDATE-AWARD-SCHEDULE	Use (select)
UCP6E	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use (select)
UCP6E	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use (select)
UCP6E1	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use
UCP6E1	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use
UCP6E2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use
UCP6E2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use
applicant_detail	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
check_exception_sched_term	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
check_term_sched	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
ins_exception_term	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
ins_rprlatr	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
ins_rprlatr_lprd	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
sel_award_exist	C/C++ Function	[F:\BANNER\C\RFRFUND.PC]	Use (select)
sel_award_info	C/C++ Function	[F:\BANNER\C\RFRFUND.PC]	Use (select)
valid_dflt_lprd	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
RFRASCH	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
P_ADD_AWARD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_UPDATE_AWARD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_USE_AWARD_SCHED	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_VOID_OLD_TERM_DISBURSE_RECS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_VOID_OLD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
F_SELECT_RFRASCH_1	Package function	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RFRASCH	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RFRBASE	TABLE	"S4B70.SCT.COM".FAISMGR	Join
RFRDEFA	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RTVAPRD	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

Fund Award Schedule Rules Table

Columns Comments for RFRASCH_AIDY_CODE (# 1)

Source Code Comments

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

Columns Comments for RFRASCH_APRD_CODE (# 2)

Source Code Comments

AID PERIOD CODE: This code identifies the particular part of the year that students may be enrolled.

Columns Comments for RFRASCH_FUND_CODE (# 3)

Source Code Comments

FUND CODE: This code identifies the different funds which the institution has.

Columns Comments for RFRASCH_TERM_CODE (# 4)

Source Code Comments

TERM CODE: This field is used to identify the effective term for this record. Examples include: 199101 = Fall; 199102 = Spring

Columns Comments for RFRASCH_AWARD_PCT (# 5)

Source Code Comments

AWARD PERCENT: This percentage, as associated with a term code determines the amount of the packaged award that will be scheduled by term(s). The award percent cannot be negative and must equal 100% within aid periods.

Columns Comments for RFRASCH_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: This field maintains the date that thie record was entered or last updated.

Columns Comments for RFRASCH_MEMO_EXP_DATE (# 7)

Source Code Comments

MEMO EXPIRATION DATE: This optional field is used to identify the date that any memo'd item for that term will expire.

Columns Comments for RFRASCH_PELL_AWARD_PCT (# 8)

Source Code Comments

PELL AWARD PERCENT: Percentage to be used when calculating the Pell award for a term. This percentage, multiplied by the max Pell award for the year based on the student's enrollment, determines the maximum Pell award for the term. Max percent is 100%.

Table RFRDEFA

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RFRDEFA

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDEFA_AIDY_CODE	RFRDEFA_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDEFA_APRD_CODE	RFRDEFA_APRD_CODE	VARCHAR2(6)	No	*	*
RFRDEFA_TERM_CODE	RFRDEFA_TERM_CODE	VARCHAR2(6)	No	*	*
RFRDEFA_AWARD_PCT	RFRDEFA_AWARD_PCT	NUMBER(6,3)	No
RFRDEFA_ACTIVITY_DATE	RFRDEFA_ACTIVITY_DATE	DATE	No
RFRDEFA_MEMO_EXP_DATE	RFRDEFA_MEMO_EXP_DATE	DATE	Yes
RFRDEFA_PELL_AWARD_PCT	RFRDEFA_PELL_AWARD_PCT	NUMBER(6,3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRDEFA_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RFRDEFA_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDEFA_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RFRDEFA	Unique	RFRDEFA_AIDY_CODE
PK_RFRDEFA	Unique	RFRDEFA_APRD_CODE
PK_RFRDEFA	Unique	RFRDEFA_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UAARTN	Cobol Program	F:\banner\cobol	Use (select)
OAA5-PELL	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OAA-AWARD-ONLY	Use
PAA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.PAA-AWARD-ELIGIBLE	Use
RAB2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.RAB-FINAL-ELIGIBLE	Use
UAA5	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAA-MAINTAIN-AWARD	Use (select)
UAA5	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAA-MAINTAIN-AWARD	Use (select)
UAA5	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAA-MAINTAIN-AWARD	Use (select)
UAA5	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAA-MAINTAIN-AWARD	Use (select)
UAH3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAH-UPDATE-AWARD-SCHEDULE	Use (select)
UAH3	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAH-UPDATE-AWARD-SCHEDULE	Use (select)
UAH3	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAH-UPDATE-AWARD-SCHEDULE	Use (select)
UAH3	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAH-UPDATE-AWARD-SCHEDULE	Use (select)
UCP6E	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use (select)
UCP6E	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use (select)
UCP6E1	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use
UCP6E1	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use
UCP6E2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use
UCP6E2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use
applicant_detail	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
check_term_sched	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
ins_exception_term	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
ins_rprlatr	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
ins_rprlatr_lprd	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
ins_standard_term	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
sel_award_deft	C/C++ Function	[F:\BANNER\C\RFRFUND.PC]	Use (select)
valid_dflt_lprd	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
RFRDEFA	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
RFRASCH	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
P_ADD_AWARD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_UPDATE_AWARD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_USE_DEFAULT_SCHED	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_VOID_OLD_TERM_DISBURSE_RECS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_VOID_OLD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RFRDEFA	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RTVAPRD	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

Default Fund Award Schedule Rules Table

Columns Comments for RFRDEFA_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this Fund Award Schedule Rules record.

Columns Comments for RFRDEFA_APRD_CODE (# 2)

Source Code Comments

AID PERIOD CODE: This code identifies particular parts of a year that students may be enrolled. Examples include: full year, academic year, summer only, etc.

Columns Comments for RFRDEFA_TERM_CODE (# 3)

Source Code Comments

TERM CODE: This field is used to identify the effective term for this record. Examples include: 199101 = Fall; 199102 = Spring, etc.

Columns Comments for RFRDEFA_AWARD_PCT (# 4)

Source Code Comments

AWARD PERCENT: This percentage as associated with a term code determines the amount of the packaged award that will be scheduled by term(s). The award percent cannot be negative and must equal 100% within aid periods.

Columns Comments for RFRDEFA_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: This field maintains the date that the record was entered or last updated.

Columns Comments for RFRDEFA_MEMO_EXP_DATE (# 6)

Source Code Comments

MEMO EXPIRATION DATE: This optional field is used to identify the date that any memo'd items for that term will expire. (Default value).

Columns Comments for RFRDEFA_PELL_AWARD_PCT (# 7)

Source Code Comments

Table RFRDEFD

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RFRDEFD

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDEFD_AIDY_CODE	RFRDEFD_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDEFD_APRD_CODE	RFRDEFD_APRD_CODE	VARCHAR2(6)	No	*	*
RFRDEFD_TERM_CODE	RFRDEFD_TERM_CODE	VARCHAR2(6)	No	*	*
RFRDEFD_DISBURSE_DATE	RFRDEFD_DISBURSE_DATE	DATE	No	*
RFRDEFD_DISBURSE_PCT	RFRDEFD_DISBURSE_PCT	NUMBER(6,3)	No
RFRDEFD_ACTIVITY_DATE	RFRDEFD_ACTIVITY_DATE	DATE	No
RFRDEFD_DISB_SCHED_NO_DAYS	RFRDEFD_DISB_SCHED_NO_DAYS	NUMBER(3,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRDEFD_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RFRDEFD_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDEFD_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RFRDEFD	Unique	RFRDEFD_AIDY_CODE
PK_RFRDEFD	Unique	RFRDEFD_APRD_CODE
PK_RFRDEFD	Unique	RFRDEFD_TERM_CODE
PK_RFRDEFD	Unique	RFRDEFD_DISBURSE_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UAARTN	Cobol Program	F:\banner\cobol	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAA-MAINTAIN-AWARD	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAEX-UPDATE-PERK-TRACKING	Use (select)
UCP13-CHECK-DEFAULT-DISB-SCHED	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use (select)
UCP13-CHECK-DEFAULT-DISB-SCHED	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use (select)
applicant_detail	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
delete_disburse_defd	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
ins_disburse_standard	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
sel_disburse_deft	C/C++ Function	[F:\BANNER\C\RFRFUND.PC]	Use (select)
sel_rfrdefd	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
upd_perkins_mpn_tracking	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
RFRDEFD	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
P_ADD_DISBURSE_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
F_COUNT_RFRDEFD	Package function	"S4B70.SCT.COM".BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_GET_RFRDEFD_DATE	Package function	"S4B70.SCT.COM".BANINST1.RB_REQUIREMENT	Rely On
F_GET_RFRDEFD_DATE	Package function	"S4B70.SCT.COM".BANINST1.RB_REQUIREMENT	Use (select)
P_ADD_DISBURSE_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKTERM	Use (select)
UT_SETUP	Package procedure	"S4B70.SCT.COM".BANINST1.UT_RB_PELL_ORIGINATIONS	Use (Insert)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RFRDEFD	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RTVAPRD	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

Default Fund Disbursement Schedule Rules Table

Columns Comments for RFRDEFD_AIDY_CODE (# 1)

Source Code Comments

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

Columns Comments for RFRDEFD_APRD_CODE (# 2)

Source Code Comments

AID PERIOD CODE: This field identifies the particular parts of the year that students may be enrolled. Examples include: full year, academic year, summer only, etc.

Columns Comments for RFRDEFD_TERM_CODE (# 3)

Source Code Comments

TERM CODE: This field identifies the term that the disbursement is scheduled for.

Columns Comments for RFRDEFD_DISBURSE_DATE (# 4)

Source Code Comments

DISBURSEMENT DATE: This field identifies the expected disbursement date for each fund by term.

Columns Comments for RFRDEFD_DISBURSE_PCT (# 5)

Source Code Comments

DISBURSEMENT PERCENT: This field indicates the percentage of the award to be disbursed for the specific term.

Columns Comments for RFRDEFD_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: This field maintains the date that record was last entered or updated.

Columns Comments for RFRDEFD_DISB_SCHED_NO_DAYS (# 7)

Source Code Comments

DISBURSEMENT DATE OFFSET: Number of days prior to or after the first class start date of the student to schedule the disbursement.

Table RFRDLCK

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RFRDLCK

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDLCK_AIDY_CODE	RFRDLCK_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDLCK_FUND_CODE	RFRDLCK_FUND_CODE	VARCHAR2(6)	No	*	*
RFRDLCK_TERM_CODE	RFRDLCK_TERM_CODE	VARCHAR2(6)	No	*	*
RFRDLCK_LOCK_IND	RFRDLCK_LOCK_IND	VARCHAR2(1)	No
RFRDLCK_ACTIVITY_DATE	RFRDLCK_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRDLCK_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDLCK_AIDY_CODE	RFRASPC_AIDY_CODE	RFRASPC
RFRDLCK_FUND_CODE	RFRASPC_FUND_CODE	RFRASPC
RFRDLCK_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RFRDLCK	Unique	RFRDLCK_AIDY_CODE
PK_RFRDLCK	Unique	RFRDLCK_FUND_CODE
PK_RFRDLCK	Unique	RFRDLCK_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
VAE2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VAE-UPDTE-DLCK	Use (update)
VBA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VBA-INSERT-DLCK	Use (Insert)
VDA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VDA-SELECT-FUND	Use (select)
sel_lock	C/C++ Function	[F:\BANNER\C\RFRFUND.PC]	Use (select)
RFRDLCK	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RFRDLCK	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RFRASPC	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:24:000

Source Code Comments

Fund Disbursement Lock Table

Columns Comments for RFRDLCK_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RFRDLCK_FUND_CODE (# 2)

Source Code Comments

FUND CODE: The fund code associated with the disbursement lock.

Columns Comments for RFRDLCK_TERM_CODE (# 3)

Source Code Comments

TERM CODE: The term in which the disbursement lock is indicated for the fund.

Columns Comments for RFRDLCK_LOCK_IND (# 4)

Source Code Comments

LOCK INDICATOR: This indicator is used to lock the specific fund from further disbursements by term.

Columns Comments for RFRDLCK_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Table RFRDSCH

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RFRDSCH

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDSCH_AIDY_CODE	RFRDSCH_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRDSCH_APRD_CODE	RFRDSCH_APRD_CODE	VARCHAR2(6)	No	*	*
RFRDSCH_FUND_CODE	RFRDSCH_FUND_CODE	VARCHAR2(6)	No	*
RFRDSCH_TERM_CODE	RFRDSCH_TERM_CODE	VARCHAR2(6)	No	*	*
RFRDSCH_DISBURSE_DATE	RFRDSCH_DISBURSE_DATE	DATE	No	*
RFRDSCH_DISBURSE_PCT	RFRDSCH_DISBURSE_PCT	NUMBER(6,3)	No
RFRDSCH_ACTIVITY_DATE	RFRDSCH_ACTIVITY_DATE	DATE	No
RFRDSCH_DISB_SCHED_NO_DAYS	RFRDSCH_DISB_SCHED_NO_DAYS	NUMBER(3,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RFRDSCH_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RFRDSCH_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDSCH_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RFRDSCH	Unique	RFRDSCH_AIDY_CODE
PK_RFRDSCH	Unique	RFRDSCH_APRD_CODE
PK_RFRDSCH	Unique	RFRDSCH_FUND_CODE
PK_RFRDSCH	Unique	RFRDSCH_TERM_CODE
PK_RFRDSCH	Unique	RFRDSCH_DISBURSE_DATE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UAARTN	Cobol Program	F:\banner\cobol	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAA-MAINTAIN-AWARD	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAEX-UPDATE-PERK-TRACKING	Use (select)
UCP12-CHECK-FUND-DISB-SCHED	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use (select)
UCP12-CHECK-FUND-DISB-SCHED	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use (select)
applicant_detail	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
check_exception_sched_disb	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
delete_disburse_rec	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
ins_disburse_exception	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
sel_disburse_exist	C/C++ Function	[F:\BANNER\C\RFRFUND.PC]	Use (select)
sel_disburse_info	C/C++ Function	[F:\BANNER\C\RFRFUND.PC]	Use (select)
sel_rfrdsch	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
upd_perkins_mpn_tracking	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
RFRDSCH	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
P_ADD_DISBURSE_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Rely On
P_ADD_DISBURSE_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
F_SELECT_RFRDSCH_2	Package function	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
F_COUNT_RFRDSCH	Package function	"S4B70.SCT.COM".BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_GET_RFRDSCH_DATE	Package function	"S4B70.SCT.COM".BANINST1.RB_REQUIREMENT	Rely On
F_GET_RFRDSCH_DATE	Package function	"S4B70.SCT.COM".BANINST1.RB_REQUIREMENT	Use (select)
P_ADD_DISBURSE_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKTERM	Rely On
P_ADD_DISBURSE_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKTERM	Use (select)
UT_SETUP	Package procedure	"S4B70.SCT.COM".BANINST1.UT_RB_REQUIREMENT	Use (Insert)
UT_SETUP	Package procedure	"S4B70.SCT.COM".BANINST1.UT_RB_PELL_ORIGINATIONS	Use (Insert)
F_SELECT_RFRDSCH_2	Package function	"S4B70.SCT.COM".BANINST1.RPKTERM	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RFRDSCH	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RTVAPRD	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

Fund Disbursement Schedule Rules Table

Columns Comments for RFRDSCH_AIDY_CODE (# 1)

Source Code Comments

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

Columns Comments for RFRDSCH_APRD_CODE (# 2)

Source Code Comments

AID PERIOD CODE: This field identifies the various portions of the year that students may be enrolled. Examples include: full academic year, summer only, twelve months, etc.

Columns Comments for RFRDSCH_FUND_CODE (# 3)

Source Code Comments

FUND CODE: This field identifies the fund to which the disbursement rules apply.

Columns Comments for RFRDSCH_TERM_CODE (# 4)

Source Code Comments

TERM CODE: This field identifies the terms to which the disbursement rules apply.

Columns Comments for RFRDSCH_DISBURSE_DATE (# 5)

Source Code Comments

DISBURSEMENT DATE: This field identifies the expected disbursement date for each fund by term.

Columns Comments for RFRDSCH_DISBURSE_PCT (# 6)

Source Code Comments

DISBURSEMENT PERCENT: This field indicates the percentage of the award to be disbursed for the specified term.

Columns Comments for RFRDSCH_ACTIVITY_DATE (# 7)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RFRDSCH_DISB_SCHED_NO_DAYS (# 8)

Source Code Comments

DISBURSEMENT DATE OFFSET: Number of days prior to or after the first class start date of the student to schedule the disbursement.

Table RJRPAYL

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RJRPAYL

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RJRPAYL_AIDY_CODE	RJRPAYL_AIDY_CODE	VARCHAR2(4)	No	*	*
RJRPAYL_YEAR	RJRPAYL_YEAR	VARCHAR2(4)	No	*
RJRPAYL_PICT_CODE	RJRPAYL_PICT_CODE	VARCHAR2(2)	No	*
RJRPAYL_PAYNO	RJRPAYL_PAYNO	NUMBER(3,0)	No	*
RJRPAYL_TERM_CODE	RJRPAYL_TERM_CODE	VARCHAR2(6)	No		*
RJRPAYL_ACTIVITY_DATE	RJRPAYL_ACTIVITY_DATE	DATE	No
RJRPAYL_PROCESS_IND	RJRPAYL_PROCESS_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RJRPAYL_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RJRPAYL_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RJRPAYL	Unique	RJRPAYL_AIDY_CODE
PK_RJRPAYL	Unique	RJRPAYL_YEAR
PK_RJRPAYL	Unique	RJRPAYL_PICT_CODE
PK_RJRPAYL	Unique	RJRPAYL_PAYNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
lock_rjrpayl	C/C++ Function	[F:\BANNER\C\RJRLOAD.PC]	Use
sel_phrearn_1	C/C++ Function	[F:\BANNER\C\RJRLOAD.PC]	Use (select)
sel_phrearn_2	C/C++ Function	[F:\BANNER\C\RJRLOAD.PC]	Use (select)
upd_rjrpayl	C/C++ Function	[F:\BANNER\C\RJRLOAD.PC]	Use (update)
validate_payroll_id	C/C++ Function	[F:\BANNER\C\RJRLOAD.PC]	Use (select)
validate_payroll_id	C/C++ Function	[F:\BANNER\C\RJRPAYE.PC]	Use (select)
RJRPAYL	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
P_PA_RJRPAYL_EQUAL	Package procedure	"S4B70.SCT.COM".BANINST1.ROKPVAL	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RJRPAYL	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:24:000

Source Code Comments

Payroll Load Rules Table

Table RORCRHR

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RORCRHR

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RORCRHR_AIDY_CODE	RORCRHR_AIDY_CODE	VARCHAR2(4)	No	*	*
RORCRHR_LEVL_CODE	RORCRHR_LEVL_CODE	VARCHAR2(2)	No	*	*
RORCRHR_TERM_CODE	RORCRHR_TERM_CODE	VARCHAR2(6)	No	*	*
RORCRHR_ACTIVITY_DATE	RORCRHR_ACTIVITY_DATE	DATE	No
RORCRHR_FULL_TIME_CR_HRS	RORCRHR_FULL_TIME_CR_HRS	NUMBER(9,3)	Yes
RORCRHR_3QUARTER_CR_HRS	RORCRHR_3QUARTER_CR_HRS	NUMBER(9,3)	Yes
RORCRHR_HALF_TIME_CR_HRS	RORCRHR_HALF_TIME_CR_HRS	NUMBER(9,3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORCRHR_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RORCRHR_LEVL_CODE	STVLEVL_CODE	STVLEVL
RORCRHR_TERM_CODE	STVTERM_CODE	STVTERM
RORCRHR_TERM_CODE	SFRSTCR_TERM_CODE	SFRSTCR
RORCRHR_LEVL_CODE	SFRSTCR_LEVL_CODE	SFRSTCR
RORCRHR_LEVL_CODE	SGBSTDN_LEVL_CODE	SGBSTDN

Index

Index Name	Index Type	Column Name
PK_RORCRHR	Unique	RORCRHR_AIDY_CODE
PK_RORCRHR	Unique	RORCRHR_LEVL_CODE
PK_RORCRHR	Unique	RORCRHR_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UCL7	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL7	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD	Use (select)
UCL7	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD	Use (select)
UCL7	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD	Use (select)
UCL7	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL7	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD	Use (select)
check_curterm	C/C++ Function	[F:\BANNER\C\RRREXIT.PC]	Use (select)
check_preterm	C/C++ Function	[F:\BANNER\C\RRREXIT.PC]	Use (select)
chk_enrl_hrs	C/C++ Function	[F:\BANNER\C\RRREXIT.PC]	Use (select)
find_candidate	C/C++ Function	[F:\BANNER\C\RRREXIT.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL00.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL01.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL02.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL03.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL04.PC]	Use (select)
sel_rorcrhr	C/C++ Function	[F:\BANNER\C\RRRAREQ.PC]	Use (select)
select_enrollments	C/C++ Function	[F:\BANNER\C\RPBLMIE.PC]	Use (select)
RORCRHR	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
RORENRL	TABLE	"S4B70.SCT.COM".FAISMGR	Join
F_GET_DEFAULT_ENROLL_STATUS	Package function	"S4B70.SCT.COM".BANINST1.RPKLOAN	Rely On
P_CALC_LOAN_ENROLL_STATUS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Rely On
P_CALC_LOAN_ENROLL_STATUS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RORCRHR	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
SFRSTCR	TABLE	"S4B70.SCT.COM".SATURN	Join
SGBSTDN	TABLE	"S4B70.SCT.COM".SATURN	Join
STVLEVL	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

Credit Hours Table

Columns Comments for RORCRHR_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RORCRHR_LEVL_CODE (# 2)

Source Code Comments

LEVEL CODE: This field identifies the educational level associated with the valid credit hours.

Columns Comments for RORCRHR_TERM_CODE (# 3)

Source Code Comments

TERM CODE: This field represents the valid term code associated with the credit hours listed.

Columns Comments for RORCRHR_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Columns Comments for RORCRHR_FULL_TIME_CR_HRS (# 5)

Source Code Comments

FULL TIME CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled in order to be considered enrolled full time.

Columns Comments for RORCRHR_3QUARTER_CR_HRS (# 6)

Source Code Comments

THREE QUARTER CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled to be considered three quarter time.

Columns Comments for RORCRHR_HALF_TIME_CR_HRS (# 7)

Source Code Comments

HALF TIME CREDIT HOURS: This field identifies the number of credit hours a student must be enrolled in order to be considered enrolled on a half time basis.

Table RORENRL

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RORENRL

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RORENRL_PIDM	RORENRL_PIDM	NUMBER(8,0)	No	*
RORENRL_TERM_CODE	RORENRL_TERM_CODE	VARCHAR2(6)	No	*	*
RORENRL_FINAID_CREDIT_HR	RORENRL_FINAID_CREDIT_HR	NUMBER(9,3)	No
RORENRL_FINAID_BILL_HR	RORENRL_FINAID_BILL_HR	NUMBER(9,3)	No
RORENRL_ACTIVITY_DATE	RORENRL_ACTIVITY_DATE	DATE	No
RORENRL_FINAID_ADJ_HR	RORENRL_FINAID_ADJ_HR	NUMBER(9,3)	No
RORENRL_USER_ID	RORENRL_USER_ID	VARCHAR2(30)	Yes
RORENRL_SYS_IND	RORENRL_SYS_IND	VARCHAR2(1)	Yes
RORENRL_CONSORTIUM_IND	RORENRL_CONSORTIUM_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORENRL_TERM_CODE	STVTERM_CODE	STVTERM
RORENRL_TERM_CODE	RORCRHR_TERM_CODE	RORCRHR

Index

Index Name	Index Type	Column Name
PK_RORENRL	Unique	RORENRL_PIDM
PK_RORENRL	Unique	RORENRL_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
sel_halftime_enrl_b_a	C/C++ Function	[F:\BANNER\C\TSP1098.PC]	Use (select)
OCA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OCA-BOTH-AWARD-LOAN	Use (select)
PAA4-A	Cobol Paragraph	[F:\banner\cobol].RPEDISB.PAA-AWARD-ELIGIBLE	Use (select)
UCL5	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL5	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD	Use (select)
UCL5	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD	Use (select)
UCL5	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD	Use (select)
UCL5	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL5	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD	Use (select)
UCL6	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL6	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD	Use (select)
UCL6	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD	Use (select)
UCL6	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD	Use (select)
UCL6	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL6	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD	Use (select)
check_existence	C/C++ Function	[F:\BANNER\C\RSRENRL.PC]	Use (select)
ins_rorenrl	C/C++ Function	[F:\BANNER\C\RSRENRL.PC]	Use (Insert)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL00.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL01.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL02.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL03.PC]	Use (select)
sel_fa_term_count	C/C++ Function	[F:\BANNER\C\RERPL04.PC]	Use (select)
sel_rorenrl	C/C++ Function	[F:\BANNER\C\RRRAREQ.PC]	Use (select)
sel_rorenrl_full	C/C++ Function	[F:\BANNER\C\RORFS00.PC]	Use (select)
sel_rorenrl_full	C/C++ Function	[F:\BANNER\C\RORFS01.PC]	Use (select)
sel_rorenrl_full	C/C++ Function	[F:\BANNER\C\RORFS02.PC]	Use (select)
sel_rorenrl_full	C/C++ Function	[F:\BANNER\C\RORFS03.PC]	Use (select)
sel_rorenrl_full	C/C++ Function	[F:\BANNER\C\RORFS04.PC]	Use (select)
sel_rorenrl_less	C/C++ Function	[F:\BANNER\C\RORFS00.PC]	Use (select)
sel_rorenrl_less	C/C++ Function	[F:\BANNER\C\RORFS01.PC]	Use (select)
sel_rorenrl_less	C/C++ Function	[F:\BANNER\C\RORFS02.PC]	Use (select)
sel_rorenrl_less	C/C++ Function	[F:\BANNER\C\RORFS03.PC]	Use (select)
sel_rorenrl_less	C/C++ Function	[F:\BANNER\C\RORFS04.PC]	Use (select)
sel_rovstdn_1	C/C++ Function	[F:\BANNER\C\RORFS00.PC]	Use (select)
sel_rovstdn_1	C/C++ Function	[F:\BANNER\C\RORFS01.PC]	Use (select)
sel_rovstdn_1	C/C++ Function	[F:\BANNER\C\RORFS02.PC]	Use (select)
sel_rovstdn_1	C/C++ Function	[F:\BANNER\C\RORFS03.PC]	Use (select)
sel_rovstdn_1	C/C++ Function	[F:\BANNER\C\RORFS04.PC]	Use (select)
sel_sfrstcr_full_adj	C/C++ Function	[F:\BANNER\C\RORFS00.PC]	Use (select)
sel_sfrstcr_full_adj	C/C++ Function	[F:\BANNER\C\RORFS01.PC]	Use (select)
sel_sfrstcr_full_adj	C/C++ Function	[F:\BANNER\C\RORFS02.PC]	Use (select)
sel_sfrstcr_full_adj	C/C++ Function	[F:\BANNER\C\RORFS03.PC]	Use (select)
sel_sfrstcr_full_adj	C/C++ Function	[F:\BANNER\C\RORFS04.PC]	Use (select)
sel_sfrstcr_full_bill	C/C++ Function	[F:\BANNER\C\RORFS00.PC]	Use (select)
sel_sfrstcr_full_bill	C/C++ Function	[F:\BANNER\C\RORFS01.PC]	Use (select)
sel_sfrstcr_full_bill	C/C++ Function	[F:\BANNER\C\RORFS02.PC]	Use (select)
sel_sfrstcr_full_bill	C/C++ Function	[F:\BANNER\C\RORFS03.PC]	Use (select)
sel_sfrstcr_full_bill	C/C++ Function	[F:\BANNER\C\RORFS04.PC]	Use (select)
sel_sfrstcr_less_adj	C/C++ Function	[F:\BANNER\C\RORFS00.PC]	Use (select)
sel_sfrstcr_less_adj	C/C++ Function	[F:\BANNER\C\RORFS01.PC]	Use (select)
sel_sfrstcr_less_adj	C/C++ Function	[F:\BANNER\C\RORFS02.PC]	Use (select)
sel_sfrstcr_less_adj	C/C++ Function	[F:\BANNER\C\RORFS03.PC]	Use (select)
sel_sfrstcr_less_adj	C/C++ Function	[F:\BANNER\C\RORFS04.PC]	Use (select)
sel_sfrstcr_less_bill	C/C++ Function	[F:\BANNER\C\RORFS00.PC]	Use (select)
sel_sfrstcr_less_bill	C/C++ Function	[F:\BANNER\C\RORFS01.PC]	Use (select)
sel_sfrstcr_less_bill	C/C++ Function	[F:\BANNER\C\RORFS02.PC]	Use (select)
sel_sfrstcr_less_bill	C/C++ Function	[F:\BANNER\C\RORFS03.PC]	Use (select)
sel_sfrstcr_less_bill	C/C++ Function	[F:\BANNER\C\RORFS04.PC]	Use (select)
selmacro_i	C/C++ Function	[F:\BANNER\C\RSRENRL.PC]	Use (select)
selmacro_n	C/C++ Function	[F:\BANNER\C\RSRENRL.PC]	Use (select)
upd_rorenrl	C/C++ Function	[F:\BANNER\C\RSRENRL.PC]	Use (update)
RORENRL	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
RORATND	TABLE	"S4B70.SCT.COM".FAISMGR	Join
SFRSTCR	TABLE	"S4B70.SCT.COM".SATURN	Join
AR_FINAID_ENROLLMENT	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
RPVAWT2	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
F_CALC_STUD_ADJ_HRS	Package function	"S4B70.SCT.COM".BANINST1.ROKMISC	Rely On
F_CALC_STUD_BILL_HRS	Package function	"S4B70.SCT.COM".BANINST1.ROKMISC	Rely On
F_CALC_STUD_CREDIT_HRS	Package function	"S4B70.SCT.COM".BANINST1.ROKMISC	Rely On
F_GET_DEFAULT_ENROLL_STATUS	Package function	"S4B70.SCT.COM".BANINST1.RPKLOAN	Rely On
P_CALC_LOAN_ENROLL_STATUS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Rely On
P_CALC_LOAN_ENROLL_STATUS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RORENRL	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RORCRHR	TABLE	"S4B70.SCT.COM".FAISMGR	Join
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:24:000

Source Code Comments

Financial Aid Enrollment Table

Columns Comments for RORENRL_PIDM (# 1)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for RORENRL_TERM_CODE (# 2)

Source Code Comments

TERM CODE: The term in which the enrollment and billing hours are associated for this record.

Columns Comments for RORENRL_FINAID_CREDIT_HR (# 3)

Source Code Comments

FINANCIAL AID CREDIT HOURS: This field maintains the enrollment credit hours of the student in this record as of the financial aid cut-off date.

Columns Comments for RORENRL_FINAID_BILL_HR (# 4)

Source Code Comments

FINANCIAL AID BILLING HOURS: This field maintains the billing hours of the student as of the financial aid cut-off date.

Columns Comments for RORENRL_ACTIVITY_DATE (# 5)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RORENRL_FINAID_ADJ_HR (# 6)

Source Code Comments

FINANCIAL AID ADJUSTED HOURS: Calculated hours in a student's schedule excluding dropped and audited courses and including non-credit/remedial courses.

Columns Comments for RORENRL_USER_ID (# 7)

Source Code Comments

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

Columns Comments for RORENRL_SYS_IND (# 8)

Source Code Comments

SYSTEM/MANUAL INDICATOR: Indicator to show if the financial aid enrollment hours were assigned (M)anually or by the (S)ystem.

Columns Comments for RORENRL_CONSORTIUM_IND (# 9)

Source Code Comments

TERM CONSORTIUM INDICATOR: Allows students to be identified as consortium participants on a term by term basis.

Table RORSAPR

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RORSAPR

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RORSAPR_PIDM	RORSAPR_PIDM	NUMBER(8,0)	No	*
RORSAPR_TERM_CODE	RORSAPR_TERM_CODE	VARCHAR2(6)	No	*	*
RORSAPR_SAPR_CODE	RORSAPR_SAPR_CODE	VARCHAR2(6)	No		*
RORSAPR_ACTIVITY_DATE	RORSAPR_ACTIVITY_DATE	DATE	No
RORSAPR_SAPR_CODE_CALC	RORSAPR_SAPR_CODE_CALC	VARCHAR2(6)	Yes		*
RORSAPR_LOCK_IND	RORSAPR_LOCK_IND	VARCHAR2(1)	Yes
RORSAPR_SLCT_IND	RORSAPR_SLCT_IND	VARCHAR2(1)	Yes
RORSAPR_USER_ID	RORSAPR_USER_ID	VARCHAR2(30)	Yes
RORSAPR_DATA_ORIGIN	RORSAPR_DATA_ORIGIN	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORSAPR_SAPR_CODE	RTVSAPR_CODE	RTVSAPR
RORSAPR_SAPR_CODE_CALC	RTVSAPR_CODE	RTVSAPR
RORSAPR_TERM_CODE	STVTERM_CODE	STVTERM

Index

Index Name	Index Type	Column Name
PK_RORSAPR	Unique	RORSAPR_PIDM
PK_RORSAPR	Unique	RORSAPR_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SAA8D-CHECK-SAP	Cobol Paragraph	[F:\banner\cobol].ROBXREC.SAA-FETCH-SECT	Use (select)
UCP6K-SAP-VALIDATE	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use (select)
UCP6K-SAP-VALIDATE	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UVA-VALIDATE-AWARDS	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UVA-VALIDATE-AWARDS	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UVA-VALIDATE-AWARDS	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UVA-VALIDATE-AWARDS	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UVA-VALIDATE-AWARDS	Use (select)
UVD3	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UVD-VALIDATE-DISBURSEMENTS	Use (select)
UVD3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UVD-VALIDATE-DISBURSEMENTS	Use (select)
applicant_detail	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use
check_for_rorsapr	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
check_rorsapr_exists	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
check_rorsapr_lock_already_set	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
ins_rorsapr	C/C++ Function	[F:\BANNER\C\RCRTP00.PC]	Use (Insert,select)
ins_rorsapr	C/C++ Function	[F:\BANNER\C\RCRTP01.PC]	Use (Insert,select)
ins_rorsapr	C/C++ Function	[F:\BANNER\C\RCRTP02.PC]	Use (Insert,select)
ins_rorsapr	C/C++ Function	[F:\BANNER\C\RCRTP03.PC]	Use (Insert,select)
ins_rorsapr	C/C++ Function	[F:\BANNER\C\RCRTP04.PC]	Use (Insert,select)
ins_rorsapr	C/C++ Function	[F:\BANNER\C\RCRTP05.PC]	Use (Insert,select)
ins_rorsapr	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (Insert)
ins_rorsapr	C/C++ Function	[F:\BANNER\C\RCRTP06.PC]	Use (Insert,select)
ins_rorsapr_n	C/C++ Function	[F:\BANNER\C\RCRTP00.PC]	Use (Insert)
ins_rorsapr_n	C/C++ Function	[F:\BANNER\C\RCRTP01.PC]	Use (Insert)
ins_rorsapr_n	C/C++ Function	[F:\BANNER\C\RCRTP02.PC]	Use (Insert)
ins_rorsapr_n	C/C++ Function	[F:\BANNER\C\RCRTP03.PC]	Use (Insert)
ins_rorsapr_n	C/C++ Function	[F:\BANNER\C\RCRTP04.PC]	Use (Insert)
ins_rorsapr_n	C/C++ Function	[F:\BANNER\C\RCRTP05.PC]	Use (Insert)
ins_rorsapr_n	C/C++ Function	[F:\BANNER\C\RCRTP06.PC]	Use (Insert)
insert_rorsapr	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (Insert)
lock_rorsapr	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use
sel_rorsapr_lock	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
upd_rorsapr_code	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (update)
upd_rorsapr_lock	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (update)
ROBXREC	Cobol Program	F:\banner\cobol	Use
RORSAPR	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
AR_SATISFACTORY_ACAD_PROGRESS	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSA00	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSA01	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSA02	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSA03	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSA04	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSA05	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSA06	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSA07	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSAPR	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
P_CREATE	Package procedure	"S4B70.SCT.COM".BANINST1.RP_REQUIREMENT	Use (Insert,select)
RORSAPR_TAB_TYPE	Package Type	"S4B70.SCT.COM".BANINST1.ROKTABS	Rely On
PREV_SAP_CODE_C	Package cursor	"S4B70.SCT.COM".BANINST1.ROKSAPR	Use (select)
PREV_SAP_TERM_C	Package cursor	"S4B70.SCT.COM".BANINST1.ROKSAPR	Use (select)
P_ADD_RORSAPR	Package procedure	"S4B70.SCT.COM".BANINST1.ROKSAPR	Use (Insert,update)
P_ALL_RORSTAT_FOR_TERM	Package procedure	"S4B70.SCT.COM".BANINST1.ROKSAPR	Use (update)
P_ALL_SFBETRM_FOR_TERM	Package procedure	"S4B70.SCT.COM".BANINST1.ROKSAPR	Use (update)
P_DISPSAP	Package procedure	"S4B70.SCT.COM".BANINST1.BWRKSAPH	Rely On
P_DISPSUMM	Package procedure	"S4B70.SCT.COM".BANINST1.BWRKSUMM	Rely On
P_EXE_ROBBGRP	Package procedure	"S4B70.SCT.COM".BANINST1.ROKSAPR	Use (update)
P_GET_RORSAPR_RTVSAPR_ROWS	Package procedure	"S4B70.SCT.COM".BANINST1.ROKFUNC	Rely On
P_TRANSLATE_RULE	Package procedure	"S4B70.SCT.COM".BANINST1.ROKSAPR	Use (update)
P_VR_GET_FIN_HOLDS	Package procedure	"S4B70.SCT.COM".BANINST1.VRRKRGNS	Rely On
GETFASAPC	Package cursor	"S4B70.SCT.COM".BANINST1.BWRKSAPH	Use (select)Rely On
RORSAPR_ROW_BY_PIDM_C	Package cursor	"S4B70.SCT.COM".BANINST1.ROKSELS	Rely On
RORSAPR_ROW_BY_PIDM_C	Package cursor	"S4B70.SCT.COM".BANINST1.ROKSELS	Use (select)Rely On

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RORSAPR	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RTVSAPR	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

Satisfactory Academic Progress Rules Table

Columns Comments for RORSAPR_PIDM (# 1)

Source Code Comments

PIDM: Internal system-generated student identification number.

Columns Comments for RORSAPR_TERM_CODE (# 2)

Source Code Comments

TERM CODE: The term associated with the SAP code in this student's record.

Columns Comments for RORSAPR_SAPR_CODE (# 3)

Source Code Comments

SATISFACTORY ACADEMIC PROGRESS CODE: This field maintains the student's SAP c ode associated with the term code in this record.

Columns Comments for RORSAPR_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RORSAPR_SAPR_CODE_CALC (# 5)

Source Code Comments

CALCULATED SAP STATUS CODE: Code which represents the calculated academic progress of applicants and aid recipients for the most recently completed term.

Columns Comments for RORSAPR_LOCK_IND (# 6)

Source Code Comments

LOCK INDICATOR: This field identifies whether a lock exists on the particular SAP Status. The lock will maintain that student in its current status so that no changes can occur on that SAP Status either manually or in batch.

Columns Comments for RORSAPR_SLCT_IND (# 7)

Source Code Comments

SELECT INDICATOR: This field is used by the Batch Process and indicates whether the student has already been processed.

Columns Comments for RORSAPR_USER_ID (# 8)

Source Code Comments

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

Columns Comments for RORSAPR_DATA_ORIGIN (# 9)

Source Code Comments

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

Table RORTPRD

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RORTPRD

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RORTPRD_AIDY_CODE	RORTPRD_AIDY_CODE	VARCHAR2(4)	No	*	*
RORTPRD_APRD_CODE	RORTPRD_APRD_CODE	VARCHAR2(6)	No	*	*
RORTPRD_TERM_CODE	RORTPRD_TERM_CODE	VARCHAR2(6)	No	*	*
RORTPRD_ACTIVITY_DATE	RORTPRD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORTPRD_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RORTPRD_TERM_CODE	STVTERM_CODE	STVTERM
RORTPRD_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RORTPRD_AIDY_CODE	RPRDATE_AIDY_CODE	RPRDATE
RORTPRD_TERM_CODE	RPRDATE_TERM_CODE	RPRDATE
RORTPRD_APRD_CODE	RORSTAT_APRD_CODE	RORSTAT

Index

Index Name	Index Type	Column Name
PK_RORTPRD	Unique	RORTPRD_AIDY_CODE
PK_RORTPRD	Unique	RORTPRD_APRD_CODE
PK_RORTPRD	Unique	RORTPRD_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
main	C/C++ Function	[F:\BANNER\C\RNRTMAC.PC]	Use (select)
DQY-CK-AIDY-TERM	Cobol Paragraph	[F:\banner\cobol].ROBBGRP.DQY-ABORT-SECT	Use
MAA3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.MAA-MAINLINE	Use (select)
UCL2	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD	Use (select)
UCL2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD	Use (select)
UCL2	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD	Use (select)
UCL2	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD	Use (select)
applicant_detail	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
check_term_change	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
sel_aprd_code	C/C++ Function	[F:\BANNER\C\RFRFUND.PC]	Use (select)
sel_awrd_period	C/C++ Function	[F:\BANNER\C\IRRKTRN.PC]	Use (select)
sel_awrd_period	C/C++ Function	[F:\BANNER\C\RHRTRAN.PC]	Use (select)
sel_awrd_period	C/C++ Function	[F:\BANNER\C\RPBLMID.PC]	Use (select)
sel_enrollment_date	C/C++ Function	[F:\BANNER\C\RERPL00.PC]	Use (select)
sel_enrollment_date	C/C++ Function	[F:\BANNER\C\RERPL01.PC]	Use (select)
sel_enrollment_date	C/C++ Function	[F:\BANNER\C\RERPL02.PC]	Use (select)
sel_enrollment_date	C/C++ Function	[F:\BANNER\C\RERPL05.PC]	Use (select)
sel_enrollment_date	C/C++ Function	[F:\BANNER\C\RERPL03.PC]	Use (select)
sel_enrollment_date	C/C++ Function	[F:\BANNER\C\RERPL04.PC]	Use (select)
val_term_code	C/C++ Function	[F:\BANNER\C\RORGRDE.PC]	Use (select)
val_term_code	C/C++ Function	[F:\BANNER\C\RORREGS.PC]	Use (select)
RPEDISB	Cobol Program	F:\banner\cobol	Use
RORTPRD	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
AR_YEAR_TYPE_DEFINITION	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSTU3	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
P_CHECK_TERM_CHANGE	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_GET_ENROL_DATES	Package procedure	"S4B70.SCT.COM".BANINST1.RSKMISC	Use (select)
F_CHECK_FUTURE_TERM_DISBURSED	Package function	"S4B70.SCT.COM".BANINST1.ROKWFLB	Use (select)
F_CHECK_UNPROCESSED_AID	Package function	"S4B70.SCT.COM".BANINST1.ROKWFLB	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RORTPRD	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RORSTAT	TABLE	"S4B70.SCT.COM".FAISMGR	Join
RPRDATE	TABLE	"S4B70.SCT.COM".FAISMGR	Join
RTVAPRD	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:24:000

Source Code Comments

Aid Period/Term Code Table

Columns Comments for RORTPRD_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for RORTPRD_APRD_CODE (# 2)

Source Code Comments

AID PERIOD CODE: The aid period in which the valid terms are established.

Columns Comments for RORTPRD_TERM_CODE (# 3)

Source Code Comments

TERM CODE: Identifies the valid term codes within the Aid Year and Aid Period selected.

Columns Comments for RORTPRD_ACTIVITY_DATE (# 4)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated

Table RORVIEW

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RORVIEW

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
RORVIEW_SESSION_ID	RORVIEW_SESSION_ID	VARCHAR2(30)	No
RORVIEW_PIDM	RORVIEW_PIDM	NUMBER(8,0)	No	*
RORVIEW_TYPE_IND	RORVIEW_TYPE_IND	VARCHAR2(1)	No
RORVIEW_TERM_CODE	RORVIEW_TERM_CODE	VARCHAR2(6)	Yes	*
RORVIEW_AIDY_CODE	RORVIEW_AIDY_CODE	VARCHAR2(4)	Yes	*

Foreign Key information

Column name	is Foreign Key For Column	on Table
RORVIEW_PIDM	TBRACCD_PIDM	TBRACCD
RORVIEW_PIDM	TBBESTU_PIDM	TBBESTU
RORVIEW_PIDM	TBBCSTU_STU_PIDM	TBBCSTU
RORVIEW_TERM_CODE	STVTERM_CODE	STVTERM
RORVIEW_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

Index

Index Name	Index Type	Column Name
RORVIEW_KEY_INDEX	Unique	RORVIEW_SESSION_ID
RORVIEW_KEY_INDEX	Unique	RORVIEW_PIDM
RORVIEW_KEY_INDEX	Unique	RORVIEW_TYPE_IND
RORVIEW_KEY_INDEX	Unique	RORVIEW_TERM_CODE
RORVIEW_KEY_INDEX	Unique	RORVIEW_AIDY_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
DEL2	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.DEL-RORVIEW	Use (delete)
DEL2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.DEL-RORVIEW	Use (delete)
GRP-PREP-FETCH-CONT	Cobol Paragraph	[F:\banner\cobol].ROBBGRP.BAA-SECT	Use (delete)
INS2	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.INS-RORVIEW	Use (Insert)
INS2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.INS-RORVIEW	Use (Insert)
MAA3	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.MAA-MAINLINE	Use (Insert)
MAA3	Cobol Paragraph	[F:\banner\cobol].RPEPINT.MAA-MAINLINE	Use (Insert,delete)
MAA6	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.MAA-MAINLINE	Use (delete)
NAA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.NAA-LOAD-APPLICANT	Use (Insert)
PAA2	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.PAA-PROCESS-ONLINE-REQUEST	Use (Insert)
PAA3	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.PAA-PROCESS-ONLINE-REQUEST	Use (delete)
R01-ALL-PENDING	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use (Insert)
R01-ERROR-CHECK	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use
R01-LETR-PENDING	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use (Insert)
R01-PROCESS-RORVIEW	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use
R01-SELECTION	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use (Insert)
TAA1-INSERT-RORVIEW	Cobol Paragraph	[F:\banner\cobol].ROBXREC.TAA-RORVIEW-SECT	Use (Insert)
TAA2-DELETE-RORVIEW	Cobol Paragraph	[F:\banner\cobol].ROBXREC.TAA-RORVIEW-SECT	Use (delete)
VCD2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VCD-DELETE-VIEW	Use (delete)
W02-DELETE	Cobol Paragraph	[F:\banner\cobol].GLBLSEL.A01-INIT-EXIT-ORACLE	Use (delete)
del_rorview	C/C++ Function	[F:\BANNER\C\RORCALC.PC]	Use (delete)
del_rorview	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (delete)
del_rorview	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (delete)
ins_rorview_accd_no_popsel	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (Insert,select)
ins_rorview_accd_popsel	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (Insert,select)
ins_rorview_memo_no_popsel	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (Insert,select)
ins_rorview_memo_popsel	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (Insert,select)
sel_id_asc	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (select)
sel_id_desc	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (select)
sel_name_asc	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (select)
sel_name_desc	C/C++ Function	[F:\BANNER\C\RPRSBPR.PC]	Use (select)
ROBBGRP	Cobol Program	F:\banner\cobol	Use
ROBXREC	Cobol Program	F:\banner\cobol	Use
RPBVLDT	Cobol Program	F:\banner\cobol	Use
RPEDISB	Cobol Program	F:\banner\cobol	Use
RPEPCKG	Cobol Program	F:\banner\cobol	Use
RPEPELL	Cobol Program	F:\banner\cobol	Use
RPEPINT	Cobol Program	F:\banner\cobol	Use
RPOVLDT	Cobol Program	F:\banner\cobol	Use
RORVIEW	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
ROVCSUM	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVESUM	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVSTDD	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
ROVTRMG	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
RPVARCO	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
RPVAREX	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
RPVATRM	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
RPVTERM	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
R$_RORVIEW_FIND_DB	FUNCTION	"S4B70.SCT.COM".BANINST1	Use (select)
R$_RORVIEW_POST_DB	FUNCTION	"S4B70.SCT.COM".BANINST1	Use (Insert)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RORVIEW_KEY_INDEX	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)
TBBCSTU	TABLE	"S4B70.SCT.COM".TAISMGR	Join
TBBESTU	TABLE	"S4B70.SCT.COM".TAISMGR	Join
TBRACCD	TABLE	"S4B70.SCT.COM".TAISMGR	Join

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

View Selection Table

Table RPBLOPT

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RPBLOPT

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RPBLOPT_AIDY_CODE	RPBLOPT_AIDY_CODE	VARCHAR2(4)	No	*	*
RPBLOPT_CREATE_APP_IND	RPBLOPT_CREATE_APP_IND	VARCHAR2(1)	No
RPBLOPT_SAT_TREQ_IND	RPBLOPT_SAT_TREQ_IND	VARCHAR2(1)	No
RPBLOPT_MEMO_LOAN_AMT_IND	RPBLOPT_MEMO_LOAN_AMT_IND	VARCHAR2(1)	No
RPBLOPT_CREATE_AWARD_IND	RPBLOPT_CREATE_AWARD_IND	VARCHAR2(1)	No
RPBLOPT_USE_RQST_AMT_IND	RPBLOPT_USE_RQST_AMT_IND	VARCHAR2(1)	No
RPBLOPT_FUND_CODE	RPBLOPT_FUND_CODE	VARCHAR2(6)	No	*
RPBLOPT_ACTIVITY_DATE	RPBLOPT_ACTIVITY_DATE	DATE	No
RPBLOPT_LNST_CODE	RPBLOPT_LNST_CODE	VARCHAR2(4)	Yes		*
RPBLOPT_LENDER_ID	RPBLOPT_LENDER_ID	VARCHAR2(6)	Yes
RPBLOPT_TREQ_CODE	RPBLOPT_TREQ_CODE	VARCHAR2(6)	Yes		*
RPBLOPT_TRST_CODE	RPBLOPT_TRST_CODE	VARCHAR2(1)	Yes		*
RPBLOPT_AWST_CODE	RPBLOPT_AWST_CODE	VARCHAR2(4)	Yes		*
RPBLOPT_CREATE_APP_TREQ_IND	RPBLOPT_CREATE_APP_TREQ_IND	VARCHAR2(1)	Yes
RPBLOPT_DL_PN_REQ_ORIG_IND	RPBLOPT_DL_PN_REQ_ORIG_IND	VARCHAR2(1)	Yes
RPBLOPT_DL_DISB_REQ_ORIG_IND	RPBLOPT_DL_DISB_REQ_ORIG_IND	VARCHAR2(1)	Yes
RPBLOPT_DL_ORIG_REQ_DISB_IND	RPBLOPT_DL_ORIG_REQ_DISB_IND	VARCHAR2(1)	Yes
RPBLOPT_DL_PN_REQ_DISB_IND	RPBLOPT_DL_PN_REQ_DISB_IND	VARCHAR2(1)	Yes
RPBLOPT_RETURN_PIDM	RPBLOPT_RETURN_PIDM	NUMBER(8,0)	Yes
RPBLOPT_LENDER_PIDM	RPBLOPT_LENDER_PIDM	NUMBER(8,0)	Yes
RPBLOPT_GUAR_PIDM	RPBLOPT_GUAR_PIDM	NUMBER(8,0)	Yes
RPBLOPT_CERT_REQUEST_AMT_IND	RPBLOPT_CERT_REQUEST_AMT_IND	VARCHAR2(1)	Yes
RPBLOPT_DETAIL_CODE_RET_STU	RPBLOPT_DETAIL_CODE_RET_STU	VARCHAR2(4)	Yes
RPBLOPT_DETAIL_CODE_LNDR_PMT	RPBLOPT_DETAIL_CODE_LNDR_PMT	VARCHAR2(4)	Yes
RPBLOPT_DETAIL_CODE_LNDR_REF	RPBLOPT_DETAIL_CODE_LNDR_REF	VARCHAR2(4)	Yes
RPBLOPT_AUTHORIZE_IND	RPBLOPT_AUTHORIZE_IND	VARCHAR2(1)	Yes
RPBLOPT_DISB_AMT_IND	RPBLOPT_DISB_AMT_IND	VARCHAR2(1)	Yes
RPBLOPT_EL_AUDIT_IND	RPBLOPT_EL_AUDIT_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPBLOPT_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RPBLOPT_AWST_CODE	RTVAWST_CODE	RTVAWST
RPBLOPT_LNST_CODE	RTVLNST_CODE	RTVLNST
RPBLOPT_TREQ_CODE	RTVTREQ_CODE	RTVTREQ
RPBLOPT_TRST_CODE	RTVTRST_CODE	RTVTRST
RPBLOPT_AIDY_CODE	RPRLPAP_AIDY_CODE	RPRLPAP

Index

Index Name	Index Type	Column Name
PK_RPBLOPT	Unique	RPBLOPT_AIDY_CODE
PK_RPBLOPT	Unique	RPBLOPT_FUND_CODE
RPBLOPT_FUND_INDEX		RPBLOPT_FUND_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UAARTN	Cobol Program	F:\banner\cobol	Use (select)
OBA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OBA-LOAN-ONLY	Use (select)
OCA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OCA-BOTH-AWARD-LOAN	Use (select)
OCA3-A	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OCA-BOTH-AWARD-LOAN	Use (select)
UAP2-1	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAP-ADD-LOAN-APP	Use (select)
UAP2-1	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAP-ADD-LOAN-APP	Use (select)
UAP2-1	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAP-ADD-LOAN-APP	Use (select)
UAP2-1	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAP-ADD-LOAN-APP	Use (select)
UVD2A	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UVD-VALIDATE-DISBURSEMENTS	Use (select)
UVD2A	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UVD-VALIDATE-DISBURSEMENTS	Use (select)
VDA3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VDA-SELECT-FUND	Use (select)
execute_fund_roll	C/C++ Function	[F:\BANNER\C\ROPROLL.PC]	Use (Insert,select)
fetch_n_process	C/C++ Function	[F:\BANNER\C\RPRLORE.PC]	Use (select)
get_lnst	C/C++ Function	[F:\BANNER\C\RPRLORC.PC]	Use (select)
get_lopt	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
process_row	C/C++ Function	[F:\BANNER\C\RPRLORE.PC]	Use (select)
RPBLOPT	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
RRRAREQ	TABLE	"S4B70.SCT.COM".FAISMGR	Join
P_ADD_LOAN_APPL_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
P_GET_LOAN_OPTION_IND	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
PKG_RPBLOPT_CREATE_APP_IND	Package variable	"S4B70.SCT.COM".BANINST1.RPKAWIU	Rely On
PKG_RPBLOPT_SAT_TREQ_IND	Package variable	"S4B70.SCT.COM".BANINST1.RPKAWIU	Rely On
PKG_RPBLOPT_TREQ_CODE	Package variable	"S4B70.SCT.COM".BANINST1.RPKAWIU	Rely On
PKG_RPBLOPT_TRST_CODE	Package variable	"S4B70.SCT.COM".BANINST1.RPKAWIU	Rely On
PKG_RPBLOPT_CREATE_APP_IND	Package variable	"S4B70.SCT.COM".BANINST1.RPKAWDL	Rely On
P_ADD_AWARD_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)
P_ADD_AWARD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)
P_ADD_LOAN_PROCESS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)
P_SELECT_DL_DISB_REQUIRED	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE05	Use (select)
P_SELECT_DL_DISB_REQUIRED	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE06	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE05	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE05	Use (select)
P_SELECT_DL_PNOTE_REQUIRED	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE06	Rely On
P_SELECT_DL_PNOTE_REQUIRED	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE06	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPBLOPT	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RPBLOPT_FUND_INDEX	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RPRLPAP	TABLE	"S4B70.SCT.COM".FAISMGR	Join
RTVAWST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RTVLNST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RTVTREQ	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RTVTRST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:24:000

Source Code Comments

Loan Options Table

Columns Comments for RPBLOPT_AIDY_CODE (# 1)

Source Code Comments

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

Columns Comments for RPBLOPT_CREATE_APP_IND (# 2)

Source Code Comments

CREATE APPLICATION INDICATOR: This indicator determines whether a loan accepted within the Packaging Module will automatically create a loan application. Valid values are (Y)es and (N)o which defaults to (N)o.

Columns Comments for RPBLOPT_SAT_TREQ_IND (# 3)

Source Code Comments

SATISFY LOAN APPLICATION REQUIREMENT INDICATOR: This field indicates whether a loan application requirement will should be satisfied by the entry of aa loan application. Valid values are (Y)es or (N)o with a default of (N)o.

Columns Comments for RPBLOPT_MEMO_LOAN_AMT_IND (# 4)

Source Code Comments

MEMO ACTUAL LOAN AMOUNT INDICATOR: This indicator determines whether the actual loan amounts on the Loan Term Schedule Table (RPRLATR) will be used during memo'ing. Valid values are (Y)es or (N)o, defaults to (N)o.

Columns Comments for RPBLOPT_CREATE_AWARD_IND (# 5)

Source Code Comments

CREATE AWARD INDICATOR: This indicator determines whether a loan application entered in the loan module should automatically create an award if one does not exist within the applicant's package. Valid values (Y)es and (N)o.

Columns Comments for RPBLOPT_USE_RQST_AMT_IND (# 6)

Source Code Comments

USE REQUESTED AMOUNT INDICATOR: This field determines whether the award amount when posted should be posted as the loan requested amount, or as a zero. (Y)es indicates to post the student's award with the requested loan amount.

Columns Comments for RPBLOPT_FUND_CODE (# 7)

Source Code Comments

FUND CODE: This field identifies the fund code that will be added to the students award record if the Create Award Indicator is set to (Y)es.

Columns Comments for RPBLOPT_ACTIVITY_DATE (# 8)

Source Code Comments

ACTIVITY DATE: This field maintains the date that information in this record was entered or last updated.

Columns Comments for RPBLOPT_LNST_CODE (# 9)

Source Code Comments

INITIAL LOAN STATUS: This field is used to identify the loan status to be used when the system creates a loan application. This can only be maintained when the loan accepted indicator is set to (Y)es.

Columns Comments for RPBLOPT_LENDER_ID (# 10)

Source Code Comments

DEFAULT LENDER ID: This code identifies the default lender ID to be used during loan processing.

Columns Comments for RPBLOPT_TREQ_CODE (# 11)

Source Code Comments

LOAN APPLICATION TRACKING REQUIREMENT CODE: This field identifies the tracking requirement code to be used when the system satisfies a loan application requirement. This can only be maintained when Satis.Loan Req. Indicator= (Y).

Columns Comments for RPBLOPT_TRST_CODE (# 12)

Source Code Comments

TRACKING REQUIREMENT STATUS CODE: This code identifies the requirement status code to be used when the system satisfies a loan application requirement. This can only be maintained when the Satisfy Loan Application Indicator is (Y)es.

Columns Comments for RPBLOPT_AWST_CODE (# 13)

Source Code Comments

AWARD STATUS CODE: This field identifies the award status code which a loan award will be added to the students award record if the Create Award indicator is set to (Y)es.

Columns Comments for RPBLOPT_CREATE_APP_TREQ_IND (# 14)

Source Code Comments

Indicator to be used for creation of a loan application when the loan application tracking requirement is satisfied

Columns Comments for RPBLOPT_RETURN_PIDM (# 19)

Source Code Comments

RETURN PIDM: The internal pidm for the default Agency/Lender to whom unused funds are to be returned for this loan code.

Columns Comments for RPBLOPT_LENDER_PIDM (# 20)

Source Code Comments

LENDER PIDM: The internal pidm for the default Lender associated with this loan code.

Columns Comments for RPBLOPT_GUAR_PIDM (# 21)

Source Code Comments

GUARANTOR PIDM: The internal pidm for the default Guarantee Agency associated with this loan code.

Columns Comments for RPBLOPT_CERT_REQUEST_AMT_IND (# 22)

Source Code Comments

CERTIFICATION REQUEST AMOUNT INDICATOR: If the loan requested amount is required for certification, this will be Y.

Columns Comments for RPBLOPT_DETAIL_CODE_RET_STU (# 23)

Source Code Comments

RETURNED CHECK STUDENT DETAIL CODE: The charge/payment detail code to be used on the student account when a returned check amount is processed by the disbursement process.

Columns Comments for RPBLOPT_DETAIL_CODE_LNDR_PMT (# 24)

Source Code Comments

RETURNED CHECK LENDER PAYMENT DETAIL CODE: The payment detail code to be used on the lender account when a returned check amount is processed on a student account by the disbursement process.

Columns Comments for RPBLOPT_DETAIL_CODE_LNDR_REF (# 25)

Source Code Comments

RETURNED CHECK LENDER REFUND DETAIL CODE: The charge detail code to be used on the lender account to allow a refund to the lender when a returned check amount is processed on a student account by
the disbursement process.

Columns Comments for RPBLOPT_AUTHORIZE_IND (# 26)

Source Code Comments

LOAN AUTHORIZATION INDICATOR: Indicates whether to create loan authorizations for this aid year and fund code when disbursing funds.

Columns Comments for RPBLOPT_DISB_AMT_IND (# 27)

Source Code Comments

LOAN DISBURSEMENT AMOUNT INDICATOR: This field indicates whether to prevent loan disbursement if Disbursement Amount > Award Amount.

Columns Comments for RPBLOPT_EL_AUDIT_IND (# 28)

Source Code Comments

CHANGE TRANSACTION INDICATOR: Flags whether or not the school will use CommonLine Change Transaction processing. Default value is Null. Valid values: Y yes, Null means No.

Table RPBOPTS

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RPBOPTS

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RPBOPTS_AIDY_CODE	RPBOPTS_AIDY_CODE	VARCHAR2(4)	No	*	*
RPBOPTS_EST_ENROLL_PELL_IND	RPBOPTS_EST_ENROLL_PELL_IND	VARCHAR2(1)	No
RPBOPTS_DEFAULT_OPTION_IND	RPBOPTS_DEFAULT_OPTION_IND	VARCHAR2(1)	No
RPBOPTS_INTERFACE_EXEMPT_IND	RPBOPTS_INTERFACE_EXEMPT_IND	VARCHAR2(1)	No
RPBOPTS_INTERFACE_3PARTY_IND	RPBOPTS_INTERFACE_3PARTY_IND	VARCHAR2(1)	No
RPBOPTS_ACTIVITY_DATE	RPBOPTS_ACTIVITY_DATE	DATE	No
RPBOPTS_PCKG_USING_TFC_IND	RPBOPTS_PCKG_USING_TFC_IND	VARCHAR2(1)	Yes
RPBOPTS_MASS_ACCEPT_IND	RPBOPTS_MASS_ACCEPT_IND	VARCHAR2(1)	Yes
RPBOPTS_DISB_ACT_ENROLL_IND	RPBOPTS_DISB_ACT_ENROLL_IND	VARCHAR2(1)	Yes
RPBOPTS_OFFER_EXP_DAYS	RPBOPTS_OFFER_EXP_DAYS	VARCHAR2(3)	Yes
RPBOPTS_TRST_CODE	RPBOPTS_TRST_CODE	VARCHAR2(1)	Yes		*
RPBOPTS_ALWAYS_USE_EST_IND	RPBOPTS_ALWAYS_USE_EST_IND	VARCHAR2(1)	Yes
RPBOPTS_ASSUME_FULL_TIME_IND	RPBOPTS_ASSUME_FULL_TIME_IND	VARCHAR2(1)	Yes
RPBOPTS_3QUARTER_TIME_PCT	RPBOPTS_3QUARTER_TIME_PCT	NUMBER(6,3)	Yes
RPBOPTS_HALF_TIME_PCT	RPBOPTS_HALF_TIME_PCT	NUMBER(6,3)	Yes
RPBOPTS_LESS_HALF_TIME_PCT	RPBOPTS_LESS_HALF_TIME_PCT	NUMBER(6,3)	Yes
RPBOPTS_USE_AR_IND	RPBOPTS_USE_AR_IND	VARCHAR2(1)	Yes
RPBOPTS_ADDL_STFD_ELIG_DEF_IND	RPBOPTS_ADDL_STFD_ELIG_DEF_IND	VARCHAR2(1)	Yes
RPBOPTS_AWRD_HIST_SRC_IND	RPBOPTS_AWRD_HIST_SRC_IND	VARCHAR2(1)	Yes
RPBOPTS_PCKG_CFLAGS_IND	RPBOPTS_PCKG_CFLAGS_IND	VARCHAR2(1)	Yes
RPBOPTS_DISB_CFLAGS_IND	RPBOPTS_DISB_CFLAGS_IND	VARCHAR2(1)	Yes
RPBOPTS_PELL_DISB_IND	RPBOPTS_PELL_DISB_IND	VARCHAR2(1)	Yes
RPBOPTS_PELL_LT_HALF_COA	RPBOPTS_PELL_LT_HALF_COA	NUMBER(9,0)	Yes
RPBOPTS_ALLOW_MEMO_IND	RPBOPTS_ALLOW_MEMO_IND	VARCHAR2(1)	Yes
RPBOPTS_PELL_EFC_DISB_IND	RPBOPTS_PELL_EFC_DISB_IND	VARCHAR2(1)	Yes
RPBOPTS_PELL_NSLDS_IND	RPBOPTS_PELL_NSLDS_IND	VARCHAR2(1)	Yes
RPBOPTS_ZERO_PELL_AWRD_DEL_IND	RPBOPTS_ZERO_PELL_AWRD_DEL_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPBOPTS_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RPBOPTS_TRST_CODE	RTVTRST_CODE	RTVTRST

Index

Index Name	Index Type	Column Name
PK_RPBOPTS	Unique	RPBOPTS_AIDY_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UAARTN	Cobol Program	F:\banner\cobol	Use (select)
BAA3	Cobol Paragraph	[F:\banner\cobol].RPEPELL.BAA-START-UP	Use (select)
BAA5-5	Cobol Paragraph	[F:\banner\cobol].RPEDISB.BAA-PARAMETER-VALIDATION	Use (select)
FILL-LOAD-ARRAY-OPTION-COL	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD	Use (select)
FILL-LOAD-ARRAY-OPTION-COL	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD	Use (select)
FILL-LOAD-ARRAY-OPTION-COL	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD	Use (select)
FILL-LOAD-ARRAY-OPTION-COL	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD	Use (select)
FILL-LOAD-ARRAY-OPTION-COL	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD	Use (select)
FILL-LOAD-ARRAY-OPTION-COL	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD	Use (select)
MAA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.MAA-MAINLINE	Use (select)
MAA2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.MAA-MAINLINE	Use (select)
PEA2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.PEA-MAINTAIN-AWARD	Use (select)
TAB1-SELECT-RPBOPTS	Cobol Paragraph	[F:\banner\cobol].ROBXREC.TAB-RPBOPTS-SECT	Use (select)
UAE2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAE-UPDATE-TRACKING	Use (select)
UAE2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAE-UPDATE-TRACKING	Use (select)
UAE2	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAE-UPDATE-TRACKING	Use (select)
UAE2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAE-UPDATE-TRACKING	Use (select)
UCL3	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCL-CALCULATE-LOAD	Use (select)
UCL3	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UCL-CALCULATE-LOAD	Use (select)
UCL3	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UCL-CALCULATE-LOAD	Use (select)
UCL3	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UCL-CALCULATE-LOAD	Use (select)
UCL3	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCL-CALCULATE-LOAD	Use (select)
UCP2C	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UCP-CALCULATE-PELL-AWARD	Use (select)
UCP2C	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UCP-CALCULATE-PELL-AWARD	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UVA-VALIDATE-AWARDS	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UVA-VALIDATE-AWARDS	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UVA-VALIDATE-AWARDS	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UVA-VALIDATE-AWARDS	Use (select)
UVA13-A	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UVA-VALIDATE-AWARDS	Use (select)
UVA17-AA	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UVA-VALIDATE-AWARDS	Use (select)
UVA17-AA	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UVA-VALIDATE-AWARDS	Use (select)
UVA17-AA	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UVA-VALIDATE-AWARDS	Use (select)
UVA17-AA	Cobol Paragraph	[F:\banner\cobol].RPOVLDT.UVA-VALIDATE-AWARDS	Use (select)
UVA17-AA	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UVA-VALIDATE-AWARDS	Use (select)
UVD3	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.UVD-VALIDATE-DISBURSEMENTS	Use (select)
UVD3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UVD-VALIDATE-DISBURSEMENTS	Use (select)
execute_packaging_roll	C/C++ Function	[F:\BANNER\C\ROPROLL.PC]	Use (Insert,select)
get_aidy_defaults	C/C++ Function	[F:\BANNER\C\RPRELAP.PC]	Use (select)
get_offer_exp_days	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
ins_rrrareq	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
sel_lhalf_coa	C/C++ Function	[F:\BANNER\C\RERPL00.PC]	Use (select)
sel_lhalf_coa	C/C++ Function	[F:\BANNER\C\RERPL01.PC]	Use (select)
sel_lhalf_coa	C/C++ Function	[F:\BANNER\C\RERPL02.PC]	Use (select)
sel_lhalf_coa	C/C++ Function	[F:\BANNER\C\RERPL03.PC]	Use (select)
sel_lhalf_coa	C/C++ Function	[F:\BANNER\C\RERPL04.PC]	Use (select)
sel_rpbopts	C/C++ Function	[F:\BANNER\C\RRRAREQ.PC]	Use (select)
sel_rpbopts	C/C++ Function	[F:\BANNER\C\RERPL00.PC]	Use (select)
sel_rpbopts	C/C++ Function	[F:\BANNER\C\RERPL01.PC]	Use (select)
sel_rpbopts	C/C++ Function	[F:\BANNER\C\RERPL02.PC]	Use (select)
sel_rpbopts	C/C++ Function	[F:\BANNER\C\RERPL03.PC]	Use (select)
sel_rpbopts	C/C++ Function	[F:\BANNER\C\RERPL04.PC]	Use (select)
upd_perkins_mpn_tracking	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
ROBXREC	Cobol Program	F:\banner\cobol	Use
RPEDISB	Cobol Program	F:\banner\cobol	Use
RPBOPTS	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
RORSTAT	TABLE	"S4B70.SCT.COM".FAISMGR	Join
RPVCRES	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
P_ADD_AWARD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Rely On
P_ADD_FUND_REQUIREMENTS	Package procedure	"S4B70.SCT.COM".BANINST1.RRKAREQ	Use (select)
P_GET_PCKG_LOAD_IND	Package procedure	"S4B70.SCT.COM".BANINST1.RPKAWIU	Use (select)
PKG_PCKG_LOAD_IND	Package variable	"S4B70.SCT.COM".BANINST1.RPKAWIU	Rely On
F_CALC_CONTRACTS	Package function	"S4B70.SCT.COM".BANINST1.RNKNEED	Rely On
F_CALC_CONTRACTS	Package function	"S4B70.SCT.COM".BANINST1.RNKNEED	Use (select)
F_CALC_EXEMPTIONS	Package function	"S4B70.SCT.COM".BANINST1.RNKNEED	Rely On
F_CALC_EXEMPTIONS	Package function	"S4B70.SCT.COM".BANINST1.RNKNEED	Use (select)
PKG_PCKG_LOAD_IND	Package variable	"S4B70.SCT.COM".BANINST1.RPKAWDL	Rely On
P_ADD_AWARD_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)
P_ADD_AWARD_TERM_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)
P_CALC_LOAN_ENROLL_STATUS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Rely On
P_CALC_LOAN_ENROLL_STATUS	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)
P_GET_PCKG_LOAD_IND	Package procedure	"S4B70.SCT.COM".BANINST1.RPKLOAN	Use (select)
P_UPD2_AWARD_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKTERM	Use (select)
P_UPD_AWARD_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RPKTERM	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPBOPTS	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RTVTRST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:23:000

Source Code Comments

Packaging Options Table

Columns Comments for RPBOPTS_AIDY_CODE (# 1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. ,

Columns Comments for RPBOPTS_EST_ENROLL_PELL_IND (# 2)

Source Code Comments

ESTIMATED ENROLLMENT INDICATOR: This field determines whether the applicant's estimated enrollment is to be used during the Awarding Process. Field defaults to value of (Y)es.

Columns Comments for RPBOPTS_DEFAULT_OPTION_IND (# 3)

Source Code Comments

DEFAULT ESTIMATED ENROLLMENT: The value in this field is used if the 'Use estimated enrollment' indicator is not checked. Also used if 'Use estimated enrollment' indicator is checked but the RCRAPP1 expected enrollment field is null.

Columns Comments for RPBOPTS_INTERFACE_EXEMPT_IND (# 4)

Source Code Comments

INTERFACE EXEMPTIONS INDICATOR: This field indicates whether the institution wishes to interface exemptions from the banner student system.

Columns Comments for RPBOPTS_INTERFACE_3PARTY_IND (# 5)

Source Code Comments

INTERFACE THIRD PARTY CONTRACTS: This field indicates whether the institution wishes to interface third party contracts from the banner student system.

Columns Comments for RPBOPTS_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that information fo this record in the table was entered or last updated.

Columns Comments for RPBOPTS_PCKG_USING_TFC_IND (# 7)

Source Code Comments

PACKAGE USING ESTIMATED TFC INDICATOR: A packaging option which allows the institution to package using estimated TFC.

Columns Comments for RPBOPTS_MASS_ACCEPT_IND (# 8)

Source Code Comments

MASS ACCEPTANCE INDICATOR: A packaging option which allows the institution to allow award mass acceptance.

Columns Comments for RPBOPTS_DISB_ACT_ENROLL_IND (# 9)

Source Code Comments

DISBURSE USING ACTUAL ENROLLMENT INDICATOR: Indicates whether the institution chooses to disburse funds based on actual enrollment.

Columns Comments for RPBOPTS_OFFER_EXP_DAYS (# 10)

Source Code Comments

OFFER EXPIRATION DAYS: A packaging option which allows the institution to determine the number of days that a financial aid offer is valid prior to expiration. Identifies the number of days to be added to the offer date.

Columns Comments for RPBOPTS_TRST_CODE (# 11)

Source Code Comments

TRACKING REQUIREMENT STATUS CODE: Allows the institution to define the tracking requirement status code which will be posted to the applicants tracking record as a fund is packaged.

Columns Comments for RPBOPTS_ALWAYS_USE_EST_IND (# 12)

Source Code Comments

ALWAYS USE ESTIMATED INDICATOR: This field indicates whether estimates should be used for exemptions and third party contracts.

Columns Comments for RPBOPTS_ASSUME_FULL_TIME_IND (# 13)

Source Code Comments

ASSUME FULL-TIME INDICATOR: Indicates whether the institution wishes to assume full-time enrollment when packaging exemptions and contracts.

Columns Comments for RPBOPTS_3QUARTER_TIME_PCT (# 14)

Source Code Comments

THREE QUARTER TIME PERCENT: Represents the percentage of the contract or exemption to use if the student is enrolled on a three-quarter time basis.

Columns Comments for RPBOPTS_HALF_TIME_PCT (# 15)

Source Code Comments

HALF-TIME PERCENT: Indicates the percentage of the contract or exemption which will be considered in packaging if the student is enrolled on a half time basis.

Columns Comments for RPBOPTS_LESS_HALF_TIME_PCT (# 16)

Source Code Comments

LESS THAN HALF TIME PERCENT: Indicates the percentage of the contract or exemption to consider in packaging if the student is enrolled on a less than half time basis.

Columns Comments for RPBOPTS_USE_AR_IND (# 17)

Source Code Comments

USE AR INDICATOR: This disbursement option controls if payments can be made to the student account if the charges haven't been accepted.

Columns Comments for RPBOPTS_ADDL_STFD_ELIG_DEF_IND (# 18)

Source Code Comments

ADDITIONAL STAFFORD ELIGIBILITY INDICATOR DEFAULT: Default indicator for additional stafford eligibility.

Columns Comments for RPBOPTS_AWRD_HIST_SRC_IND (# 19)

Source Code Comments

AWARD HISTORY SOURCE INDICATOR: Indicates which source of award history to use during award packaging and disbursement validation. B or blank - Banner, N - NSLDS.

Columns Comments for RPBOPTS_PCKG_CFLAGS_IND (# 20)

Source Code Comments

PACKAGE C-FLAGS INDICATOR: Indicates whether Packaging should occur if SAR C-Flags exist. Y or blank - Package even if C-Flags exist. N - Do not package if C-Flags exist.

Columns Comments for RPBOPTS_DISB_CFLAGS_IND (# 21)

Source Code Comments

DISBURSE C-FLAGS INDICATOR: Indicates whether Disbursement should occur if SAR C-Flags exist. Y or blank - Disburse even if C-Flags exist. N - Do not disburse if C-Flags exist.

Columns Comments for RPBOPTS_PELL_DISB_IND (# 22)

Source Code Comments

PELL DISBURSEMENT INDICATOR: Indicates if disbursement amount, award amount or a zero amount should be used for PELL disbursement when award and disbursement amounts are not equal.

Columns Comments for RPBOPTS_PELL_LT_HALF_COA (# 23)

Source Code Comments

PELL LESS THAN HALF TIME COA: Default PELL Cost of Attendance for students who are enrolled for less than half time.

Columns Comments for RPBOPTS_ALLOW_MEMO_IND (# 24)

Source Code Comments

ALLOW MEMO INDICATOR: This field indicates whether to allow memoing when disbursement has been backed out.

Columns Comments for RPBOPTS_PELL_EFC_DISB_IND (# 25)

Source Code Comments

PELL PAYMENT CELL EFC INDICATOR: This field indicates whether to disburse Pell when System EFC and SAR EFC are not equal but are within the same PELL payment cell.

Columns Comments for RPBOPTS_PELL_NSLDS_IND (# 26)

Source Code Comments

PELL NSLDS INDICATOR: A value of 'Y' indicates that NSLDS Pell award information will be used in the calculation of Pell awards. The Pell award received at this school will be reduced by any Pell award amounts received at other schools.

Columns Comments for RPBOPTS_ZERO_PELL_AWRD_DEL_IND (# 27)

Source Code Comments

PELL DELETE ZERO AWARD: A 'Y' indicates that Pell awards will be physically deleted from the database if the award is reduced to 0 by the Pell calculation, if no locks, originations, memo, authorization, or paid amounts exist.

Table RPRADSB

Server Name S4B70.SCT.COM
Database Name FAISMGR
Table Label RPRADSB

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
RPRADSB_AIDY_CODE	RPRADSB_AIDY_CODE	VARCHAR2(4)	No	*
RPRADSB_PIDM	RPRADSB_PIDM	NUMBER(8,0)	No	*
RPRADSB_SCHEDULE_DATE	RPRADSB_SCHEDULE_DATE	DATE	No
RPRADSB_FUND_CODE	RPRADSB_FUND_CODE	VARCHAR2(6)	No	*
RPRADSB_TERM_CODE	RPRADSB_TERM_CODE	VARCHAR2(6)	No	*
RPRADSB_ACTIVITY_DATE	RPRADSB_ACTIVITY_DATE	DATE	No
RPRADSB_SCHEDULE_AMT	RPRADSB_SCHEDULE_AMT	NUMBER(11,2)	Yes
RPRADSB_DISBURSE_DATE	RPRADSB_DISBURSE_DATE	DATE	Yes
RPRADSB_DISBURSE_AMT	RPRADSB_DISBURSE_AMT	NUMBER(11,2)	Yes
RPRADSB_TRAN_NUMBER	RPRADSB_TRAN_NUMBER	NUMBER(8,0)	Yes
RPRADSB_DISBURSE_PCT	RPRADSB_DISBURSE_PCT	NUMBER(6,3)	Yes
RPRADSB_DISBURSE_LOAD	RPRADSB_DISBURSE_LOAD	VARCHAR2(1)	Yes
RPRADSB_DISBURSE_LOAD_OPT	RPRADSB_DISBURSE_LOAD_OPT	VARCHAR2(1)	Yes
RPRADSB_LMS_FEED_IND	RPRADSB_LMS_FEED_IND	VARCHAR2(1)	Yes
RPRADSB_PELL_CALC_DISB_AMT	RPRADSB_PELL_CALC_DISB_AMT	NUMBER(11,2)	Yes
RPRADSB_PELLC_DISB_LOAD	RPRADSB_PELLC_DISB_LOAD	VARCHAR2(1)	Yes
RPRADSB_PELLC_DISB_LOAD_OPT	RPRADSB_PELLC_DISB_LOAD_OPT	VARCHAR2(1)	Yes
RPRADSB_DISB_BATCH_NO	RPRADSB_DISB_BATCH_NO	VARCHAR2(26)	Yes
RPRADSB_DISB_REF_NO	RPRADSB_DISB_REF_NO	NUMBER(2,0)	Yes
RPRADSB_DEBIT_CR_IND	RPRADSB_DEBIT_CR_IND	VARCHAR2(1)	Yes
RPRADSB_DISB_AMT	RPRADSB_DISB_AMT	NUMBER(7,2)	Yes
RPRADSB_DISB_ACTION_CODE	RPRADSB_DISB_ACTION_CODE	VARCHAR2(1)	Yes
RPRADSB_DISB_ACK_REF_NO	RPRADSB_DISB_ACK_REF_NO	NUMBER(2,0)	Yes
RPRADSB_DISB_ACPT_DEBIT_CR_IND	RPRADSB_DISB_ACPT_DEBIT_CR_IND	VARCHAR2(1)	Yes
RPRADSB_DISB_ACPT_AMT	RPRADSB_DISB_ACPT_AMT	NUMBER(7,2)	Yes
RPRADSB_DISB_ACPT_DATE	RPRADSB_DISB_ACPT_DATE	DATE	Yes
RPRADSB_YTD_AMT_PAID	RPRADSB_YTD_AMT_PAID	NUMBER(7,2)	Yes
RPRADSB_EDIT_REJ_01	RPRADSB_EDIT_REJ_01	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_02	RPRADSB_EDIT_REJ_02	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_03	RPRADSB_EDIT_REJ_03	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_04	RPRADSB_EDIT_REJ_04	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_05	RPRADSB_EDIT_REJ_05	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_06	RPRADSB_EDIT_REJ_06	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_07	RPRADSB_EDIT_REJ_07	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_08	RPRADSB_EDIT_REJ_08	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_09	RPRADSB_EDIT_REJ_09	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_10	RPRADSB_EDIT_REJ_10	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_11	RPRADSB_EDIT_REJ_11	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_12	RPRADSB_EDIT_REJ_12	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_13	RPRADSB_EDIT_REJ_13	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_14	RPRADSB_EDIT_REJ_14	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_15	RPRADSB_EDIT_REJ_15	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_16	RPRADSB_EDIT_REJ_16	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_17	RPRADSB_EDIT_REJ_17	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_18	RPRADSB_EDIT_REJ_18	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_19	RPRADSB_EDIT_REJ_19	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_20	RPRADSB_EDIT_REJ_20	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_21	RPRADSB_EDIT_REJ_21	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_22	RPRADSB_EDIT_REJ_22	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_23	RPRADSB_EDIT_REJ_23	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_24	RPRADSB_EDIT_REJ_24	VARCHAR2(3)	Yes
RPRADSB_EDIT_REJ_25	RPRADSB_EDIT_REJ_25	VARCHAR2(3)	Yes
RPRADSB_SHARED_SAR_ID_FLAG	RPRADSB_SHARED_SAR_ID_FLAG	VARCHAR2(1)	Yes
RPRADSB_VERIF_W_STATUS_FLAG	RPRADSB_VERIF_W_STATUS_FLAG	VARCHAR2(1)	Yes
RPRADSB_CONCUR_ENROLL_FLAG	RPRADSB_CONCUR_ENROLL_FLAG	VARCHAR2(1)	Yes
RPRADSB_POTENTIAL_OVERPMT_FLAG	RPRADSB_POTENTIAL_OVERPMT_FLAG	VARCHAR2(1)	Yes
RPRADSB_ORIG_ID	RPRADSB_ORIG_ID	VARCHAR2(23)	Yes
RPRADSB_INST_XREF	RPRADSB_INST_XREF	VARCHAR2(9)	Yes
RPRADSB_DISB_DATE_SENT	RPRADSB_DISB_DATE_SENT	DATE	Yes
RPRADSB_DISB_DATE	RPRADSB_DISB_DATE	DATE	Yes
RPRADSB_PAY_PD_NUMBER	RPRADSB_PAY_PD_NUMBER	RAW(1)	Yes
RPRADSB_PAY_PD_START_DATE	RPRADSB_PAY_PD_START_DATE	DATE	Yes
RPRADSB_PAY_PD_END_DATE	RPRADSB_PAY_PD_END_DATE	RAW(14)	Yes
RPRADSB_NBR_MTHS_PAY	RPRADSB_NBR_MTHS_PAY	RAW(1)	Yes
RPRADSB_PAY_PD_TOTAL	RPRADSB_PAY_PD_TOTAL	RAW(11)	Yes
RPRADSB_PAY_PD_ACAD_CAL	RPRADSB_PAY_PD_ACAD_CAL	RAW(1)	Yes
RPRADSB_PAY_PD_PMT_METH	RPRADSB_PAY_PD_PMT_METH	RAW(1)	Yes
RPRADSB_PAY_PD_ATTEND_COST	RPRADSB_PAY_PD_ATTEND_COST	RAW(11)	Yes
RPRADSB_PAY_PD_ENRL_STAT	RPRADSB_PAY_PD_ENRL_STAT	RAW(1)	Yes
RPRADSB_PAY_PD_EXPECT_WKS	RPRADSB_PAY_PD_EXPECT_WKS	RAW(2)	Yes
RPRADSB_WKS_IN_YR	RPRADSB_WKS_IN_YR	RAW(2)	Yes
RPRADSB_PAY_PD_EXPECT_HRS	RPRADSB_PAY_PD_EXPECT_HRS	RAW(4)	Yes
RPRADSB_HRS_IN_YR	RPRADSB_HRS_IN_YR	RAW(4)	Yes
RPRADSB_ACPT_PAY_PD_NUMBER	RPRADSB_ACPT_PAY_PD_NUMBER	RAW(1)	Yes
RPRADSB_ACPT_PAY_PD_START_DATE	RPRADSB_ACPT_PAY_PD_START_DATE	DATE	Yes
RPRADSB_ACPT_PAY_PD_END_DATE	RPRADSB_ACPT_PAY_PD_END_DATE	RAW(14)	Yes
RPRADSB_ACPT_NBR_MTHS_PAY	RPRADSB_ACPT_NBR_MTHS_PAY	RAW(1)	Yes
RPRADSB_ACPT_PAY_PD_TOTAL	RPRADSB_ACPT_PAY_PD_TOTAL	RAW(11)	Yes
RPRADSB_ACPT_PAY_PD_ACAD_CAL	RPRADSB_ACPT_PAY_PD_ACAD_CAL	RAW(1)	Yes
RPRADSB_ACPT_PAY_PD_PMT_METH	RPRADSB_ACPT_PAY_PD_PMT_METH	RAW(1)	Yes
RPRADSB_ACPT_PAY_PD_ATTEND_CST	RPRADSB_ACPT_PAY_PD_ATTEND_CST	RAW(11)	Yes
RPRADSB_ACPT_PAY_PD_ENRL_STAT	RPRADSB_ACPT_PAY_PD_ENRL_STAT	RAW(1)	Yes
RPRADSB_ACPT_PAY_PD_EXPECT_WKS	RPRADSB_ACPT_PAY_PD_EXPECT_WKS	RAW(2)	Yes
RPRADSB_ACPT_WKS_IN_YR	RPRADSB_ACPT_WKS_IN_YR	RAW(2)	Yes
RPRADSB_ACPT_PAY_PD_EXPECT_HRS	RPRADSB_ACPT_PAY_PD_EXPECT_HRS	RAW(4)	Yes
RPRADSB_ACPT_HRS_IN_YR	RPRADSB_ACPT_HRS_IN_YR	RAW(4)	Yes
RPRADSB_DISB_LOCK_IND	RPRADSB_DISB_LOCK_IND	VARCHAR2(1)	Yes
RPRADSB_PAY_PD_RPT_REG	RPRADSB_PAY_PD_RPT_REG	NUMBER(7,2)	Yes
RPRADSB_ACPT_PAY_PD_RPT_REG	RPRADSB_ACPT_PAY_PD_RPT_REG	NUMBER(7,2)	Yes
RPRADSB_ALTERNATE_PELL_IND	RPRADSB_ALTERNATE_PELL_IND	VARCHAR2(1)	Yes
RPRADSB_USER_ID	RPRADSB_USER_ID	VARCHAR2(30)	Yes
RPRADSB_DISB_SEQ_NO	RPRADSB_DISB_SEQ_NO	NUMBER(2,0)	Yes
RPRADSB_ACPT_DISB_SEQ_NO	RPRADSB_ACPT_DISB_SEQ_NO	NUMBER(2,0)	Yes
RPRADSB_DOCUMENT_ID	RPRADSB_DOCUMENT_ID	VARCHAR2(30)	Yes
RPRADSB_DISB_NET_AMT	RPRADSB_DISB_NET_AMT	NUMBER(7,2)	Yes
RPRADSB_ACPT_PREV_DISB_SEQ_NO	RPRADSB_ACPT_PREV_DISB_SEQ_NO	NUMBER(2,0)	Yes
RPRADSB_DISB_SCHED_NO_DAYS	RPRADSB_DISB_SCHED_NO_DAYS	NUMBER(3,0)	Yes
RPRADSB_SYS_IND	RPRADSB_SYS_IND	VARCHAR2(1)	Yes
RPRADSB_DATA_ORIGIN	RPRADSB_DATA_ORIGIN	VARCHAR2(30)	Yes
RPRADSB_CPS_VER_IND	RPRADSB_CPS_VER_IND	VARCHAR2(1)	Yes
RPRADSB_HIGHEST_CPS_TRAN_NO	RPRADSB_HIGHEST_CPS_TRAN_NO	VARCHAR2(2)	Yes
RPRADSB_EXCL_FROM_NET_AMT	RPRADSB_EXCL_FROM_NET_AMT	VARCHAR2(1)	Yes
RPRADSB_EDIT_FIELD_1		VARCHAR2(35)	Yes
RPRADSB_EDIT_VALUE_1		VARCHAR2(150)	Yes
RPRADSB_EDIT_FIELD_2		VARCHAR2(35)	Yes
RPRADSB_EDIT_VALUE_2		VARCHAR2(150)	Yes
RPRADSB_EDIT_FIELD_3		VARCHAR2(35)	Yes
RPRADSB_EDIT_VALUE_3		VARCHAR2(150)	Yes
RPRADSB_EDIT_FIELD_4		VARCHAR2(35)	Yes
RPRADSB_EDIT_VALUE_4		VARCHAR2(150)	Yes
RPRADSB_EDIT_FIELD_5		VARCHAR2(35)	Yes
RPRADSB_EDIT_VALUE_5		VARCHAR2(150)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRADSB_AIDY_CODE	RPRATRM_AIDY_CODE	RPRATRM
RPRADSB_PIDM	RPRATRM_PIDM	RPRATRM
RPRADSB_FUND_CODE	RPRATRM_FUND_CODE	RPRATRM
RPRADSB_TERM_CODE	RPRATRM_TERM_CODE	RPRATRM
RPRADSB_TERM_CODE	STVTERM_CODE	STVTERM
RPRADSB_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RPRADSB_FUND_CODE	RFRBASE_FUND_CODE	RFRBASE

Index

Index Name	Index Type	Column Name
RPRADSB_DISB_BATCH_INDEX		RPRADSB_DISB_BATCH_NO
RPRADSB_DOCUMENT_ID_INDEX		RPRADSB_DOCUMENT_ID
RPRADSB_KEY2_INDEX		RPRADSB_AIDY_CODE
RPRADSB_KEY2_INDEX		RPRADSB_FUND_CODE
RPRADSB_KEY2_INDEX		RPRADSB_TERM_CODE
RPRADSB_KEY_INDEX		RPRADSB_PIDM
RPRADSB_KEY_INDEX		RPRADSB_AIDY_CODE
RPRADSB_KEY_INDEX		RPRADSB_FUND_CODE
RPRADSB_KEY_INDEX		RPRADSB_TERM_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
UAARTN	Cobol Program	F:\banner\cobol	Use (Insert,delete,select)
CAB2	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.CAB-OPEN-DISBURSE-CURSOR	Use (select)
NAB2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.NAB-VERIFY-TERMS	Use (select)
OAA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OAA-AWARD-ONLY	Use (select)
OAA3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OAA-AWARD-ONLY	Use (select)
OAA3-A	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OAA-AWARD-ONLY	Use (select)
OAA3-B	Cobol Paragraph	[F:\banner\cobol].RPEDISB.OAA-AWARD-ONLY	Use (select)
OCA2	Cobol Paragraph	[F:\banner\cobol].RPBVLDT.OCA-BATCH-DISBURSE	Use (select)
PAG2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.PAG-AUTHORIZE	Use (select)
PAG2-A-REMAINING-SCHEDULED	Cobol Paragraph	[F:\banner\cobol].RPEDISB.PAG-AUTHORIZE	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAA-MAINTAIN-AWARD	Use (select)
UAA7	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAA-MAINTAIN-AWARD	Use (select)
UAA7A	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAA-MAINTAIN-AWARD	Use (select)
UAA7A	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAA-MAINTAIN-AWARD	Use (select)
UAA7A	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAA-MAINTAIN-AWARD	Use (select)
UAA7A	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAA-MAINTAIN-AWARD	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAEX2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAEX-UPDATE-PERK-TRACKING	Use (select)
UAH2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAH-UPDATE-AWARD-SCHEDULE	Use (delete)
UAH2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAH-UPDATE-AWARD-SCHEDULE	Use (delete)
UAH2	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAH-UPDATE-AWARD-SCHEDULE	Use (delete)
UAH2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAH-UPDATE-AWARD-SCHEDULE	Use (delete)
UAH3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAH-UPDATE-AWARD-SCHEDULE	Use (delete)
UAH3	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAH-UPDATE-AWARD-SCHEDULE	Use (delete)
UAH3	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAH-UPDATE-AWARD-SCHEDULE	Use (delete)
UAH3	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAH-UPDATE-AWARD-SCHEDULE	Use (delete)
UAI2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAI-DELETE-DISBURSE-SCHEDULE	Use (delete)
UAI2	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAI-DELETE-DISBURSE-SCHEDULE	Use (delete)
UAI2	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAI-DELETE-DISBURSE-SCHEDULE	Use (delete)
UAI2	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAI-DELETE-DISBURSE-SCHEDULE	Use (delete)
UAJ3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAJ-ADD-DISBURSE-SCHEDULE	Use (Insert)
UAJ3	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAJ-ADD-DISBURSE-SCHEDULE	Use (Insert)
UAJ3	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAJ-ADD-DISBURSE-SCHEDULE	Use (Insert)
UAJ3	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAJ-ADD-DISBURSE-SCHEDULE	Use (Insert)
UAK5	Cobol Paragraph	[F:\banner\cobol].RPEDISB.UAK-UPDATE-DISBURSE-SCHEDULE	Use (Insert,select)
UAK5	Cobol Paragraph	[F:\banner\cobol].RPEPCKG.UAK-UPDATE-DISBURSE-SCHEDULE	Use (Insert,select)
UAK5	Cobol Paragraph	[F:\banner\cobol].RPEPINT.UAK-UPDATE-DISBURSE-SCHEDULE	Use (Insert,select)
UAK5	Cobol Paragraph	[F:\banner\cobol].RPEPELL.UAK-UPDATE-DISBURSE-SCHEDULE	Use (Insert,select)
VAD2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VAD-UPDTE-ADSB	Use (update)
VAD3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VAD3-APPLY-PELL-RULES	Use (select)
VADA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VADA-UPDTE-ADSB	Use (update)
VAK2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VAK-GET-PAID-SCHEDULED	Use (select)
VAK3	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VAK-GET-PAID-SCHEDULED	Use (select)
VBB2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VBB-INSERT-ADSB	Use (Insert)
VBBA2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VBBA-INSERT-ADSB	Use (Insert)
VED2	Cobol Paragraph	[F:\banner\cobol].RPEDISB.VED-COUNT-PAID	Use (select)
applicant_detail	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
calc_pell_disb_amt	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (select)
calc_pell_disb_amt	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (select)
check_disb_exists	C/C++ Function	[F:\BANNER\C\RERFI00.PC]	Use (select)
check_disb_exists	C/C++ Function	[F:\BANNER\C\RERFI01.PC]	Use (select)
check_disb_exists	C/C++ Function	[F:\BANNER\C\RERFI02.PC]	Use (select)
check_disb_exists	C/C++ Function	[F:\BANNER\C\RERFI03.PC]	Use (select)
check_disb_exists	C/C++ Function	[F:\BANNER\C\RERFI04.PC]	Use (select)
check_disb_exists	C/C++ Function	[F:\BANNER\C\RERFI05.PC]	Use (select)
chk_for_disb_status	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
chk_for_disb_status2	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
count_disb	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
count_term_code	C/C++ Function	[F:\BANNER\C\RPRADSB.PC]	Use (select)
count_term_code	C/C++ Function	[F:\BANNER\C\RPRAWDB.PC]	Use (select)
delete_disburse_defd	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (delete)
delete_disburse_manual	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (delete)
delete_disburse_rec	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (delete)
fetch_sum	C/C++ Function	[F:\BANNER\C\RERFI01.PC]	Use (select)
fetch_sum	C/C++ Function	[F:\BANNER\C\RERFI02.PC]	Use (select)
fetch_sum	C/C++ Function	[F:\BANNER\C\RERFI03.PC]	Use (select)
fetch_sum	C/C++ Function	[F:\BANNER\C\RERFI04.PC]	Use (select)
fetch_sum	C/C++ Function	[F:\BANNER\C\RERFI05.PC]	Use (select)
gen_pell_disb_ref_no	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (select)
gen_pell_disb_ref_no	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (select)
gen_pell_disb_ref_no_adj	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (select)
gen_pell_disb_ref_no_adj	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (select)
gen_pell_disb_seq_no	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (select)
gen_pell_disb_seq_no	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (select)
generate_ref_no	C/C++ Function	[F:\BANNER\C\RERPL00.PC]	Use (select)
generate_ref_no	C/C++ Function	[F:\BANNER\C\RERPL01.PC]	Use (select)
generate_ref_no	C/C++ Function	[F:\BANNER\C\RERPL02.PC]	Use (select)
generate_ref_no	C/C++ Function	[F:\BANNER\C\RERPL03.PC]	Use (select)
generate_ref_no	C/C++ Function	[F:\BANNER\C\RERPL04.PC]	Use (select)
get_PellDisbDateSeq01	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (select)
get_PellDisbDateSeq01	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (select)
init_var_table	C/C++ Function	[F:\BANNER\C\RPRADSB.PC]	Use
ins_disburse_exception	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (Insert,select)
ins_disburse_standard	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (Insert,select)
ins_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI00.PC]	Use (Insert,select)
ins_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI01.PC]	Use (Insert,select)
ins_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI02.PC]	Use (Insert,select)
ins_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI03.PC]	Use (Insert,select)
ins_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI04.PC]	Use (Insert,select)
ins_rpradsb_9x	C/C++ Function	[F:\BANNER\C\RERFI00.PC]	Use (Insert)
ins_rpradsb_9x	C/C++ Function	[F:\BANNER\C\RERFI01.PC]	Use (Insert)
ins_rpradsb_9x	C/C++ Function	[F:\BANNER\C\RERFI02.PC]	Use (Insert)
ins_rpradsb_9x	C/C++ Function	[F:\BANNER\C\RERFI03.PC]	Use (Insert)
ins_rpradsb_9x	C/C++ Function	[F:\BANNER\C\RERFI04.PC]	Use (Insert)
lock_rpradsb	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use
sel_disb_pay_pd_start_date	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (select)
sel_disb_pay_pd_start_date	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (select)
sel_disb_pay_pd_start_date	C/C++ Function	[F:\BANNER\C\RERPL02.PC]	Use (select)
sel_disb_pay_pd_start_date	C/C++ Function	[F:\BANNER\C\RERPL03.PC]	Use (select)
sel_disb_pay_pd_start_date	C/C++ Function	[F:\BANNER\C\RERPL04.PC]	Use (select)
sel_original_disb_amt	C/C++ Function	[F:\BANNER\C\RERFI00.PC]	Use (select)
sel_original_disb_amt	C/C++ Function	[F:\BANNER\C\RERFI01.PC]	Use (select)
sel_original_disb_amt	C/C++ Function	[F:\BANNER\C\RERFI02.PC]	Use (select)
sel_original_disb_amt	C/C++ Function	[F:\BANNER\C\RERFI03.PC]	Use (select)
sel_original_disb_amt	C/C++ Function	[F:\BANNER\C\RERFI04.PC]	Use (select)
sel_rpradsb	C/C++ Function	[F:\BANNER\C\RERPR04.PC]	Use (select)
sel_rpradsb	C/C++ Function	[F:\BANNER\C\RERPR05.PC]	Use (select)
sel_src_pell_addl	C/C++ Function	[F:\BANNER\C\RHRTRAN.PC]	Use (select)
sel_src_pell_addl	C/C++ Function	[F:\BANNER\C\IRRKTRN.PC]	Use (select)
select_loans	C/C++ Function	[F:\BANNER\C\RPBLMID.PC]	Use (select)
select_status_change	C/C++ Function	[F:\BANNER\C\RPBLMID.PC]	Use (select)
selmacro_fund_id	C/C++ Function	[F:\BANNER\C\RPRADSB.PC]	Use (select)
selmacro_fund_name	C/C++ Function	[F:\BANNER\C\RPRADSB.PC]	Use (select)
selmacro_id	C/C++ Function	[F:\BANNER\C\RPRADSB.PC]	Use (select)
selmacro_name	C/C++ Function	[F:\BANNER\C\RPRADSB.PC]	Use (select)
upd_disb_rec	C/C++ Function	[F:\BANNER\C\RPBLMID.PC]	Use (update)
upd_perkins_mpn_tracking	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (select)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI00.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI01.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI02.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI03.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERFI04.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERPL00.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERPL01.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERPL02.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERPL03.PC]	Use (update)
upd_rpradsb	C/C++ Function	[F:\BANNER\C\RERPL04.PC]	Use (update)
upd_rpradsb_net_disb_amt	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (update)
upd_rpradsb_net_disb_amt	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (update)
upd_rpradsb_ref_no	C/C++ Function	[F:\BANNER\C\REREX04.PC]	Use (update)
upd_rpradsb_ref_no	C/C++ Function	[F:\BANNER\C\REREX05.PC]	Use (update)
upd_rpradsb_schedule_date	C/C++ Function	[F:\BANNER\C\RORBPST.PC]	Use (update)
upd_rpradsb_spec	C/C++ Function	[F:\BANNER\C\RERFI00.PC]	Use (update)
upd_rpradsb_spec	C/C++ Function	[F:\BANNER\C\RERFI01.PC]	Use (update)
upd_rpradsb_spec	C/C++ Function	[F:\BANNER\C\RERPL00.PC]	Use (update)
upd_rpradsb_spec	C/C++ Function	[F:\BANNER\C\RERPL01.PC]	Use (update)
ROBXREC	Cobol Program	F:\banner\cobol	Use
RPEDISB	Cobol Program	F:\banner\cobol	Use
RPRADSB	SYNONYM	"S4B70.SCT.COM".PUBLIC	Rely On
AR_AWARD_DISBURSEMENT	VIEW	"S4B70.SCT.COM".BANINST1	Use (select)
F_GET_PCKG_LOAD_IND	FUNCTION	"S4B70.SCT.COM".BANINST1	Use (select)
AWARD_DISBURSEMENT_REC	Package Type	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
PAYMENT_TYPE	Package Type	"S4B70.SCT.COM".BANINST1.BWRKPAYS	Rely On
P_RESCHED_FUND_TERM_DISBURSE	Package procedure	"S4B70.SCT.COM".BANINST1.ROKMISC	Rely On
P_RESCHED_FUND_YEAR_DISBURSE	Package procedure	"S4B70.SCT.COM".BANINST1.ROKMISC	Rely On
P_RESCHED_FUND_YEAR_DISBURSE	Package procedure	"S4B70.SCT.COM".BANINST1.ROKMISC	Use (select)
P_RESCHED_TERM_DISBURSE	Package procedure	"S4B70.SCT.COM".BANINST1.ROKMISC	Rely On
P_RESCHED_YEAR_DISBURSE	Package procedure	"S4B70.SCT.COM".BANINST1.ROKMISC	Rely On
P_RESCHED_YEAR_DISBURSE	Package procedure	"S4B70.SCT.COM".BANINST1.ROKMISC	Use (select)
F_GET_VALID_SCHEDULE_DATE	Package function	"S4B70.SCT.COM".BANINST1.ROKMISC	Rely On
F_GET_VALID_SCHEDULE_DATE	Package function	"S4B70.SCT.COM".BANINST1.ROKMISC	Use (select)
P_OVERLAY_VALIDATION_REC	Package procedure	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
P_UPDATEPELLDISB	Package procedure	"S4B70.SCT.COM".BANINST1.REKCI04	Rely On
P_UPDATEPELLDISB	Package procedure	"S4B70.SCT.COM".BANINST1.REKCI04	Use (Insert,update,select)Rely On
CALC_DISB_IND	Package cursor	"S4B70.SCT.COM".BANINST1.ROKSUMM	Use (select)
DISBURSE_PCT	Package variable	"S4B70.SCT.COM".BANINST1.BWRKPAYS	Rely On
RPRADSB_ROW	Package variable	"S4B70.SCT.COM".BANINST1.REKCI06	Rely On
RPRADSB_ROW	Package variable	"S4B70.SCT.COM".BANINST1.REKCI04	Rely On
RPRADSB_ROW	Package variable	"S4B70.SCT.COM".BANINST1.REKCI05	Rely On
F_BUILD_RPRADSB_REC	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
F_COUNT_RPRADSB	Package function	"S4B70.SCT.COM".BANINST1.RB_PELL_ORIGINATIONS	Use (select)
F_GET_RPRADSB_DATE	Package function	"S4B70.SCT.COM".BANINST1.RB_REQUIREMENT	Rely On
F_GET_RPRADSB_DATE	Package function	"S4B70.SCT.COM".BANINST1.RB_REQUIREMENT	Use (select)
F_PACKAGE_LOCKED	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_PAID	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_SELECT_PELL_DISB_SUM	Package function	"S4B70.SCT.COM".BANINST1.REKCI06	Rely On
F_SELECT_PELL_DISB_SUM	Package function	"S4B70.SCT.COM".BANINST1.REKCI06	Use (select)
F_SELECT_PELL_DISB_SUM	Package function	"S4B70.SCT.COM".BANINST1.REKCI04	Rely On
F_SELECT_PELL_DISB_SUM	Package function	"S4B70.SCT.COM".BANINST1.REKCI04	Use (select)
F_SELECT_PELL_DISB_SUM	Package function	"S4B70.SCT.COM".BANINST1.REKCI05	Rely On
F_SELECT_PELL_DISB_SUM	Package function	"S4B70.SCT.COM".BANINST1.REKCI05	Use (select)
F_SENT	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
P_CALC_PELL_DATA	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE05	Rely On
P_CALC_PELL_DATA	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE05	Use (select)
P_CALC_PELL_DATA	Package procedure	"S4B70.SCT.COM".BANINST1.REKCEXX	Rely On
P_CALC_PELL_DATA	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE06	Rely On
P_CALC_PELL_DATA	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE06	Use (select)
P_CREATE	Package procedure	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
P_DELETE	Package procedure	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
P_DELETE	Package procedure	"S4B70.SCT.COM".BANINST1.DML_RPRADSB	Use (delete)
P_DISPPAYSCHED	Package procedure	"S4B70.SCT.COM".BANINST1.BWRKPAYS	Rely On
P_INSERT	Package procedure	"S4B70.SCT.COM".BANINST1.DML_RPRADSB	Use (Insert)Rely On
P_LOCK	Package procedure	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
P_REGISTER_ENTITY	Package procedure	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT_RULES	Rely On
P_UPDATE	Package procedure	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
P_UPDATE	Package procedure	"S4B70.SCT.COM".BANINST1.DML_RPRADSB	Rely On
P_UPDATE_PELL_DISBURSEMENT	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE05	Rely On
P_UPDATE_PELL_DISBURSEMENT	Package procedure	"S4B70.SCT.COM".BANINST1.REKCEXX	Rely On
P_UPDATE_PELL_DISBURSEMENT	Package procedure	"S4B70.SCT.COM".BANINST1.REKCE06	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Package procedure	"S4B70.SCT.COM".BANINST1.REKCI06	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Package procedure	"S4B70.SCT.COM".BANINST1.REKCI06	Use (select)Rely On
P_UPDATE_PELL_DISBURSEMENTS	Package procedure	"S4B70.SCT.COM".BANINST1.REKCI05	Rely On
P_UPDATE_PELL_DISBURSEMENTS	Package procedure	"S4B70.SCT.COM".BANINST1.REKCI05	Use (select)Rely On
P_UPDATE_PELL_DISBURSEMENTS	Package procedure	"S4B70.SCT.COM".BANINST1.REKCIXX	Rely On
P_VALIDATE	Package procedure	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT_RULES	Rely On
P_VALIDATE_DATE	Package procedure	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT_RULES	Rely On
UT_SETUP	Package procedure	"S4B70.SCT.COM".BANINST1.UT_RB_PELL_ORIGINATIONS	Use (Insert)
GETPAYITEMC	Package cursor	"S4B70.SCT.COM".BANINST1.BWRKPAYS	Use (select)
F_EXISTS	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_PARENT_EXISTS	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT_RULES	Rely On
F_QUERY_ALL	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
F_QUERY_ALL	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_QUERY_BY_ROWID	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_QUERY_ONE	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
F_QUERY_ONE	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_QUERY_ONE_LOCK	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Rely On
F_QUERY_ONE_LOCK	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT	Use (select)
F_SELECT_PELL_AWARDS	Package function	"S4B70.SCT.COM".BANINST1.REKCE05	Use (select)
F_SELECT_PELL_AWARDS	Package function	"S4B70.SCT.COM".BANINST1.REKCE06	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Package function	"S4B70.SCT.COM".BANINST1.REKCE05	Rely On
F_SELECT_PELL_DISBURSEMENTS	Package function	"S4B70.SCT.COM".BANINST1.REKCE05	Use (select)
F_SELECT_PELL_DISBURSEMENTS	Package function	"S4B70.SCT.COM".BANINST1.REKCEXX	Rely On
F_SELECT_PELL_DISBURSEMENTS	Package function	"S4B70.SCT.COM".BANINST1.REKCE06	Rely On
F_SELECT_PELL_DISBURSEMENTS	Package function	"S4B70.SCT.COM".BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Package function	"S4B70.SCT.COM".BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Package function	"S4B70.SCT.COM".BANINST1.REKCE06	Use (select)
F_TERM_DATE_EXISTS	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT_RULES	Rely On
F_TERM_DATE_EXISTS	Package function	"S4B70.SCT.COM".BANINST1.RB_AWARD_DISBURSEMENT_RULES	Use (select)

No calling Objects

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRADSB_DISB_BATCH_INDEX	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RPRADSB_DOCUMENT_ID_INDEX	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RPRADSB_KEY2_INDEX	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RPRADSB_KEY_INDEX	INDEX	"S4B70.SCT.COM".FAISMGR	Rely On
RT_RPRADSB_LOG_INSUPDDTL	TRIGGER	"S4B70.SCT.COM".FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RPRADSB_USERACTIVIT_INSUPD	TRIGGER	"S4B70.SCT.COM".FAISMGR	Fire (Insert,update,before,each row)
RFRBASE	TABLE	"S4B70.SCT.COM".FAISMGR	Join
ROBINST	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
RPRATRM	TABLE	"S4B70.SCT.COM".FAISMGR	Refer (no action)
STVTERM	TABLE	"S4B70.SCT.COM".SATURN	Refer (no action)

No called Objects

Object Dates

Creation Date	Analysis Date
12/13/2005 01:46:40:000	12/13/2005 19:35:24:000

Source Code Comments

Applicant Award Disbursement Table

Columns Comments for RPRADSB_AIDY_CODE (# 1)

Source Code Comments

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

Columns Comments for RPRADSB_PIDM (# 2)

Source Code Comments

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

Columns Comments for RPRADSB_SCHEDULE_DATE (# 3)

Source Code Comments

SCHEDULED DATE: The date that the disbursement is scheduled to be paid.

Columns Comments for RPRADSB_FUND_CODE (# 4)

Source Code Comments

FUND CODE: The fund code associated with the disbursement information in this record.

Columns Comments for RPRADSB_TERM_CODE (# 5)

Source Code Comments

TERM CODE: The term associated with the disbursement information in this record.

Columns Comments for RPRADSB_ACTIVITY_DATE (# 6)

Source Code Comments

ACTIVITY DATE: The date that information in this record was entered or last updated.

Columns Comments for RPRADSB_SCHEDULE_AMT (# 7)

Source Code Comments

SCHEDULED AMOUNT: The scheduled amount of the disbursement associated with the fund.

Columns Comments for RPRADSB_DISBURSE_DATE (# 8)

Source Code Comments

DISBURSEMENT DATE: The actual date that the funds in this record were disbursed to the student.

Columns Comments for RPRADSB_DISBURSE_AMT (# 9)

Source Code Comments

DISBURSED AMOUNT: The actual dollar amount disbursed to the student for this record.

Columns Comments for RPRADSB_TRAN_NUMBER (# 10)

Source Code Comments

TRANSACTION NUMBER: The transaction number on the student's accounts receivable detail.

Columns Comments for RPRADSB_DISBURSE_PCT (# 11)

Source Code Comments

DISBURSEMENT PERCENTAGE: The percentage of the fund term award that this scheduled disbursement represents.

Columns Comments for RPRADSB_DISBURSE_LOAD (# 12)

Source Code Comments

DISBURSED LOAD: The enrollment load of the student at the time of this disbursement.

Columns Comments for RPRADSB_DISBURSE_LOAD_OPT (# 13)

Source Code Comments

DISBURSEMENT ENROLLMENT OPTION: The disbursement enrollment option used when this disbursement was paid.

Columns Comments for RPRADSB_LMS_FEED_IND (# 14)

Source Code Comments

LMS FEED INDICATOR: A value of Y specifies that a Loan Management System feed transaction has been created. Used for institutional loan disbursements only.

Columns Comments for RPRADSB_PELL_CALC_DISB_AMT (# 15)

Source Code Comments

APPLICANT CALCULATED PELL DISBURSEMENT AMOUNT: The calculated amount of the Pell award for the student, as a result of the disbursement process, before the disbursement options are considered.

Columns Comments for RPRADSB_PELLC_DISB_LOAD (# 16)

Source Code Comments

APPLICANT CALCULATED PELL LOAD: The calculated enrollment load for the applicant's Pell award, as a result of the disbursement process, before the disbursement options are considered.

Columns Comments for RPRADSB_PELLC_DISB_LOAD_OPT (# 17)

Source Code Comments

APPLICANT CALCULATED PELL LOAD OPTION: The source of the calculated enrollment load for the applicant's Pell award, as a result of the disbursement process, before the disbursement options are considered.

Columns Comments for RPRADSB_DISB_BATCH_NO (# 18)

Source Code Comments

DISBURSEMENT BATCH NUMBER: The batch number associated with this Pell disbursement record.

Columns Comments for RPRADSB_DISB_REF_NO (# 19)

Source Code Comments

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

Columns Comments for RPRADSB_DEBIT_CR_IND (# 20)

Source Code Comments

PELL SIGN INDICATOR: The debit/credit indicator for this Pell award disbursement. It indicates if the disbursement is positive (P) or negative (N).

Columns Comments for RPRADSB_DISB_AMT (# 21)

Source Code Comments

PELL DISBURSEMENT AMOUNT: The amount of this Pell disbursement, as sent to 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 RPRADSB_DISB_ACTION_CODE (# 22)

Source Code Comments

PELL DISBURSEMENT ACTION CODE: The processing status of this Pell disbursement.

Columns Comments for RPRADSB_DISB_ACK_REF_NO (# 23)

Source Code Comments

DISBURSEMENT ACKNOWLEDGEMENT REFERENCE NUMBER: The reference number (sequence number) of this Pell disbursement sent back on acknowledgement from COD. If COD is generating the disbursement, 91 through 99 will be used.

Columns Comments for RPRADSB_DISB_ACPT_DEBIT_CR_IND (# 24)

Source Code Comments

ACCEPTED DEBIT/CREDIT INDICATOR: The debit/credit indicator for this Pell disbursement, as acknowledged by COD. It indicates if the disbursement is positive (P) or negative (N).

Columns Comments for RPRADSB_DISB_ACPT_AMT (# 25)

Source Code Comments

ACCEPTED DISBURSEMENT AMOUNT: The amount of this Pell disbursement, 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 RPRADSB_DISB_ACPT_DATE (# 26)

Source Code Comments

ACCEPTED DISBURSEMENT DATE: The date this Pell disbursement was or will be made, as acknowledged by COD.

Columns Comments for RPRADSB_YTD_AMT_PAID (# 27)

Source Code Comments

YEAR TO DATE AMOUNT PAID: The year to date Pell amount which has been disbursed to the student for this award year, as reported by COD.

Columns Comments for RPRADSB_EDIT_REJ_01 (# 28)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 1: Disbursement Edit/Reject/Comment code 1.

Columns Comments for RPRADSB_EDIT_REJ_02 (# 29)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 2: Disbursement Edit/Reject/Comment code 2.

Columns Comments for RPRADSB_EDIT_REJ_03 (# 30)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 3: Disbursement Edit/Reject/Comment code 3.

Columns Comments for RPRADSB_EDIT_REJ_04 (# 31)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 4: Disbursement Edit/Reject/Comment code 4.

Columns Comments for RPRADSB_EDIT_REJ_05 (# 32)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 5: Disbursement Edit/Reject/Comment code 5.

Columns Comments for RPRADSB_EDIT_REJ_06 (# 33)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 6: Disbursement Edit/Reject/Comment code 6.

Columns Comments for RPRADSB_EDIT_REJ_07 (# 34)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 7: Disbursement Edit/Reject/Comment code 7.

Columns Comments for RPRADSB_EDIT_REJ_08 (# 35)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 8: Disbursement Edit/Reject/Comment code 8.

Columns Comments for RPRADSB_EDIT_REJ_09 (# 36)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 9: Disbursement Edit/Reject/Comment code 9.

Columns Comments for RPRADSB_EDIT_REJ_10 (# 37)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 10: Disbursement Edit/Reject/Comment code 10.

Columns Comments for RPRADSB_EDIT_REJ_11 (# 38)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 11: Disbursement Edit/Reject/Comment code 11.

Columns Comments for RPRADSB_EDIT_REJ_12 (# 39)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 12: Disbursement Edit/Reject/Comment code 12.

Columns Comments for RPRADSB_EDIT_REJ_13 (# 40)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 13: Disbursement Edit/Reject/Comment code 13.

Columns Comments for RPRADSB_EDIT_REJ_14 (# 41)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 14: Disbursement Edit/Reject/Comment code 14.

Columns Comments for RPRADSB_EDIT_REJ_15 (# 42)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 15: Disbursement Edit/Reject/Comment code 15.

Columns Comments for RPRADSB_EDIT_REJ_16 (# 43)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 16: Disbursement Edit/Reject/Comment code 16.

Columns Comments for RPRADSB_EDIT_REJ_17 (# 44)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 17: Disbursement Edit/Reject/Comment code 17.

Columns Comments for RPRADSB_EDIT_REJ_18 (# 45)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 18: Disbursement Edit/Reject/Comment code 18.

Columns Comments for RPRADSB_EDIT_REJ_19 (# 46)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 19: Disbursement Edit/Reject/Comment code 19.

Columns Comments for RPRADSB_EDIT_REJ_20 (# 47)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 20: Disbursement Edit/Reject/Comment code 20.

Columns Comments for RPRADSB_EDIT_REJ_21 (# 48)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 21: Disbursement Edit/Reject/Comment code 21.

Columns Comments for RPRADSB_EDIT_REJ_22 (# 49)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 22: Disbursement Edit/Reject/Comment code 22.

Columns Comments for RPRADSB_EDIT_REJ_23 (# 50)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 23: Disbursement Edit/Reject/Comment code 23.

Columns Comments for RPRADSB_EDIT_REJ_24 (# 51)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 24: Disbursement Edit/Reject/Comment code 24.

Columns Comments for RPRADSB_EDIT_REJ_25 (# 52)

Source Code Comments

DISBURSEMENT EDIT/REJECT/COMMENT CODE 25: Disbursement Edit/Reject/Comment code 25.

Columns Comments for RPRADSB_SHARED_SAR_ID_FLAG (# 53)

Source Code Comments

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

Columns Comments for RPRADSB_VERIF_W_STATUS_FLAG (# 54)

Source Code Comments

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

Columns Comments for RPRADSB_CONCUR_ENROLL_FLAG (# 55)

Source Code Comments

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

Columns Comments for RPRADSB_POTENTIAL_OVERPMT_FLAG (# 56)

Source Code Comments

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

Columns Comments for RPRADSB_ORIG_ID (# 57)

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 RPRADSB_INST_XREF (# 58)

Source Code Comments

DISBURSEMENT CROSS REFERENCE: The institution defined identifier used to identify student records internally.

Columns Comments for RPRADSB_DISB_DATE_SENT (# 59)

Source Code Comments

DISBURSEMENT RECORD EXTRACTED DATE: The date the disbursement record was extracted for submission to COD.

Columns Comments for RPRADSB_DISB_DATE (# 60)

Source Code Comments

PELL DISBURSEMENT DATE: The actual date of disbursement of the Pell payment or if not yet disbursed, the scheduled disbursement date.