GPBR_JOBDAT_TMP(SQL Table) |
Index Back |
---|---|
Temp Job Data MANADTemp 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 |