GPBR_LAYOUT_FLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPBR_LAYOUT_ID	Character(15)	VARCHAR2(15) NOT NULL	Layout identificator.
2	GPBR_ROW_SEQUENCE	Number(3,0)	SMALLINT NOT NULL	Row sequence in the layout.
3	GPBR_FLD_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Field sequence in a given row and layout.
4	GPBR_QRY_ALIAS	Character(1)	VARCHAR2(1) NOT NULL	Query alias linked to the field
5	GPBR_FIELD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Unique field name used in query definition, includes alias table.
6	GPBR_QRY_FLD_SEQ	Number(4,0)	SMALLINT NOT NULL	Query field sequence, maps the sequence of the columns in the query.
7	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: GPBR_LAYOUT_FLD.DESCR50
9	GPBR_FIELD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Field Type 0=Character 1=Long Char 2=Numeric 3=Signed Number 4=Date 5=Time 6=Date Time 7=Image Default Value: 0
10	GPBR_BREAK_DATA	Character(1)	VARCHAR2(1) NOT NULL	Indicates if agent count has to be triggered. Y/N Table Edit Default Value: N
11	GPBR_START_POSN	Number(3,0)	SMALLINT NOT NULL	Field start position in the row.
12	GPBR_FIELD_LENGTH	Number(3,0)	SMALLINT NOT NULL	Stores the field length used in the layout.
13	GPBR_DECIMALS	Number(2,0)	SMALLINT NOT NULL	Stores the number of decimals to be displayed in the format.
14	GPBR_FIELD_VALUE	Character(1)	VARCHAR2(1) NOT NULL	Defines the field source value, which may be from the field data, user default, conversion or an agent. A=Agent Value C=Conversion D=User Default S=Field Data
15	GPBR_DEFAULT_VALUE	Character(100)	VARCHAR2(100) NOT NULL	Stores the default value for a field, this field is related with field value.
16	GPBR_DATE_FORMAT	Character(2)	VARCHAR2(2) NOT NULL	Field to store date format based on DD for day, MM for month, YYYY for year. 01=DDMMYY 02=DDMMYYYY 03=DDMMMYY 04=DDMMMYYYY 05=MMDDYY 06=MMDDYYYY 07=MMMDDYY 08=MMMDDYYYY 09=YYMMDD 10=YYMMMDD 11=YYYYMMDD 12=YYYYMMMDD Default Value: 02
17	GPBR_TIME_FORMAT	Character(2)	VARCHAR2(2) NOT NULL	Field to store date format based on HH for hours MM for minutes, SS for seconds. 01=HHMMSS 02=HHMM Default Value: 01
18	GPBR_DELIMIT_DATE	Character(1)	VARCHAR2(1) NOT NULL	Character used as delimiter in date construction to separate day, month and year.
19	GPBR_PAD_CHAR	Character(1)	VARCHAR2(1) NOT NULL	Pad character used in the layout field
20	GPBR_UPPERCASE	Character(1)	VARCHAR2(1) NOT NULL	Define if characters have to be uppercased Y/N Table Edit Default Value: N
21	GPBR_STRIP_CHARS	Character(10)	VARCHAR2(10) NOT NULL	Characters to be stripped from the field string.
22	GPBR_FIELD_SUPRESS	Character(1)	VARCHAR2(1) NOT NULL	Used to store if a field has to be suppresed and not used to write in the layout. Y/N Table Edit Default Value: N
23	GPBR_TRIM_SPACES	Character(1)	VARCHAR2(1) NOT NULL	Defines if spaces will be trimed in field layout. Y/N Table Edit Default Value: N
24	GPBR_FIELD_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Field source Q=From Query U=From User Default Value: U
25	GPBR_AGENT_VALUE	Character(2)	VARCHAR2(2) NOT NULL	Stores the agent value to be applied. 01=Get Sum Field 02=Get Count Field 03=Get Current Date 04=Get Current Time
26	GPBR_AGENT_FIELD	Character(30)	VARCHAR2(30) NOT NULL	Unique field name used in query definition, includes alias table. Prompt Table: GPBR_AGENTS_VW
27	GPBR_AGENT_COUNT	Character(1)	VARCHAR2(1) NOT NULL	Indicates if agent count has to be triggered. Y/N Table Edit Default Value: N
28	GPBR_AGENT_SUM	Character(1)	VARCHAR2(1) NOT NULL	Indicates if agent sum has to be triggered. Y/N Table Edit Default Value: N
29	GPBR_AGENT_RST_VAL	Character(1)	VARCHAR2(1) NOT NULL	Indicates if agent count has to be triggered. Y/N Table Edit Default Value: N
30	GPBR_ALIGNMENT	Character(1)	VARCHAR2(1) NOT NULL	Used to keep the alignment value C=Center L=Left R=Right Default Value: L