SCC_SM_PARM_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. This view is Campus Solutions specific and only retrieves Person type Search/Match Parameters for batch processing.

SCC_SM_PARM_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. This view is Campus Solutions specific and only retrieves Person type Search/Match Parameters for batch processing.

SELECT DISTINCT(B.OPRID) ,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_TYPE = 'P' AND (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.SM_ADHOC_FLG = 'N' AND A.STATUS = 'A'

# 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_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.

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

4 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

5 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

6 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_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.
3	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
4	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
5	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
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description