SFA_PU_INSP_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 CALC_PC_IND_IM Character(1) VARCHAR2(1) NOT NULL Calc PC For Independent

    Y/N Table Edit

    4 INAS_RULE_SET Character(4) VARCHAR2(4) NOT NULL Option Rule Set
    BASE=CSS Rules/Values
    HLTH=Health Professional
    STD=Undergrad/Graduate
    5 INST_APP_SOURCE Character(1) VARCHAR2(1) NOT NULL Application Source
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Renewal Application
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan
    6 PE_BDGT_DUR_A Number(4,1) DECIMAL(3,1) NOT NULL Budget Duration Acad Per
    7 PE_BDGT_DUR_N Number(4,1) DECIMAL(3,1) NOT NULL Budget Duration NStd Per