RF_AGREESRC3_VW (SQL View)	Index Back
Agreement Search View This is the search view for the Configurable Search component associated with Agreements.

RF_AGREESRC3_VW

(SQL View)

Agreement Search View

This is the search view for the Configurable Search component associated with Agreements.

SELECT A.SETID , A.AGREEMENT_CODE , A.AGR_RENEWAL_NUM , C.BO_NAME_DISPLAY , C.BO_NAME_AC , D.BO_NAME_DISPLAY , D.BO_NAME_AC , A.AGRT_STATUS , A.AGREEMENT_CATEGORY , A.BO_ID_CUST , A.ROLE_TYPE_ID_CUST , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.RO_CAPTURE_FLAG , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , A.SYNCID FROM PS_RF_AGREEMENT A , PS_BO_NAME C , PS_BO_NAME D WHERE AGR_TEMPLATE_ID = ' ' AND A.BO_ID_CUST = C.BO_ID(+) AND C.PRIMARY_IND(+) = 'Y' AND A.BO_ID_CONTACT = D.BO_ID(+) AND D.PRIMARY_IND(+) = 'Y'

# 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.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

3 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
Default Value: 1

4 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

5 BO_NAME_AC Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

6 BO_NAME_DISPLAY_1 Character(80) VARCHAR2(80) NOT NULL This field represents the Display Name for a business object

7 BO_NAME_CONTACT_AC Character(50) VARCHAR2(50) NOT NULL Alt-Char Contact Name

8 AGRT_STATUS Character(3) VARCHAR2(3) NOT NULL This field represents the agreement status value.
001=Pending
002=Pending Activation
003=Action Required
005=Active
009=Closed
Default Value: 005

9 AGREEMENT_CATEGORY Character(1) VARCHAR2(1) NOT NULL Field for defining the Category for the Agreement, to be used in the Agreement Header Record.
1=External
2=Internal
3=External - No Pricing

10 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

11 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

12 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

13 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

14 RO_CAPTURE_FLAG Character(1) VARCHAR2(1) NOT NULL This field indicates if an agreement is created through Order Capture. It also indicates if an Agreement Template may be sold through Order Capture.
N=No
Y=Yes

15 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: PROD_ITEM

16 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID
Prompt Table: RF_SERVICE

17 ENTITLE_NAME Character(10) VARCHAR2(10) NOT NULL This field represents the name of the entitlement
Prompt Table: RF_ENTL_PRM_VW

18 RC_SOURCE Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
Prompt Table: RC_SOURCE_TBL

19 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
Prompt Table: RC_PRIORITY_TBL

20 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type
Prompt Table: RC_CASETYPE_TBL

21 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.
Prompt Table: RC_CATEGORY_VW

22 ASSESS_DESCR Character(30) VARCHAR2(30) NOT NULL ASSESS_DESCR

23 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
Prompt Table: RF_DEPT_ALL_VW

24 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
Prompt Table: RF_ALL_LOC_VW

25 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level.
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager

26 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

#	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. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
3	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal) Default Value: 1
4	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
5	BO_NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
6	BO_NAME_DISPLAY_1	Character(80)	VARCHAR2(80) NOT NULL	This field represents the Display Name for a business object
7	BO_NAME_CONTACT_AC	Character(50)	VARCHAR2(50) NOT NULL	Alt-Char Contact Name
8	AGRT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	This field represents the agreement status value. 001=Pending 002=Pending Activation 003=Action Required 005=Active 009=Closed Default Value: 005
9	AGREEMENT_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Field for defining the Category for the Agreement, to be used in the Agreement Header Record. 1=External 2=Internal 3=External - No Pricing
10	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
11	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
12	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
13	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
14	RO_CAPTURE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if an agreement is created through Order Capture. It also indicates if an Agreement Template may be sold through Order Capture. N=No Y=Yes
15	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PROD_ITEM
16	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID Prompt Table: RF_SERVICE
17	ENTITLE_NAME	Character(10)	VARCHAR2(10) NOT NULL	This field represents the name of the entitlement Prompt Table: RF_ENTL_PRM_VW
18	RC_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated Prompt Table: RC_SOURCE_TBL
19	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority Prompt Table: RC_PRIORITY_TBL
20	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type Prompt Table: RC_CASETYPE_TBL
21	RC_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	CallCenter Category. Used in HD. Prompt Table: RC_CATEGORY_VW
22	ASSESS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	ASSESS_DESCR
23	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department Prompt Table: RF_DEPT_ALL_VW
24	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code. Prompt Table: RF_ALL_LOC_VW
25	MANAGER_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Manager Level. 0=Chief Operating Officer 1=Director 2=Senior Officer 3=Vice President 4=Senior Manager 5=Mid-Level Manager 6=First-Line Manager 7=Supervisor 8=All Other Positions 9=Non-Manager
26	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.