| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: BRA
Prompt Table:
COUNTRY_TBL
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
RELATIONSHIP |
Character(2) |
VARCHAR2(2) NOT NULL |
Relationship to Employee
|
| 4 |
GPBR_DEP_TYPE_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
eSocial Dependent Type Legal Code
00=Not Applicable
01=Spouse
02=Partner with Chilldren/<5 yrs
03=Child/StepChild
04=Child/StepChild Univ. Student
04=Child/StepChild Univ. Student
06=Siblings/GrandChild
07=Siblings/Grandchild Univ.Stdnt
07=Siblings/Grandchild Univ.Stdnt
09=Parents/Grand/GreatGra Parents
10=Poor Minors
11=Disabled Person with Guardian
12=Ex Spouse
99=Aggregate / Others
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
GPBR_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Student
Y/N Table Edit
Default Value: N
|
| 7 |
GPBR_AGE_1 |
Number(2,0) |
SMALLINT NOT NULL |
eSocial - Older than Age - field used for Dependents information.
|
| 8 |
GPBR_AGE_2 |
Number(2,0) |
SMALLINT NOT NULL |
eSocial - Younger than Age - field used for Dependents information.
|