SCC_SM_PRM_VW (SQL View)	Index Back
Search Match Parameter View Search Match Parameter View. This view selects Search/Match Parameters that have Full Access or Role Access for the current user.

SCC_SM_PRM_VW

(SQL View)

Search Match Parameter View

Search Match Parameter View. This view selects Search/Match Parameters that have Full Access or Role Access for the current user.

SELECT DISTINCT(B.OPRID) ,A.SM_TYPE ,A.SM_PARM_CD ,A.STATUS ,A.SM_ADHOC_FLG ,A.SM_ACCESS_FLG ,A.DESCR FROM PS_HCR_SM_PARM_TBL A , PSROLEUSER_VW B WHERE (A.SM_ACCESS_FLG = 'Y' OR A.SM_PARM_CD IN ( SELECT B1.SM_PARM_CD FROM PS_HCR_SM_PSEC_TBL B1 WHERE B1.SM_TYPE = A.SM_TYPE AND B1.SM_PARM_CD = A.SM_PARM_CD AND B1.ROLENAME IN ( SELECT C1.ROLENAME FROM PSROLEUSER_VW C1 WHERE C1.OPRID = B.OPRID))) AND A.STATUS = 'A' AND A.SM_ADHOC_FLG ='N'

Related Language Record: SCC_SM_PARM_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 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

3 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: HCR_SM_PARM_TBL

4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

5 SM_ADHOC_FLG Character(1) VARCHAR2(1) NOT NULL Search Match Add Hoc flag. This flag identifies a Rule or Parameter as an Add Hoc search.
Y/N Table Edit
Default Value: N

6 SM_ACCESS_FLG Character(1) VARCHAR2(1) NOT NULL Search Match Parameters Full Access flag. This flag identifies a Parameter as having Full Access for prompting.
Y/N Table Edit
Default Value: N

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	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
3	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: HCR_SM_PARM_TBL
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
5	SM_ADHOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Search Match Add Hoc flag. This flag identifies a Rule or Parameter as an Add Hoc search. Y/N Table Edit Default Value: N
6	SM_ACCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Search Match Parameters Full Access flag. This flag identifies a Parameter as having Full Access for prompting. Y/N Table Edit Default Value: N
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description