AID_YEARPrompt Table: AID_YEAR_TBL
ISIR_FIELD_NUMISIR_XREF_VW(SQL View) |
Index Back |
|---|---|
ISIR/SAR Question # XREFISIR_XREF_VW is a view of the ISIR_SAR_XREF used for displaying ISIR field numbers associated with Table/Columns. |
| select aid_year ,isir_field_num ,descr from PS_ISIR_SAR_XREF |
| # | 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 | ISIR_FIELD_NUM |
Character(4) | VARCHAR2(4) NOT NULL | ISIR Field Num |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |