GPBR_DIRF_WRK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
5	PYMT_DT	Date(10)	DATE NOT NULL	Payment Date
6	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
7	RSLT_REV_NUM	Number(4,0)	SMALLINT NOT NULL	Result Revision Number
8	RSLT_VER_NUM	Number(4,0)	SMALLINT NOT NULL	Result Version Number
9	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
10	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
11	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
12	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
13	SEFIP_CATEGORY_BRA	Character(2)	VARCHAR2(2) NOT NULL	SEFIP CATEGORY Brazil 01=Employee 02=Temporary Worker 03=Worker w/FGTS benefit w/o link 04=Limited Period Employee 05=Director not employed w/FGTS 07=Underaged Intern 11=Director not employed w/o FGTS 12=Other Public Agents 13=Self-empl w/payment withholdng 14=Selfempl w/base-sal withholdng 15=Ind. transporter w/contr compe 16=Ind. transporter w/contr salar 17=Coop worker, Service Provider 18=Freight Coop, service provider 19=Political Agent 20=Non-permanent Governmnt Worker 21=Permanent Government Worker 22=Not Applicable Default Value: 22
14	GPBR_LEG_EMPL_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Employee Legal Type