FA_INST_CRITLST (SQL Table)	Index Back
Inst Batch Pckg Criteria Table Institutional Batch Packaging Criteria Table This table contains the fieldname and fieldvalues used to select students with institutional data for batch packaging.

FA_INST_CRITLST

(SQL Table)

Inst Batch Pckg Criteria Table

Institutional Batch Packaging Criteria Table This table contains the fieldname and fieldvalues used to select students with institutional data for batch packaging.

Parent record: FA_INST_CRIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 FA_BPKG_QUERY_DEFN Character(50) VARCHAR2(50) NOT NULL Selection Definition

4 CRITERIA_NBR Number(3,0) SMALLINT NOT NULL Criteria Nbr
Default Value: 1

5 FA_BPKG_INLIST_NBR Number(3,0) SMALLINT NOT NULL In List Item Nbr
Default Value: 1

6 FA_CHAR Character(50) VARCHAR2(50) NOT NULL Character Field
Prompt Table: %EDITTABLE

7 FA_DATE Date(10) DATE Date

8 FA_SIGNED_NBR Signed Number(13,2) DECIMAL(11,2) NOT NULL Signed Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
2	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL
3	FA_BPKG_QUERY_DEFN	Character(50)	VARCHAR2(50) NOT NULL	Selection Definition
4	CRITERIA_NBR	Number(3,0)	SMALLINT NOT NULL	Criteria Nbr Default Value: 1
5	FA_BPKG_INLIST_NBR	Number(3,0)	SMALLINT NOT NULL	In List Item Nbr Default Value: 1
6	FA_CHAR	Character(50)	VARCHAR2(50) NOT NULL	Character Field Prompt Table: %EDITTABLE
7	FA_DATE	Date(10)	DATE	Date
8	FA_SIGNED_NBR	Signed Number(13,2)	DECIMAL(11,2) NOT NULL	Signed Number