Model STVTERM

Model Label : Banner Financial Aid Support Table STVTERM
Path : Default Folder/B70/finaid/STVTERM_ERD

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

Comments

Model View

Table RCRTERM

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

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

Comments

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

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

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	RFRDEFA_AIDY_CODE	RFRDEFA
RFRASCH_APRD_CODE	RFRDEFA_APRD_CODE	RFRDEFA
RFRASCH_TERM_CODE	RFRDEFA_TERM_CODE	RFRDEFA
RFRASCH_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
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

Comments

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

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

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_TERM_CODE	STVTERM_CODE	STVTERM
RFRDEFA_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

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

Comments

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

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

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_TERM_CODE	STVTERM_CODE	STVTERM
RFRDEFD_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

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

Comments

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

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

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	RFRASPC_AIDY_CODE	RFRASPC
RFRDLCK_FUND_CODE	RFRASPC_FUND_CODE	RFRASPC
RFRDLCK_TERM_CODE	STVTERM_CODE	STVTERM
RFRDLCK_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

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

Comments

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

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

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_TERM_CODE	STVTERM_CODE	STVTERM
RFRDSCH_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST

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

Comments

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

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

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

Comments

Source Code Comments

Payroll Load Rules Table

Table RORCRHR

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

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_LEVL_CODE	STVLEVL_CODE	STVLEVL
RORCRHR_TERM_CODE	STVTERM_CODE	STVTERM
RORCRHR_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
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

Comments

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

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

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

Comments

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

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

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

Comments

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

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

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

Comments

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

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

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_TERM_CODE	STVTERM_CODE	STVTERM
RORVIEW_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RORVIEW_PIDM	TBRACCD_PIDM	TBRACCD
RORVIEW_PIDM	TBBESTU_PIDM	TBBESTU
RORVIEW_PIDM	TBBCSTU_STU_PIDM	TBBCSTU

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

Comments

Source Code Comments

View Selection Table

Table RPBLOPT

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

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