SCC_SL_ID_SELCT (SQL View)	Index Back
SnL run control SnL run control

SCC_SL_ID_SELCT

(SQL View)

SnL run control

SELECT DISTINCT A.SCC_TRANSAC_CD ,A.SCC_TEMP_ID ,D.FIRST_NAME ,D.LAST_NAME ,D.NAME FROM PS_SCC_STG_CONSTIT A , PS_SAD_APL_DAT_STG B , PS_SAD_PDL_HDR_STG C , PS_SCC_STG_NAMES D WHERE ((A.SCC_TEMP_ID = B.SCC_TEMP_ID AND B.SCC_TRANS_STS IN('SV','SB') AND B.SCC_TEMP_ID=D.SCC_TEMP_ID) OR (A.SCC_TEMP_ID = C.SCC_TEMP_ID AND C.SCC_TRANS_STS IN('SV','SB') AND C.SCC_TEMP_ID = D.SCC_TEMP_ID)) AND A.SCC_STG_STATUS <> 'CN' AND D.NAME_TYPE='PRI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction
Prompt Table: SCC_TRNSAC_DTLS

2 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID

3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_TRANSAC_CD	Character(25)	VARCHAR2(25) NOT NULL	Transaction Prompt Table: SCC_TRNSAC_DTLS
2	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
3	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
4	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name