SuperGlue Fraud Data Reporting Dictionary

The name of the SuperGlue Fraud Data Reporting database is bi_directional_fraud and it contains one user table, fraud_reports. When a college submits an fraud report, SuperGlue does a lookup for all the applications the student has submitted to other colleges. This table captures which colleges have also had an application from that student so that data can be used in reports and to act as event triggers.

Users will only be able to see data they have submitted for their college.

Data Element Dict Name	Data Element Dict Friendly Name	Data Element Dict Simplified Type	Data Element Dict Max Length	Description	FraudReport DB Field Name	Apollo Payload Field Name	Banner Fraud Report Table.Column Name	MS SQL Fraud Report Table.Column Name	Colleague Fraud Report Entity::Attribute(s) Name	PeopleSoft Fraud Report Record::Field Name
submit_timestamp	Submit Timestamp	Date with UTC time	24	Timestamp of when report was created.	submitEpoch	submitTimestamp	SZRFRAD.SZRFRAD_TSTMP_SUBMIT	SZRFRAD.tstmpSubmit	XCTC.FRAUD.REPORT::XCTC.FR.TSTMP.SUBMIT.DATE XCTC.FR.TSTMP.SUBMIT.TIME	CCTC_FRDRPT_STG::CCTC_FRDRP_SBT_TS
ccc_id	California Community Colleges ID	Text	8	A systemwide student account that enables single sign on for multiple college applications.	sk	cccId	SZRFRAD.SZRFRAD_CCCID	SZRFRAD.cccId	XCTC.FRAUD.REPORT::XCTC.FR.CCC.ID	CCTC_FRDRPT_STG::CCTC_CCCID
reported_by_college	Reported by College Code	Text	3	The college that submitted the report.	reportedByMisCode	reportedByMisCode	SZRFRAD.SZRFRAD_REPORTING_MIS	SZRFRAD.reportedByMisCode	XCTC.FRAUD.REPORT::XCTC.FR.REPORTED.BY.MIS.CODE	CCTC_FRDRPT_STG::CCTC_MIS_CD2
recipient_college	Intended Recipient of the Report	Text	3	The college that the report impacts.	recipientMisCode	recipientMisCode	SZRFRAD.SZRFRAD_MIS_CODE	SZRFRAD.misCode	XCTC.FRAUD.REPORT::XCTC.FR.COLLEGE.ID	CCTC_FRDRPT_STG::CCTC_MIS_CD
app_id	Fraudulent Application Id	Very Large Number	16	Application ID generated by Apply, used for tracking placement back to student application. Each fraud report will generate a new appId.	appId	appId	SZRFRAD.SZRFRAD_APP_ID	SZRFRAD.appId	XCTC.FRAUD.REPORT::XCTC.FR.APPL.ID	CCTC_FRDRPT_STG::CCTC_APPL_ID
fraud_type	Fraud Report Type	Text	15	only value is application	fraudType	fraudType	SZRFRAD.SZRFRAD_TYPE	SZRFRAD.fraudType	XCTC.FRAUD.REPORT::XCTC.FR.FRAUD.TYPE	CCTC_FRDRPT_STG::CCTC_FRDTYP