ITRECON_DSPLY_C(SQL Table) |
Index Back |
---|---|
Reconciliation Details DisplayReconciliation 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 |