FA_INST_PLAN_VW(SQL View) |
Index Back |
---|---|
Mass Packaging Student PlansA 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 = 'Y' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
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: FA_INST_DEFN |