RETRO_RQST1_VW (SQL View)	Index Back
Retro Pay Rqst Vw 1-Job/AddlPy Retro Pay Rqst Vw 1-Job/AddlPy

RETRO_RQST1_VW

(SQL View)

Retro Pay Rqst Vw 1-Job/AddlPy

SELECT a.emplid , a.retropay_seq_no , b.name FROM ps_retropay_rqst a , PS_PERSON_NAME b WHERE a.retropay_rqst_type <> 'M' AND a.retropay_prcs_flag IN ( 'N','R') AND a.emplid = b.emplid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DTA_VW

2 RETROPAY_SEQ_NO Character(8) VARCHAR2(8) NOT NULL Retro Pay Sequence Number

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DTA_VW
2	RETROPAY_SEQ_NO	Character(8)	VARCHAR2(8) NOT NULL	Retro Pay Sequence Number
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name