RETRODED_RQE_VW (SQL View)	Index Back
Retro Ded Request Emplid View This is a view of the RETRODED_RQST table where RETRODED_RQST_TYPE <> 'M' and RETRODED_PRCS_FLAG = 'N'.

RETRODED_RQE_VW

(SQL View)

Retro Ded Request Emplid View

This is a view of the RETRODED_RQST table where RETRODED_RQST_TYPE <> 'M' and RETRODED_PRCS_FLAG = 'N'.

SELECT a.emplid , a.retroded_seq_no , b.name FROM ps_retroded_rqst a , PS_PERSON_NAME b WHERE a.retroded_rqst_type <> 'M' AND a.retroded_prcs_flag = 'N' 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 RETRODED_SEQ_NO Character(8) VARCHAR2(8) NOT NULL Retro Ded 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	RETRODED_SEQ_NO	Character(8)	VARCHAR2(8) NOT NULL	Retro Ded Sequence Number
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name