ITRECON_DSPLY_C

(SQL Table)
Index Back

Reconciliation Details Display

Reconciliation Details Display

# 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 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
6 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
7 IN_PROCESS Character(1) VARCHAR2(1) NOT NULL Process
8 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
9 DISCO_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
10 ARM_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
11 IT_BU_STATUS Character(1) VARCHAR2(1) NOT NULL IT Business Unit 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
12 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
13 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
14 DEPTID_STATUS Character(1) VARCHAR2(1) NOT NULL Department Id 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
15 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
16 DEPTID_2 Character(10) VARCHAR2(10) NOT NULL Department ID
17 MODEL_STATUS Character(1) VARCHAR2(1) NOT NULL Model 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
18 DISCO_MODEL Character(30) VARCHAR2(30) NOT NULL Model
19 ARM_MODEL Character(30) VARCHAR2(30) NOT NULL Model
20 CSTDN_STATUS Character(1) VARCHAR2(1) NOT NULL Custodian 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
21 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
22 EMPLID2 Character(11) VARCHAR2(11) NOT NULL Employee ID
23 DISCO_CSTDN Character(30) VARCHAR2(30) NOT NULL DISCO Custodian
24 ARM_CSTDN Character(30) VARCHAR2(30) NOT NULL ARM Custodian
25 MFG_ID_STATUS Character(1) VARCHAR2(1) NOT NULL Manufacturer Id 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
26 DISCO_MFG_ID Character(50) VARCHAR2(50) NOT NULL Discovery Manufacturer ID
27 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
28 ARM_MFG_ID Character(50) VARCHAR2(50) NOT NULL ARM Manufacturer ID
29 MANUFACTURER_B Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
30 LOCATION_STATUS Character(1) VARCHAR2(1) NOT NULL Location 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
31 DISCO_LOCATION Character(10) VARCHAR2(10) NOT NULL Discovery Location Code
32 ARM_LOCATION Character(10) VARCHAR2(10) NOT NULL ARM Location Code
33 IT_UD_CHAR1_STATUS Character(1) VARCHAR2(1) NOT NULL IT_UD_CHAR1 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
34 DISCO_IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL Discovery UD Char
35 ARM_IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL ARM IT User Defined Char
36 IT_UD_CHAR2_STATUS Character(1) VARCHAR2(1) NOT NULL IT_UD_CHAR2 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
37 DISCO_IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL Discovery UD Char2
38 ARM_IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL ARM User Defined Char2
39 IT_UD_DATE1_STATUS Character(1) VARCHAR2(1) NOT NULL IT_UD_DATE1 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
40 DISCO_IT_UD_DATE1 Date(10) DATE Discovery User Defined Date
41 ARM_IT_UD_DATE1 Date(10) DATE ARM User Defined Date
42 SFTWR_ERR_FLAG Character(1) VARCHAR2(1) NOT NULL Software Error Flag
N=No Errors/Exceptions
O=Over The Limit
P=Processed / In Process
R=Resolved
U=Unauthorized Install
W=Auto Processed Unauthorized
X=Auto Processed Over Limit
Y=Processed Over the Limit
Z=Processed Unauthorized Install
43 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance