RJBJOBT RJBPLBD RJBSEDR RJRPAYL RJRPLRL RJRSEAR RJRSERF RJRSEWH RORENRL RORSAPR RORSTRF RPRATRM RTVAUST RTVRFST RTVSAPR

Model Student Employment


Model Label : Banner Financial Aid Student Employment Module
Path : Default Folder/B70/finaid/StudentEmployment_ERD

List of Objects

Object Name Object Type Layer Name
RJBJOBT TABLE Default
RJBPLBD TABLE Default
RJBSEDR TABLE Default
RJRPAYL TABLE Default
RJRPLRL TABLE Default
RJRSEAR TABLE Default
RJRSERF TABLE Default
RJRSEWH TABLE Default
RORENRL TABLE Default
RORSAPR TABLE Default
RORSTRF TABLE Default
RPRATRM TABLE Default
RTVAUST TABLE Default
RTVRFST TABLE Default
RTVSAPR TABLE Default

Comments

Model View

''

Table RJBJOBT

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RJBJOBT_CODE RJBJOBT_CODE VARCHAR2(6) No *
RJBJOBT_DESC RJBJOBT_DESC VARCHAR2(30) No
RJBJOBT_HRLY_PAY_IND RJBJOBT_HRLY_PAY_IND VARCHAR2(1) No
RJBJOBT_PAY_RANGE_LOW RJBJOBT_PAY_RANGE_LOW NUMBER(7,2) No
RJBJOBT_PAY_RANGE_HIGH RJBJOBT_PAY_RANGE_HIGH NUMBER(7,2) No
RJBJOBT_DEFAULT_PAY RJBJOBT_DEFAULT_PAY NUMBER(7,2) No
RJBJOBT_ACTIVITY_DATE RJBJOBT_ACTIVITY_DATE DATE No
RJBJOBT_REQUIREMENTS RJBJOBT_REQUIREMENTS VARCHAR2(180) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RJBJOBT Unique RJBJOBT_CODE

Comments

Source Code Comments

Job Title Table

Columns Comments for RJBJOBT_CODE (1)

Source Code Comments

JOB TITLE CODE: The Student Employment Module code that controls the student's pay rate and required job skills for a particular job.

Columns Comments for RJBJOBT_DESC (2)

Source Code Comments

JOB TITLE DESCRIPTION: The description for the Job Title Code.

Columns Comments for RJBJOBT_HRLY_PAY_IND (3)

Source Code Comments

HOURLY PAY INDICATOR: Indicates if the pay range and default amounts mean an hourly rate of pay (Y) or a stipend amount (N).

Columns Comments for RJBJOBT_PAY_RANGE_LOW (4)

Source Code Comments

PAY RANGE LOW: The low end of the range of eligible pay rates for a particular Job Title Code.

Columns Comments for RJBJOBT_PAY_RANGE_HIGH (5)

Source Code Comments

PAY RANGE HIGH: The high end of the range of eligible pay rates for a particular job title code.

Columns Comments for RJBJOBT_DEFAULT_PAY (6)

Source Code Comments

DEFAULT PAY: This is the amount (hourly rate or stipend amount) that is defaulted on the Authorization Form for a particular job title.

Columns Comments for RJBJOBT_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for RJBJOBT_REQUIREMENTS (8)

Source Code Comments

JOB TITLE REQUIREMENTS: A list of required job skills for a particular Job Title Code.

Table RJBPLBD

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RJBPLBD_PLACE_CDE RJBPLBD_PLACE_CDE VARCHAR2(6) No *
RJBPLBD_PLACE_DESC RJBPLBD_PLACE_DESC VARCHAR2(30) No
RJBPLBD_SUPERVISOR RJBPLBD_SUPERVISOR VARCHAR2(30) No
RJBPLBD_ACTIVITY_DATE RJBPLBD_ACTIVITY_DATE DATE No
RJBPLBD_PHONE_AREA RJBPLBD_PHONE_AREA VARCHAR2(3) Yes
RJBPLBD_PHONE_NUMBER RJBPLBD_PHONE_NUMBER VARCHAR2(7) Yes
RJBPLBD_PHONE_EXT RJBPLBD_PHONE_EXT VARCHAR2(4) Yes
RJBPLBD_STREET_LINE1 RJBPLBD_STREET_LINE1 VARCHAR2(30) Yes
RJBPLBD_STREET_LINE2 RJBPLBD_STREET_LINE2 VARCHAR2(30) Yes
RJBPLBD_STREET_LINE3 RJBPLBD_STREET_LINE3 VARCHAR2(30) Yes
RJBPLBD_CITY RJBPLBD_CITY VARCHAR2(20) Yes
RJBPLBD_STAT_CODE RJBPLBD_STAT_CODE VARCHAR2(3) Yes *
RJBPLBD_ZIP RJBPLBD_ZIP VARCHAR2(10) Yes
RJBPLBD_NATN_CODE RJBPLBD_NATN_CODE VARCHAR2(5) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
RJBPLBD_NATN_CODE STVNATN_CODE STVNATN
RJBPLBD_STAT_CODE STVSTAT_CODE STVSTAT

Index

Index Name Index Type Column Name
PK_RJBPLBD Unique RJBPLBD_PLACE_CDE

Comments

Source Code Comments

Placement Base Data Table

Table RJBSEDR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RJBSEDR_AIDY_CODE RJBSEDR_AIDY_CODE VARCHAR2(4) No * *
RJBSEDR_AUTH_START_DATE RJBSEDR_AUTH_START_DATE DATE No
RJBSEDR_AUTH_END_DATE RJBSEDR_AUTH_END_DATE DATE No
RJBSEDR_PAY_START_DATE RJBSEDR_PAY_START_DATE DATE No
RJBSEDR_PAY_END_DATE RJBSEDR_PAY_END_DATE DATE No
RJBSEDR_AUST_CODE RJBSEDR_AUST_CODE VARCHAR2(4) No *
RJBSEDR_ACTIVITY_DATE RJBSEDR_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
RJBSEDR_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RJBSEDR_AUST_CODE RTVAUST_CODE RTVAUST

Index

Index Name Index Type Column Name
PK_RJBSEDR Unique RJBSEDR_AIDY_CODE

Comments

Source Code Comments

Student Employment Default Rules Table

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 RJRPLRL

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RJRPLRL_AIDY_CODE RJRPLRL_AIDY_CODE VARCHAR2(4) No *
RJRPLRL_PLACE_CDE RJRPLRL_PLACE_CDE VARCHAR2(6) No *
RJRPLRL_ALLOCATION RJRPLRL_ALLOCATION NUMBER(11,2) No
RJRPLRL_ECLS_CODE RJRPLRL_ECLS_CODE VARCHAR2(2) No
RJRPLRL_POSN RJRPLRL_POSN VARCHAR2(6) No
RJRPLRL_ORGN_CODE RJRPLRL_ORGN_CODE VARCHAR2(6) No
RJRPLRL_ACTIVITY_DATE RJRPLRL_ACTIVITY_DATE DATE No
RJRPLRL_COAS_CODE RJRPLRL_COAS_CODE VARCHAR2(1) Yes
RJRPLRL_ECLS_DESC RJRPLRL_ECLS_DESC VARCHAR2(30) Yes
RJRPLRL_POSN_TITLE RJRPLRL_POSN_TITLE VARCHAR2(30) Yes
RJRPLRL_ORGN_DESC RJRPLRL_ORGN_DESC VARCHAR2(35) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RJRPLRL_PLACE_CDE RJBPLBD_PLACE_CDE RJBPLBD
RJRPLRL_AIDY_CODE ROBINST_AIDY_CODE ROBINST

Index

Index Name Index Type Column Name
RJRPLRL_KEY_INDEX RJRPLRL_AIDY_CODE
RJRPLRL_KEY_INDEX RJRPLRL_PLACE_CDE
RJRPLRL_KEY_INDEX RJRPLRL_POSN

Comments

Source Code Comments

Placement Rules Table

Table RJRSEAR

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RJRSEAR_AIDY_CODE RJRSEAR_AIDY_CODE VARCHAR2(4) No * *
RJRSEAR_PIDM RJRSEAR_PIDM NUMBER(8,0) No *
RJRSEAR_JOBT_CODE RJRSEAR_JOBT_CODE VARCHAR2(6) No
RJRSEAR_PLACE_CDE RJRSEAR_PLACE_CDE VARCHAR2(6) No
RJRSEAR_POSN RJRSEAR_POSN VARCHAR2(6) No *
RJRSEAR_SUFF RJRSEAR_SUFF VARCHAR2(2) No *
RJRSEAR_AUST_CODE RJRSEAR_AUST_CODE VARCHAR2(4) No *
RJRSEAR_AUTH_START_DATE RJRSEAR_AUTH_START_DATE DATE No
RJRSEAR_AUTH_END_DATE RJRSEAR_AUTH_END_DATE DATE No
RJRSEAR_PAY_START_DATE RJRSEAR_PAY_START_DATE DATE No
RJRSEAR_PAY_END_DATE RJRSEAR_PAY_END_DATE DATE No
RJRSEAR_ACTIVITY_DATE RJRSEAR_ACTIVITY_DATE DATE No
RJRSEAR_FUND_CODE RJRSEAR_FUND_CODE VARCHAR2(6) Yes
RJRSEAR_AUTH_HRS RJRSEAR_AUTH_HRS NUMBER(6,2) Yes
RJRSEAR_PAY_RATE RJRSEAR_PAY_RATE NUMBER(11,6) Yes
RJRSEAR_AUTH_EARNINGS RJRSEAR_AUTH_EARNINGS NUMBER(11,2) Yes
RJRSEAR_STIPEND_AMT RJRSEAR_STIPEND_AMT NUMBER(11,2) Yes
RJRSEAR_SORT_KEY RJRSEAR_SORT_KEY VARCHAR2(20) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RJRSEAR_AUST_CODE RTVAUST_CODE RTVAUST
RJRSEAR_AIDY_CODE ROBINST_AIDY_CODE ROBINST

Index

Index Name Index Type Column Name
PK_RJRSEAR Unique RJRSEAR_AIDY_CODE
PK_RJRSEAR Unique RJRSEAR_PIDM
PK_RJRSEAR Unique RJRSEAR_POSN
PK_RJRSEAR Unique RJRSEAR_SUFF
RJRSEAR_KEY_INDEX RJRSEAR_AIDY_CODE
RJRSEAR_KEY_INDEX RJRSEAR_PLACE_CDE
RJRSEAR_KEY_INDEX RJRSEAR_POSN

Comments

Source Code Comments

Student Employment Authorization Table

Columns Comments for RJRSEAR_JOBT_CODE (3)

Source Code Comments

JOB TITLE CODE: The student's Job Title for this authorization record.

Columns Comments for RJRSEAR_SORT_KEY (18)

Source Code Comments

SORT KEY: Field used for enabling dynamic sorting by any value which is entered into this field.

Table RJRSERF

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RJRSERF_AIDY_CODE RJRSERF_AIDY_CODE VARCHAR2(4) No *
RJRSERF_PIDM RJRSERF_PIDM NUMBER(8,0) No
RJRSERF_REF_DATE RJRSERF_REF_DATE DATE No
RJRSERF_RFST_CODE RJRSERF_RFST_CODE VARCHAR2(4) No *
RJRSERF_PLACE_CDE RJRSERF_PLACE_CDE VARCHAR2(6) No
RJRSERF_ACTIVITY_DATE RJRSERF_ACTIVITY_DATE DATE No
RJRSERF_FUND_CODE RJRSERF_FUND_CODE VARCHAR2(6) Yes
RJRSERF_POSN RJRSERF_POSN VARCHAR2(6) Yes
RJRSERF_SUFF RJRSERF_SUFF VARCHAR2(2) Yes
RJRSERF_JOBT_CODE RJRSERF_JOBT_CODE VARCHAR2(6) Yes
RJRSERF_COMMENT RJRSERF_COMMENT VARCHAR2(50) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RJRSERF_RFST_CODE RTVRFST_CODE RTVRFST
RJRSERF_AIDY_CODE ROBINST_AIDY_CODE ROBINST

