IT_UNDISC1_TAO

(SQL Table)
Index Back

Aging Inventory Temp table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 IT_TIMESPAN_ID Character(15) VARCHAR2(15) NOT NULL Inventory Age
3 IT_TIMESPAN_SEQ Number(5,0) INTEGER NOT NULL Inventory Age Seq
4 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype
5 DISCO_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
6 DISCO_MFG_ID Character(50) VARCHAR2(50) NOT NULL Discovery Manufacturer ID
7 DISCO_MODEL Character(30) VARCHAR2(30) NOT NULL Model
8 MACHINENAME_DISCO Character(64) VARCHAR2(64) NOT NULL Machine Name from 3rd Party
9 DISCOVERY_DATE Date(10) DATE Last Inventory Date
10 IP_ADDRESS_DISCO Character(39) VARCHAR2(39) NOT NULL IP Address from Third Party
11 DISCO_LOCATION Character(10) VARCHAR2(10) NOT NULL Discovery Location Code
12 PUSER_EMPLID Character(11) VARCHAR2(11) NOT NULL Primary User Empl Id