ITRECON_HRDWR_C(SQL Table) |
Index Back |
|---|---|
Reconciliation - Hardware DataReconciliation - 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 | COMPARE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected) 2=Expected data not in Results 3=Unexpected data in Results |
| 3 | COMPARE_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals E=Expected |
| 4 | SERIAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 5 | RULE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Rule ID |
| 6 | 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 |
| 7 | ATTRIBUTE_ID | Character(20) | VARCHAR2(20) NOT NULL | Attribute ID |
| 8 | DISCO_VALUE | Character(60) | VARCHAR2(60) NOT NULL | Discovery Value |
| 9 | ARM_VALUE | Character(60) | VARCHAR2(60) NOT NULL | ARM Value |
| 10 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |