ITRECON_DSPLY_E

(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 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
4 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
5 IN_PROCESS Character(1) VARCHAR2(1) NOT NULL Process
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 DISCO_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
8 ARM_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
9 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
10 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
11 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
12 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
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
14 DEPTID_2 Character(10) VARCHAR2(10) NOT NULL Department ID
15 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
16 DISCO_MODEL Character(30) VARCHAR2(30) NOT NULL Model
17 ARM_MODEL Character(30) VARCHAR2(30) NOT NULL Model
18 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
19 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
20 EMPLID2 Character(11) VARCHAR2(11) NOT NULL Employee ID
21 DISCO_CSTDN Character(30) VARCHAR2(30) NOT NULL DISCO Custodian
22 ARM_CSTDN Character(30) VARCHAR2(30) NOT NULL ARM Custodian
23 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
24 DISCO_MFG_ID Character(50) VARCHAR2(50) NOT NULL Discovery Manufacturer ID
25 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
26 ARM_MFG_ID Character(50) VARCHAR2(50) NOT NULL ARM Manufacturer ID
27 MANUFACTURER_B Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
28 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
29 DISCO_LOCATION Character(10) VARCHAR2(10) NOT NULL Discovery Location Code
30 ARM_LOCATION Character(10) VARCHAR2(10) NOT NULL ARM Location Code
31 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
32 DISCO_IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL Discovery UD Char
33 ARM_IT_UD_CHAR1 Character(50) VARCHAR2(50) NOT NULL ARM IT User Defined Char
34 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
35 DISCO_IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL Discovery UD Char2
36 ARM_IT_UD_CHAR2 Character(50) VARCHAR2(50) NOT NULL ARM User Defined Char2
37 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
38 DISCO_IT_UD_DATE1 Date(10) DATE Discovery User Defined Date
39 ARM_IT_UD_DATE1 Date(10) DATE ARM User Defined Date
40 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
41 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
42 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.