PY_IC_PI_DT_VW (SQL View)	Index Back
WEB-PayChk Rvw Pay End Dates View created to support WEB-enabled Paycheck Review. It is based on the PAY_CHECK record. It contains all the Pay End Dates for which the user has a confirmed check.

PY_IC_PI_DT_VW

(SQL View)

WEB-PayChk Rvw Pay End Dates

View created to support WEB-enabled Paycheck Review. It is based on the PAY_CHECK record. It contains all the Pay End Dates for which the user has a confirmed check.

select distinct A.OPRID , B.PAY_END_DT , B.EMPLID from PSOPRDEFN A, PS_PAY_CHECK B where A.EMPLID = B.EMPLID and B.PAYCHECK_STATUS = 'F' and B.PAYCHECK_OPTION <> 'R'

# 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 PAY_END_DT_ALT Date(10) DATE NOT NULL Pay Period End Date

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	PAY_END_DT_ALT	Date(10)	DATE NOT NULL	Pay Period End Date
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID