COMPANYPrompt Table: COMPANY_TBL
GPBR_ESTAB_RESPGPBR_EST_RES_VW(SQL View) |
Index Back |
|---|---|
Establishment ResponsibleEstablishment Responsible by Company & Effdt |
| SELECT COMPANY , A.ESTABID , A.DESCR FROM PS_ESTAB_TBL A , PS_ESTAB_ID_BRA B WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ESTAB_TBL WHERE COMPANY = A.COMPANY AND ESTABID = A.ESTABID) AND B.ESTABID = A.ESTABID AND B.EFFDT = A.EFFDT AND B.COUNTRY = 'BRA' AND B.ESTAB_ID_TYPE_BRA = 'CNPJ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | GPBR_ESTAB_RESP |
Character(12) | VARCHAR2(12) NOT NULL | Establishment Responsible |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |