ITRECON_DSPLY_E(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 | 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. |