HCM Security: Core Security Views

 Components Storing All Person Types (* Includes Future Dated Rows)

Type	Security View	Rows Returned
*Component search view	PERALL_SEC_SRCH	One row per EMPLID and distinct search items.
SQR view	PERALL_SEC_SQR	One row per EMPLID.
Query view	PERALL_SEC_QRY	One row per EMPLID.

Components Storing People With Jobs 

Type	Security View	Rows Returned
*Component search view	PERS_SRCH_GBL	One row per EMPLID and EMPL_RCD combination, effective date, and distinct search items.
*Component search view	PERS_SRCH_EMP	One row per EMPLID for employees only.
Component search view	PERS_SRCH_CURR	One row per EMPLID.
SQR view	FAST_SQR_SEC_VW	One row per EMPLID.
Query view	PERS_SRCH_QRY	One row per EMPLID.
Prompt view	EMPL_ACTV_SRCH	One row per EMPLID for people with current, active (as of the system date) job records.
Prompt view	WORKER_PROMPT	One row per EMPLID for employees and contingent workers with current, active (as of the effective date of the component) job records.

Components Storing People With Potentially More Than One Job Data Record

Type	Security View	Rows Returned
*Component search view	EMPLMT_SRCH_GBL	One row per EMPLID and EMPL_RCD combination, effective date, and distinct search items.
*Component search view	EMPLMT_SRCH_EMP	One row per EMPLID and EMPL_RCD combination for employees only.
*SQR View	FAST_SQRFUT_SEC	One row per EMPLID.
SQR view	FAST_SQR_SEC_VW	One row per EMPLID and EMPL_RCD combination.
Query view	EMPLMT_SRCH_QRY	One row per EMPLID and EMPL_RCD combination.
Prompt view	PERJOB_PROMPT	One row per EMPLID for people with current, active (as of the effective date of the component) job records.

 Components Storing People Without Jobs

Type	Security View	Rows Returned
Component search view	POI_SEC_SRCH	One row per EMPLID, POI_TYPE and distinct search items.
SQR view	POI_SEC_SQR	One row per EMPLID and POI_TYPE.
Query view	POI_SEC_QRY	One row per EMPLID and POI_TYPE.