GPBR_LAYAGE_WRK (SQL Table)	Index Back
Agents values work table Agents values work table

GPBR_LAYAGE_WRK

(SQL Table)

Agents values work table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 GPBR_KEY_ORDER Character(30) VARCHAR2(30) NOT NULL Used to keep the output row order in EFT Brazil. file generation.

3 GPBR_AGENT_FIELD Character(30) VARCHAR2(30) NOT NULL Unique field name used in query definition, includes alias table.

4 GPBR_COMP_VAL_PREV Number(18,2) DECIMAL(17,2) NOT NULL Previous Competency Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPBR_KEY_ORDER	Character(30)	VARCHAR2(30) NOT NULL	Used to keep the output row order in EFT Brazil. file generation.
3	GPBR_AGENT_FIELD	Character(30)	VARCHAR2(30) NOT NULL	Unique field name used in query definition, includes alias table.
4	GPBR_COMP_VAL_PREV	Number(18,2)	DECIMAL(17,2) NOT NULL	Previous Competency Value