GPBR_MANAD_TMP2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPBR_MAN_ROW_TYPE	Character(4)	VARCHAR2(4) NOT NULL	MANAD Record Type
3	GP_RPT_KEY	Character(22)	VARCHAR2(22) NOT NULL	Output Result Key
4	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
8	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
9	HIRE_DT	Date(10)	DATE	First Start Date
10	TERMINATION_DT	Date(10)	DATE	Termination Date
11	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
12	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
13	GPBR_MAN_TEXT	Character(230)	VARCHAR2(230) NOT NULL	MANAD Text
14	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
15	BIRTHDATE	Date(10)	DATE	Date of Birth
16	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
17	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
18	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
19	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
20	GPBR_SEFIP_RIS_LVL	Character(2)	VARCHAR2(2) NOT NULL	SEFIP risk lever Brazil 00=Default 01=Non Exp.Harmful Agent 02=Exp. Ret. at 15 years 03=Exp. Ret. at 20 years 04=Exp. Ret. at 25 years 05=Non Exp. Harmful Agent M.Jobs 06=Exp. Ret. at 15 years M.Jobs 07=Exp. Ret. at 20 years M.Jobs 08=Exp. Ret. at 25 years M.Jobs 09=Not Applicable
21	GPBR_SERVICE_TAKER	Character(3)	VARCHAR2(3) NOT NULL	Service Taker
22	PYMNT_DT	Date(10)	DATE	Date the payment should be sent to the bank for execution
23	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
24	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
25	GPBR_RUN_TYPE_ID	Character(1)	VARCHAR2(1) NOT NULL	Run Type ID 1=1-Regular Payroll 2=2-13th Salary 3=3-Vacations 4=4-Complementary Payroll 5=5-Complementary 13 Salary 6=6-Other
26	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
27	SLICE_END_DT	Date(10)	DATE	Element Slice End Date