GPAR_LAYOUT_CON (SQL Table)	Index Back
Field conversion values Contains field conversion values for file layout based Argentinean reports

GPAR_LAYOUT_CON

(SQL Table)

Field conversion values

Contains field conversion values for file layout based Argentinean reports

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPAR_LAYOUT_ID Character(15) VARCHAR2(15) NOT NULL Layout Identificator.

2 GPAR_ROW_SEQUENCE Number(3,0) SMALLINT NOT NULL Layout Row Sequence

3 GPAR_FLD_SEQUENCE Number(4,0) SMALLINT NOT NULL Field sequence in a given row and layout.

4 GPAR_FROM_VALUE Character(30) VARCHAR2(30) NOT NULL Value to be replaced with another value.

5 GPAR_TO_VALUE Character(30) VARCHAR2(30) NOT NULL Target value used to replace a source value in a layout field.

6 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPAR_LAYOUT_ID	Character(15)	VARCHAR2(15) NOT NULL	Layout Identificator.
2	GPAR_ROW_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	Layout Row Sequence
3	GPAR_FLD_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Field sequence in a given row and layout.
4	GPAR_FROM_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Value to be replaced with another value.
5	GPAR_TO_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Target value used to replace a source value in a layout field.
6	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N