SFA_EA_SRCH_ADD(SQL Table) |
Index Back |
|---|---|
SFA EA Search/Match DefinitionSFA EA Search/Match Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 3 | SCCFP_MAP_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Mapping ID - the unique key that identifies the file mapping
Prompt Table: SFA_EA_SCCFPMAP |
| 4 | SM_PARM_CD | Character(15) | VARCHAR2(15) NOT NULL |
Search Match Parameter Code. This field stores the high level key for a Search Match Parameter definition.
Prompt Table: SCC_SM_PARM_VW |
| 5 | PER_ADD_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Add Criteria
A=Add I=Ignore S=Suspend U=Update Default Value: S |
| 6 | LAST_CHANGED_DTTM | DateTime(26) | TIMESTAMP | Last Changed |