Index

Index Name Index Type Column Name
RJRSERF_INDEX RJRSERF_AIDY_CODE
RJRSERF_INDEX RJRSERF_PIDM
RJRSERF_INDEX RJRSERF_REF_DATE

Comments

Source Code Comments

Student Employment Referral Table

Columns Comments for RJRSERF_FUND_CODE (7)

Source Code Comments

FUND CODE: The financial aid source that will be funding the job.

Columns Comments for RJRSERF_POSN (8)

Source Code Comments

POSITION CODE: The BANNER Human Resources position code that controls the job.

Columns Comments for RJRSERF_SUFF (9)

Source Code Comments

POSITION CODE SUFFIX: The BANNER HR suffix for the student's position code.

Columns Comments for RJRSERF_JOBT_CODE (10)

Source Code Comments

JOB TITLE CODE: The student employment job title code for the referral.

Table RJRSEWH

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RJRSEWH_AIDY_CODE RJRSEWH_AIDY_CODE VARCHAR2(4) No *
RJRSEWH_PIDM RJRSEWH_PIDM NUMBER(8,0) No
RJRSEWH_POSN RJRSEWH_POSN VARCHAR2(6) No
RJRSEWH_SUFF RJRSEWH_SUFF VARCHAR2(2) No
RJRSEWH_PAY_END_DATE RJRSEWH_PAY_END_DATE DATE No
RJRSEWH_ACTIVITY_DATE RJRSEWH_ACTIVITY_DATE DATE No
RJRSEWH_HRS RJRSEWH_HRS NUMBER(6,2) Yes
RJRSEWH_RATE RJRSEWH_RATE NUMBER(11,6) Yes
RJRSEWH_AMT RJRSEWH_AMT NUMBER(11,2) Yes
RJRSEWH_YEAR RJRSEWH_YEAR VARCHAR2(4) Yes
RJRSEWH_PICT_CODE RJRSEWH_PICT_CODE VARCHAR2(2) Yes
RJRSEWH_PAYNO RJRSEWH_PAYNO NUMBER(3,0) Yes

Foreign Key information

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

Index

Index Name Index Type Column Name
RJRSEWH_INDEX RJRSEWH_AIDY_CODE
RJRSEWH_INDEX RJRSEWH_PIDM
RJRSEWH_INDEX RJRSEWH_POSN
RJRSEWH_INDEX RJRSEWH_SUFF
RJRSEWH_INDEX RJRSEWH_PAY_END_DATE

Comments

Source Code Comments

Student Employment Work History Table

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 RORSTRF

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RORSTRF_SAPR_CODE_PREV RORSTRF_SAPR_CODE_PREV VARCHAR2(6) No * *
RORSTRF_SAPR_CODE_CALC RORSTRF_SAPR_CODE_CALC VARCHAR2(6) No * *
RORSTRF_SAPR_CODE_NEW RORSTRF_SAPR_CODE_NEW VARCHAR2(6) No *
RORSTRF_USER_ID RORSTRF_USER_ID VARCHAR2(30) No
RORSTRF_ACTIVITY_DATE RORSTRF_ACTIVITY_DATE DATE No
RORSTRF_LETR_CODE RORSTRF_LETR_CODE VARCHAR2(15) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
RORSTRF_SAPR_CODE_PREV RTVSAPR_CODE RTVSAPR
RORSTRF_SAPR_CODE_CALC RTVSAPR_CODE RTVSAPR
RORSTRF_SAPR_CODE_NEW RTVSAPR_CODE RTVSAPR
RORSTRF_LETR_CODE GTVLETR_CODE GTVLETR

