FA_SAA_CMN_MC

(SQL Table)
 Index Back

FA Stdnt Aid Attr tmp tbl MC

Contains FIELDNAME/FIELDVALUE pairs for update of the STDNT_AID_ATRBT table. The EMPLIDs are contained in child record FA_SAA_UNQ_MC. Table is created and deleted using Mass Change Definition executions.

  • Parent Record Of FA_SAA_UNQ_MC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MC_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Template ID
    2 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    5 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    6 TABLE_ID Character(1) VARCHAR2(1) NOT NULL Child Table Key
    7 FA_SAA_FLD_FLG Character(2) VARCHAR2(2) NOT NULL New Setting of Indicator
    AP=Satisfactory Academic Progress
    AS=Fin Aid Application Status
    CS=Community Service Indicator
    DH=Disbursement Hold
    PM=Aid Packaging Method
    PP=Aid Packaging Plan
    PS=Aid Package Processing Status
    QS=QA Selected
    QV=Verification Select
    RS=Review Status
    SS=Scholarship Status
    VS=Verification Status
    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    9 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value