SCC_SL_SMP_PARM(SQL Table) |
Index Back |
|---|---|
SnL run controlSnL run control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SCC_TRANSAC_CD |
Character(25) | VARCHAR2(25) NOT NULL | Transaction |
| 4 | SM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant O=Organization P=Person Default Value: P |
| 5 | 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_PRM_VW |
| 6 | 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_VW |
| 7 | PER_ADD_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Personal Info - Add Criteria
A=Add I=Ignore S=Suspend U=Update |
| 8 | LAST_CHANGED_DTTM | DateTime(26) | TIMESTAMP | Last Changed |
| 9 | SCC_SUSPEND_DUPS | Character(1) | VARCHAR2(1) NOT NULL |
Suspend Duplicates
Indicates whether or not duplicate transactions on the input staging table should be suspended.
Y/N Table Edit Default Value: Y |
| 10 | SCC_DUP_RULE | Character(15) | VARCHAR2(15) NOT NULL |
Duplicate rule: rule to detect whether an input staging table transaction is among duplicates of itself within the staging table.
Prompt Table: SCC_DUP_RULE_VW |