Index

Index Name Index Type Column Name
PK_RORSTRF Unique RORSTRF_SAPR_CODE_PREV
PK_RORSTRF Unique RORSTRF_SAPR_CODE_CALC

Comments

Source Code Comments

SAP Translation Rules Table

Columns Comments for RORSTRF_SAPR_CODE_PREV (1)

Source Code Comments

PREVIOUS SAP STATUS CODE: Code which represents the previous academic progress of applicants and aid recipients.

Columns Comments for RORSTRF_SAPR_CODE_CALC (2)

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 RORSTRF_SAPR_CODE_NEW (3)

Source Code Comments

NEW SAP STATUS CODE: Code which represents the New academic progress of applicants and aid recipients from the rule based on the combination of Previous and Calculated SAP Status Codes.

Columns Comments for RORSTRF_USER_ID (4)

Source Code Comments

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

Columns Comments for RORSTRF_ACTIVITY_DATE (5)

Source Code Comments

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

Columns Comments for RORSTRF_LETR_CODE (6)

Source Code Comments

LETTER CODE: Code of the letter to be posted when attaining the corresponding New SAP Status. Letter code references GTVLETR table.

Table RPRATRM

Schema Name FAISMGR
Label RPRATRM
Server name S4B70
Creation Date 12/31/2003 13:32:20:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RPRATRM_AIDY_CODE RPRATRM_AIDY_CODE VARCHAR2(4) No * *
RPRATRM_PIDM RPRATRM_PIDM NUMBER(8,0) No * *
RPRATRM_FUND_CODE RPRATRM_FUND_CODE VARCHAR2(6) No * *
RPRATRM_TERM_CODE RPRATRM_TERM_CODE VARCHAR2(6) No * *
RPRATRM_OFFER_AMT RPRATRM_OFFER_AMT NUMBER(11,2) No
RPRATRM_OFFER_DATE RPRATRM_OFFER_DATE DATE No
RPRATRM_ACTIVITY_DATE RPRATRM_ACTIVITY_DATE DATE No
RPRATRM_DISB_FINAL_IND RPRATRM_DISB_FINAL_IND VARCHAR2(1) No
RPRATRM_DIST_PCT RPRATRM_DIST_PCT NUMBER(6,3) Yes
RPRATRM_MEMO_EXP_DATE RPRATRM_MEMO_EXP_DATE DATE Yes
RPRATRM_ORIG_OFFER_AMT RPRATRM_ORIG_OFFER_AMT NUMBER(11,2) Yes
RPRATRM_ORIG_OFFER_DATE RPRATRM_ORIG_OFFER_DATE DATE Yes
RPRATRM_ACCEPT_AMT RPRATRM_ACCEPT_AMT NUMBER(11,2) Yes
RPRATRM_ACCEPT_DATE RPRATRM_ACCEPT_DATE DATE Yes
RPRATRM_DECLINE_AMT RPRATRM_DECLINE_AMT NUMBER(11,2) Yes
RPRATRM_DECLINE_DATE RPRATRM_DECLINE_DATE DATE Yes
RPRATRM_CANCEL_AMT RPRATRM_CANCEL_AMT NUMBER(11,2) Yes
RPRATRM_CANCEL_DATE RPRATRM_CANCEL_DATE DATE Yes
RPRATRM_AUTHORIZE_AMT RPRATRM_AUTHORIZE_AMT NUMBER(11,2) Yes
RPRATRM_AUTHORIZE_DATE RPRATRM_AUTHORIZE_DATE DATE Yes
RPRATRM_MEMO_AMT RPRATRM_MEMO_AMT NUMBER(11,2) Yes
RPRATRM_MEMO_DATE RPRATRM_MEMO_DATE DATE Yes
RPRATRM_PAID_AMT RPRATRM_PAID_AMT NUMBER(11,2) Yes
RPRATRM_PAID_DATE RPRATRM_PAID_DATE DATE Yes
RPRATRM_PCKG_LOAD_IND RPRATRM_PCKG_LOAD_IND VARCHAR2(1) No
RPRATRM_NSLDS_OVRD_IND RPRATRM_NSLDS_OVRD_IND VARCHAR2(1) Yes
RPRATRM_PELL_AWRD_LOAD_OPT RPRATRM_PELL_AWRD_LOAD_OPT VARCHAR2(1) Yes
RPRATRM_LOCK_IND RPRATRM_LOCK_IND VARCHAR2(1) Yes
RPRATRM_USER_ID RPRATRM_USER_ID VARCHAR2(30) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
RPRATRM_AIDY_CODE ROBINST_AIDY_CODE ROBINST
RPRATRM_TERM_CODE STVTERM_CODE STVTERM
RPRATRM_FUND_CODE ADRFUND_FA_FUND_CODE ADRFUND
RPRATRM_PIDM RPRAWRD_PIDM RPRAWRD
RPRATRM_AIDY_CODE RPRAWRD_AIDY_CODE RPRAWRD
RPRATRM_FUND_CODE RPRAWRD_FUND_CODE RPRAWRD
RPRATRM_FUND_CODE RPRAWRD_FUND_CODE RPRAWRD
RPRATRM_PIDM RPRAWRD_PIDM RPRAWRD
RPRATRM_AIDY_CODE RPRAWRD_AIDY_CODE RPRAWRD

