SCC_SL_PURG_TGT (SQL Table)	Index Back
Pop Sel Target Record - Purge Pop Select Target Record for purge process

SCC_SL_PURG_TGT

(SQL Table)

Pop Sel Target Record - Purge

Pop Select Target Record for purge process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 SCC_TRANSAC_CD Character(25) VARCHAR2(25) NOT NULL Transaction

4 SCC_STG_STATUS Character(2) VARCHAR2(2) NOT NULL Staging 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

5 SCC_STG_STS_DT Date(10) DATE SnL Staging Status Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
3	SCC_TRANSAC_CD	Character(25)	VARCHAR2(25) NOT NULL	Transaction
4	SCC_STG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Staging 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
5	SCC_STG_STS_DT	Date(10)	DATE	SnL Staging Status Date