GPBR_SEFIP_G_WA

(SQL Table)
Index Back

Sefip Guide Writable Array

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 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

9 ABS_BGN_DT Date(10) DATE NOT NULL Absence Begin Date

Default Value: %date

10 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
11 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
12 PRD_BGN_DT Date(10) DATE Period Begin Date
13 PRD_END_DT Date(10) DATE Pay Period End Date
14 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
15 GPBR_PROCESS_ID Number(11,0) DECIMAL(11) NOT NULL Process Number ID