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.
|
Thats a really very good post about Peoplesoft HCM.thanks for sharing.
ReplyDeletethanks Chandru...for sharing the detail.Can you please some NA Payroll process interview questions.
ReplyDeleteThank you for sharing your blog, seems to be useful information can’t wait to dig deep!
ReplyDelete