PERALL_SEC_SQR (SQL View)	Index Back
Srch - All Persons SQR PERALL_SEC_SQR is used as a search view to select person records for use in SQR or other Batch programs. This view includes all people (except Kenmu appts). Includes Future dated rows. One row per EMPLID Uses Security Sets PPLPOI and PPLJOB

PERALL_SEC_SQR

(SQL View)

Srch - All Persons SQR

PERALL_SEC_SQR is used as a search view to select person records for use in SQR or other Batch programs. This view includes all people (except Kenmu appts). Includes Future dated rows. One row per EMPLID Uses Security Sets PPLPOI and PPLJOB

SELECT DISTINCT %Sql(SCRTY_SEL_PSQRKEY, OPR,SEC) FROM %Sql(SCRTY_PER_FROM) WHERE %Sql(SCRTY_NO_APPT1) AND SEC.FUTURE_FLG <> 'Y' AND (%Sql(SCRTY_WHERE, 'PPLJOB') OR %Sql(SCRTY_WHERE, 'PPLPOI'))

# 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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

#	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	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID