SCC_CG_COMPRCVW (SQL View)	Index Back
COMMGEN Process Instance View View of COMMUNICATIONs processed by SCC_COMMGEN process listing the Process Instance. Processing Statuses limited to: Successful. Communication records that are Completed. Communication method limited to: B, D, L (Publication, Document, or Letter). Used to prompt for communication records that need envelopes and/or labels created.

SCC_CG_COMPRCVW

(SQL View)

COMMGEN Process Instance View

View of COMMUNICATIONs processed by SCC_COMMGEN process listing the Process Instance. Processing Statuses limited to: Successful. Communication records that are Completed. Communication method limited to: B, D, L (Publication, Document, or Letter). Used to prompt for communication records that need envelopes and/or labels created.

SELECT DISTINCT A.PRCSINSTANCE , A.PRCSNAME , B.SCC_LETTER_CD , A.RUNDTTM , A.OPRID , A.RUNCNTLID FROM PS_PMN_PRCSLIST A , PS_COMMUNICATION B WHERE A.PRCSNAME IN ('SCC_COMMGEN', 'SCC_CGLABELS') AND A.RUNSTATUS = '9' AND A.PRCSINSTANCE = B.PROCESS_INSTANCE AND B.COMPLETED_COMM = 'Y' AND B.SCC_COMM_MTHD IN ('B', 'D', 'L', ' ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

3 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code

4 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time

5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

6 RUNCNTLID Character(30) VARCHAR2(30) NOT NULL Run Control ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
3	SCC_LETTER_CD	Character(3)	VARCHAR2(3) NOT NULL	Letter Code
4	RUNDTTM	DateTime(26)	TIMESTAMP	Run Date/Time
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	RUNCNTLID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID