SCC_CG_COMORGVW (SQL View)	Index Back
Org Communication View SCC_CG_CCMORGVW is a view of Communication records with Process Instance > 0 (joined to SCC_CG_COMPRCVW). Used to prompt for communication ORGANIZATION records that need envelopes and/or labels created.

SCC_CG_COMORGVW

(SQL View)

Org Communication View

SCC_CG_CCMORGVW is a view of Communication records with Process Instance > 0 (joined to SCC_CG_COMPRCVW). Used to prompt for communication ORGANIZATION records that need envelopes and/or labels created.

SELECT DISTINCT A.PROCESS_INSTANCE , B.EXT_ORG_ID , B.EFFDT , B.EFF_STATUS , B.DESCR50 FROM PS_COMMUNICATION A , PS_EXT_ORG_TBL B WHERE A.COMMON_ID = B.EXT_ORG_ID AND A.PROCESS_INSTANCE > 0 AND EXISTS ( SELECT 'X' FROM PS_SCC_CG_COMPRCVW X WHERE X.PROCESS_INSTANCE = A.PROCESS_INSTANCE)

Related Language Record: SCC_CG_COMORGLN

# 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50