COMPANYGPBR_PROC_SOURCE1=Judicial
2=Submitted to CCP or NINTER
GPBR_PROC_NUMGPBR_CPF_IDEMPLIDNATIONAL_ID01=default
Prompt Table: DEPENDENT_VW
GPBR_LBR_PROC_D(SQL Table) |
Index Back |
|---|---|
Labor Proceedings DependentsLabor Proceedings - Employee Dependent Details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPBR_PROC_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Proceeding Source.
1=Judicial 2=Submitted to CCP or NINTER |
| 3 | GPBR_PROC_NUM |
Character(30) | VARCHAR2(30) NOT NULL | Proceeding Number |
| 4 | GPBR_CPF_ID |
Character(11) | VARCHAR2(11) NOT NULL | eSocial National ID Number |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | NATIONAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 7 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 8 | RELATIONSHIP | Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |
| 9 | GPBR_DESCR1 | Character(35) | VARCHAR2(35) NOT NULL | eSocial Events Monitor - generic description. |
| 10 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEPENDENT_VW |