AID_YEARPrompt Table: AID_YEAR_TBL
FIELD_NUMBERC=Character
N=Numeric
Default Value: N
SFA_VER_INS_PRM(SQL View) |
Index Back |
|---|---|
Verification Field TolerancesThis table contains field level tolerances observed by the verification process. |
| SELECT AID_YEAR , FIELD_NUMBER , FIELD_NUM_OR_CHAR , FA_FIELD_NAME , ISIR_FIELD_NUM , INST_FIELD_NUM FROM PS_ISIR_VERIF_XREF WHERE INST_FIELD_NUM > '0000' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
| 2 | FIELD_NUMBER |
Number(3,0) | SMALLINT NOT NULL | Field Number |
| 3 | FIELD_NUM_OR_CHAR | Character(1) | VARCHAR2(1) NOT NULL |
Field Numeric or Character
C=Character N=Numeric Default Value: N |
| 4 | FA_FIELD_NAME | Character(30) | VARCHAR2(30) NOT NULL | Field Name |
| 5 | ISIR_FIELD_NUM | Character(4) | VARCHAR2(4) NOT NULL | ISIR Field Num |
| 6 | INST_FIELD_NUM | Character(4) | VARCHAR2(4) NOT NULL | INST Field Nbr |