PKG_RULE_COPY

(SQL View)
 Index Back

FA Packaging Rule Table

PKG_RULE_TBL defines the award item types to be used in a particular packaging plan. It also lets the users define rules on how the award amount should be manipulated in determining the total amount of the award package. Rules include minimum amount, maximum amount, and percentages of total amount.

SELECT INSTITUTION ,AID_YEAR ,ACAD_CAREER ,PKG_PLAN_ID ,EFFDT ,PKG_RULE_NBR ,PKG_SEQ_NBR ,REPKG_SEQ_NBR ,PKG_RULE_PREF ,ITEM_TYPE ,SETID ,PCT_TOTAL_PKG ,REL_ITEM_TYPE ,ITEM_MAX_PREF ,ITEM_MIN_PREF ,AWARD_PKG_MAX ,AWARD_PKG_MIN ,AWRD_PKG_MAX_EQTN ,AWRD_PKG_MIN_EQTN ,SPENDING_LMT_PREF ,SPENDING_LIMIT ,PCT_FUND_BALANCE ,DISB_PLAN_PREF ,DISBURSEMENT_PLAN ,SPLIT_CODE_PREF ,SPLIT_CODE ,SPLIT_CODE_DEFN ,PKG_ACTION ,CURRENCY_CD ,SELECTION_CRITERIA ,AWARD_LIMIT_FACTOR FROM PS_SFA_PKG_PLNRULE

  • Parent record: PKG_PLAN_TBL

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

    Prompt Table: AID_YR_CAR_VW

    4 PKG_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Packaging Plan ID

    Prompt Table: PKG_PLAN_TBL

    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    6 PKG_RULE_NBR Number(5,0) INTEGER NOT NULL Packaging Rule Nbr
    7 PKG_SEQ_NBR Number(5,0) INTEGER NOT NULL Sequence Nbr
    8 REPKG_SEQ_NBR Number(5,0) INTEGER NOT NULL Repackaging Sequence

    Default Value: SFA_PKG_PLNRULE.PKG_SEQ_NBR

    9 PKG_RULE_PREF Character(1) VARCHAR2(1) NOT NULL Packaging Rule Preference
    G=Gap
    I=Item Type
    R=Related Item Group

    Default Value: I

    10 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TP_FA_PKG

    11 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    12 PCT_TOTAL_PKG Number(5,1) DECIMAL(4,1) NOT NULL % of Total Package
    13 REL_ITEM_TYPE Character(8) VARCHAR2(8) NOT NULL Related Item Group

    Prompt Table: PKG_REL_ITM_TBL

    14 ITEM_MAX_PREF Character(1) VARCHAR2(1) NOT NULL Award Item Max Preference
    C=Constant
    E=Equation
    O=Original Award

    Default Value: C

    15 ITEM_MIN_PREF Character(1) VARCHAR2(1) NOT NULL Award Item Min Preference
    C=Constant
    E=Equation

    Default Value: C

    16 AWARD_PKG_MAX Number(12,2) DECIMAL(11,2) NOT NULL Packaging Maximum
    17 AWARD_PKG_MIN Number(12,2) DECIMAL(11,2) NOT NULL Packaging Minimum
    18 AWRD_PKG_MAX_EQTN Character(12) VARCHAR2(12) NOT NULL Equation for Equation

    Prompt Table: SFA_PKGEQTNA_VW

    19 AWRD_PKG_MIN_EQTN Character(12) VARCHAR2(12) NOT NULL Equation for Minimum

    Prompt Table: SFA_PKGEQTNA_VW

    20 SPENDING_LMT_PREF Character(1) VARCHAR2(1) NOT NULL Spending Limit Preferences
    B=Use Remaining Fund Balance
    N=No Spending Limit
    P=% of Original Fund Balance
    S=Specify Amount

    Default Value: B

    21 SPENDING_LIMIT Number(12,2) DECIMAL(11,2) NOT NULL Spending Limit
    22 PCT_FUND_BALANCE Number(5,1) DECIMAL(4,1) NOT NULL % of Remaining Fund Balance
    23 DISB_PLAN_PREF Character(1) VARCHAR2(1) NOT NULL Disbursement Plan Preference
    D=Use Item Type Default
    O=Override Default

    Default Value: D

    24 DISBURSEMENT_PLAN Character(2) VARCHAR2(2) NOT NULL Disbursement Plan

    Prompt Table: DISB_PLAN_VW

    25 SPLIT_CODE_PREF Character(1) VARCHAR2(1) NOT NULL Split Code Preference
    C=Custom Split Defined By:
    D=Use Item Type Default
    O=Override Default

    Default Value: D

    26 SPLIT_CODE Character(2) VARCHAR2(2) NOT NULL Split Code

    Prompt Table: DISB_SPLIT_VW

    27 SPLIT_CODE_DEFN Character(1) VARCHAR2(1) NOT NULL Custom Split Code Definition
    A=Length of Attendance
    C=Cost of Attendance
    E=Estimated Family Contribution
    L=Enrollment Load
    N=Need
    W=Equal Weight
    28 PKG_ACTION Character(1) VARCHAR2(1) NOT NULL Packaging Award Action
    B=Offer/Accept
    O=Offer

    Default Value: B

    29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    30 SELECTION_CRITERIA Character(12) VARCHAR2(12) NOT NULL Selection Criteria

    Prompt Table: SFA_PKGEQTNS_VW

    31 AWARD_LIMIT_FACTOR Character(1) VARCHAR2(1) NOT NULL Limiting Factor
    A=Enrollment Units
    B=Matriculation Weeks
    N=None

    Default Value: N