Model Short Term Credit

Model Label : Banner Financial Aid Short Term Credit Module

List of Objects

Object Name	Object Type	Layer Name
RPBSTAB	SQL Table	Default
RPRASTC	SQL Table	Default
RPRASTD	SQL Table	Default
RPRLCRT	SQL Table	Default
RPRSTAC	SQL Table	Default
RTVCINT	SQL Table	Default
RTVRPSR	SQL Table	Default

Model View

Table RPBSTAB

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RPBSTAB_CREDIT_ACCT	VARCHAR2(6)	No	*
RPBSTAB_DESC	VARCHAR2(30)	No
RPBSTAB_BUDG_AMT	NUMBER(11,2)	No
RPBSTAB_AVAIL_LOAN_AMT	NUMBER(11,2)	No
RPBSTAB_MIN_LOAN_AMT	NUMBER(11,2)	No
RPBSTAB_MAX_LOAN_AMT	NUMBER(11,2)	No
RPBSTAB_ACTIVITY_DATE	DATE	Yes
RPBSTAB_REQUEST_AMT	NUMBER(11,2)	Yes
RPBSTAB_APPROVE_AMT	NUMBER(11,2)	Yes
RPBSTAB_REPAID_AMT	NUMBER(11,2)	Yes
RPBSTAB_DURATION	VARCHAR2(3)	Yes
RPBSTAB_RECEIVE_AMT	NUMBER(11,2)	Yes
RPBSTAB_COLLECT_AMT	NUMBER(11,2)	Yes
RPBSTAB_BALANCE_DUE	NUMBER(11,2)	Yes
RPBSTAB_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RPBSTAB	Unique	RPBSTAB_CREDIT_ACCT

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRSTAC	SQL Table	S10B80.FAISMGR	Refer (no action)
P_PA_RPBSTAB_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
RPBSTAB	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPBSTAB	SQL Index	S10B80.FAISMGR	Rely On
RT_RPBSTAB_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RPBSTAB_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPBSTAB

Object Dates

Creation Date	Analysis Date
04/02/2008 10:24:52:000	04/02/2008 10:35:18:000

Source Code Comments

Short-Term Credit Account Base Table

