VERIF_COMP_DTL(SQL Table) |
Index Back |
|---|---|
Verification Compare DetailThis table contains verification results on a field by field level, allowing users to view and or dupate any differences found 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: 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 | FIELD_NUMBER |
Number(3,0) | SMALLINT NOT NULL | Field Number |
| 6 | APPLY_DIFF | Character(1) | VARCHAR2(1) NOT NULL |
Apply Difference to Target
Y/N Table Edit Default Value: N |
| 7 | APPLIED_DIFF | Character(1) | VARCHAR2(1) NOT NULL |
Applied Difference
Y/N Table Edit Default Value: N |
| 8 | VAL_SOURCE_CHAR | Character(5) | VARCHAR2(5) NOT NULL | Value Source Character |
| 9 | VAL_TARGET_CHAR | Character(5) | VARCHAR2(5) NOT NULL | Value Target Character |
| 10 | VAL_SOURCE_NUM | Signed Number(11,0) | DECIMAL(10) NOT NULL | Value Source Numeric |
| 11 | VAL_TARGET_NUM | Signed Number(11,0) | DECIMAL(10) NOT NULL | Value Target Numeric |
| 12 | VERIF_FLD_DIFF | Signed Number(11,0) | DECIMAL(10) NOT NULL | Verification Field Difference |
| 13 | PASS_OR_FAIL | Character(1) | VARCHAR2(1) NOT NULL |
Pass or Fail
F=Failed P=Passed |
| 14 | VERIF_FLD_DIFPCT | Number(3,0) | SMALLINT NOT NULL | Verification Field Pct Diff |
| 15 | BLANK_FIELD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Blank Numeric Field
Y/N Table Edit Default Value: N |