SCC_TRANSAC_CDSM_PARM_CDPrompt Table: SCC_SL_SM_VW
A=Add
I=Ignore
S=Suspend
U=Update
Default Value: A
Prompt Table: HCR_SM_RSLT_TBL
SCC_SRCHPARM_VW(SQL View) |
Index Back |
|---|---|
Search Add Parms ViewSCC_SRCHPARM_VW is a view on SCC_SRCHADDPARMS |
| SELECT SCC_TRANSAC_CD , SM_PARM_CD , PER_ADD_PARM , LAST_CHANGED_DTTM , SM_RSLT_FLD FROM PS_SCC_SRCHADDPARM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TRANSAC_CD |
Character(25) | VARCHAR2(25) NOT NULL | Transaction |
| 2 | 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_SL_SM_VW |
| 3 | PER_ADD_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Add Criteria
A=Add I=Ignore S=Suspend U=Update Default Value: A |
| 4 | LAST_CHANGED_DTTM | DateTime(26) | TIMESTAMP | Last Changed |
| 5 | SM_RSLT_FLD | Character(30) | VARCHAR2(30) NOT NULL |
Search Match Result Field. This field relates the search result record.field relationships.
Prompt Table: HCR_SM_RSLT_TBL |