SCC_CG_CLRORGLN (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.

SCC_CG_CLRORGLN

(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 A.PROCESS_INSTANCE , 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 SCC_CG_CLRORGVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

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

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

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