COMM_LTR_SRCH (SQL View)	Index Back
Communication Ltr Prompt Srch COMM_LTR_SRCH is the search record for Communication Letter Generation when the 'one emplid' option is selected. It provides a list of all those people who have outgoing letters which are waiting to be printed.

COMM_LTR_SRCH

(SQL View)

Communication Ltr Prompt Srch

COMM_LTR_SRCH is the search record for Communication Letter Generation when the 'one emplid' option is selected. It provides a list of all those people who have outgoing letters which are waiting to be printed.

SELECT DISTINCT B.EMPLID , B.NAME FROM PS_COMMUNICATION A , PS_SCC_PRI_NAME_VW B WHERE A.COMMON_ID = B.EMPLID AND A.COMPLETED_COMM <> 'Y' AND A.SCC_LETTER_CD > ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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: PEOPLE_SRCH
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name