SCC_SL_PURGIDVW

(SQL View)
 Index Back

Constituent Stage Purge Record

Constituent Stage Purge Record

SELECT DISTINCT A.SCC_TEMP_ID ,A.EMPLID ,A.USERID ,B.LAST_NAME ,B.FIRST_NAME ,A.SCC_TRANSAC_CD ,%DatePart(A.CREATED_DTTM) ,A.SCC_STG_STATUS FROM PS_SCC_STG_CONSTIT A , PS_SCC_STG_NAMES B WHERE A.SCC_TEMP_ID = B.SCC_TEMP_ID AND B.NAME_TYPE = 'PRI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temporary ID

Prompt Table: SCC_STG_CONSTIT

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SCC_STGE_VW

3 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

Prompt Table: SCC_STGU_VW

4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

Prompt Table: SCC_TRN_SCTY_VW

7 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
8 SCC_STG_STATUS Character(2) VARCHAR2(2) NOT NULL Constituent Status
AN=Add New ID
CN=Cancelled
LD=Loaded
SA=New ID Created
SI=Ignore
SS=Suspended
SU=ID Updated
UE=Update ID
VE=Error