GPBR_PYEST_PARM(SQL Table) |
Index Back |
|---|---|
Payee ParametersPayee Parameters for Brazil. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | BGN_DT |
Date(10) | DATE NOT NULL |
Begin Date
Default Value: %date |
| 4 | END_DT | Date(10) | DATE | end date |
| 5 | GPBR_PREGNT_DATE | Date(10) | DATE | Pregnant Date for Termination Calculation |
| 6 | GPBR_UNIONIZED_EMP | Number(1,0) | SMALLINT NOT NULL |
Unionized Payee
1/0 Table Edit (1=True, 0=False) Default Value: 0 |
| 7 | GPBR_CIPA_TITLE | Number(1,0) | SMALLINT NOT NULL |
Cipa's Titleholder/Substitute
1/0 Table Edit (1=True, 0=False) Default Value: 0 |
| 8 | GPBR_COOP_MANGR | Number(1,0) | SMALLINT NOT NULL |
Cooperative Society Mgr.
1/0 Table Edit (1=True, 0=False) Default Value: 0 |
| 9 | GPBR_MEMBER_FGTS | Number(1,0) | SMALLINT NOT NULL |
FGTS Board Member
1/0 Table Edit (1=True, 0=False) |
| 10 | GPBR_CNPS_MEMBER | Number(1,0) | SMALLINT NOT NULL |
CNPS Board Member
1/0 Table Edit (1=True, 0=False) Default Value: 0 |
| 11 | GPBR_PREV_SET_COM | Number(1,0) | SMALLINT NOT NULL |
Prev.Settlement Committee Member
1/0 Table Edit (1=True, 0=False) Default Value: 0 |
| 12 | ACTIVEFLAG | Number(1,0) | SMALLINT NOT NULL | Index Active |
| 13 | GPBR_FGTS_DONE | Number(1,0) | SMALLINT NOT NULL |
FGTS Gathering Done
1/0 Table Edit (1=True, 0=False) Default Value: 0 |
| 14 | GPBR_FGTS_CD | Number(2,0) | SMALLINT NOT NULL | FGTS Code |
| 15 | GPBR_TERM_INFO | Long Character(255) | VARCHAR2(255) | Termination Information Brazil |