AID_YEARDefault Value: AID_YEAR_TBL.AID_YEAR
Prompt Table: AID_YEAR_TBL
RECNAMEFIELDNAMEA=Active
I=Inactive
INST_XREF(SQL Table) |
Index Back |
|---|---|
INST XREFinst_xref is used when making electronic corrections to the INST data, and the field number is required for those changes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: AID_YEAR_TBL.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | INST_FIELD_NUM | Character(4) | VARCHAR2(4) NOT NULL | INST Field Nbr |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |