VERIF_COMP_SMRY

(SQL View)
 Index Back

Verification Compare Summary

This table contains information reguarding specific verification runs ordered by Process Instance. It is a view of the data in VERIF_COMP_HDR.

SELECT DISTINCT A.INSTITUTION, A.AID_YEAR, A.PROCESS_INSTANCE, A.OPRID, A.VERIFICATION_DATE, A.VERIFICATION_TYPE, A.VERIF_SOURCE, A.VERIF_TARGET, A.APP_SOURCE_CODE, A.CHANGES_APPLIED, A.USE_STU_OVRD, A.MARK_AS_VERIFIED, A.VERIF_FAILURE_LVL, A.UPDATE_ISIR_STATUS FROM PS_VERIF_COMP_HDR A WHERE A.EXECUTION_TYPE='B'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: AID_YEAR_TBL

3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time
6 VERIFICATION_TYPE Character(1) VARCHAR2(1) NOT NULL Verification Type
F=Federal
I=Institutional

Default Value: F

7 VERIF_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
I=ISIR
P=Institutional App
T=Tax Forms/Verification
8 VERIF_TARGET Character(1) VARCHAR2(1) NOT NULL Target
I=ISIR
P=Institutional App
9 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
0=Need Access
0=Need Access
1=Electronic Initial Application
2=Electronic Renewal Aplication
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
10 CHANGES_APPLIED Character(1) VARCHAR2(1) NOT NULL Changes Applied to Target

Y/N Table Edit

Default Value: N

11 USE_STU_OVRD Character(1) VARCHAR2(1) NOT NULL Use Student Level Override

Y/N Table Edit

Default Value: N

12 MARK_AS_VERIFIED Character(1) VARCHAR2(1) NOT NULL Mark Assumptions as Verified

Y/N Table Edit

Default Value: N

13 VERIF_FAILURE_LVL Character(3) VARCHAR2(3) NOT NULL Pass/Fail Option
FED=Federal Level
FLD=Field Level

Default Value: FED

14 UPDATE_ISIR_STATUS Character(1) VARCHAR2(1) NOT NULL Set to Send ISIR Correction

Y/N Table Edit

Default Value: N