GPBR_ES_LPT_HDR (SQL Table)	Index Back
Labor Proceedings BRA - Header Labor Proceedings BRA - Header

GPBR_ES_LPT_HDR

(SQL Table)

Labor Proceedings BRA - Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPBR_PROC_NUM Character(30) VARCHAR2(30) NOT NULL Proceeding Number
Prompt Table: GPBR_LP_HDR_VW

3 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year

4 GPBR_ESOC_MONTHCD Character(2) VARCHAR2(2) NOT NULL eSocial Competency Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

5 GPBR_COMMENTS Long Character CLOB Comments.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: GPBR_COMPBRA_VW
2	GPBR_PROC_NUM	Character(30)	VARCHAR2(30) NOT NULL	Proceeding Number Prompt Table: GPBR_LP_HDR_VW
3	GPBR_ESOC_YEAR	Number(4,0)	SMALLINT NOT NULL	Competency Year
4	GPBR_ESOC_MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	eSocial Competency Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
5	GPBR_COMMENTS	Long Character	CLOB	Comments.