WM_INBOX_SEARCH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SAVED_SEARCH	Character(30)	VARCHAR2(30) NOT NULL	Saved Search Name
3	AGENT_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Agent role name
4	ASSIGNED_TO_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Assigned To
5	ASSIGNED_BY_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Group Assigned by
6	STATUS_CD	Character(4)	VARCHAR2(4) NOT NULL	User defined Status Code
7	INTERNAL_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Internal Status 01=Open 02=Awaiting Schedule 03=Scheduled 04=Work In Progress 05=Complete 06=Closed 07=Canceled 08=On Hold 09=Work Order Created
8	WR_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Service Request Priority 1=1-Critical 2=2-Urgent 3=3-Standard 4=4-Low
9	WR_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Request ID
10	LAST_VIEW_SW	Character(1)	VARCHAR2(1) NOT NULL	Last View used flag. Default Value: N
11	RQST_FOR_USERID	Character(30)	VARCHAR2(30) NOT NULL	Request For User ID
12	CONTACT_USERID	Character(30)	VARCHAR2(30) NOT NULL	Contact User ID
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
14	RQST_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Request type equivalent to tree node.
15	REQ_START_DT	Date(10)	DATE	Required Start
16	REQ_END_DT	Date(10)	DATE	Required End
17	WR_SUBJECT	Character(60)	VARCHAR2(60) NOT NULL	Subject
18	ASSET_DESCR30	Character(30)	VARCHAR2(30) NOT NULL	Asset Description
19	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
20	TAG_NUMBER	Character(12)	VARCHAR2(12) NOT NULL	Tag Number
21	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
22	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit