RCRTERM ROBEXTR ROBFSAP RORCOLS RORGSQL RORSYMB ROTWFAE RURVERS

Model Miscellaneous


Model Label :
Path : Default Folder/B70/finaid/Miscellaneous_ERD

List of Objects

Object Name Object Type Layer Name
RCRTERM TABLE Default
ROBEXTR TABLE Default
ROBFSAP TABLE Default
RORCOLS TABLE Default
RORGSQL TABLE Default
RORSYMB TABLE Default
ROTWFAE TABLE Default
RURVERS 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 ROBEXTR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ROBEXTR_APPL_CODE ROBEXTR_APPL_CODE VARCHAR2(10) No
ROBEXTR_QUERY ROBEXTR_QUERY VARCHAR2(10) No
ROBEXTR_KEY ROBEXTR_KEY VARCHAR2(80) No
ROBEXTR_ACTIVITY_DATE ROBEXTR_ACTIVITY_DATE DATE No
ROBEXTR_OWNER_ID ROBEXTR_OWNER_ID VARCHAR2(30) No
ROBEXTR_USER_ID ROBEXTR_USER_ID VARCHAR2(30) No
ROBEXTR_SYS_IND ROBEXTR_SYS_IND VARCHAR2(1) No
ROBEXTR_SLCT_IND ROBEXTR_SLCT_IND VARCHAR2(1) Yes

Foreign Key information

No Foreign Key

Index

No Result

Comments

Source Code Comments

Report Extract Base Table

Columns Comments for ROBEXTR_QUERY (2)

Source Code Comments

QUERY: The name of the Selection Identifier that was used to create this Report Extract record.

Columns Comments for ROBEXTR_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 ROBEXTR_USER_ID (6)

Source Code Comments

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

Columns Comments for ROBEXTR_SLCT_IND (8)

Source Code Comments

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

Table ROBFSAP

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ROBFSAP_PIDM ROBFSAP_PIDM NUMBER(9,0) No *
ROBFSAP_FISAP_INC ROBFSAP_FISAP_INC NUMBER(7,0) Yes
ROBFSAP_LEVL_CODE ROBFSAP_LEVL_CODE VARCHAR2(2) Yes
ROBFSAP_FULL_TIME_IND ROBFSAP_FULL_TIME_IND VARCHAR2(1) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ROBFSAP Unique ROBFSAP_PIDM

Comments

Source Code Comments

FISAP report interim processing table. Records created during and deleted after execution of FISAP report.

Columns Comments for ROBFSAP_PIDM (1)

Source Code Comments

PIDM: Internal system student identification number.

Columns Comments for ROBFSAP_FISAP_INC (2)

Source Code Comments

FISAP INCOME: Income calculated for each student and reported on FISAP report.

Columns Comments for ROBFSAP_LEVL_CODE (3)

Source Code Comments

LEVEL CODE: Level code reported for each student on the FISAP report.

Columns Comments for ROBFSAP_FULL_TIME_IND (4)

Source Code Comments

FULL TIME INDICATOR: An indicator specifying whether student is FULL TIME or less than FULL TIME for FISAP reporting purposes.

Table RORCOLS

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RORCOLS_COLUMN_NAME RORCOLS_COLUMN_NAME VARCHAR2(30) No
RORCOLS_COLUMN_DESC RORCOLS_COLUMN_DESC VARCHAR2(250) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
RORCOLS_DESC_INDEX RORCOLS_COLUMN_DESC
RORCOLS_DESC_INDEX RORCOLS_COLUMN_NAME
RORCOLS_KEY_INDEX RORCOLS_COLUMN_NAME
RORCOLS_KEY_INDEX RORCOLS_COLUMN_DESC

Comments

Source Code Comments

All Financial Aid columns Table

Columns Comments for RORCOLS_COLUMN_NAME (1)

Source Code Comments

COLUMN NAME: Field to hold the name of a column from the dictionary.

Columns Comments for RORCOLS_COLUMN_DESC (2)

Source Code Comments

COLUMN DESCRIPTION: Field to hold the description of a column from the dictionary.

Table RORGSQL

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RORGSQL_SLCT RORGSQL_SLCT NUMBER(10,0) No *
RORGSQL_LINE_NO RORGSQL_LINE_NO NUMBER(4,0) No *
RORGSQL_SEQ_NO RORGSQL_SEQ_NO NUMBER(6,0) No
RORGSQL_SQL_STATEMENT RORGSQL_SQL_STATEMENT VARCHAR2(78) No
RORGSQL_ACTIVITY_DATE RORGSQL_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RORGSQL Unique RORGSQL_SLCT
PK_RORGSQL Unique RORGSQL_LINE_NO

Comments

Source Code Comments

Generated SQL Selection Identifier Table

Columns Comments for RORGSQL_SLCT (1)

Source Code Comments

SLCT: The internal number that uniquely identifies this Selection Identifier.

Columns Comments for RORGSQL_LINE_NO (2)

Source Code Comments

LINE NUMBER: The internal number that uniquely identifies this line of the Selection Identifier.

Columns Comments for RORGSQL_SEQ_NO (3)

Source Code Comments

SEQUENCE NUMBER: The internal sequence number that uniquely identifies this Selection Identifier record.

Columns Comments for RORGSQL_SQL_STATEMENT (4)

Source Code Comments

SQL STATEMENT: The pseudo sql statement logic in this Selection condition.

Columns Comments for RORGSQL_ACTIVITY_DATE (5)

Source Code Comments

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

Table RORSYMB

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RORSYMB_SLCT RORSYMB_SLCT NUMBER(6,0) No
RORSYMB_SEQ_NO RORSYMB_SEQ_NO NUMBER(6,0) No
RORSYMB_ACTIVITY_DATE RORSYMB_ACTIVITY_DATE DATE No
RORSYMB_RESULT RORSYMB_RESULT VARCHAR2(240) No
RORSYMB_RESULT_LEN RORSYMB_RESULT_LEN NUMBER(6,0) No
RORSYMB_BASED_ON RORSYMB_BASED_ON VARCHAR2(240) Yes
RORSYMB_ORDER_BY RORSYMB_ORDER_BY VARCHAR2(60) Yes
RORSYMB_GROUP_BY RORSYMB_GROUP_BY VARCHAR2(240) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
RORSYMB_KEY_INDEX Unique RORSYMB_SLCT
RORSYMB_KEY_INDEX Unique RORSYMB_SEQ_NO

Comments

Source Code Comments

Letter Generation Variable Table

Columns Comments for RORSYMB_SLCT (1)

Source Code Comments

SLCT: The internal number that uniquely identifies this Variable.

Columns Comments for RORSYMB_SEQ_NO (2)

Source Code Comments

SEQUENCE NUMBER: The internal sequence number that uniquely identifies this Variable.

Columns Comments for RORSYMB_ACTIVITY_DATE (3)

Source Code Comments

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

Columns Comments for RORSYMB_RESULT (4)

Source Code Comments

RESULT: The 'SELECT' portion of the SQL statement that represents this Variable. For example, if the Result is defined as RBRACMP_AMT, then the SQL statement that represents this variable contains 'SELECT RBRACMP_AMT...'.

Columns Comments for RORSYMB_RESULT_LEN (5)

Source Code Comments

RESULT LENGTH: The actual length (in characters) of the RORSYMB_RESULT field.

Columns Comments for RORSYMB_BASED_ON (6)

Source Code Comments

BASED ON: The name of another Variable on which this Variable definition is based.

Columns Comments for RORSYMB_ORDER_BY (7)

Source Code Comments

ORDER BY: The name of another Variable which defines the order in which records are retrieved from the database when this Variable is used.

Table ROTWFAE

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
ROTWFAE_SOURCE ROTWFAE_SOURCE VARCHAR2(1) No
ROTWFAE_PIDM ROTWFAE_PIDM NUMBER(9,0) No *
ROTWFAE_AIDY_CODE ROTWFAE_AIDY_CODE VARCHAR2(15) No
ROTWFAE_ACADEMIC_YEAR ROTWFAE_ACADEMIC_YEAR VARCHAR2(15) No
ROTWFAE_TERM_SEQUENCE ROTWFAE_TERM_SEQUENCE VARCHAR2(6) No
ROTWFAE_TERM_CODE ROTWFAE_TERM_CODE VARCHAR2(15) No *
ROTWFAE_EXTRACT_DATE ROTWFAE_EXTRACT_DATE DATE No
ROTWFAE_USER ROTWFAE_USER VARCHAR2(30) No
ROTWFAE_ACTIVITY_DATE ROTWFAE_ACTIVITY_DATE DATE No
ROTWFAE_AGE ROTWFAE_AGE NUMBER(3,0) Yes
ROTWFAE_GENDER_CODE ROTWFAE_GENDER_CODE VARCHAR2(15) Yes
ROTWFAE_ETHNIC_CODE ROTWFAE_ETHNIC_CODE VARCHAR2(15) Yes
ROTWFAE_GOVT_ETHNIC_CODE ROTWFAE_GOVT_ETHNIC_CODE VARCHAR2(15) Yes
ROTWFAE_LEVEL_CODE ROTWFAE_LEVEL_CODE VARCHAR2(15) Yes
ROTWFAE_STUDENT_TYPE_CODE ROTWFAE_STUDENT_TYPE_CODE VARCHAR2(15) Yes
ROTWFAE_CAMPUS_CODE ROTWFAE_CAMPUS_CODE VARCHAR2(15) Yes
ROTWFAE_RESIDENCY_CODE ROTWFAE_RESIDENCY_CODE VARCHAR2(15) Yes
ROTWFAE_RESIDENCY_TYPE ROTWFAE_RESIDENCY_TYPE VARCHAR2(15) Yes
ROTWFAE_HOUSING_IND ROTWFAE_HOUSING_IND VARCHAR2(15) Yes
ROTWFAE_COLLEGE_CODE ROTWFAE_COLLEGE_CODE VARCHAR2(15) Yes
ROTWFAE_DEPARTMENT_CODE ROTWFAE_DEPARTMENT_CODE VARCHAR2(15) Yes
ROTWFAE_DEGREE_CODE ROTWFAE_DEGREE_CODE VARCHAR2(15) Yes
ROTWFAE_MAJOR_CODE ROTWFAE_MAJOR_CODE VARCHAR2(15) Yes
ROTWFAE_PROGRAM_CODE ROTWFAE_PROGRAM_CODE VARCHAR2(15) Yes
ROTWFAE_AWARD_CAT_CODE ROTWFAE_AWARD_CAT_CODE VARCHAR2(15) Yes
ROTWFAE_CLASS_CODE ROTWFAE_CLASS_CODE VARCHAR2(15) Yes
ROTWFAE_ENROLL_STATUS ROTWFAE_ENROLL_STATUS VARCHAR2(15) Yes
ROTWFAE_TIME_STATUS ROTWFAE_TIME_STATUS VARCHAR2(15) Yes
ROTWFAE_GOVT_TIME_STATUS ROTWFAE_GOVT_TIME_STATUS VARCHAR2(15) Yes
ROTWFAE_INST_SCHOLAR ROTWFAE_INST_SCHOLAR NUMBER(12,2) Yes
ROTWFAE_FED_SCHOLAR ROTWFAE_FED_SCHOLAR NUMBER(12,2) Yes
ROTWFAE_STATE_SCHOLAR ROTWFAE_STATE_SCHOLAR NUMBER(12,2) Yes
ROTWFAE_OTHER_SCHOLAR ROTWFAE_OTHER_SCHOLAR NUMBER(12,2) Yes
ROTWFAE_INST_GRANT ROTWFAE_INST_GRANT NUMBER(12,2) Yes
ROTWFAE_FED_GRANT ROTWFAE_FED_GRANT NUMBER(12,2) Yes
ROTWFAE_STATE_GRANT ROTWFAE_STATE_GRANT NUMBER(12,2) Yes
ROTWFAE_OTHER_GRANT ROTWFAE_OTHER_GRANT NUMBER(12,2) Yes
ROTWFAE_INST_LOAN ROTWFAE_INST_LOAN NUMBER(12,2) Yes
ROTWFAE_FED_LOAN ROTWFAE_FED_LOAN NUMBER(12,2) Yes
ROTWFAE_STATE_LOAN ROTWFAE_STATE_LOAN NUMBER(12,2) Yes
ROTWFAE_OTHER_LOAN ROTWFAE_OTHER_LOAN NUMBER(12,2) Yes
ROTWFAE_EMPLOYMENT_AMT ROTWFAE_EMPLOYMENT_AMT NUMBER(12,2) Yes
ROTWFAE_FAMILY_INCOME ROTWFAE_FAMILY_INCOME NUMBER(7,0) Yes
ROTWFAE_FAMILY_CONTRIB ROTWFAE_FAMILY_CONTRIB NUMBER(12,2) Yes
ROTWFAE_COST_EDUCATION ROTWFAE_COST_EDUCATION NUMBER(12,2) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_ROTWFAE Unique ROTWFAE_PIDM
PK_ROTWFAE Unique ROTWFAE_TERM_CODE

