SFA_PU_INSF_TRG

(SQL Table)
Index Back

Bind for Population Update

This table hosts required fields for multiple records for Population Update.

  • Parent record: STUDENT_AID
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 BUDGET_DURATION_A Number(2,0) SMALLINT NOT NULL Budget Duration - Acad Per
    4 BUDGET_DURATION_N Number(2,0) SMALLINT NOT NULL Budget Duration - Non-Std
    5 CALC_PC_FOR_IND Character(1) VARCHAR2(1) NOT NULL Calc a PC for Independent

    Y/N Table Edit

    6 FM_EFC_PRORTN_ACAD Character(1) VARCHAR2(1) NOT NULL Academic Proration Method
    1=Use Monthly EFCs
    2=Adjust Based on Total EFC
    3=Proportion Monthly Share
    7 FM_EFC_PRORTN_NSTD Character(1) VARCHAR2(1) NOT NULL Non-Standard Proration Method
    1=Leading Months
    2=Trailing Months
    3=FA Term Based
    8 INAS_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Calc Type
    B=Both FM & IM
    F=Federal Methodology
    I=Institutional Methodology
    9 INAS_DATA_TYPE Character(1) VARCHAR2(1) NOT NULL Data Source
    B=Both Federal & Institutional
    F=Federal Data
    I=Institutional Data
    10 INAS_RULE_SET Character(4) VARCHAR2(4) NOT NULL Option Rule Set
    BASE=CSS Rules/Values
    HLTH=Health Professional
    STD=Undergrad/Graduate