SCC_CG_ORG_BIND

(SQL View)
 Index Back

CommGenOrg PopSelect Bind View

PopSel Bind record for COMMGEN External Org Communications

SELECT DISTINCT A.COMMON_ID ,A.SA_ID_TYPE ,B.DESCR FROM PS_COMMUNICATION A , PS_EXT_ORG_TBL B WHERE A.COMPLETED_COMM <>'Y' AND A.PROCESS_INSTANCE=0 AND A.SA_ID_TYPE = 'O' AND A.COMMON_ID = B.EXT_ORG_ID AND B.EFFDT = ( SELECT MAX(Y.EFFDT) FROM PS_EXT_ORG_TBL Y WHERE Y.EXT_ORG_ID = B.EXT_ORG_ID AND Y.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