Sigma Systems, Inc' Financial Aid Process Overview

1
Sigma Systems, Inc.Financial Aid Process Overview
Student Applicant Data File
DL Loan Servicer
Guarantor/Lender
COD (Pell/DL Loans)
CPS
DOE
Student
School
2
CPS Database Match Overview
Prisoner Match (Discontinued)
Valid Soc. Sec
SOC SEC
NSLDS
INS
IRS
SEL SERV
CPS
3
SAM ProSAM SYSTEMSINFORMATION FLOW
Admissions Student Rec.. Integration
Financial Verification
BSP
COM
Funds Management
Student Need Analysis
External Data Exchange
Reporting and Analysis
Evaluation
Packaging
Notification
Disbursement
BIO
Aid Application
Tracking
Interfaces with Financial Systems
Pell
DL/FFELP
Earnings Monitoring
CA/ILL State Grant
4
Sigma SystemsApplication Architecture
Access Control System
Data Dictionary
Biographic
Report Writer
SAM
SARS
ProSAM
Table
Memorandum
Audit
5
CSS/Federal/PHEAA Data
Recruitment / Admissions
Demographics
Academic / Enrollment
Housing
SYSTEM LINKAGES
6
SAM ProSAM Database Structure
BIO
MEM
COM
BSP
SNS SNP SNB SNF
SAM
TRK
SNx
TRK2
AWD
FLO
HAW
DIS
EOR
ADS
7
SAM ProSAM Database Structure (Cont)
Key Structure
ECP
ECP ID
AIDYR ECP ID PRD TYPE
PRD
TBL SCR DED AUD SEC ACT
MSF
KEY MRG
AMS AMD
PGM
EFM
8
SAM ProSAM Database Structure (Cont)
Key Structure
BIO
SID
Current SSN Current DOB Current Name
PSN
Aidid Type
DIE