GPBR_LBR_PRC_CH(SQL Table) |
Index Back |
---|---|
Labor Proceedings Chg CategoryLabor Proceedings - Employee Category Changed. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPBR_COMPBRA_VW |
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 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
6 | DECIS_DATE_BRA | Date(10) | DATE | Desicion Date Legal Proceedings table |
7 | GPBR_LABOR_CAT_CD | Character(3) | VARCHAR2(3) NOT NULL |
eSocial Labor Category Legal Code
Prompt Table: GPBR_LCAT_CD_VW |
8 | GPBR_NAT_ACTV | Character(1) | VARCHAR2(1) NOT NULL |
eSocial Nature of Activity
0=Not Applicable 1=URBAN 2=RURAL |