FA_SAA_TMP_MC

(SQL Table)
 Index Back

FA Stdnt Aid Attr tmp tbl MC

Temp table used by Mass Change to collect set of students that meet a particular criteria for updating the STDNT_AID_ATRBT table. The data will then be reduced down to one record of common data - FA_SAA_CMN_MC and multiple records of unique data - 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 MC_STATUS Character(3) VARCHAR2(3) NOT NULL Mass Change Status
APR=Approved Transaction
CAN=Cancel Transaction
ERR=Errored Transaction
PND=Pending Transaction
SCS=Successful Transaction
6 CURRENT_VALUE Character(4) VARCHAR2(4) NOT NULL Current Value
7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

8 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
9 PROCESSING_STATUS Character(1) VARCHAR2(1) NOT NULL Aid Package Processing Status
0=No Electronic Application
1=Applied
2=Ready For Counselor Review
3=Ready for Packaging
4=Repackage
9=Packaging Completed
10 VERIFICATON_STATUS Character(1) VARCHAR2(1) NOT NULL ED Verification Status
C=ED Verification Complete
N=Not Required
P=Verification Pending
R=Required to be Performed
11 SFA_REVIEW_STATUS Character(1) VARCHAR2(1) NOT NULL Review Status
C=Review Complete
I=Incomplete
12 SCHOLARSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Scholarship Status
E=Evaluated
N=Not Evaluated
13 PACKAGING_METHOD Character(1) VARCHAR2(1) NOT NULL Aid Packaging Method
0=Not Packaged
5=Auto Packaged
9=Counselor Packaged
14 PACKAGING_PLAN Character(2) VARCHAR2(2) NOT NULL Aid Packaging Plan
00=No Formula Used
01=Grant Eligible Dependent
02=Grant Eligible Independent
03=No Need Undergraduate
04=No Need Graduate
15 SAT_ACADEMIC_PRG Character(1) VARCHAR2(1) NOT NULL Used on Packaging Status Summary to note current Satisfactory Academic Progress status.
A=Academic Plan
N=Not Meeting Satis Acad Prgrs
P=Probation
U=SAP Undetermined
W=Warning
Y=Meeting Satis Acad Progress
16 DISBURSEMENT_HOLD Character(1) VARCHAR2(1) NOT NULL Disbursement Hold
F=Hold Federal Aid
I=Hold Institutional Aid
L=Hold All Loans
17 COMMUNITY_SERVICE Character(1) VARCHAR2(1) NOT NULL Community Service Indicator
1=Community Service Placement
2=Not Community Service
18 QA_VERF_SELECT Character(1) VARCHAR2(1) NOT NULL Inst Verification Status
1=Non Select
2=Selected for Verification
3=Document Select
19 QA_SELECTED Character(1) VARCHAR2(1) NOT NULL QA Sample
1=Not Selected as QA Sample
2=Selected as QA Sample
20 AID_APP_STATUS Character(1) VARCHAR2(1) NOT NULL Aid Application Status
A=Application Active for All Aid
C=Application Canceled
R=Apply for Restricted Aid Only