| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 4 |
GPBR_START_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Start Month
|
| 5 |
GPBR_END_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
End Year
|
| 6 |
GPBR_GATHERING_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Gathering Code
115=115 - FGTS Pay & Info to INSS
130=130 - Alone Worker
135=135 - Alone Worker
145=145 - Collect FGTS Differences
150=150 - Service Supplier
155=155 - Civil Construction
640=640 - Non Opting Employee
650=650 - Labor Collect. Law/Disp
660=660 - Collect FGTS on Amnesty
904=904 - INSS Decl. of Labor Disp
905=905 - INSS Declaration
907=907 - INSS Decl of Serv Inst.
908=908 - INSS Decl of Civil Const
911=911 - INSS Decl Work Cooperat.
N/A=Not Available
Default Value: N/A
|
| 7 |
GPBR_FGTS_GATHER |
Character(1) |
VARCHAR2(1) NOT NULL |
FGTS Gather Indicator
1=1 GRF On Time
2=2 GRF Delayed
3=3 GRF Delayed - Fiscal Action
5=5 Individualization
6=6 Individlztn - Fiscal Action
|
| 8 |
GPBR_FGTS_DT |
Date(10) |
DATE |
FGTS Date
|
| 9 |
GPBR_GPS_GATHER_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
GPS Gather Code
1=1 GPS On Time
2=2 GPS Delayed
3=3 Does not generate GPS
|
| 10 |
GPBR_GPS_DT |
Date(10) |
DATE |
GPS Gather Date
|
| 11 |
GPBR_INDEX_NUMBER |
Character(7) |
VARCHAR2(7) NOT NULL |
Correction Index
|
| 12 |
GPBR_FILE_MODE |
Character(2) |
VARCHAR2(2) NOT NULL |
File mode used by SEFIP
0=FGTS Payment/Declare Welfare
1=1 FGTS/Welfare Declaration
7=7 FGTS/Welfare Pmnt Correction
8=8 FGTS/Welfare Dec. Correction
9=9 Previous Data Confirmation
Default Value: 0
|
| 13 |
GPBR_LIST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
List Option
Brazil Run Control
1=All Establishments & Employees
2=Select Establishment ID
3=Select Employees
4=Select Group ID
5=Select Pay Group
6=All Employees
7=Select Department ID
Default Value: 6
|
| 14 |
GPBR_EXCLUDE_FLG1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Flag 1
Run Control Vacation Receipt Brazil
Y/N Table Edit
Default Value: N
|
| 15 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table:
GB_GROUP_TBL
|
| 16 |
GPBR_INC_ADM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to define if administrative employees have to be included in SEFIP report.
Y/N Table Edit
Default Value: N
|
| 17 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table:
GP_RUN_TYPE_VW
|
| 18 |
UNION_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Union Code
Prompt Table:
GPBR_UNIONS_VW
|
| 19 |
GPBR_INC_AUT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to identify if autonomous are going to be included.
Y/N Table Edit
Default Value: N
|
| 20 |
GPBR_PRC_ST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to identify if Service Taker structure is going to be used.
Y/N Table Edit
Default Value: N
|