SCC_CG_PER_BIND (SQL View)	Index Back
CommGenPer PopSelect Bind View The CommGen PopSelect Bind View selects the Person COMMUNICATION records that are available for processing (not yet completed and not currently selected).

SCC_CG_PER_BIND

(SQL View)

CommGenPer PopSelect Bind View

The CommGen PopSelect Bind View selects the Person COMMUNICATION records that are available for processing (not yet completed and not currently selected).

SELECT DISTINCT A.COMMON_ID , A.SA_ID_TYPE , B.NAME FROM PS_COMMUNICATION A , PS_SCC_PRI_NAME_VW B WHERE A.COMPLETED_COMM <>'Y' AND A.PROCESS_INSTANCE=0 AND A.SA_ID_TYPE = 'P' AND A.COMMON_ID = B.EMPLID AND B.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_SCC_PRI_NAME_VW X WHERE X.EMPLID = B.EMPLID AND X.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value

2 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
2	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name