Columns Comments for RPBSTAB_CREDIT_ACCT (# 1)

Source Code Comments

CREDIT ACCOUNT: This key field identifies the short term credit accounts that will be included within the Short Term Loan Module. If the short term credit account does not exist, it will be added.

Columns Comments for RPBSTAB_DESC (# 2)

Source Code Comments

SHORT TERM CREDIT ACCOUNT DESCRIPTION: This field provides a description of the short term credit accounts. The field is required but is free-form with no validation.

Columns Comments for RPBSTAB_BUDG_AMT (# 3)

Source Code Comments

BUDGET AMOUNT: This field identifies the amount of funds in the budget for the specific credit account.

Columns Comments for RPBSTAB_AVAIL_LOAN_AMT (# 4)

Source Code Comments

AVAILABLE TO LOAN AMOUNT: This field identifies the dollar amount that is available to be lent from the credit account.

Columns Comments for RPBSTAB_MIN_LOAN_AMT (# 5)

Source Code Comments

MINIMUM LOAN AMOUNT: This field specifies the minimum amount to be loaned to a single student from the credit account identified in the key block.

Columns Comments for RPBSTAB_MAX_LOAN_AMT (# 6)

Source Code Comments

MAXIMUM LOAN AMOUNT: This field maintains the maximum amount to be loaned to a single student from the credit account specified in the key block.

Columns Comments for RPBSTAB_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 RPBSTAB_REQUEST_AMT (# 8)

Source Code Comments

REQUEST AMOUNT: This system maintained field indicates the dollar amount of requests from the credit account identified in the key block.

Columns Comments for RPBSTAB_APPROVE_AMT (# 9)

Source Code Comments

APPROVE AMOUNT: This system maintained field indicates the dollar amount of approved short term loans associated with the credit account in the key block.

Columns Comments for RPBSTAB_REPAID_AMT (# 10)

Source Code Comments

REPAID AMOUNT: This system maintained field indicates the dollar amount of loans repaid to the credit account identified in the key block.

Columns Comments for RPBSTAB_DURATION (# 11)

Source Code Comments

CREDIT DURATION: This optional field indicates the duration of the grace period associated with the credit account. The due date is calculated using this.

Columns Comments for RPBSTAB_RECEIVE_AMT (# 12)

Source Code Comments

RECEIVED AMOUNT: This system maintained amount represents the sum of all amounts actually received by students from a particular account.

Columns Comments for RPBSTAB_COLLECT_AMT (# 13)

Source Code Comments

COLLECTION FEE: This system maintained amount represents the sum of all the collection, penalty, interest and processing charges for all students for a particular account.

Columns Comments for RPBSTAB_BALANCE_DUE (# 14)

Source Code Comments

BALANCE DUE: This system maintained amount represents the sum of all the balances due from students for a particular account.

Columns Comments for RPBSTAB_USER_ID (# 15)

Source Code Comments

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

Table RPRASTC

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RPRASTC_PIDM	NUMBER(8,0)	No	*
RPRASTC_ASTD_SEQ_NO	NUMBER(3,0)	No	*
RPRASTC_SEQ_NO	NUMBER(6,3)	No	*
RPRASTC_USER_ID	VARCHAR2(30)	Yes
RPRASTC_ACTIVITY_DATE	DATE	Yes
RPRASTC_COMMENT	VARCHAR2(50)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RPRASTC	Unique	RPRASTC_PIDM
PK_RPRASTC	Unique	RPRASTC_ASTD_SEQ_NO
PK_RPRASTC	Unique	RPRASTC_SEQ_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRASTC	SQL Index	S10B80.FAISMGR	Rely On
RT_RPRASTC_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RPRASTC_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRASTC

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:56:000	04/02/2008 10:35:21:000

Source Code Comments

Applicant Short-Term Credit Comments

Columns Comments for RPRASTC_PIDM (# 1)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for RPRASTC_ASTD_SEQ_NO (# 2)

Source Code Comments

SEQUENCE NUMBER: This field maintains a unique sequence number to identify the short term credit record.

Columns Comments for RPRASTC_SEQ_NO (# 3)

Source Code Comments

COMMENT SEQUENCE NUMBER: This field maintains the sequence number of the comment associated with the credit record.

Columns Comments for RPRASTC_USER_ID (# 4)

Source Code Comments

USER ID: This field maintains the user id of the person entering or updating the record.

Columns Comments for RPRASTC_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 RPRASTC_COMMENT (# 6)

Source Code Comments

COMMENT: This field maintains a comment regarding the short-term credit account record.

Table RPRASTD

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRASTD_PIDM	NUMBER(8,0)	No	*
RPRASTD_SEQ_NO	NUMBER(3,0)	No	*
RPRASTD_CREDIT_ACCT	VARCHAR2(6)	No	*
RPRASTD_APPLIED_DATE	DATE	No
RPRASTD_REQUEST_AMT	NUMBER(11,2)	No
RPRASTD_DUE_DATE	DATE	No
RPRASTD_ACTIVITY_DATE	DATE	Yes
RPRASTD_APPROVE_DATE	DATE	Yes
RPRASTD_APPROVE_AMT	NUMBER(11,2)	Yes
RPRASTD_CINT_CODE	VARCHAR2(4)	Yes		*
RPRASTD_RPSR_CODE	VARCHAR2(4)	Yes		*
RPRASTD_RECEIVE_DATE	DATE	Yes
RPRASTD_REPAID_DATE	DATE	Yes
RPRASTD_REPAID_AMT	NUMBER(11,2)	Yes
RPRASTD_RECEIVE_AMT	NUMBER(11,2)	Yes
RPRASTD_COLLECT_AMT	NUMBER(11,2)	Yes
RPRASTD_BALANCE_DUE	NUMBER(11,2)	Yes
RPRASTD_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRASTD_CINT_CODE	RTVCINT_CODE	RTVCINT
RPRASTD_RPSR_CODE	RTVRPSR_CODE	RTVRPSR

Index

Index Name	Index Type	Column Name
PK_RPRASTD	Unique	RPRASTD_PIDM
PK_RPRASTD	Unique	RPRASTD_SEQ_NO
PK_RPRASTD	Unique	RPRASTD_CREDIT_ACCT

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRASTD	SQL Index	S10B80.FAISMGR	Rely On
RTVCINT	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVRPSR	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_RPRASTD_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RPRASTD_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRASTD

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:57:000	04/02/2008 10:35:21:000

Source Code Comments

Applicant Short-Term Credit Table

Columns Comments for RPRASTD_PIDM (# 1)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for RPRASTD_SEQ_NO (# 2)

Source Code Comments

SEQUENCE NUMBER: This field maintains the sequence number of the short-term credit application.

Columns Comments for RPRASTD_CREDIT_ACCT (# 3)

Source Code Comments

CREDIT ACCOUNT: This field identifies the funding source of the loan. Example: Emergency Loan Fund.

Columns Comments for RPRASTD_APPLIED_DATE (# 4)

Source Code Comments

APPLIED DATE: This field maintains the application date of the short-term loan.

Columns Comments for RPRASTD_REQUEST_AMT (# 5)

Source Code Comments

REQUESTED AMOUNT: This field maintains the amount of the short-term loan that was requested.

Columns Comments for RPRASTD_DUE_DATE (# 6)

Source Code Comments

DUE DATE: This field maintains the due date of the short-term loan.

Columns Comments for RPRASTD_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 RPRASTD_APPROVE_DATE (# 8)

Source Code Comments

APPROVED DATE: This field maintains the date that the short-term credit application was approved.

Columns Comments for RPRASTD_APPROVE_AMT (# 9)

Source Code Comments

APPROVED AMOUNT: This field maintains the approved amount of the short-term loan.

Columns Comments for RPRASTD_CINT_CODE (# 10)

Source Code Comments

CERTIFICATION INITIALS: This field maintains the initials of the person who approved the short-term credit application.

Columns Comments for RPRASTD_RPSR_CODE (# 11)

Source Code Comments

REPAYMENT SOURCE: This field maintains the source of repayment.

Columns Comments for RPRASTD_RECEIVE_DATE (# 12)

Source Code Comments

RECEIVED DATE: This field maintains the date that the student received the short-term loan.

Columns Comments for RPRASTD_REPAID_DATE (# 13)

Source Code Comments

REPAID DATE: This field maintains the most recent date that repayment was made.

Columns Comments for RPRASTD_REPAID_AMT (# 14)

Source Code Comments

REPAID AMOUNT: This field maintains the amount of the actual repayment.

Columns Comments for RPRASTD_RECEIVE_AMT (# 15)

Source Code Comments

AMOUNT RECEIVED: This is the amount of the short-term loan that was actually paid to the student.

Columns Comments for RPRASTD_COLLECT_AMT (# 16)

Source Code Comments

COLLECTION FEE: This is the amount of collection, penalty or interest charges on the short-term credit loan application of the student.

Columns Comments for RPRASTD_BALANCE_DUE (# 17)

Source Code Comments

BALANCE DUE: This is the current balance due on the loan record accounting for the amount actually paid, partial repayments, and extra fees charged for collection, interest, penalties, or processing fees.

Columns Comments for RPRASTD_USER_ID (# 18)

Source Code Comments

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

Table RPRLCRT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRLCRT_PIDM	NUMBER(8,0)	No	*	*
RPRLCRT_FUND_CODE	VARCHAR2(6)	No	*	*
RPRLCRT_APPL_NO	NUMBER(3,0)	No	*	*
RPRLCRT_SEQ_NO	NUMBER(3,0)	No	*
RPRLCRT_BUDGET_AMT	NUMBER(11,2)	Yes
RPRLCRT_TOTAL_AID_AMT	NUMBER(11,2)	Yes
RPRLCRT_TFC_AMT	NUMBER(11,2)	Yes
RPRLCRT_MAX_ELIG_AMT	NUMBER(11,2)	Yes
RPRLCRT_AGI_AMT	NUMBER(11,2)	Yes
RPRLCRT_EXPECT_AMT	NUMBER(11,2)	No
RPRLCRT_ACTIVITY_DATE	DATE	No
RPRLCRT_CINT_CODE	VARCHAR2(4)	Yes		*
RPRLCRT_CERT_DATE	DATE	Yes
RPRLCRT_CLAS_CODE	VARCHAR2(1)	Yes
RPRLCRT_EXP_GRAD_MTH_YR	VARCHAR2(8)	Yes
RPRLCRT_DEPEND_STATUS	VARCHAR2(1)	Yes
RPRLCRT_HOUS_CDE	VARCHAR2(1)	Yes
RPRLCRT_ENROLL_STATUS	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRLCRT_PIDM	RPRLAPP_PIDM	RPRLAPP
RPRLCRT_FUND_CODE	RPRLAPP_FUND_CODE	RPRLAPP
RPRLCRT_APPL_NO	RPRLAPP_APPL_NO	RPRLAPP
RPRLCRT_CINT_CODE	RTVCINT_CODE	RTVCINT

Index

Index Name	Index Type	Column Name
PK_RPRLCRT	Unique	RPRLCRT_PIDM
PK_RPRLCRT	Unique	RPRLCRT_FUND_CODE
PK_RPRLCRT	Unique	RPRLCRT_APPL_NO
PK_RPRLCRT	Unique	RPRLCRT_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_CALC_LOAN_ENROLL_STATUS	Oracle Package Procedure	S10B80.BANINST1.RPKLOAN	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRLCRT	SQL Index	S10B80.FAISMGR	Rely On
RPRLAPP	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVCINT	SQL Table	S10B80.FAISMGR	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRLCRT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:45:000	04/02/2008 10:35:22:000

Source Code Comments

Loan Certification Table

Columns Comments for RPRLCRT_PIDM (# 1)

Source Code Comments

PIDM: Internal system generated student identification number.

Columns Comments for RPRLCRT_FUND_CODE (# 2)

Source Code Comments

FUND CODE: This field represents the fund code associated with the loan being processed.

Columns Comments for RPRLCRT_APPL_NO (# 3)

Source Code Comments

APPLICATION NUMBER:

Columns Comments for RPRLCRT_SEQ_NO (# 4)

Source Code Comments

SEQUENCE NUMBER: This field represents the internal assigned sequence of the loan certification.

Columns Comments for RPRLCRT_BUDGET_AMT (# 5)

Source Code Comments

BUDGET AMOUNT: This field represents the student's budget for the loan period.

Columns Comments for RPRLCRT_TOTAL_AID_AMT (# 6)

Source Code Comments

TOTAL AID AMOUNT: This field represents the total aid and resources the student has during the specified loan period.

Columns Comments for RPRLCRT_TFC_AMT (# 7)

Source Code Comments

TOTAL FAMILY CONTRIBUTION AMOUNT: This field represents the TFC for the loan period.

Columns Comments for RPRLCRT_MAX_ELIG_AMT (# 8)

Source Code Comments

MAXIMUM ELIGIBLE AMOUNT: This field represents the maximum amount of the loan that the student is eligible to receive during the specified loan period.

Columns Comments for RPRLCRT_AGI_AMT (# 9)

Source Code Comments

ADJUSTED GROSS INCOME AMOUNT: This field represents the family AGI.

Columns Comments for RPRLCRT_EXPECT_AMT (# 10)

Source Code Comments

EXPECTED AMOUNT: This field maintains the expected amount of the loan. This will be the lesser of either the processed amount or the requested amount.

Columns Comments for RPRLCRT_ACTIVITY_DATE (# 11)

Source Code Comments

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

Columns Comments for RPRLCRT_CINT_CODE (# 12)

Source Code Comments

CERTIFICATION INITIALS: This field identifies the initials of the person certifying the loan.

Columns Comments for RPRLCRT_CERT_DATE (# 13)

Source Code Comments

CERTIFICATION DATE: This field maintains the date that the certification was signed.

Columns Comments for RPRLCRT_CLAS_CODE (# 14)

Source Code Comments

CLASS CODE: This field identifies the current class level of the student.

Columns Comments for RPRLCRT_EXP_GRAD_MTH_YR (# 15)

Source Code Comments

EXPECTED GRADUATION DATE: This field maintains the expected graduation date of the student in this record.

Columns Comments for RPRLCRT_DEPEND_STATUS (# 16)

Source Code Comments

DEPENDENCY STATUS: This field identifies the dependency status of the student in this record.

Columns Comments for RPRLCRT_HOUS_CDE (# 17)

Source Code Comments

HOUSING CODE: This field maintains the housing code representing where the student will be living during the loan period.

Columns Comments for RPRLCRT_ENROLL_STATUS (# 18)

Source Code Comments

ENROLLMENT STATUS: This field identifies the enrollment status of the student in this record during the intended loan period.

Table RPRSTAC

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
RPRSTAC_CREDIT_ACCT	VARCHAR2(6)	No	*	*
RPRSTAC_SEQ_NO	NUMBER(6,3)	No	*
RPRSTAC_USER_ID	VARCHAR2(30)	Yes
RPRSTAC_ACTIVITY_DATE	DATE	Yes
RPRSTAC_COMMENT	VARCHAR2(50)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RPRSTAC_CREDIT_ACCT	RPBSTAB_CREDIT_ACCT	RPBSTAB

Index

Index Name	Index Type	Column Name
PK_RPRSTAC	Unique	RPRSTAC_CREDIT_ACCT
PK_RPRSTAC	Unique	RPRSTAC_SEQ_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RPRSTAC	SQL Index	S10B80.FAISMGR	Rely On
RPBSTAB	SQL Table	S10B80.FAISMGR	Refer (no action)
RT_RPRSTAC_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RPRSTAC_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RPRSTAC

Object Dates

Creation Date	Analysis Date
04/02/2008 10:29:06:000	04/02/2008 10:35:21:000

Source Code Comments

Short-Term Credit Account Comments

Columns Comments for RPRSTAC_CREDIT_ACCT (# 1)

Source Code Comments

CREDIT ACCOUNT: This field maintains the credit account associated with the comment.

Columns Comments for RPRSTAC_SEQ_NO (# 2)

Source Code Comments

SEQUENCE NUMBER: System-generated sequence number assigned to the comment.

Columns Comments for RPRSTAC_USER_ID (# 3)

Source Code Comments

USER ID: This field maintains the user identification of the user entering the comment.

Columns Comments for RPRSTAC_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 RPRSTAC_COMMENT (# 5)

Source Code Comments

COMMENT: This field maintains a free-form, non-validated comment associated with the credit account identified in the key block.

Table RTVCINT

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVCINT_CODE	VARCHAR2(4)	No	*
RTVCINT_LAST_NAME	VARCHAR2(60)	No
RTVCINT_FIRST_NAME	VARCHAR2(60)	No
RTVCINT_MI	VARCHAR2(60)	Yes
RTVCINT_ACTIVITY_DATE	DATE	Yes
RTVCINT_SURNAME_PREFIX	VARCHAR2(60)	Yes
RTVCINT_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVCINT	Unique	RTVCINT_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRASTD	SQL Table	S10B80.FAISMGR	Refer (no action)
RPRLCRT	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVCINTC	Oracle Package Cursor	S10B80.BANINST1.RTKCINT	Use (select)Rely On
RTVCINT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RTVCINT	SQL Index	S10B80.FAISMGR	Rely On
RT_RTVCINT_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RTVCINT_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVCINT

Object Dates

Creation Date	Analysis Date
04/02/2008 10:28:36:000	04/02/2008 10:35:21:000

Source Code Comments

Certification Initials Validation Table

Columns Comments for RTVCINT_CODE (# 1)

Source Code Comments

CERTIFICATION INITIALS: This field is used to store valid initials of people who are eligible to certify a loan.

Columns Comments for RTVCINT_LAST_NAME (# 2)

Source Code Comments

LAST NAME: This field stores the last name associated with the last character of the certification initials.

Columns Comments for RTVCINT_FIRST_NAME (# 3)

Source Code Comments

FIRST NAME: This is the first name associated with the first character of the certification initials.

Columns Comments for RTVCINT_MI (# 4)

Source Code Comments

MIDDLE INITIAL: This field stores the middle initial associated with the middle character of the certification initials.

Columns Comments for RTVCINT_ACTIVITY_DATE (# 5)

Source Code Comments

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

Columns Comments for RTVCINT_SURNAME_PREFIX (# 6)

Source Code Comments

SURNAME PREFIX: Name tag preceding the last name or surname. (Van, Von, Mac. etc.)

Columns Comments for RTVCINT_USER_ID (# 7)

Source Code Comments

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

Table RTVRPSR

Server Name S10B80
Database Name FAISMGR
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
RTVRPSR_CODE	VARCHAR2(4)	No	*
RTVRPSR_DESC	VARCHAR2(30)	No
RTVRPSR_ACTIVITY_DATE	DATE	Yes
RTVRPSR_USER_ID	VARCHAR2(30)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RTVRPSR	Unique	RTVRPSR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
RPRASTD	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVRPSRC	Oracle Package Cursor	S10B80.BANINST1.RTKRPSR	Use (select)Rely On
RTVRPSR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_RTVRPSR	SQL Index	S10B80.FAISMGR	Rely On
RT_RTVRPSR_LOG_INSUPDDTL	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,delete,after,each row)
RT_RTVRPSR_USERACTIVIT_INSUPD	SQL Trigger	S10B80.FAISMGR	Fire (Insert,update,before,each row)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.FAISMGR.RTVRPSR

Object Dates

Creation Date	Analysis Date
04/02/2008 10:26:26:000	04/02/2008 10:35:19:000

Source Code Comments

Repayment Source Validation Table

Columns Comments for RTVRPSR_CODE (# 1)

Source Code Comments

REPAYMENT SOURCE CODE: This field maintains the various source codes for repayment.

Columns Comments for RTVRPSR_DESC (# 2)

Source Code Comments

REPAYMENT SOURCE CODE DESCRIPTION: This field maintains the description of the repayment source code.

Columns Comments for RTVRPSR_ACTIVITY_DATE (# 3)

Source Code Comments

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

Columns Comments for RTVRPSR_USER_ID (# 4)

Source Code Comments

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

Link between RPRASTD and RTVCINT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRASTD and RTVCINT (FK1_RPRASTD_INV_RTVCINT_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRASTD	RPRASTD_CINT_CODE	RTVCINT_CODE	RTVCINT	(0,1)-(0,n)

Link between RPRASTD and RTVRPSR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRASTD and RTVRPSR (FK1_RPRASTD_INV_RTVRPSR_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRASTD	RPRASTD_RPSR_CODE	RTVRPSR_CODE	RTVRPSR	(0,1)-(0,n)

Link between RPRSTAC and RPBSTAB

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRSTAC and RPBSTAB (FK1_RPRSTAC_INV_RPBSTAB_KEY)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRSTAC	RPRSTAC_CREDIT_ACCT	RPBSTAB_CREDIT_ACCT	RPBSTAB	(1,1)-(0,n)

Link between RPRLCRT and RTVCINT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between RPRLCRT and RTVCINT (FK1_RPRLCRT_INV_RTVCINT_CODE)	FAISMGR

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
RPRLCRT	RPRLCRT_CINT_CODE	RTVCINT_CODE	RTVCINT	(0,1)-(0,n)