Model Logging

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

List of Objects

Object Name	Object Type	Layer Name
RCRLDS1	TABLE	Default
RCRLDS2	TABLE	Default
RCRLDS3	TABLE	Default
RCRLDS4	TABLE	Default
RCRLDS5	TABLE	Default
RCRLDS6	TABLE	Default
RCRLDS7	TABLE	Default
RCRLDS8	TABLE	Default
RLRAPP1	TABLE	Default
RLRAPP2	TABLE	Default
RLRAPP3	TABLE	Default
RLRAPP4	TABLE	Default
RLRIMP1	TABLE	Default
RLRLDS1	TABLE	Default
RLRLDS2	TABLE	Default
RLRLDS3	TABLE	Default
RLRLDS4	TABLE	Default
RLRLDS5	TABLE	Default
RLRLDS6	TABLE	Default
RLRLDS7	TABLE	Default
RLRLDS8	TABLE	Default
RLROVRD	TABLE	Default
RLRSTAT	TABLE	Default
ROBALOG	TABLE	Default
ROBLOGC	TABLE	Default
RORDSUP	TABLE	Default
RORDVAL	TABLE	Default
RORLOGC	TABLE	Default
RORLOGD	TABLE	Default
RORLOGM	TABLE	Default
RTVAPRD	TABLE	Default
RTVBGRP	TABLE	Default
RTVINFC	TABLE	Default
RTVPGRP	TABLE	Default
RTVTGRP	TABLE	Default

Comments

Model View

Table RCRLDS1

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RCRLDS1_AIDY_CODE	RCRLDS1_AIDY_CODE	VARCHAR2(4)	No	*	*
RCRLDS1_PIDM	RCRLDS1_PIDM	NUMBER(8,0)	No	*	*
RCRLDS1_INFC_CODE	RCRLDS1_INFC_CODE	VARCHAR2(7)	No	*	*
RCRLDS1_SEQ_NO	RCRLDS1_SEQ_NO	NUMBER(3,0)	No	*	*
RCRLDS1_CURR_REC_IND	RCRLDS1_CURR_REC_IND	VARCHAR2(1)	No
RCRLDS1_CREATOR_ID	RCRLDS1_CREATOR_ID	VARCHAR2(30)	No
RCRLDS1_USER_ID	RCRLDS1_USER_ID	VARCHAR2(30)	No
RCRLDS1_CREATE_DATE	RCRLDS1_CREATE_DATE	DATE	No
RCRLDS1_ACTIVITY_DATE	RCRLDS1_ACTIVITY_DATE	DATE	No
RCRLDS1_GA_CODE_1	RCRLDS1_GA_CODE_1	VARCHAR2(3)	Yes
RCRLDS1_GA_CODE_2	RCRLDS1_GA_CODE_2	VARCHAR2(3)	Yes
RCRLDS1_GA_CODE_3	RCRLDS1_GA_CODE_3	VARCHAR2(3)	Yes
RCRLDS1_GA_SCHL_CODE_1	RCRLDS1_GA_SCHL_CODE_1	VARCHAR2(8)	Yes
RCRLDS1_GA_SCHL_CODE_2	RCRLDS1_GA_SCHL_CODE_2	VARCHAR2(8)	Yes
RCRLDS1_GA_SCHL_CODE_3	RCRLDS1_GA_SCHL_CODE_3	VARCHAR2(8)	Yes
RCRLDS1_GA_REGION_CODE	RCRLDS1_GA_REGION_CODE	VARCHAR2(2)	Yes
RCRLDS1_GRANT_PROG_1	RCRLDS1_GRANT_PROG_1	VARCHAR2(2)	Yes
RCRLDS1_GRANT_OVERPMT_1	RCRLDS1_GRANT_OVERPMT_1	VARCHAR2(1)	Yes
RCRLDS1_GRANT_PROG_2	RCRLDS1_GRANT_PROG_2	VARCHAR2(2)	Yes
RCRLDS1_GRANT_OVERPMT_2	RCRLDS1_GRANT_OVERPMT_2	VARCHAR2(1)	Yes
RCRLDS1_GRANT_PROG_3	RCRLDS1_GRANT_PROG_3	VARCHAR2(2)	Yes
RCRLDS1_GRANT_OVERPMT_3	RCRLDS1_GRANT_OVERPMT_3	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RCRLDS1_AIDY_CODE	RCRAPP2_AIDY_CODE	RCRAPP2
RCRLDS1_PIDM	RCRAPP2_PIDM	RCRAPP2
RCRLDS1_INFC_CODE	RCRAPP2_INFC_CODE	RCRAPP2
RCRLDS1_SEQ_NO	RCRAPP2_SEQ_NO	RCRAPP2

Index

Index Name	Index Type	Column Name
PK_RCRLDS1	Unique	RCRLDS1_AIDY_CODE
PK_RCRLDS1	Unique	RCRLDS1_PIDM
PK_RCRLDS1	Unique	RCRLDS1_INFC_CODE
PK_RCRLDS1	Unique	RCRLDS1_SEQ_NO
RCRLDS1_AIDY_INDEX		RCRLDS1_AIDY_CODE
RCRLDS1_AIDY_INDEX		RCRLDS1_PIDM
RCRLDS1_AIDY_INDEX		RCRLDS1_CURR_REC_IND

Comments

Source Code Comments

Applicant NSLDS Table Part 1

Columns Comments for RCRLDS1_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, 1991, 1992, etc.

Columns Comments for RCRLDS1_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RCRLDS1_INFC_CODE (3)

Source Code Comments

INTERFACE TAPE CODE: A code from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, ACT-CSS

Columns Comments for RCRLDS1_SEQ_NO (4)

Source Code Comments