Comments

Source Code Comments

Web for Executives - Financial Aid Extract.

Columns Comments for ROTWFAE_SOURCE (1)

Source Code Comments

SOURCE: B for BANNER

Columns Comments for ROTWFAE_PIDM (2)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for ROTWFAE_AIDY_CODE (3)

Source Code Comments

AID YEAR CODE: The aid year to which this extract applies.

Columns Comments for ROTWFAE_ACADEMIC_YEAR (4)

Source Code Comments

ACADEMIC YEAR: The academic year to which this extract applies.

Columns Comments for ROTWFAE_TERM_SEQUENCE (5)

Source Code Comments

TERM SEQUENCE: This field represents the term code to which all award information in this record is associated.

Columns Comments for ROTWFAE_TERM_CODE (6)

Source Code Comments

TERM CODE: This field represents the term code to which all award information in this record is associated.

Columns Comments for ROTWFAE_EXTRACT_DATE (7)

Source Code Comments

EXTRACT DATE: The date this record was created.

Columns Comments for ROTWFAE_USER (8)

Source Code Comments

USER ID: The user ID who created this record.

Columns Comments for ROTWFAE_ACTIVITY_DATE (9)

Source Code Comments

ACTIVITY DATE: The date this record was created.

Columns Comments for ROTWFAE_AGE (10)

Source Code Comments

STUDENT AGE: The student's current age as calculated when this record was created.

Columns Comments for ROTWFAE_GENDER_CODE (11)

Source Code Comments

GENDER: This field maintains the sex of person. Valid values are: M - Male, F - Female, N - Unknown.

Columns Comments for ROTWFAE_ETHNIC_CODE (12)

Source Code Comments

ETHNICITY CODE: This field maintains ethnicity code associated with person.

Columns Comments for ROTWFAE_GOVT_ETHNIC_CODE (13)

Source Code Comments

GOVERNMENTAL ETHNICITY CODE: This field maintains the ethnicity code used in IPEDs reporting.

Columns Comments for ROTWFAE_LEVEL_CODE (14)

Source Code Comments

STUDENT LEVEL CODE: This field identifies the level of the student for the selected term code.

Columns Comments for ROTWFAE_STUDENT_TYPE_CODE (15)

Source Code Comments

STUDENT TYPE: This field identifies the student type for the selected term code.

Columns Comments for ROTWFAE_CAMPUS_CODE (16)

Source Code Comments

STUDENT CAMPUS: This field identifies the campus location associated with the student for the selected term code.

Columns Comments for ROTWFAE_RESIDENCY_CODE (17)

Source Code Comments

STUDENT RESIDENCY CODE: This field identifies the residency status of the student for the selected term code.

Columns Comments for ROTWFAE_RESIDENCY_TYPE (18)

Source Code Comments

STUDENT RESIDENCY TYPE: This field indicates whether residency is in or out of state. I - In-state residency, O - Out-of-state residency.

Columns Comments for ROTWFAE_HOUSING_IND (19)

Source Code Comments

STUDENT HOUSING INDICATOR: This field indicates whether the student has a housing assignment.

Columns Comments for ROTWFAE_COLLEGE_CODE (20)

Source Code Comments

STUDENT COLLEGE CODE: This field identifies the college associated with the primary curriculum for the selected term code.

Columns Comments for ROTWFAE_DEPARTMENT_CODE (21)

Source Code Comments

STUDENT DEPARTMENT CODE: This field identifies the department associated with the primary curriculum for the selected term code.

Columns Comments for ROTWFAE_DEGREE_CODE (22)

Source Code Comments

STUDENT DEGREE CODE: This field identifies the degree within the primary curriculum for the selected term code.

Columns Comments for ROTWFAE_MAJOR_CODE (23)

Source Code Comments

STUDENT MAJOR CODE: This field identifies the primary major within the primary curriculum for the selected term code.

Columns Comments for ROTWFAE_PROGRAM_CODE (24)

Source Code Comments

