AGREEMENT_FRA (SQL Table)	Index Back
Agreement List Table Table of Agreements used in French Labor Relations module PRJxxxxxx - 30th August 2002 Added AGREEMENT_NBR_FRA as the fourth element of the index and included it in the search and list box and made it a required field.

AGREEMENT_FRA

(SQL Table)

Agreement List Table

Table of Agreements used in French Labor Relations module PRJxxxxxx - 30th August 2002 Added AGREEMENT_NBR_FRA as the fourth element of the index and included it in the search and list box and made it a required field.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID

2 AGREEMENT_DT_FRA Date(10) DATE NOT NULL Agreement Date

3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

4 AGREEMENT_NBR_FRA Character(11) VARCHAR2(11) NOT NULL Agreement Number

5 AGREEMENT_TYPE_FRA Character(1) VARCHAR2(1) NOT NULL Agreement Type
A=Annual
M=Multi-Annula
S=Simple

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	VENDOR	Character(6)	VARCHAR2(6) NOT NULL	Vendor ID
2	AGREEMENT_DT_FRA	Date(10)	DATE NOT NULL	Agreement Date
3	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
4	AGREEMENT_NBR_FRA	Character(11)	VARCHAR2(11) NOT NULL	Agreement Number
5	AGREEMENT_TYPE_FRA	Character(1)	VARCHAR2(1) NOT NULL	Agreement Type A=Annual M=Multi-Annula S=Simple