IT_HW_CACHE_C(SQL Table) |
Index Back |
|---|---|
IT HardwareIT Hardware table is populated via the IT_LOAD_PROC (input is IT_DISCO_HW_STG) |
| # | 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 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: IT_MFG_IDS |
| 6 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table: IT_AM_SUBTYPES |
| 7 | IT_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL |
IT Subtype
Prompt Table: IT_SUBTYPE |
| 8 | IT_RESOURCE | Character(30) | VARCHAR2(30) NOT NULL | ITAM - Used for mapping the IT Devices. Example: The values Mini-Tower and Desktop from 3rd Party will be mapped to PSFT value of Desktop. |
| 9 | PARENT_SERIAL | Character(20) | VARCHAR2(20) NOT NULL | Parent Serial ID |
| 10 | MACHINENAME | Character(30) | VARCHAR2(30) NOT NULL | Machine Name |
| 11 | MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |
| 12 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 13 | BUSINESS_UNIT_HR | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit HR
Prompt Table: BUS_UNIT_TBL_FS |
| 14 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 15 | IP_ADDRESS | Character(39) | VARCHAR2(39) NOT NULL | Internet Protocol Address |
| 16 | IP_ADDR_FORMAT1 | Character(39) | VARCHAR2(39) NOT NULL | Used in formatting an IP Address entered online or received from a 3rd party integration source. Format is: xxx.xxx.xxx.xxx |
| 17 | DISCOVERY_DATE | Date(10) | DATE | Last Inventory Date |
| 18 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: IT_LOCATIONS |
| 19 | VPN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | IP Address for VPN |
| 20 | IT_UD_CHAR1 | Character(50) | VARCHAR2(50) NOT NULL | IT User Defined Char Field1 |
| 21 | IT_UD_CHAR2 | Character(50) | VARCHAR2(50) NOT NULL | IT User Defined Char Field2 |
| 22 | IT_UD_DATE1 | Date(10) | DATE | IT User Defined Date Field |
| 23 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All S=Only purge items with at least |
| 24 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |