VERIF_FLD_TOLS(SQL Table) |
Index Back |
|---|---|
Verification Field TolerancesThis table contains field level tolerances observed by the verification process. |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | FIELD_NUMBER |
Number(3,0) | SMALLINT NOT NULL |
Field Number
Prompt Table: %EDITTABLE |
| 5 | USE_FOR_FED | Character(1) | VARCHAR2(1) NOT NULL |
Use For Federal Verification
Y/N Table Edit Default Value: Y |
| 6 | USE_FOR_INST | Character(1) | VARCHAR2(1) NOT NULL |
Use For Instituional Verif
Y/N Table Edit Default Value: Y |
| 7 | USE_FOR_IND_FED | Character(1) | VARCHAR2(1) NOT NULL |
Use in Fed Ver with Indep Stu
Y/N Table Edit Default Value: Y |
| 8 | USE_FOR_DEP_FED | Character(1) | VARCHAR2(1) NOT NULL |
Use in Fed Verif with Dep Stu
Y/N Table Edit Default Value: Y |
| 9 | USE_FOR_IND_INST | Character(1) | VARCHAR2(1) NOT NULL |
Use in Inst Verif for Ind Stu
Y/N Table Edit Default Value: Y |
| 10 | USE_FOR_DEP_INST | Character(1) | VARCHAR2(1) NOT NULL |
Use in Inst Verif with Dep Stu
Y/N Table Edit Default Value: Y |
| 11 | TOL_AMT_FED | Signed Number(8,0) | DECIMAL(7) NOT NULL | Tolerance Amt Federal |
| 12 | TOL_AMT_INST | Signed Number(8,0) | DECIMAL(7) NOT NULL | Tolerance Amount Institutional |
| 13 | TOL_PCT_FED | Signed Number(4,0) | DECIMAL(3) NOT NULL | Tolerance Pct Federal |
| 14 | TOL_PCT_INST | Signed Number(4,0) | DECIMAL(3) NOT NULL | Tolerance Pct Institutional |
| 15 | AMT_PCT_IND_FED | Character(1) | VARCHAR2(1) NOT NULL |
Amount Pct Indicator Federal
A=Use Amount P=Use Pct |
| 16 | AMT_PCT_IND_INST | Character(1) | VARCHAR2(1) NOT NULL |
Amt or Pct Institutional
A=Use Amount P=Use Pct |