SCC_RSLVLOG_VW

(SQL View)

SELECT RECNAME ,PROCESS_INSTANCE ,SCC_INTGR_ROWNUM ,SCC_RESOLVE_DTM ,SCC_DATA_SOURCE ,SCC_DISCREP_KEYS ,SCC_RESOLVE_ACTION ,SCC_NONKEY_CHANGES FROM PS_SCC_RESOLVE_LOG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

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

3 SCC_INTGR_ROWNUM Number(10,0) DECIMAL(10) NOT NULL Row Number

4 SCC_RESOLVE_DTM DateTime(26) TIMESTAMP Resolve Date Time

5 SCC_DATA_SOURCE Character(30) VARCHAR2(30) NOT NULL Data Source

6 SCC_DISCREP_KEYS Character(240) VARCHAR2(240) NOT NULL Key fields of discrepancies

7 SCC_RESOLVE_ACTION Character(1) VARCHAR2(1) NOT NULL Resolve Action
A=Add
C=Change
D=Delete

8 SCC_NONKEY_CHANGES Long Character CLOB Non Key Changes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	SCC_INTGR_ROWNUM	Number(10,0)	DECIMAL(10) NOT NULL	Row Number
4	SCC_RESOLVE_DTM	DateTime(26)	TIMESTAMP	Resolve Date Time
5	SCC_DATA_SOURCE	Character(30)	VARCHAR2(30) NOT NULL	Data Source
6	SCC_DISCREP_KEYS	Character(240)	VARCHAR2(240) NOT NULL	Key fields of discrepancies
7	SCC_RESOLVE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Resolve Action A=Add C=Change D=Delete
8	SCC_NONKEY_CHANGES	Long Character	CLOB	Non Key Changes