SFA_SLC_SRCHADD(SQL Table) |
Index Back |
---|---|
SLC SearchMatch ParmetersSLC SearchMatch Parameters |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
|
2 | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
|
3 | Character(4) | VARCHAR2(4) NOT NULL | HEI Code | |
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 |