HR_TBH_SEC_QRY (SQL View)	Index Back
TBH Security Query Template Based Hire Security Query

HR_TBH_SEC_QRY

(SQL View)

TBH Security Query

Template Based Hire Security Query

SELECT DISTINCT %Sql(SCRTY_SEL_SPKEY, OPR,SEC) ,OPR.ROWSECCLASS FROM %Sql(SCRTY_SP_FROM) WHERE %Sql(SCRTY_WHERE, 'TBHTMPL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TBH_TMPL_ID Character(18) VARCHAR2(18) NOT NULL Template ID

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

3 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TBH_TMPL_ID	Character(18)	VARCHAR2(18) NOT NULL	Template ID
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security