COMPANYGPBR_ES_CMP_VW(SQL View) |
Index Back |
|---|---|
eSocail Company HQ VieweSocail Company HQ View |
| SELECT a.company , a.descr FROM ps_estab_tbl a , PS_ESTAB_TBL_BRA b WHERE a.country = 'BRA' AND a.HQUNIT = 'Y' AND b.OTHER_SECTORS_BRA = '2' AND a.effdt = ( SELECT MAX(effdt) FROM ps_estab_tbl WHERE estabid = a.estabid AND country = a.country AND effdt <= %CurrentDateIn) AND b.estabid = a.estabid AND b.effdt = a.effdt |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |