Model STVTERM

Model Label :
Path : BANNER DEV/Financial Aid/Finaid_ERD/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
ROBINST	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 MALDEV8_B60
Creation Date 04/15/2002 18:17:12: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_AIDY_YEAR	ROBINST_AIDY_CODE	ROBINST
RCRTERM_TERM_CODE_HOST	STVTERM_CODE	STVTERM

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 MALDEV8_B60
Creation Date 10/29/2002 15:27:37:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRASCH_AIDY_CODE	RFRASCH_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASCH_AIDY_CODE	RFRASCH_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASCH_AIDY_CODE	RFRASCH_AIDY_CODE	VARCHAR2(4)	No	*	*
RFRASCH_APRD_CODE	RFRASCH_APRD_CODE	VARCHAR2(6)	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_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_FUND_CODE	RPRAWRD_FUND_CODE	RPRAWRD
RFRASCH_AIDY_CODE	RPRAWRD_AIDY_CODE	RPRAWRD
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_APRD_CODE	RTVAPRD_CODE	RTVAPRD
RFRASCH_TERM_CODE	STVTERM_CODE	STVTERM

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 MALDEV8_B60
Creation Date 10/29/2002 15:27:39:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDEFA_AIDY_CODE	RFRDEFA_AIDY_CODE	VARCHAR2(4)	No	*	*
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_AIDY_CODE	RPRAWRD_AIDY_CODE	RPRAWRD
RFRDEFA_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDEFA_APRD_CODE	RTVAPRD_CODE	RTVAPRD
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

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 MALDEV8_B60
Creation Date 01/22/2003 16:50:10: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_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDEFD_APRD_CODE	RTVAPRD_CODE	RTVAPRD
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

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 MALDEV8_B60
Creation Date 04/15/2002 18:17:15:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RFRDLCK_AIDY_CODE	RFRDLCK_AIDY_CODE	VARCHAR2(4)	No	*	*
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_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
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

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 MALDEV8_B60
Creation Date 01/22/2003 16:50:10: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_AIDY_CODE	ROBINST_AIDY_CODE	ROBINST
RFRDSCH_APRD_CODE	RTVAPRD_CODE	RTVAPRD
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

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 MALDEV8_B60
Creation Date 04/15/2002 18:17:16: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 ROBINST

Schema Name FAISMGR
Label ROBINST
Server name MALDEV8_B60
Creation Date 11/11/2003 15:18:05:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
ROBINST_AIDY_CODE	ROBINST_AIDY_CODE	VARCHAR2(4)	No	*
ROBINST_AIDY_DESC	ROBINST_AIDY_DESC	VARCHAR2(30)	No
ROBINST_AIDY_START_DATE	ROBINST_AIDY_START_DATE	DATE	No
ROBINST_AIDY_END_DATE	ROBINST_AIDY_END_DATE	DATE	No
ROBINST_AIDY_START_YEAR	ROBINST_AIDY_START_YEAR	NUMBER(4,0)	No
ROBINST_AIDY_END_YEAR	ROBINST_AIDY_END_YEAR	NUMBER(4,0)	No
ROBINST_STATUS_IND	ROBINST_STATUS_IND	VARCHAR2(1)	No
ROBINST_BUDG_AUDIT_IND	ROBINST_BUDG_AUDIT_IND	VARCHAR2(1)	No
ROBINST_NEED_AUDIT_IND	ROBINST_NEED_AUDIT_IND	VARCHAR2(1)	No
ROBINST_PCKG_AUDIT_IND	ROBINST_PCKG_AUDIT_IND	VARCHAR2(1)	No
ROBINST_PELL_AUDIT_IND	ROBINST_PELL_AUDIT_IND	VARCHAR2(1)	No
ROBINST_APPL_DATE_IND	ROBINST_APPL_DATE_IND	VARCHAR2(1)	No
ROBINST_TFC_PRO_IND	ROBINST_TFC_PRO_IND	VARCHAR2(1)	No
ROBINST_PAYVOCH_REQ_IND	ROBINST_PAYVOCH_REQ_IND	VARCHAR2(1)	No
ROBINST_METHOD_IND	ROBINST_METHOD_IND	VARCHAR2(1)	No
ROBINST_INFC_CODE	ROBINST_INFC_CODE	VARCHAR2(7)	No		*
ROBINST_INAS_OPTION	ROBINST_INAS_OPTION	VARCHAR2(1)	No
ROBINST_ACTIVITY_DATE	ROBINST_ACTIVITY_DATE	DATE	No
ROBINST_TRST_CODE_EST	ROBINST_TRST_CODE_EST	VARCHAR2(1)	Yes		*
ROBINST_TRST_CODE_EST	ROBINST_TRST_CODE_EST	VARCHAR2(1)	Yes		*
ROBINST_TRST_CODE_EST	ROBINST_TRST_CODE_EST	VARCHAR2(1)	Yes		*
ROBINST_BGRP_CODE	ROBINST_BGRP_CODE	VARCHAR2(6)	Yes		*
ROBINST_TGRP_CODE	ROBINST_TGRP_CODE	VARCHAR2(6)	Yes		*
ROBINST_PGRP_CODE	ROBINST_PGRP_CODE	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_APPL	ROBINST_TREQ_CODE_APPL	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_APPL	ROBINST_TREQ_CODE_APPL	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_APPL	ROBINST_TREQ_CODE_APPL	VARCHAR2(6)	Yes		*
ROBINST_APRD_CODE_DEF	ROBINST_APRD_CODE_DEF	VARCHAR2(6)	Yes		*
ROBINST_SAPR_CODE	ROBINST_SAPR_CODE	VARCHAR2(6)	Yes		*
ROBINST_SAPR_CODE	ROBINST_SAPR_CODE	VARCHAR2(6)	Yes		*
ROBINST_SAPR_CODE	ROBINST_SAPR_CODE	VARCHAR2(6)	Yes		*
ROBINST_FINAID_DIR_NAME	ROBINST_FINAID_DIR_NAME	VARCHAR2(30)	Yes
ROBINST_TREQ_CODE_SAR	ROBINST_TREQ_CODE_SAR	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_SAR	ROBINST_TREQ_CODE_SAR	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_SAR	ROBINST_TREQ_CODE_SAR	VARCHAR2(6)	Yes		*
ROBINST_CURRENT_TERM_CODE	ROBINST_CURRENT_TERM_CODE	VARCHAR2(6)	Yes		*
ROBINST_TRST_CODE_SAR	ROBINST_TRST_CODE_SAR	VARCHAR2(1)	Yes		*
ROBINST_TRST_CODE_SAR	ROBINST_TRST_CODE_SAR	VARCHAR2(1)	Yes		*
ROBINST_TRST_CODE_SAR	ROBINST_TRST_CODE_SAR	VARCHAR2(1)	Yes		*
ROBINST_FINAID_DIR_PHONE_AREA	ROBINST_FINAID_DIR_PHONE_AREA	VARCHAR2(3)	Yes
ROBINST_FINAID_DIR_PHONE_NO	ROBINST_FINAID_DIR_PHONE_NO	VARCHAR2(7)	Yes
ROBINST_PELL_ID	ROBINST_PELL_ID	VARCHAR2(6)	Yes
ROBINST_ENTITY_ID	ROBINST_ENTITY_ID	VARCHAR2(12)	Yes
ROBINST_SERV_AGENT_CDE	ROBINST_SERV_AGENT_CDE	VARCHAR2(2)	Yes
ROBINST_SBGI_CONV_IND	ROBINST_SBGI_CONV_IND	VARCHAR2(1)	Yes
ROBINST_INST_SBGI_CODE	ROBINST_INST_SBGI_CODE	VARCHAR2(6)	Yes		*
ROBINST_ELO_IND	ROBINST_ELO_IND	VARCHAR2(1)	Yes
ROBINST_DL_SCHOOL_CODE	ROBINST_DL_SCHOOL_CODE	VARCHAR2(6)	Yes
ROBINST_DEST_NUMBER	ROBINST_DEST_NUMBER	VARCHAR2(5)	Yes
ROBINST_INFO_ACCESS_IND	ROBINST_INFO_ACCESS_IND	VARCHAR2(1)	Yes
ROBINST_DFLT_MSG_EXP_DAYS	ROBINST_DFLT_MSG_EXP_DAYS	NUMBER(4,0)	Yes
ROBINST_INAS_NON_CUST	ROBINST_INAS_NON_CUST	VARCHAR2(1)	Yes
ROBINST_UPD_TRAN_IND	ROBINST_UPD_TRAN_IND	VARCHAR2(1)	Yes
ROBINST_LOAN_PROCESS_TYPE	ROBINST_LOAN_PROCESS_TYPE	VARCHAR2(1)	Yes
ROBINST_SAPR_CODE_EXCEPT	ROBINST_SAPR_CODE_EXCEPT	VARCHAR2(6)	Yes		*
ROBINST_SAPR_CODE_EXCEPT	ROBINST_SAPR_CODE_EXCEPT	VARCHAR2(6)	Yes		*
ROBINST_SAPR_CODE_EXCEPT	ROBINST_SAPR_CODE_EXCEPT	VARCHAR2(6)	Yes		*
ROBINST_PIVOT_DATE	ROBINST_PIVOT_DATE	DATE	Yes
ROBINST_DL_AFFIRM_IND	ROBINST_DL_AFFIRM_IND	VARCHAR2(1)	Yes
ROBINST_FORMER_HEAL_IND	ROBINST_FORMER_HEAL_IND	VARCHAR2(1)	Yes
ROBINST_CASH_MONITOR_IND	ROBINST_CASH_MONITOR_IND	VARCHAR2(1)	Yes
ROBINST_JUST_IN_TIME_IND	ROBINST_JUST_IN_TIME_IND	VARCHAR2(1)	Yes
ROBINST_PELL_RED_ELIG_IND	ROBINST_PELL_RED_ELIG_IND	VARCHAR2(1)	Yes
ROBINST_TREQ_CODE_ENTER_INTV	ROBINST_TREQ_CODE_ENTER_INTV	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_ENTER_INTV	ROBINST_TREQ_CODE_ENTER_INTV	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_ENTER_INTV	ROBINST_TREQ_CODE_ENTER_INTV	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_EXIT_INTV	ROBINST_TREQ_CODE_EXIT_INTV	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_EXIT_INTV	ROBINST_TREQ_CODE_EXIT_INTV	VARCHAR2(6)	Yes		*
ROBINST_TREQ_CODE_EXIT_INTV	ROBINST_TREQ_CODE_EXIT_INTV	VARCHAR2(6)	Yes		*
ROBINST_JIT_NO_DAYS	ROBINST_JIT_NO_DAYS	NUMBER(2,0)	Yes
ROBINST_EL_SCHOOL_CDE	ROBINST_EL_SCHOOL_CDE	VARCHAR2(6)	Yes
ROBINST_MYN_ELIGIBLE	ROBINST_MYN_ELIGIBLE	VARCHAR2(1)	Yes
ROBINST_TITLE_IV_RET_IND	ROBINST_TITLE_IV_RET_IND	VARCHAR2(1)	Yes
ROBINST_TITLE_IV_ROUND_IND	ROBINST_TITLE_IV_ROUND_IND	VARCHAR2(1)	Yes
ROBINST_EL_BRANCH_CDE	ROBINST_EL_BRANCH_CDE	VARCHAR2(2)	Yes
ROBINST_APPL_DATE_SOURCE	ROBINST_APPL_DATE_SOURCE	VARCHAR2(7)	Yes
ROBINST_ALTERNATE_PELL_IND	ROBINST_ALTERNATE_PELL_IND	VARCHAR2(1)	Yes
ROBINST_EL_AUDIT_IND	ROBINST_EL_AUDIT_IND	VARCHAR2(1)	Yes
ROBINST_EL_AUDIT_NO_DAYS	ROBINST_EL_AUDIT_NO_DAYS	NUMBER(2,0)	Yes
ROBINST_TRST_CODE_ENTER_INTV	ROBINST_TRST_CODE_ENTER_INTV	VARCHAR2(1)	Yes
ROBINST_TRST_CODE_EXIT_INTV	ROBINST_TRST_CODE_EXIT_INTV	VARCHAR2(1)	Yes
ROBINST_NEW_PELL_CALC_IND	ROBINST_NEW_PELL_CALC_IND	VARCHAR2(1)	No
ROBINST_FULL_PARTICIPANT_IND	ROBINST_FULL_PARTICIPANT_IND	VARCHAR2(1)	Yes
ROBINST_COMMON_SCHOOL_ID	ROBINST_COMMON_SCHOOL_ID	VARCHAR2(8)	Yes
ROBINST_TURN_OFF_PELL_IND	ROBINST_TURN_OFF_PELL_IND	VARCHAR2(1)	Yes
ROBINST_PELL_FUND_CODE	ROBINST_PELL_FUND_CODE	VARCHAR2(6)	Yes
ROBINST_RESCHED_DISB_DATE_IND	ROBINST_RESCHED_DISB_DATE_IND	VARCHAR2(1)	Yes
ROBINST_DL_COD_FP_IND	ROBINST_DL_COD_FP_IND	VARCHAR2(1)	Yes
ROBINST_PELL_COD_FP_IND	ROBINST_PELL_COD_FP_IND	VARCHAR2(1)	Yes
ROBINST_PELL_LT_HALF_IND	ROBINST_PELL_LT_HALF_IND	VARCHAR2(1)	Yes
ROBINST_MULTI_YR_PERK_MPN_FLAG	ROBINST_MULTI_YR_PERK_MPN_FLAG	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
ROBINST_PGRP_CODE	RTVPGRP_CODE	RTVPGRP
ROBINST_INFC_CODE	RTVINFC_CODE	RTVINFC
ROBINST_APRD_CODE_DEF	RTVAPRD_CODE	RTVAPRD
ROBINST_TGRP_CODE	RTVTGRP_CODE	RTVTGRP
ROBINST_BGRP_CODE	RTVBGRP_CODE	RTVBGRP
ROBINST_CURRENT_TERM_CODE	STVTERM_CODE	STVTERM
ROBINST_INST_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_ROBINST	Unique	ROBINST_AIDY_CODE

Comments

Source Code Comments

Financial Aid Institution Table

Columns Comments for ROBINST_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 ROBINST_AIDY_DESC (2)

Source Code Comments

AID YEAR DESCRIPTION: The description of the valid aid year.

Columns Comments for ROBINST_AIDY_START_DATE (3)

Source Code Comments

AID YEAR START DATE: This is the official start date of the aid year.

Columns Comments for ROBINST_AIDY_END_DATE (4)

Source Code Comments

AID YEAR END DATE: This is the official end date of the aid year.

Columns Comments for ROBINST_AIDY_START_YEAR (5)

Source Code Comments

AID YEAR START YEAR: The year and century of the Aid Year Start date. Example: If the Aid Year Start Date = 01-JUL-1990, then Aid Year Start Year = 1990.

Columns Comments for ROBINST_AIDY_END_YEAR (6)

Source Code Comments

AID YEAR END YEAR: The year and century of the Aid Year End date. Example: If the Aid Year End Date = 30-JUN-1991, then Aid Year End Year = 1991.

Columns Comments for ROBINST_STATUS_IND (7)

Source Code Comments

AID YEAR STATUS CODE: This code defines if this Aid Year is an active year.

Columns Comments for ROBINST_BUDG_AUDIT_IND (8)

Source Code Comments

