VERIF_COMP_HDR

(SQL Table)
 Index Back

Verification Compare Header

This table contains information reguarding specific verification runs. It is also used as a mechanism for passing paramaters to the verification process in the online mode.

  • Parent Record Of VERIF_COMP_DTL VERIF_COMP_SRCH VERIF_STU_TOLVW

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

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: STUDENT_AID

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: STUDENT_AID

    4 VERIF_SEQ_NBR Number(3,0) SMALLINT NOT NULL Verification Sequence Number
    5 VERIFICATION_DATE DateTime(26) TIMESTAMP Verification Date
    6 VERIFICATION_TYPE Character(1) VARCHAR2(1) NOT NULL Verification Type
    F=Federal
    I=Institutional
    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 CHANGES_APPLIED Character(1) VARCHAR2(1) NOT NULL Changes Applied to Target

    Y/N Table Edit

    Default Value: N

    10 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
    11 PASS_OR_FAIL Character(1) VARCHAR2(1) NOT NULL Pass or Fail
    F=Failed
    P=Passed
    12 TOTAL_DIFF Signed Number(12,0) DECIMAL(11) NOT NULL Total Difference
    13 EXECUTION_TYPE Character(1) VARCHAR2(1) NOT NULL Execution Type
    B=Batch
    O=Online
    14 USE_STU_OVRD Character(1) VARCHAR2(1) NOT NULL Use Student Level Override

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    16 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    18 FED_CALC_DIFF Signed Number(8,0) DECIMAL(7) NOT NULL Net Variance - Federal Method
    19 VERIF_FAILURE_LVL Character(3) VARCHAR2(3) NOT NULL Pass/Fail Option
    FED=Federal Level
    FLD=Field Level

    Default Value: FED

    20 SPECIAL_PROCESSING Character(1) VARCHAR2(1) NOT NULL Special Circumstances
    1=Yes
    N=No
    Y=Yes
    21 UPDATE_ISIR_STATUS Character(1) VARCHAR2(1) NOT NULL Set to Send ISIR Correction

    Y/N Table Edit

    Default Value: N