FA_BPKG_CRITLST (SQL Table)	Index Back
Batch Packaging Criteria Table Batch Packaging Criteria Table This table contains the fieldname and fieldvalues used to select students for batch packaging.

FA_BPKG_CRITLST

(SQL Table)

Batch Packaging Criteria Table

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

Parent record: FA_BPKG_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