ITRECON_HRDWR_E (SQL Table)	Index Back
Reconciliation - Hardware Data Reconciliation - Hardware Data

ITRECON_HRDWR_E

(SQL Table)

Reconciliation - Hardware Data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case

2 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

3 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID

4 COMP_STATUS Character(1) VARCHAR2(1) NOT NULL Comparison Status
A=Resolved by Auto-reconcile
I=Ignore Exception
N=Never in Exception
P=In Process/Processed
R=Resolved / Reconciled
U=Unreconciled
X=Processed by Auto-reconcile

5 ATTRIBUTE_ID Character(20) VARCHAR2(20) NOT NULL Attribute ID

6 DISCO_VALUE Character(60) VARCHAR2(60) NOT NULL Discovery Value

7 ARM_VALUE Character(60) VARCHAR2(60) NOT NULL ARM Value

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

9 DTTM_REFRESHED DateTime(26) TIMESTAMP Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEST_CASE	Character(30)	VARCHAR2(30) NOT NULL	BTF Test Case
2	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
3	RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Rule ID
4	COMP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Comparison Status A=Resolved by Auto-reconcile I=Ignore Exception N=Never in Exception P=In Process/Processed R=Resolved / Reconciled U=Unreconciled X=Processed by Auto-reconcile
5	ATTRIBUTE_ID	Character(20)	VARCHAR2(20) NOT NULL	Attribute ID
6	DISCO_VALUE	Character(60)	VARCHAR2(60) NOT NULL	Discovery Value
7	ARM_VALUE	Character(60)	VARCHAR2(60) NOT NULL	ARM Value
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
9	DTTM_REFRESHED	DateTime(26)	TIMESTAMP	Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.