RF_AGR_CREATOR (SQL View)	Index Back
Agreement Creator This view returns the person id of the creator of the agreement.

RF_AGR_CREATOR

(SQL View)

Agreement Creator

This view returns the person id of the creator of the agreement.

SELECT B.SETID , B.AGREEMENT_CODE , A.PERSON_ID FROM PSOPRALIAS A , PS_RF_AGREEMENT B WHERE A.OPRID = B.ROW_LASTMANT_OPRID

# 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 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

#	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	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
3	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID