ISIR_COMMT_TBL (SQL Table)	Index Back
ISIR Comment Descriptions This table contians the comment codes that are issued from CPS.

ISIR_COMMT_TBL

(SQL Table)

ISIR Comment Descriptions

This table contians the comment codes that are issued from CPS.

Related Language Record: ISIR_COMMT_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Prompt Table: FED_AID_YR_TBL

2 COMMENT_CODE Character(3) VARCHAR2(3) NOT NULL Comment

3 SFA_DB_MATCH_USE Character(2) VARCHAR2(2) NOT NULL DB Match Use
01=SSN Match
02=SSA Citizenship
03=DHS (INS) Match
04=VA Match
05=Selective Service Match
06=Selective Service Registration
07=NSLDS Match
08=Drug Offense Conviction Match
09=Parent SSN Match
10=Not Related to DB Match
11=Department of Defense Match
12=Foreign Income Exempt
13=Unaccompanied Youth

4 SEVERITY_LVL Character(1) VARCHAR2(1) NOT NULL Severity Level
0=Ignore
1=Action Required
2=Action Required if SAR C Flag
Default Value: 1

5 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Prompt Table: FED_AID_YR_TBL
2	COMMENT_CODE	Character(3)	VARCHAR2(3) NOT NULL	Comment
3	SFA_DB_MATCH_USE	Character(2)	VARCHAR2(2) NOT NULL	DB Match Use 01=SSN Match 02=SSA Citizenship 03=DHS (INS) Match 04=VA Match 05=Selective Service Match 06=Selective Service Registration 07=NSLDS Match 08=Drug Offense Conviction Match 09=Parent SSN Match 10=Not Related to DB Match 11=Department of Defense Match 12=Foreign Income Exempt 13=Unaccompanied Youth
4	SEVERITY_LVL	Character(1)	VARCHAR2(1) NOT NULL	Severity Level 0=Ignore 1=Action Required 2=Action Required if SAR C Flag Default Value: 1
5	DESCRLONG	Long Character	CLOB	Long Description