SEQUENCE NUMBER: The number to uniquely identify the application if multiple applications have been stored from the same processor/source.

Columns Comments for RCRLDS1_CURR_REC_IND (5)

Source Code Comments

APPLICATION CREATOR ID: The ID of the person who created this application record on the database.

Columns Comments for RCRLDS1_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 RCRLDS1_CREATE_DATE (8)

Source Code Comments

APPLICATION CREATED DATE: The date that this application record was created on the database.

Columns Comments for RCRLDS1_ACTIVITY_DATE (9)

Source Code Comments

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

Columns Comments for RCRLDS1_GA_CODE_1 (10)

Source Code Comments

GA MATCH CODE 1: GA Match, Code 1

Columns Comments for RCRLDS1_GA_CODE_2 (11)

Source Code Comments

GA MATCH CODE 2: GA Match, Code 2

Columns Comments for RCRLDS1_GA_CODE_3 (12)

Source Code Comments

GA MATCH CODE 3: GA Match, Code 3

Columns Comments for RCRLDS1_GA_SCHL_CODE_1 (13)

Source Code Comments

GA MATCH SCHOOL CODE 1: GA Match, SCHOOL Code 1

Columns Comments for RCRLDS1_GA_SCHL_CODE_2 (14)

Source Code Comments

GA MATCH SCHOOL CODE 2: GA Match, SCHOOL Code 2

Columns Comments for RCRLDS1_GA_SCHL_CODE_3 (15)

Source Code Comments

GA MATCH SCHOOL CODE 3: GA Match, SCHOOL Code 3

Columns Comments for RCRLDS1_GA_REGION_CODE (16)

Source Code Comments

GA MATCH REGION CODE: GA Match, Region Code

Columns Comments for RCRLDS1_GRANT_PROG_1 (17)

Source Code Comments

GRANT MATCH 1 GRANT PROGRAM: Grant Match 1, Grant Program

Columns Comments for RCRLDS1_GRANT_OVERPMT_1 (18)

Source Code Comments

GRANT MATCH 1 OVERPAYMENT: Grant Match 1, Overpayment

Columns Comments for RCRLDS1_GRANT_PROG_2 (19)

Source Code Comments

GRANT MATCH 2 GRANT PROGRAM: Grant Match 2, Grant Program

Columns Comments for RCRLDS1_GRANT_OVERPMT_2 (20)

Source Code Comments

GRANT MATCH 2 OVERPAYMENT: Grant Match 2, Overpayment

Columns Comments for RCRLDS1_GRANT_PROG_3 (21)

Source Code Comments

GRANT MATCH 3 GRANT PROGRAM: Grant Match 3, Grant Program

Columns Comments for RCRLDS1_GRANT_OVERPMT_3 (22)

Source Code Comments

GRANT MATCH 3 OVERPAYMENT: Grant Match 3, Overpayment

Table RCRLDS2

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
RCRLDS2_AIDY_CODE	RCRLDS2_AIDY_CODE	VARCHAR2(4)	No	*
RCRLDS2_PIDM	RCRLDS2_PIDM	NUMBER(8,0)	No	*
RCRLDS2_INFC_CODE	RCRLDS2_INFC_CODE	VARCHAR2(7)	No	*
RCRLDS2_SEQ_NO	RCRLDS2_SEQ_NO	NUMBER(3,0)	No	*
RCRLDS2_CURR_REC_IND	RCRLDS2_CURR_REC_IND	VARCHAR2(1)	No
RCRLDS2_CREATOR_ID	RCRLDS2_CREATOR_ID	VARCHAR2(30)	No
RCRLDS2_USER_ID	RCRLDS2_USER_ID	VARCHAR2(30)	No
RCRLDS2_CREATE_DATE	RCRLDS2_CREATE_DATE	DATE	No
RCRLDS2_ACTIVITY_DATE	RCRLDS2_ACTIVITY_DATE	DATE	No
RCRLDS2_MATCH_NO	RCRLDS2_MATCH_NO	NUMBER(2,0)	No	*
RCRLDS2_PRCD_CODE	RCRLDS2_PRCD_CODE	VARCHAR2(2)	Yes
RCRLDS2_LOAN_TYPE_STATUS	RCRLDS2_LOAN_TYPE_STATUS	VARCHAR2(2)	Yes
RCRLDS2_LOAN_TYPE_BAL	RCRLDS2_LOAN_TYPE_BAL	NUMBER(6,0)	Yes
RCRLDS2_LOAN_TYPE_UPDATE	RCRLDS2_LOAN_TYPE_UPDATE	DATE	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RCRLDS2	Unique	RCRLDS2_AIDY_CODE
PK_RCRLDS2	Unique	RCRLDS2_PIDM
PK_RCRLDS2	Unique	RCRLDS2_INFC_CODE
PK_RCRLDS2	Unique	RCRLDS2_SEQ_NO
PK_RCRLDS2	Unique	RCRLDS2_MATCH_NO
RCRLDS2_AIDY_INDEX		RCRLDS2_AIDY_CODE
RCRLDS2_AIDY_INDEX		RCRLDS2_PIDM
RCRLDS2_AIDY_INDEX		RCRLDS2_CURR_REC_IND

Comments

Source Code Comments

Applicant NSLDS Table Part 2

Columns Comments for RCRLDS2_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, 1991, 1992, etc.

Columns Comments for RCRLDS2_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RCRLDS2_INFC_CODE (3)

Source Code Comments

INTERFACE TAPE CODE: A code from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, ACT-CSS

Columns Comments for RCRLDS2_SEQ_NO (4)

Source Code Comments

SEQUENCE NUMBER: The number to uniquely identify the application if multiple applications have been stored from the same processor/source.

