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

PI_IC_CHK_DT_VW

(SQL View)

WEB-PayChk Rvw PayEndDates(PI)

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

SELECT DISTINCT A.OPRID , B.PAY_END_DT , B.PI_CHECK_NBR , B.PI_NET_PAY , C.EMPLID , B.CURRENCY_CD FROM PSOPRDEFN A , PS_PI_CHECK B , PS_PI_EMPLID_TBL C WHERE A.EMPLID = C.EMPLID AND B.PI_EMPLID = C.PI_EMPLID

# 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 PI_CHECK_NBR Character(10) VARCHAR2(10) NOT NULL Payroll Check Number

4 PI_NET_PAY Signed Number(20,3) DECIMAL(18,3) NOT NULL Net Py

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

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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	PI_CHECK_NBR	Character(10)	VARCHAR2(10) NOT NULL	Payroll Check Number
4	PI_NET_PAY	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Net Py
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code