FA_BPKG_DRV_HDR

(SQL Table)
 Index Back

Batch Pkg Driver Header

Batch 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.

  • Parent Record Of FA_BPKG_DRV_DTL FA_BPKG_DTL_VW FA_INST_DTL_VW

    • # 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