FA_BPKG_SEL_VW (SQL View)	Index Back
Batch Packaging Student Select A view of the Batch Packaging table that contains kids ready to package where batch process uses ISIR. Used on the Student List panel.

FA_BPKG_SEL_VW

(SQL View)

Batch Packaging Student Select

A view of the Batch Packaging table that contains kids ready to package where batch process uses ISIR. Used on the Student List panel.

SELECT INSTITUTION , AID_YEAR , FA_INST_BPKG_SW , FA_BPKG_QUERY_DEFN FROM PS_FA_BPKG_STDLIST WHERE FA_INST_BPKG_SW = 'N'

# 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_INST_BPKG_SW Character(1) VARCHAR2(1) NOT NULL Institutional Mass Packaging

4 FA_BPKG_QUERY_DEFN Character(50) VARCHAR2(50) NOT NULL Selection Definition
Prompt Table: SFA_BPKG_STDLVW

#	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_INST_BPKG_SW	Character(1)	VARCHAR2(1) NOT NULL	Institutional Mass Packaging
4	FA_BPKG_QUERY_DEFN	Character(50)	VARCHAR2(50) NOT NULL	Selection Definition Prompt Table: SFA_BPKG_STDLVW