Columns Comments for RCRLDS2_CURR_REC_IND (5)

Source Code Comments

APPLICATION CREATOR ID: The ID of the person who created this application record on the database.

Columns Comments for RCRLDS2_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 RCRLDS2_CREATE_DATE (8)

Source Code Comments

APPLICATION CREATED DATE: The date that this application record was created on the database.

Columns Comments for RCRLDS2_ACTIVITY_DATE (9)

Source Code Comments

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

Columns Comments for RCRLDS2_MATCH_NO (10)

Source Code Comments

MATCH NUMBER: This number indicates what occurrence of the Loan Type Program this record is

Columns Comments for RCRLDS2_PRCD_CODE (11)

Source Code Comments

LOAN TYPE MATCH PROGRAM: Loan Type Match, Program

Columns Comments for RCRLDS2_LOAN_TYPE_STATUS (12)

Source Code Comments

LOAN TYPE MATCH MATCH TYPE: Loan Type Match, Match Type

Columns Comments for RCRLDS2_LOAN_TYPE_BAL (13)

Source Code Comments

LOAN TYPE MATCH OUTSTANDING BALANCE: Loan Type Match, Outstanding Balance

Columns Comments for RCRLDS2_LOAN_TYPE_UPDATE (14)

Source Code Comments

LOAN TYPE MATCH UPDATE DATE: Loan Type Match, Update Date

Table RCRLDS3

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
RCRLDS3_AIDY_CODE	RCRLDS3_AIDY_CODE	VARCHAR2(4)	No	*
RCRLDS3_PIDM	RCRLDS3_PIDM	NUMBER(8,0)	No	*
RCRLDS3_INFC_CODE	RCRLDS3_INFC_CODE	VARCHAR2(7)	No	*
RCRLDS3_SEQ_NO	RCRLDS3_SEQ_NO	NUMBER(3,0)	No	*
RCRLDS3_CURR_REC_IND	RCRLDS3_CURR_REC_IND	VARCHAR2(1)	No
RCRLDS3_CREATOR_ID	RCRLDS3_CREATOR_ID	VARCHAR2(30)	No
RCRLDS3_USER_ID	RCRLDS3_USER_ID	VARCHAR2(30)	No
RCRLDS3_CREATE_DATE	RCRLDS3_CREATE_DATE	DATE	No
RCRLDS3_ACTIVITY_DATE	RCRLDS3_ACTIVITY_DATE	DATE	No
RCRLDS3_MATCH_NO	RCRLDS3_MATCH_NO	NUMBER(2,0)	No	*
RCRLDS3_PRCD_CODE	RCRLDS3_PRCD_CODE	VARCHAR2(2)	Yes
RCRLDS3_LOAN_LEVEL_NET_AMT	RCRLDS3_LOAN_LEVEL_NET_AMT	NUMBER(5,0)	Yes
RCRLDS3_LOAN_LEVEL_ACYR	RCRLDS3_LOAN_LEVEL_ACYR	VARCHAR2(1)	Yes
RCRLDS3_LOAN_LEVEL_BEG_DATE	RCRLDS3_LOAN_LEVEL_BEG_DATE	DATE	Yes
RCRLDS3_LOAN_LEVEL_END_DATE	RCRLDS3_LOAN_LEVEL_END_DATE	DATE	Yes
RCRLDS3_LOAN_LEVEL_DISB_AMT	RCRLDS3_LOAN_LEVEL_DISB_AMT	NUMBER(5,0)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RCRLDS3	Unique	RCRLDS3_AIDY_CODE
PK_RCRLDS3	Unique	RCRLDS3_PIDM
PK_RCRLDS3	Unique	RCRLDS3_INFC_CODE
PK_RCRLDS3	Unique	RCRLDS3_SEQ_NO
PK_RCRLDS3	Unique	RCRLDS3_MATCH_NO
RCRLDS3_AIDY_INDEX		RCRLDS3_AIDY_CODE
RCRLDS3_AIDY_INDEX		RCRLDS3_PIDM
RCRLDS3_AIDY_INDEX		RCRLDS3_CURR_REC_IND

Comments

Source Code Comments

Applicant NSLDS Table Part 3

Columns Comments for RCRLDS3_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, 1991, 1992, etc.

Columns Comments for RCRLDS3_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RCRLDS3_INFC_CODE (3)

Source Code Comments

INTERFACE TAPE CODE: A code from the Interface Tape Table indicating the source and format of the application record. EXAMPLES: CSS, ACT-CSS

Columns Comments for RCRLDS3_SEQ_NO (4)

Source Code Comments

SEQUENCE NUMBER: The number to uniquely identify the application if multiple applications have been stored from the same processor/source.

Columns Comments for RCRLDS3_CURR_REC_IND (5)

Source Code Comments

APPLICATION CREATOR ID: The ID of the person who created this application record on the database.

Columns Comments for RCRLDS3_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 RCRLDS3_CREATE_DATE (8)

Source Code Comments

APPLICATION CREATED DATE: The date that this application record was created on the database.

Columns Comments for RCRLDS3_ACTIVITY_DATE (9)

Source Code Comments

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

Columns Comments for RCRLDS3_MATCH_NO (10)

Source Code Comments

MATCH NUMBER: This number indicates what occurrence of the Loan Level Match this record is

Columns Comments for RCRLDS3_PRCD_CODE (11)

Source Code Comments

LOAN LEVEL MATCH PROGRAM: Loan Level Match, Program

Columns Comments for RCRLDS3_LOAN_LEVEL_NET_AMT (12)

Source Code Comments

LOAN LEVEL MATCH NET AMOUNT: Loan Level Match, Net Amount

Columns Comments for RCRLDS3_LOAN_LEVEL_ACYR (13)

Source Code Comments

LOAN LEVEL MATCH ACADEMIC YEAR: Loan Level Match, Academic Year

Columns Comments for RCRLDS3_LOAN_LEVEL_BEG_DATE (14)

Source Code Comments

LOAN LEVEL MATCH LOAN BEG DATE: Loan Level Match, Loan begining date

Columns Comments for RCRLDS3_LOAN_LEVEL_END_DATE (15)

Source Code Comments

LOAN LEVEL MATCH LOAN END DATE: Loan Level Match, Loan ending date

Columns Comments for RCRLDS3_LOAN_LEVEL_DISB_AMT (16)

Source Code Comments

LOAN LEVEL MATCH GROSS AMT DISBURSED: Loan Level Match, Gross Amount Disbursed

Table RCRLDS4

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
RCRLDS4_AIDY_CODE	RCRLDS4_AIDY_CODE	VARCHAR2(4)	No	*	*
RCRLDS4_PIDM	RCRLDS4_PIDM	NUMBER(8,0)	No	*	*
RCRLDS4_INFC_CODE	RCRLDS4_INFC_CODE	VARCHAR2(7)	No	*	*
RCRLDS4_SEQ_NO	RCRLDS4_SEQ_NO	NUMBER(3,0)	No	*	*
RCRLDS4_CURR_REC_IND	RCRLDS4_CURR_REC_IND	VARCHAR2(1)	No
RCRLDS4_CREATOR_ID	RCRLDS4_CREATOR_ID	VARCHAR2(30)	No
RCRLDS4_USER_ID	RCRLDS4_USER_ID	VARCHAR2(30)	No
RCRLDS4_CREATE_DATE	RCRLDS4_CREATE_DATE	DATE	No
RCRLDS4_ACTIVITY_DATE	RCRLDS4_ACTIVITY_DATE	DATE	No
RCRLDS4_NSLDS_DB_RESULT_FLAG	RCRLDS4_NSLDS_DB_RESULT_FLAG	VARCHAR2(1)	Yes
RCRLDS4_AGT_SUB_OUT_PRIN_BAL	RCRLDS4_AGT_SUB_OUT_PRIN_BAL	NUMBER(6,0)	Yes
RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL	RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL	NUMBER(6,0)	Yes
RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2	RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2	NUMBER(6,0)	Yes
RCRLDS4_PERK_CUMULATIVE_AMT	RCRLDS4_PERK_CUMULATIVE_AMT	NUMBER(6,0)	Yes
RCRLDS4_PERK_CURRENT_YR_AMT	RCRLDS4_PERK_CURRENT_YR_AMT	NUMBER(6,0)	Yes
RCRLDS4_PERK_1ST_DISB_FLAG_1	RCRLDS4_PERK_1ST_DISB_FLAG_1	VARCHAR2(1)	Yes
RCRLDS4_PERK_1ST_DISB_FLAG_2	RCRLDS4_PERK_1ST_DISB_FLAG_2	VARCHAR2(1)	Yes
RCRLDS4_PERK_EXP_LOAN_FLAG	RCRLDS4_PERK_EXP_LOAN_FLAG	VARCHAR2(1)	Yes
RCRLDS4_PELL_OVER_PAY_FLAG	RCRLDS4_PELL_OVER_PAY_FLAG	VARCHAR2(1)	Yes
RCRLDS4_SEOG_OVER_PAY_FLAG	RCRLDS4_SEOG_OVER_PAY_FLAG	VARCHAR2(1)	Yes
RCRLDS4_PERK_DEFAULT_FLAG	RCRLDS4_PERK_DEFAULT_FLAG	VARCHAR2(1)	Yes
RCRLDS4_ACT_BANKRUPT_FLAG	RCRLDS4_ACT_BANKRUPT_FLAG	VARCHAR2(1)	Yes
RCRLDS4_PROC_DATE	RCRLDS4_PROC_DATE	DATE	Yes
RCRLDS4_MATCH_IND	RCRLDS4_MATCH_IND	VARCHAR2(1)	Yes
RCRLDS4_AGT_SUB_PEND_DISB	RCRLDS4_AGT_SUB_PEND_DISB	NUMBER(6,0)	Yes
RCRLDS4_AGT_UNSUB_PEND_DISB	RCRLDS4_AGT_UNSUB_PEND_DISB	NUMBER(6,0)	Yes
RCRLDS4_AGT_CONSOL_PEND_DISB	RCRLDS4_AGT_CONSOL_PEND_DISB	NUMBER(6,0)	Yes
RCRLDS4_AGT_SUB_TOTAL	RCRLDS4_AGT_SUB_TOTAL	NUMBER(6,0)	Yes
RCRLDS4_AGT_UNSUB_TOTAL	RCRLDS4_AGT_UNSUB_TOTAL	NUMBER(6,0)	Yes
RCRLDS4_AGT_CONSOL_TOTAL	RCRLDS4_AGT_CONSOL_TOTAL	NUMBER(6,0)	Yes
RCRLDS4_TRAN_NO	RCRLDS4_TRAN_NO	VARCHAR2(2)	Yes
RCRLDS4_PELL_OVER_PAY_CONTACT	RCRLDS4_PELL_OVER_PAY_CONTACT	VARCHAR2(8)	Yes
RCRLDS4_SEOG_OVER_PAY_CONTACT	RCRLDS4_SEOG_OVER_PAY_CONTACT	VARCHAR2(8)	Yes
RCRLDS4_PERK_OVER_PAY_CONTACT	RCRLDS4_PERK_OVER_PAY_CONTACT	VARCHAR2(8)	Yes
RCRLDS4_PERK_OVER_PAY_FLG	RCRLDS4_PERK_OVER_PAY_FLG	VARCHAR2(1)	Yes
RCRLDS4_DEFAULTED_LOAN_FLG	RCRLDS4_DEFAULTED_LOAN_FLG	VARCHAR2(1)	Yes
RCRLDS4_DISCHARG_LOAN_FLG	RCRLDS4_DISCHARG_LOAN_FLG	VARCHAR2(1)	Yes
RCRLDS4_LOAN_SAT_REPAY_FLG	RCRLDS4_LOAN_SAT_REPAY_FLG	VARCHAR2(1)	Yes
RCRLDS4_DEF_LOAN_CHG_FLG	RCRLDS4_DEF_LOAN_CHG_FLG	VARCHAR2(1)	Yes
RCRLDS4_DISCHARG_LOAN_CHG_FLG	RCRLDS4_DISCHARG_LOAN_CHG_FLG	VARCHAR2(1)	Yes
RCRLDS4_LOAN_SAT_REPAY_CHG_FLG	RCRLDS4_LOAN_SAT_REPAY_CHG_FLG	VARCHAR2(1)	Yes
RCRLDS4_ACT_BANKRUPT_CHG_FLG	RCRLDS4_ACT_BANKRUPT_CHG_FLG	VARCHAR2(1)	Yes
RCRLDS4_OVER_PAY_CHG_FLG	RCRLDS4_OVER_PAY_CHG_FLG	VARCHAR2(1)	Yes
RCRLDS4_AGT_CHG_FLG	RCRLDS4_AGT_CHG_FLG	VARCHAR2(1)	Yes
RCRLDS4_PERK_CHG_FLG	RCRLDS4_PERK_CHG_FLG	VARCHAR2(1)	Yes
RCRLDS4_PELL_PMT_CHG_FLG	RCRLDS4_PELL_PMT_CHG_FLG	VARCHAR2(1)	Yes
RCRLDS4_ADDL_PELL_FLG	RCRLDS4_ADDL_PELL_FLG	VARCHAR2(1)	Yes
RCRLDS4_ADDL_LOANS_FLG	RCRLDS4_ADDL_LOANS_FLG	VARCHAR2(1)	Yes
RCRLDS4_AGT_COMB_TOTAL	RCRLDS4_AGT_COMB_TOTAL	NUMBER(6,0)	Yes
RCRLDS4_AGT_COMB_PEND_DISB	RCRLDS4_AGT_COMB_PEND_DISB	NUMBER(6,0)	Yes
RCRLDS4_AGT_COMB_PRIN_BAL	RCRLDS4_AGT_COMB_PRIN_BAL	NUMBER(6,0)	Yes
RCRLDS4_POST_SCREEN_RSN_CDE	RCRLDS4_POST_SCREEN_RSN_CDE	VARCHAR2(2)	Yes
RCRLDS4_DL_MPN_FLAG	RCRLDS4_DL_MPN_FLAG	VARCHAR2(1)	Yes
RCRLDS4_FFEL_MPN_FLAG	RCRLDS4_FFEL_MPN_FLAG	VARCHAR2(1)	Yes
RCRLDS4_FFEL_LEND_CODE	RCRLDS4_FFEL_LEND_CODE	VARCHAR2(6)	Yes
RCRLDS4_LOAN_CHG_FLAG	RCRLDS4_LOAN_CHG_FLAG	VARCHAR2(1)	Yes
RCRLDS4_CURRENT_SSN	RCRLDS4_CURRENT_SSN	VARCHAR2(9)	Yes
RCRLDS4_CURRENT_FIRST_NAME	RCRLDS4_CURRENT_FIRST_NAME	VARCHAR2(12)	Yes
RCRLDS4_CURRENT_LAST_NAME	RCRLDS4_CURRENT_LAST_NAME	VARCHAR2(35)	Yes
RCRLDS4_CURRENT_BIRTH_DATE	RCRLDS4_CURRENT_BIRTH_DATE	DATE	Yes
RCRLDS4_DL_PLUS_MPN_FLAG	RCRLDS4_DL_PLUS_MPN_FLAG	VARCHAR2(1)	Yes
RCRLDS4_POST_SCREEN_RSN_CDE_2	RCRLDS4_POST_SCREEN_RSN_CDE_2	VARCHAR2(2)	Yes
RCRLDS4_POST_SCREEN_RSN_CDE_3	RCRLDS4_POST_SCREEN_RSN_CDE_3	VARCHAR2(2)	Yes
RCRLDS4_AGT_OVER_LIMIT_SUB	RCRLDS4_AGT_OVER_LIMIT_SUB	VARCHAR2(1)	Yes
RCRLDS4_AGT_OVER_LIMIT_COMB	RCRLDS4_AGT_OVER_LIMIT_COMB	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
RCRLDS4_AIDY_CODE	RCRAPP2_AIDY_CODE	RCRAPP2
RCRLDS4_PIDM	RCRAPP2_PIDM	RCRAPP2
RCRLDS4_INFC_CODE	RCRAPP2_INFC_CODE	RCRAPP2
RCRLDS4_SEQ_NO	RCRAPP2_SEQ_NO	RCRAPP2

Index

Index Name	Index Type	Column Name
PK_RCRLDS4	Unique	RCRLDS4_AIDY_CODE
PK_RCRLDS4	Unique	RCRLDS4_PIDM
PK_RCRLDS4	Unique	RCRLDS4_INFC_CODE
PK_RCRLDS4	Unique	RCRLDS4_SEQ_NO
RCRLDS4_KEY_INDEX		RCRLDS4_AIDY_CODE
RCRLDS4_KEY_INDEX		RCRLDS4_PIDM
RCRLDS4_KEY_INDEX		RCRLDS4_CURR_REC_IND

Comments

Source Code Comments

Applicant NSLDS Table Part 1

Columns Comments for RCRLDS4_AGT_UNSUB_OUT_PRIN_BAL (12)

Source Code Comments

AGGREGATE UNSUBSIDIZED OUTSTANDING PRINCIPLE BALANCE: Provides the cumulative dollars of unsubsidized outstanding principle balance; from the 1999-2000 aid year onward, the term 'unsubsidized' is replaced by 'combined' in this context.

Columns Comments for RCRLDS4_AGT_SUB_OUT_PRIN_BAL_2 (13)

Source Code Comments

NSLDS UNALLOCATED CONSOLIDATED OUTSTANDING PRINCIPAL BALANCE: NSLDS Unallocated Consolidated Outstanding Principal Balance