STUDENT PROGRAM CODE: This field identifies the program associated with the primary curriculum for the selected term code.

Columns Comments for ROTWFAE_AWARD_CAT_CODE (25)

Source Code Comments

AWARD CATEGORY CODE: This field identifies the award category code associated with the degree.

Columns Comments for ROTWFAE_CLASS_CODE (26)

Source Code Comments

STUDENT CLASS CODE: This field identifies the class code of the student for the selected term code.

Columns Comments for ROTWFAE_ENROLL_STATUS (27)

Source Code Comments

STUDENT ENROLLMENT STATUS: This field identifies the student enrollment status code for the selected termcode.

Columns Comments for ROTWFAE_TIME_STATUS (28)

Source Code Comments

STUDENT TIME STATUS: Most recently calculated time status code of the student for the selected term code.

Columns Comments for ROTWFAE_GOVT_TIME_STATUS (29)

Source Code Comments

GOVERNMENTAL TIME STATUS: This field identifies the full time part time indicator used in IPEDS reporting.

Columns Comments for ROTWFAE_INST_SCHOLAR (30)

Source Code Comments

INSTITUTIONAL SCHOLARSHIP AMOUNT: This field maintains the amount of the institutional scholarships of the student for the selected term.

Columns Comments for ROTWFAE_FED_SCHOLAR (31)

Source Code Comments

FEDERAL SCHOLARSHIP AMOUNT: This field maintains the amount of the federal scholarships of the student for the selected term.

Columns Comments for ROTWFAE_STATE_SCHOLAR (32)

Source Code Comments

STATE SCHOLARSHIP AMOUNT: This field maintains the amount of the state scholarships of the student for the selected term.

Columns Comments for ROTWFAE_OTHER_SCHOLAR (33)

Source Code Comments

OTHER SCHOLARSHIP AMOUNT: This field maintains the amount of the other scholarships of the student for the selected term.

Columns Comments for ROTWFAE_INST_GRANT (34)

Source Code Comments

INSTITUTIONAL GRANT AMOUNT: This field maintains the amount of the institutional grants of the student for the selected term.

Columns Comments for ROTWFAE_FED_GRANT (35)

Source Code Comments

FEDERAL GRANT AMOUNT: This field maintains the amount of the federal grants of the student for the selected term.

Columns Comments for ROTWFAE_STATE_GRANT (36)

Source Code Comments

STATE GRANT AMOUNT: This field maintains the amount of the state grants of the student for the selected term.

Columns Comments for ROTWFAE_OTHER_GRANT (37)

Source Code Comments

OTHER GRANT AMOUNT: This field maintains the amount of the other grants of the student for the selected term.

Columns Comments for ROTWFAE_INST_LOAN (38)

Source Code Comments

INSTITUTIONAL LOAN AMOUNT: This field maintains the amount of the institutional loans of the student for the selected term.

Columns Comments for ROTWFAE_FED_LOAN (39)

Source Code Comments

FEDERAL LOAN AMOUNT: This field maintains the amount of the federal loans of the student for the selected term.

Columns Comments for ROTWFAE_STATE_LOAN (40)

Source Code Comments

STATE LOAN AMOUNT: This field maintains the amount of the state loans of the student for the selected term.

Columns Comments for ROTWFAE_OTHER_LOAN (41)

Source Code Comments

OTHER LOAN AMOUNT: This field maintains the amount of the other loans of the student for the selected term.

Columns Comments for ROTWFAE_EMPLOYMENT_AMT (42)

Source Code Comments

EMPLOYMENT AMOUNT: This field maintains the amount of the employment of the student for the selected term.

Columns Comments for ROTWFAE_FAMILY_INCOME (43)

Source Code Comments

FAMILY INCOME: The students family income.

Columns Comments for ROTWFAE_FAMILY_CONTRIB (44)

Source Code Comments

FAMILY CONTRIBUTION: The students most recently calculated family contribution.

Columns Comments for ROTWFAE_COST_EDUCATION (45)

Source Code Comments

EDUCATIONAL COST: The students cost of education.

Table RURVERS

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RURVERS_RELEASE RURVERS_RELEASE VARCHAR2(10) No
RURVERS_STAGE_DATE RURVERS_STAGE_DATE DATE No

Foreign Key information

No Foreign Key

Index

No Result

Comments

Source Code Comments

Financial Aid Version Tracking Table