FA_BPKG_PLAN_VW (SQL View)	Index Back
Mass Packaging Student Plans A view of the Batch Packaging table that contains kids who have packaging plans assigned to them and are ready to be packaged. Used on the Student Plan panel.

FA_BPKG_PLAN_VW

(SQL View)

Mass Packaging Student Plans

A view of the Batch Packaging table that contains kids who have packaging plans assigned to them and are ready to be packaged. Used on the Student Plan panel.

SELECT INSTITUTION, AID_YEAR, FA_INST_BPKG_SW, FA_BPKG_QUERY_DEFN FROM PS_FA_BPKG_DRV_HDR 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
Y/N Table Edit

4 FA_BPKG_QUERY_DEFN Character(50) VARCHAR2(50) NOT NULL Selection Definition
Default Value: SFA_BPKG_STDLVW.FA_BPKG_QUERY_DEFN
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 Y/N Table Edit
4	FA_BPKG_QUERY_DEFN	Character(50)	VARCHAR2(50) NOT NULL	Selection Definition Default Value: SFA_BPKG_STDLVW.FA_BPKG_QUERY_DEFN Prompt Table: SFA_BPKG_STDLVW