CC_SCAN_LIST

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCAN_LIST_ID Number(9,0) DECIMAL(9) NOT NULL Scan List ID
Prompt Table: CC_SCAN_TBL

2 WHEREUSEDPARTYPE Signed Number(6,0) DECIMAL(5) NOT NULL Parent Type
Prompt Table: WHEREUSEDOBJTBL

3 WHEREUSEDPARENT Character(100) VARCHAR2(100) NOT NULL Parent

4 SCAN_STATUS Character(1) VARCHAR2(1) NOT NULL Scan Status
A=Adding To List
E=Error
O=Omitting From List
S=Scanned
U=Unscanned

5 SCAN_PASS_NBR Number(7,0) INTEGER NOT NULL Scan Pass Number indicates when the object was added to the scan list. Which pass added it. e.g. first pass, second pass, etc. zero is valid and indicates that it was in the initial scan list.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCAN_LIST_ID	Number(9,0)	DECIMAL(9) NOT NULL	Scan List ID Prompt Table: CC_SCAN_TBL
2	WHEREUSEDPARTYPE	Signed Number(6,0)	DECIMAL(5) NOT NULL	Parent Type Prompt Table: WHEREUSEDOBJTBL
3	WHEREUSEDPARENT	Character(100)	VARCHAR2(100) NOT NULL	Parent
4	SCAN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Scan Status A=Adding To List E=Error O=Omitting From List S=Scanned U=Unscanned
5	SCAN_PASS_NBR	Number(7,0)	INTEGER NOT NULL	Scan Pass Number indicates when the object was added to the scan list. Which pass added it. e.g. first pass, second pass, etc. zero is valid and indicates that it was in the initial scan list.