COMM_ORGSRCHLNG (SQL View)	Index Back
Communication Org Prompt Srch COMM_ORG_SRCH is the search record for Communication Letter Generation when the 'One Org ID' option is selected. It provides a list of all those Organizations who have outgoing letters which are waiting to be printed.

COMM_ORGSRCHLNG

(SQL View)

Communication Org Prompt Srch

COMM_ORG_SRCH is the search record for Communication Letter Generation when the 'One Org ID' option is selected. It provides a list of all those Organizations who have outgoing letters which are waiting to be printed.

SELECT DISTINCT B.EXT_ORG_ID , B.EFFDT ,B.LANGUAGE_CD , C.DESCR50 FROM PS_COMMUNICATION A , PS_EXT_ORG_LANG B , PS_EXT_ORG_TBL C WHERE A.COMMON_ID = B.EXT_ORG_ID AND C.EXT_ORG_ID = B.EXT_ORG_ID AND C.EFFDT = B.EFFDT AND A.COMPLETED_COMM <> 'Y' AND A.SCC_LETTER_CD > ' '

Related Language Record for COMM_ORG_SRCH

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
Prompt Table: EXT_ORG_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: EXT_ORG_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50