IT_SFTWR_INVDTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SFTWR_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Software Title
2	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	NAME50	Character(50)	VARCHAR2(50) NOT NULL	name field of length 50
7	PERMISSION_REQD	Character(1)	VARCHAR2(1) NOT NULL	Permission Required
8	AUTH_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Authorized A=Authorized U=Unauthorized
9	TRACK_REQ	Character(1)	VARCHAR2(1) NOT NULL	Track Requisition
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	TOTAL_RUN_TIME	Number(31,0)	DECIMAL(31) NOT NULL	Total Run Time in Seconds
12	SFTWR_INSTALL_DT	Date(10)	DATE	Software Installation Date
13	IT_GRP_ID	Character(11)	VARCHAR2(11) NOT NULL	Employee Group Id
14	GRP_OWNER_ID	Character(11)	VARCHAR2(11) NOT NULL	Group Owner Id
15	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
16	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	SFTWR_PUBLISHER	Character(30)	VARCHAR2(30) NOT NULL	Software Publisher
19	DISCOVERY_DATE	Date(10)	DATE	Last Inventory Date