SFA_PU_INSF_BND

(SQL View)
 Index Back

Bind for Population Update

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

SELECT DISTINCT A.EMPLID , B.NAME ,0 ,0 ,' ' ,' ' ,' ' ,' ' ,' ' ,' ' FROM PS_INAS_FED_EXT A , PS_SCC_PRI_NAME_VW B WHERE A.EMPLID = B.EMPLID

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    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