GP_ABS_SEC_QRY (SQL View)	Index Back
Absence Security Query Configurable Sections: Template Based Absence Extended Leave Security Query

GP_ABS_SEC_QRY

(SQL View)

Absence Security Query

Configurable Sections: Template Based Absence Extended Leave Security Query

SELECT DISTINCT SEC.GP_ABS_CS_TMPL_ID ,OPR.OPRID ,OPR.ROWSECCLASS FROM %Sql(GP_ABS_CS_SCRTY_FROM) WHERE (CLS.SCRTY_SET_CD = 'ABSTMPL' ) AND %Sql(SCRTY_WHERE,'ABSTMPL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_ABS_CS_TMPL_ID Character(18) VARCHAR2(18) NOT NULL Template ID or Template Section Configuration ID. Used by EA to create templates that are used by Absence requests.

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	GP_ABS_CS_TMPL_ID	Character(18)	VARCHAR2(18) NOT NULL	Template ID or Template Section Configuration ID. Used by EA to create templates that are used by Absence requests.
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