Columns Comments for RCRLDS4_PROC_DATE (23)

Source Code Comments

PROCESS DATE: The date on which NSLDS processed this student record.

Columns Comments for RCRLDS4_MATCH_IND (24)

Source Code Comments

MATCH INDICATOR: Indicates that NSLDS is in default or refund status.

Columns Comments for RCRLDS4_AGT_SUB_PEND_DISB (25)

Source Code Comments

PENDING SUBSIDIZED DISBURSEMENTS: Aggregate subsidized pending disbursements reported to NSLDS.

Columns Comments for RCRLDS4_AGT_UNSUB_PEND_DISB (26)

Source Code Comments

PENDING UNSUBSIDIZED DISBURSEMENTS: Aggregate unsubsidized pending disbursements reported to NSLDS; from the 1999-2000 aid year onward, the term 'unsubsidized' is replaced by 'combined' in this context.

Columns Comments for RCRLDS4_AGT_CONSOL_PEND_DISB (27)

Source Code Comments

PENDING CONSOLIDATED DISBURSEMENTS: Aggregate consolidated pending disbursements reported to NSLDS.

Columns Comments for RCRLDS4_AGT_SUB_TOTAL (28)

Source Code Comments

AGGREGATE SUBSIDIZED TOTAL: Aggregate total subsidized disbursements reported to NSLDS.

Columns Comments for RCRLDS4_AGT_UNSUB_TOTAL (29)

Source Code Comments

AGGREGATE UNSUBSIDIZED TOTAL: Aggregate total unsubsidized disbursements reported to NSLDS; from the 1999-2000 aid year onward, the term 'unsubsidized' is replaced by 'combined' in this context.

Columns Comments for RCRLDS4_AGT_CONSOL_TOTAL (30)

Source Code Comments

NSLDS UNALLOCATED CONSOLIDATED TOTAL: NSLDS Unallocated Consolidated Total

Columns Comments for RCRLDS4_TRAN_NO (31)

Source Code Comments

TRANSACTION NUMBER: NSLDS transaction number.

Columns Comments for RCRLDS4_PELL_OVER_PAY_CONTACT (32)

Source Code Comments

NSLDS PELL OVERPAYMENT CONTACT: This field indicates the school code where the student's PELL overpayment occurred.

Columns Comments for RCRLDS4_SEOG_OVER_PAY_CONTACT (33)

Source Code Comments

NSLDS SEOG OVERPAYMENT CONTACT: This field indicates the school code where the student's SEOG overpayment occurred.

Columns Comments for RCRLDS4_PERK_OVER_PAY_CONTACT (34)

Source Code Comments

NSLDS PERK OVERPAYMENT CONTACT: This field indicates the school code where the student's PERK overpayment occurred.

Columns Comments for RCRLDS4_PERK_OVER_PAY_FLG (35)

Source Code Comments

PERKINS OVERPAYMENT FLAG: This field indicates whether Perkins was overpaid or if satisfactory repayment has occurred.

Columns Comments for RCRLDS4_DEFAULTED_LOAN_FLG (36)

Source Code Comments

DEFAULTED LOAN FLAG: This field indicates if the student has any loans in default.

Columns Comments for RCRLDS4_DISCHARG_LOAN_FLG (37)

Source Code Comments

DISCHARGED LOAN FLAG: This field indicates if the student has any loans that have been discharged.

Columns Comments for RCRLDS4_LOAN_SAT_REPAY_FLG (38)

Source Code Comments

LOAN SATISFACTORY REPAYMENT FLAG: This field indicates if the student has made satisfactory arrangements to repay the loan.

Columns Comments for RCRLDS4_DEF_LOAN_CHG_FLG (39)

Source Code Comments

DEFAULTED LOAN CHANGE FLAG: This field indicates if there has been a change to the defaulted loan flag since the previous transaction.

Columns Comments for RCRLDS4_DISCHARG_LOAN_CHG_FLG (40)

Source Code Comments

DISCHARGED LOAN CHANGE FLAG: This field indicates if there has been a change to the discharged loan flag since the previous transaction.

Columns Comments for RCRLDS4_LOAN_SAT_REPAY_CHG_FLG (41)

Source Code Comments

LOAN SATISFACTORY REPAYMENT CHANGE FLAG: This field indicates if there has been a change to the satisfactory repayment flag since the previous transaction.

Columns Comments for RCRLDS4_ACT_BANKRUPT_CHG_FLG (42)

Source Code Comments

ACTIVE BANKRUPTCY CHANGE FLAG: This field indicates if there has been a change to the active bankruptcy flag since the previous transaction.

Columns Comments for RCRLDS4_OVER_PAY_CHG_FLG (43)

Source Code Comments

OVERPAYMENTS CHANGE FLAG: This field indicates if there has been a change to any of the overpayment flags since the previous transaction.

Columns Comments for RCRLDS4_AGT_CHG_FLG (44)

Source Code Comments

AGGREGATE LOAN CHANGE FLAG: This field indicates if there has been a change to the aggregate loan amounts since the previous transaction.

Columns Comments for RCRLDS4_PERK_CHG_FLG (45)

Source Code Comments

PERKINS LOAN CHANGE FLAG: This field indicates if there has been a change to the Perkins loan data since the previous transaction.

Columns Comments for RCRLDS4_PELL_PMT_CHG_FLG (46)

Source Code Comments

PELL PAYMENT CHANGE FLAG: This field indicates if there has been a change to the Pell Payment data since the previous transaction.

Columns Comments for RCRLDS4_ADDL_PELL_FLG (47)

Source Code Comments

ADDITIONAL PELL FLAG: This field indicates if the student has additional Pell records beyond what has been included on the ISIR.

Columns Comments for RCRLDS4_ADDL_LOANS_FLG (48)

Source Code Comments

ADDITIONAL LOANS FLAG: This field indicates if the student has additional loans beyond what has been included on the ISIR.

Columns Comments for RCRLDS4_AGT_COMB_TOTAL (49)

Source Code Comments

NSLDS AGGREGATE COMBINED TOTAL: NSLDS Aggregate Combined Total.

Columns Comments for RCRLDS4_AGT_COMB_PEND_DISB (50)

Source Code Comments

NSLDS AGGREGATE COMBINED PENDING DISBURSEMENT: NSLDS Aggregate Combined Pending Disbursement.

Columns Comments for RCRLDS4_AGT_COMB_PRIN_BAL (51)

Source Code Comments

NSLDS AGGREGATE COMBINED PRINCIPLE BALANCE: NSLDS Aggregate Combined Principle Balance.

Columns Comments for RCRLDS4_POST_SCREEN_RSN_CDE (52)

Source Code Comments

NSLDS POST-SCREENING REASON CODE: NSLDS Post-Screening Reason Code; The student's eligibility has changed since the initial screening.

Columns Comments for RCRLDS4_DL_MPN_FLAG (53)

Source Code Comments

DIRECT LOAN MASTER PROMISSORY NOTE FLAG: Direct Loan Master Promissory Note Flag.

Columns Comments for RCRLDS4_FFEL_MPN_FLAG (54)

Source Code Comments

FFEL MASTER PROMISSORY NOTE FLAG: FFEL Master Promissory Note Flag.

Columns Comments for RCRLDS4_FFEL_LEND_CODE (55)

Source Code Comments

FFEL LENDER CODE: FFEL Lender Code.

Columns Comments for RCRLDS4_LOAN_CHG_FLAG (56)

Source Code Comments

LOAN CHANGE FLAG: Indicates that information about 1 or more loans changed.

Columns Comments for RCRLDS4_CURRENT_SSN (57)

Source Code Comments

CURRENT SSN: The current Social Security Number from NSLDS for the student.

Columns Comments for RCRLDS4_CURRENT_FIRST_NAME (58)

Source Code Comments

CURRENT FIRST NAME: The current first name from NSLDS for the student.

Columns Comments for RCRLDS4_CURRENT_LAST_NAME (59)

Source Code Comments

CURRENT LAST NAME: The current last name from NSLDS for the student.

Columns Comments for RCRLDS4_CURRENT_BIRTH_DATE (60)

Source Code Comments

CURRENT BIRTH DATE: The current date of birth from NSLDS for the student.

Columns Comments for RCRLDS4_DL_PLUS_MPN_FLAG (61)

Source Code Comments

DIRECT LOAN PLUS MASTER PROMISSORY NOTE FLAG: Direct Loan PLUS Master Promissory Note Flag.

Columns Comments for RCRLDS4_POST_SCREEN_RSN_CDE_2 (62)

Source Code Comments

NSLDS POST-SCREENING REASON CODE 2: The second NSLDS Post-Screening Reason Code. The student's eligibility has changed since the initial screening.

Columns Comments for RCRLDS4_POST_SCREEN_RSN_CDE_3 (63)

Source Code Comments

NSLDS POST-SCREENING REASON CODE 3: The third NSLDS Post-Screening Reason Code. The student's eligibility has changed since the initial screening.

Columns Comments for RCRLDS4_AGT_OVER_LIMIT_SUB (64)

Source Code Comments

SUBSIDIZED LOAN LIMIT IND: Subsidized Loan Limit Indicator

Columns Comments for RCRLDS4_AGT_OVER_LIMIT_COMB (65)

Source Code Comments

COMBINED LOAN LIMIT IND: Combined Loan Limit Indicator

Table RCRLDS5

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
RCRLDS5_AIDY_CODE	RCRLDS5_AIDY_CODE	VARCHAR2(4)	No	*
RCRLDS5_PIDM	RCRLDS5_PIDM	NUMBER(8,0)	No	*
RCRLDS5_INFC_CODE	RCRLDS5_INFC_CODE	VARCHAR2(7)	No	*
RCRLDS5_SEQ_NO	RCRLDS5_SEQ_NO	NUMBER(3,0)	No	*
RCRLDS5_CURR_REC_IND	RCRLDS5_CURR_REC_IND	VARCHAR2(1)	No
RCRLDS5_CREATOR_ID	RCRLDS5_CREATOR_ID	VARCHAR2(30)	No
RCRLDS5_USER_ID	RCRLDS5_USER_ID	VARCHAR2(30)	No
RCRLDS5_CREATE_DATE	RCRLDS5_CREATE_DATE	DATE	No
RCRLDS5_ACTIVITY_DATE	RCRLDS5_ACTIVITY_DATE	DATE	No
RCRLDS5_MATCH_NO	RCRLDS5_MATCH_NO	NUMBER(3,0)	No	*
RCRLDS5_DEF_LOAN_FAM_CD	RCRLDS5_DEF_LOAN_FAM_CD	VARCHAR2(1)	Yes
RCRLDS5_DEF_ADD_LOAN_FLAG	RCRLDS5_DEF_ADD_LOAN_FLAG	VARCHAR2(1)	Yes
RCRLDS5_DEF_PROG_CD	RCRLDS5_DEF_PROG_CD	VARCHAR2(2)	Yes
RCRLDS5_DEF_STAT_CD	RCRLDS5_DEF_STAT_CD	VARCHAR2(2)	Yes
RCRLDS5_DEF_STAT_DATE	RCRLDS5_DEF_STAT_DATE	DATE	Yes
RCRLDS5_DEF_OUT_BAL	RCRLDS5_DEF_OUT_BAL	NUMBER(5,0)	Yes
RCRLDS5_DEF_BEGIN_DATE	RCRLDS5_DEF_BEGIN_DATE	DATE	Yes
RCRLDS5_DEF_END_DATE	RCRLDS5_DEF_END_DATE	DATE	Yes
RCRLDS5_DEF_GA_CD	RCRLDS5_DEF_GA_CD	VARCHAR2(3)	Yes
RCRLDS5_DEF_INST_CD	RCRLDS5_DEF_INST_CD	VARCHAR2(8)	Yes
RCRLDS5_DEF_SERVICE_CD	RCRLDS5_DEF_SERVICE_CD	VARCHAR2(6)	Yes
RCRLDS5_DEF_REGION_CD	RCRLDS5_DEF_REGION_CD	VARCHAR2(2)	Yes
RCRLDS5_LOAN_AMT	RCRLDS5_LOAN_AMT	NUMBER(5,0)	Yes
RCRLDS5_OUT_BAL_DATE	RCRLDS5_OUT_BAL_DATE	DATE	Yes
RCRLDS5_TRAN_NO	RCRLDS5_TRAN_NO	VARCHAR2(2)	Yes

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_RCRLDS5	Unique	RCRLDS5_AIDY_CODE
PK_RCRLDS5	Unique	RCRLDS5_PIDM
PK_RCRLDS5	Unique	RCRLDS5_INFC_CODE
PK_RCRLDS5	Unique	RCRLDS5_SEQ_NO
PK_RCRLDS5	Unique	RCRLDS5_MATCH_NO
RCRLDS5_KEY_INDEX		RCRLDS5_AIDY_CODE
RCRLDS5_KEY_INDEX		RCRLDS5_PIDM
RCRLDS5_KEY_INDEX		RCRLDS5_CURR_REC_IND

Comments

Source Code Comments

Applicant NSLDS Table Part 2

Columns Comments for RCRLDS5_AIDY_CODE (1)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9495, 9596, 9697.

Columns Comments for RCRLDS5_PIDM (2)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for RCRLDS5_INFC_CODE (3)

Source Code Comments

INTERFACE TAPE CODE: A code from the Interface Tape Table indicating the source and format of the application record.

Columns Comments for RCRLDS5_SEQ_NO (4)

Source Code Comments

SEQUENCE NUMBER: The number to uniquely identify the application if multiple applications have been stored for the student.

Columns Comments for RCRLDS5_CURR_REC_IND (5)

Source Code Comments

CURRENT RECORD INDICATOR: Indicates if this application record has been flagged as the 'current' record for processing.

Columns Comments for RCRLDS5_CREATOR_ID (6)

Source Code Comments

APPLICATION CREATOR ID: The ID of the user who entered or last updated the record on the database.

Columns Comments for RCRLDS5_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 RCRLDS5_CREATE_DATE (8)

Source Code Comments

APPLICATION CREATED DATE: The date that the application record was created on the database.

Columns Comments for RCRLDS5_ACTIVITY_DATE (9)

Source Code Comments

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

Columns Comments for RCRLDS5_MATCH_NO (10)

Source Code Comments

MATCH NUMBER: This number indicates what occurrence of the Loan Level Match this record is

Columns Comments for RCRLDS5_DEF_LOAN_FAM_CD (11)

Source Code Comments

DEFAULTED LOAN 1 - LOAN FAMILY CODE: This field indicates if the defaulted loan is a F=FFEL, D=Direct, or a P=Perkins Loan.

Columns Comments for RCRLDS5_DEF_ADD_LOAN_FLAG (12)

Source Code Comments

DEFAULTED LOAN 1 - ADDITIONAL LOAN FLAG: This field indicates if the student received the defaulted loan funds under the additional loan program.

Columns Comments for RCRLDS5_DEF_PROG_CD (13)

Source Code Comments

DEFAULTED LOAN 1-PROGRAM CODE: This field provides the program code for the defaulted loan 1.

Columns Comments for RCRLDS5_DEF_STAT_CD (14)

Source Code Comments

DEFAULTED LOAN 1 -STATUS CODE: This field provides the status code for the defaulted loan 1.

Columns Comments for RCRLDS5_DEF_STAT_DATE (15)

Source Code Comments

DEFAULTED LOAN 1 - STATUS DATE: This field provides the date that the status was reported.

Columns Comments for RCRLDS5_DEF_OUT_BAL (16)

Source Code Comments

DEFAULTED LOAN 1 - OUTSTANDING BALANCE: This field provides the outstanding balance on the defaulted loan 1.

Columns Comments for RCRLDS5_DEF_BEGIN_DATE (17)

Source Code Comments

DEFAULTED LOAN 1 - BEGIN DATE: This field provides the beginning date of the loan that is defaulted.

Columns Comments for RCRLDS5_DEF_END_DATE (18)

Source Code Comments

DEFAULTED LOAN 1 - END DATE: This field provides the ending date of the loan that is defaulted 1.
<