GPBR_SEFIP_G_WA(SQL Table) |
Index Back |
---|---|
Sefip Guide Writable ArrayWritable Array SEFIP Guide |
# | 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 Record |
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. Agreement 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 |