BUDGET AUDIT TRAIL INDICATOR: This indicator is used to define if the institution wishes to log changes to selected fields in the budgeting module.

Columns Comments for ROBINST_NEED_AUDIT_IND (9)

Source Code Comments

NEED ANALYSIS AUDIT TRAIL INDICATOR: This indicator is used to define if the institution wishes to log changes to selected fields in the Need Analysis module.

Columns Comments for ROBINST_PCKG_AUDIT_IND (10)

Source Code Comments

PACKAGING AUDIT INDICATOR: This indicator is used to define if the institution wishes to log changes to selected fields in the Packaging Module.

Columns Comments for ROBINST_PELL_AUDIT_IND (11)

Source Code Comments

PELL CORRECTION AUDIT INDICATOR: This indicator is used to define if the institution wishes to log changes for electronic pell corrections.

Columns Comments for ROBINST_APPL_DATE_IND (12)

Source Code Comments

APPLICATION RECEIVE DATE INDICATOR: This field identifies which date the institution wishes to use as the application receipt date.

Columns Comments for ROBINST_TFC_PRO_IND (13)

Source Code Comments

TOTAL FAMILY CONTRIBUTION PRORATION: This code indicates whether the institution wishes to use TFC proration based on the percentage of year identified by the aid period in budgeting.

Columns Comments for ROBINST_PAYVOCH_REQ_IND (14)

Source Code Comments

CREATE PAYMENT VOUCHER PRIOR TO PAYMENT: This field indicates whether the institution can create a Pell payment voucher prior to payment.

Columns Comments for ROBINST_METHOD_IND (15)

Source Code Comments

METHODOLOGY INDICATOR: This code specifies the primary methodology that the institution uses in the processing of applications. Examples: Federal Methodology or Institutional Methodology.

Columns Comments for ROBINST_INFC_CODE (16)

Source Code Comments

INTERFACE CODE: The code of the originating source of records from outside agencies.

Columns Comments for ROBINST_INAS_OPTION (17)

Source Code Comments

INAS OPTION: The default INAS calculation option that will be used when INAS is performed. Valid values are (S)hort and (L)ong.

Columns Comments for ROBINST_ACTIVITY_DATE (18)

Source Code Comments

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

Columns Comments for ROBINST_TRST_CODE_EST (19)

Source Code Comments

REQUIREMENT TRACKING ESTABLISHED STATUS CODE: This field maintains the tracking status code which means the requirement has been established.

Columns Comments for ROBINST_BGRP_CODE (20)

Source Code Comments

DEFAULT BUDGET GROUP: This field identifies the default budget group.

Columns Comments for ROBINST_TGRP_CODE (21)

Source Code Comments

DEFAULT TRACKING GROUP CODE: This code identifies the default tracking group.

Columns Comments for ROBINST_PGRP_CODE (22)

Source Code Comments

DEFAULT PACKAGING GROUP: This field identifies the default packaging group.

Columns Comments for ROBINST_TREQ_CODE_APPL (23)

Source Code Comments

APPLICATION REQUIREMENT CODE: This code is the institution's defined tracking requirement code for an institutional application.