PY_MOD_ADM_SVW (SQL View)	Index Back
Paycheck Modeling Search Paycheck Modeling Self Service Search View

PY_MOD_ADM_SVW

(SQL View)

Paycheck Modeling Search

Paycheck Modeling Self Service Search View

SELECT DISTINCT A.COMPANY ,A.PAYGROUP ,B.OPRID ,A.EMPLID ,A.NAME FROM PS_PAY_CHK_MOD_VW A ,PS_PERS_SRCH_GBL B ,PS_PY_MOD_PAYGRP C WHERE B.EMPLID = A.EMPLID AND C.COMPANY = A.COMPANY AND C.PAYGROUP = A.PAYGROUP AND ( (C.PY_MOD_ACCES_CNTRL = 'E') OR (C.PY_MOD_ACCES_CNTRL = 'T' AND NOT EXISTS ( SELECT 'Y' FROM PS_PY_MOD_PGRP_PRD D WHERE D.COMPANY = C.COMPANY AND D.PAYGROUP = C.PAYGROUP AND (%CurrentDateTimeIn BETWEEN %Dttm(D.START_DT,D.START_TIME) AND %Dttm(D.END_DT, D.END_TIME))) ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
Prompt Table: PAYGROUP_TBL

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

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

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name