VERIF_FLD_TOLVW(SQL View) |
Index Back |
|---|---|
Verification Field TolerancesThis view is used by the verification panels to view the field tolerances. |
| SELECT A.INSTITUTION, A.AID_YEAR, 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_FLD_TOLS A WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_VERIF_FLD_TOLS B WHERE B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR =A.AID_YEAR AND B.EFFDT <= %CURRENTDATEIN) |
| # | 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: AID_YEAR_TBL |
| 3 | FIELD_NUMBER |
Number(3,0) | SMALLINT NOT NULL | Field Number |
| 4 | USE_FOR_FED | Character(1) | VARCHAR2(1) NOT NULL |
Use For Federal Verification
Y/N Table Edit Default Value: Y |
| 5 | USE_FOR_INST | Character(1) | VARCHAR2(1) NOT NULL |
Use For Instituional Verif
Y/N Table Edit Default Value: Y |
| 6 | USE_FOR_IND_FED | Character(1) | VARCHAR2(1) NOT NULL |
Use in Fed Ver with Indep Stu
Y/N Table Edit Default Value: Y |
| 7 | USE_FOR_DEP_FED | Character(1) | VARCHAR2(1) NOT NULL |
Use in Fed Verif with Dep Stu
Y/N Table Edit Default Value: Y |
| 8 | USE_FOR_IND_INST | Character(1) | VARCHAR2(1) NOT NULL |
Use in Inst Verif for Ind Stu
Y/N Table Edit Default Value: Y |
| 9 | USE_FOR_DEP_INST | Character(1) | VARCHAR2(1) NOT NULL |
Use in Inst Verif with Dep Stu
Y/N Table Edit Default Value: Y |
| 10 | TOL_AMT_FED | Signed Number(8,0) | DECIMAL(7) NOT NULL | Tolerance Amt Federal |
| 11 | TOL_AMT_INST | Signed Number(8,0) | DECIMAL(7) NOT NULL | Tolerance Amount Institutional |
| 12 | TOL_PCT_FED | Signed Number(4,0) | DECIMAL(3) NOT NULL | Tolerance Pct Federal |
| 13 | TOL_PCT_INST | Signed Number(4,0) | DECIMAL(3) NOT NULL | Tolerance Pct Institutional |
| 14 | AMT_PCT_IND_FED | Character(1) | VARCHAR2(1) NOT NULL |
Amount Pct Indicator Federal
A=Use Amount P=Use Pct Default Value: A |
| 15 | AMT_PCT_IND_INST | Character(1) | VARCHAR2(1) NOT NULL |
Amt or Pct Institutional
A=Use Amount P=Use Pct Default Value: A |