FA_INST_HDR_VW(SQL View) |
Index Back |
---|---|
Batch Pkg Driver HeaderBatch Pkg Driver Header This table contains the header info for batch packaging. This table is read by batch packaging when selecting the students to package. |
SELECT institution , aid_year , fa_inst_bpkg_sw , fa_bpkg_query_defn , acad_career , pkg_plan_id , processing_order , sort_pkg , fa_sort_order 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 |
2 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
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 |
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 |
7 | PROCESSING_ORDER | Number(5,0) | INTEGER NOT NULL | Processing Order |
8 | SORT_PKG | Character(20) | VARCHAR2(20) NOT NULL | Sort Packaging by |
9 | FA_SORT_ORDER | Character(1) | VARCHAR2(1) NOT NULL |
Ascending/Descending
A=Ascending D=Descending |