GPBR_USTE_TBL(SQL Table) |
Index Back |
|---|---|
Work record for app engineGPBR_UEST_AE app engine Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPBR_SERVICE_TAKER |
Character(3) | VARCHAR2(3) NOT NULL |
Service Taker
Prompt Table: GPBR_SERV_TAKER |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: GPBR_ESTAB2_VW |
| 5 | TP_SERV_TAKER_BRA | Character(2) | VARCHAR2(2) NOT NULL |
Service Taker Type
04=Legal Entity 05=ST-Temp Work- Replace of Staff 06=ST-Temp Work- Contingent Work Default Value: 04 |
| 6 | TP_OWNER_BRA | Character(1) | VARCHAR2(1) NOT NULL |
CNO Owner
0=Not Applicable 1=Estab 2=Service Taker 3=Other CNPJ 4=Other CPF Default Value: 0 |
| 7 | OWNER_INSCR_BRA | Character(14) | VARCHAR2(14) NOT NULL | CNPJ of the CNO Owner's |
| 8 | GPBR_CNTRCT_BGN_DT | Date(10) | DATE NOT NULL | Contract Begin Date for Service Takers Bra |
| 9 | GPBR_VAL_DT | Date(10) | DATE | Date Value |