RF_AGREE_ADD_VW (SQL View)	Index Back
Agreement Add view Agreement Component Add view (lists all existing agreements)

RF_AGREE_ADD_VW

(SQL View)

Agreement Add view

Agreement Component Add view (lists all existing agreements)

SELECT SETID ,AGREEMENT_CODE ,AGR_RENEWAL_NUM ,AGREEMENT_CATEGORY FROM PS_RF_AGREEMENT

# 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 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

#	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	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