SFA_PU_INSP_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_PROF_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 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