FA_BPKG_STUD_VW

(SQL View)
 Index Back

Mass Pkging Students by Plan

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 Students by Plan panel.

SELECT INSTITUTION, AID_YEAR, FA_INST_BPKG_SW, FA_BPKG_QUERY_DEFN, ACAD_CAREER, PKG_PLAN_ID 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

Prompt Table: SFA_BPKG_STDLVW

5 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
6 PKG_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Packaging Plan ID

Prompt Table: PKG_PLAN_TBL