RF_AGR_CA_VW (SQL View)	Index Back
Agreement Mapping Table View Mapping Table for Agreement with External Systems View

RF_AGR_CA_VW

(SQL View)

Agreement Mapping Table View

Mapping Table for Agreement with External Systems View

SELECT SETID , AGREEMENT_CODE , AGR_RENEWAL_NUM , %Substring(EXTERNAL_KEY_2,1,25) FROM PS_RF_INT_AGRMNT WHERE INTGN_SOURCE = '001'

# 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 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL This field is used to represent the contract number

#	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	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	This field is used to represent the contract number