GPBR_DRIVER_SEQGPBR_DRV_SPLIT_SEQCOMPANYPrompt Table: GPBR_COMPBRA_VW
GPBR_PROC_SOURCE1=Judicial
2=Submitted to CCP or NINTER
GPBR_PROC_NUMGPBR_CPF_IDSEQNBRGPBR_YEAR_CDGPBR_STG_LBALVW(SQL View) |
Index Back |
|---|---|
Salary Allowance - Stg Rec ViwSalary Allowance - Staging record view. |
| SELECT LBALLW.GPBR_DRIVER_SEQ , LBALLW.GPBR_DRV_SPLIT_SEQ , LBALLW.COMPANY , LBALLW.GPBR_PROC_SOURCE , LBALLW.GPBR_PROC_NUM , LBALLW.GPBR_CPF_ID , LBALLW.SEQNBR , LBALLW.GPBR_YEAR_CD FROM %TABLE(GPBR_STG_LBALLW) LBALLW , %Table(GPBR_DRIVER_DAT) DRV WHERE LBALLW.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LBALLW.GPBR_DRV_SPLIT_SEQ = DRV.GPBR_DRV_SPLIT_SEQ AND DRV.GPBR_STATUS = 'XRDY' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPBR_DRIVER_SEQ |
Number(30,0) | DECIMAL(30) NOT NULL | Driver Sequence |
| 2 | GPBR_DRV_SPLIT_SEQ |
Number(20,0) | DECIMAL(20) NOT NULL | eSocial - Split Sequence |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GPBR_COMPBRA_VW |
| 4 | GPBR_PROC_SOURCE |
Character(1) | VARCHAR2(1) NOT NULL |
Proceeding Source.
1=Judicial 2=Submitted to CCP or NINTER |
| 5 | GPBR_PROC_NUM |
Character(30) | VARCHAR2(30) NOT NULL | Proceeding Number |
| 6 | GPBR_CPF_ID |
Character(11) | VARCHAR2(11) NOT NULL | eSocial National ID Number |
| 7 | SEQNBR |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 8 | GPBR_YEAR_CD |
Character(4) | VARCHAR2(4) NOT NULL | Calendar Year |