GPBR_JOBDAT_TMP

(SQL Table)
Index Back

Temp Job Data MANAD

Temp Job Data - Purpose : Used in MANAD Report

# 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 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
5 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
8 SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 CBO_CD_BRA Character(7) VARCHAR2(7) NOT NULL Occupation Code for Brazil
10 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