SCC_DUP_RULE_VW (SQL View)	Index Back
Duplicates Rule View View of rules for handling duplicate input transactions

SCC_DUP_RULE_VW

(SQL View)

Duplicates Rule View

View of rules for handling duplicate input transactions

SELECT A.SM_RULE_CD ,A.DESCR FROM PS_HCR_SM_RULE_TBL A WHERE A.SM_TYPE = 'P'

Related Language Record: SCC_DUPRULVW_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description