SFA_ASG_ELIGRSN (SQL Table)	Index Back
ACG/SMART Eligibility Reasons Stores information about a student's ACG/SMART eligibility.

SFA_ASG_ELIGRSN

(SQL Table)

ACG/SMART Eligibility Reasons

Stores information about a student's ACG/SMART eligibility.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: STDNT_AID_SRCH

2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table: AID_YEAR_TBL

4 SFA_ASG_GRANT_TYPE Character(4) VARCHAR2(4) NOT NULL Grant Type
ACG=Academic Competitiveness
SMRT=National SMART

5 STRM Character(4) VARCHAR2(4) NOT NULL Term
Prompt Table: TERM_VAL_TBL

6 SFA_ASG_ELIG_SEQ Number(3,0) SMALLINT NOT NULL ACG/SMART Eligibility Sequence

7 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN

8 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN

9 EQUATION_NAME Character(12) VARCHAR2(12) NOT NULL Equation Name

10 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: STDNT_AID_SRCH
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
3	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL
4	SFA_ASG_GRANT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Grant Type ACG=Academic Competitiveness SMRT=National SMART
5	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term Prompt Table: TERM_VAL_TBL
6	SFA_ASG_ELIG_SEQ	Number(3,0)	SMALLINT NOT NULL	ACG/SMART Eligibility Sequence
7	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: PSMSGSETDEFN
8	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog. Prompt Table: PSMSGCATDEFN
9	EQUATION_NAME	Character(12)	VARCHAR2(12) NOT NULL	Equation Name
10	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.