RC_INSTH_ALL_VW (SQL View)	Index Back
Installed Product prompt Prompt on all installed products for all employees and all departments. (Helpdesk)

RC_INSTH_ALL_VW

(SQL View)

Installed Product prompt

Prompt on all installed products for all employees and all departments. (Helpdesk)

SELECT SETID , INST_PROD_ID , ASSETTAG , DESCR FROM %Table(RC_INST_PROD_VW) WHERE INST_PROD_TYPE = '001'

Related Language Record: RC_INSTH_ALLLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

3 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
3	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description