SCC_DUPRULVW_LN (SQL View)	Index Back
Duplicates Rule Language View Related Language view of rules for handling duplicate input transactions

SCC_DUPRULVW_LN

(SQL View)

Duplicates Rule Language View

Related Language view of rules for handling duplicate input transactions

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

Related Language Record for SCC_DUP_RULE_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description