RF_AGRMT_LANG (SQL Table)	Index Back
Agreement Related Language Agreement Header Related Language table

RF_AGRMT_LANG

(SQL Table)

Agreement Related Language

Agreement Header Related Language table

Related Language Record for 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)

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.

#	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)
4	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.