VERIF_STU_FLDVW

(SQL View)
 Index Back

Verification Field Tolerances

This view is used to display student override field level tolerances to the users of the verification panels.

SELECT A.EMPLID, A.FIELD_NUMBER, A.USE_FOR_FED, A.USE_FOR_INST, A.USE_FOR_IND_FED, A.USE_FOR_DEP_FED, A.USE_FOR_IND_INST, A.USE_FOR_DEP_INST, A.TOL_AMT_FED, A.TOL_AMT_INST, A.TOL_PCT_FED, A.TOL_PCT_INST, A.AMT_PCT_IND_FED, A.AMT_PCT_IND_INST FROM PS_VERIF_STU_FLDS A

  • Parent record: VERIF_STU_TOL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 FIELD_NUMBER Number(3,0) SMALLINT NOT NULL Field Number
    3 USE_FOR_FED Character(1) VARCHAR2(1) NOT NULL Use For Federal Verification

    Y/N Table Edit

    Default Value: Y

    4 USE_FOR_INST Character(1) VARCHAR2(1) NOT NULL Use For Instituional Verif

    Y/N Table Edit

    Default Value: Y

    5 USE_FOR_IND_FED Character(1) VARCHAR2(1) NOT NULL Use in Fed Ver with Indep Stu

    Y/N Table Edit

    Default Value: Y

    6 USE_FOR_DEP_FED Character(1) VARCHAR2(1) NOT NULL Use in Fed Verif with Dep Stu

    Y/N Table Edit

    Default Value: Y

    7 USE_FOR_IND_INST Character(1) VARCHAR2(1) NOT NULL Use in Inst Verif for Ind Stu

    Y/N Table Edit

    Default Value: Y

    8 USE_FOR_DEP_INST Character(1) VARCHAR2(1) NOT NULL Use in Inst Verif with Dep Stu

    Y/N Table Edit

    Default Value: Y

    9 TOL_AMT_FED Signed Number(8,0) DECIMAL(7) NOT NULL Tolerance Amt Federal
    10 TOL_AMT_INST Signed Number(8,0) DECIMAL(7) NOT NULL Tolerance Amount Institutional
    11 TOL_PCT_FED Signed Number(4,0) DECIMAL(3) NOT NULL Tolerance Pct Federal
    12 TOL_PCT_INST Signed Number(4,0) DECIMAL(3) NOT NULL Tolerance Pct Institutional
    13 AMT_PCT_IND_FED Character(1) VARCHAR2(1) NOT NULL Amount Pct Indicator Federal
    A=Use Amount
    P=Use Pct

    Default Value: A

    14 AMT_PCT_IND_INST Character(1) VARCHAR2(1) NOT NULL Amt or Pct Institutional
    A=Use Amount
    P=Use Pct

    Default Value: A