Index

Index Name Index Type Column Name
PK_RPRATRM Unique RPRATRM_AIDY_CODE
PK_RPRATRM Unique RPRATRM_PIDM
PK_RPRATRM Unique RPRATRM_FUND_CODE
PK_RPRATRM Unique RPRATRM_TERM_CODE
RPRATRM_PIDM_INDEX RPRATRM_PIDM
RPRATRM_PIDM_INDEX RPRATRM_FUND_CODE
RPRATRM_PIDM_INDEX RPRATRM_TERM_CODE

Comments

Source Code Comments

Applicant Award by Term Table

Columns Comments for RPRATRM_AIDY_CODE (1)

Source Code Comments

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

Columns Comments for RPRATRM_PIDM (2)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for RPRATRM_FUND_CODE (3)

Source Code Comments

FUND CODE: This field maintains the fund code associated with the dollar amounts in this record.

Columns Comments for RPRATRM_TERM_CODE (4)

Source Code Comments

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

Columns Comments for RPRATRM_OFFER_AMT (5)

Source Code Comments

OFFERED AMOUNT: This field represents the current offered amount of the award for the term.

Columns Comments for RPRATRM_OFFER_DATE (6)

Source Code Comments

OFFERED DATE: This field maintains the date that the current award was offered.

Columns Comments for RPRATRM_ACTIVITY_DATE (7)

Source Code Comments

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

Columns Comments for RPRATRM_DISB_FINAL_IND (8)

Source Code Comments

DISBURSED FINAL INDICATOR: This field indicates whether all disbursements have been made within the term indicated.

Columns Comments for RPRATRM_DIST_PCT (9)

Source Code Comments

DISTRIBUTION PERCENT: This field defines the distribution of the award over the terms associated with the record.

Columns Comments for RPRATRM_MEMO_EXP_DATE (10)

Source Code Comments

MEMO EXPIRATION DATE: This field maintains the date that the memo will be cancelled.

Columns Comments for RPRATRM_ORIG_OFFER_AMT (11)

Source Code Comments

ORIGINAL OFFERED AMOUNT: This field represents the dollar amount of the original offer of this fund code for this term.

Columns Comments for RPRATRM_ORIG_OFFER_DATE (12)

Source Code Comments

ORIGINAL OFFER AMOUNT DATE: This field maintains the date that the original offer of the award was made.

Columns Comments for RPRATRM_ACCEPT_AMT (13)

Source Code Comments

ACCEPT AMOUNT: This field represents the dollar amount of the award that was accepted in the specified term.

Columns Comments for RPRATRM_ACCEPT_DATE (14)

Source Code Comments

ACCEPT DATE: This field maintains the date that the award was accepted.

Columns Comments for RPRATRM_DECLINE_AMT (15)

Source Code Comments

DECLINE AMOUNT: This field represents the dollar amount of the award that has been declined.

Columns Comments for RPRATRM_DECLINE_DATE (16)

Source Code Comments

DECLINE DATE: This field maintains the date that the award was declined.

Columns Comments for RPRATRM_CANCEL_AMT (17)

Source Code Comments

CANCELLED AMOUNT: This field maintains the dollar amount of the cancelled award for the term indicated.

Columns Comments for RPRATRM_CANCEL_DATE (18)

Source Code Comments

CANCELLED DATE: This field maintains the date that the award was cancelled.

Columns Comments for RPRATRM_AUTHORIZE_AMT (19)

Source Code Comments

AUTHORIZED AMOUNT: This field maintains the dollar amount of the award that was authorized.

Columns Comments for RPRATRM_AUTHORIZE_DATE (20)

Source Code Comments

AUTHORIZED DATE: This field maintains the date of the award authorization.

Columns Comments for RPRATRM_MEMO_AMT (21)

Source Code Comments

MEMO'D AMOUNT: This field represents the dollar amount of the award which was memo'd.

Columns Comments for RPRATRM_MEMO_DATE (22)

Source Code Comments

MEMO'D DATE: This field maintains the date that the award was memo'd.

Columns Comments for RPRATRM_PAID_AMT (23)

Source Code Comments

PAID AMOUNT: This field represents the actual amount of the award that was paid for the term.

Columns Comments for RPRATRM_PAID_DATE (24)

Source Code Comments

PAID DATE: This field maintains the date that the award was paid.

Columns Comments for RPRATRM_PCKG_LOAD_IND (25)

Source Code Comments

PACKAGING LOAD INDICATOR: This field contains the students enrollment status at the time of packaging. Values are 1 = Full Time, 2 = Three-Quarter Time, 3 = Half Time, 4 = Less than Half Time.

Columns Comments for RPRATRM_NSLDS_OVRD_IND (26)

Source Code Comments

NSLDS OVERRIDE: Indicates which validation tests Packaging/Disbursment processes should override for a specific Year/Student/Fund/Term. L - limit tests (aggregate). D - default tests. O - overpayment
tests. A - all.

Columns Comments for RPRATRM_PELL_AWRD_LOAD_OPT (27)

Source Code Comments

APPLICANT PELL AWARD ENROLLMENT OPTION: This indicates the source of the enrollment option when calculating a PELL award in the RPEPELL program.

Columns Comments for RPRATRM_LOCK_IND (28)

Source Code Comments

TERM BASED LOCK INDICATOR: Term lock indicator, Set to Y to totally lock the term award amount. Set to 'E' to lock the award amount except for enrollment adjustments during disbursement

Columns Comments for RPRATRM_USER_ID (29)

Source Code Comments

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

Table RTVAUST

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RTVAUST_CODE RTVAUST_CODE VARCHAR2(4) No *
RTVAUST_DESC RTVAUST_DESC VARCHAR2(30) No
RTVAUST_ACTIVE_IND RTVAUST_ACTIVE_IND VARCHAR2(1) No
RTVAUST_ACTIVITY_DATE RTVAUST_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RTVAUST Unique RTVAUST_CODE

Comments

Source Code Comments

Employment Authorization Status Validation Table

Table RTVRFST

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

Table Columns information

Column Name Label Column Type Allow NULL PK FK
RTVRFST_CODE RTVRFST_CODE VARCHAR2(4) No *
RTVRFST_DESC RTVRFST_DESC VARCHAR2(30) No
RTVRFST_ACTIVITY_DATE RTVRFST_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_RTVRFST Unique RTVRFST_CODE

Comments

Source Code Comments

Referral Status Validation Table

Table RTVSAPR

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

Table Columns information

Column Name Label Column Type Allow NULL