ESTABIDGPBR_SEF_EST_VW(SQL View) |
Index Back |
|---|---|
SEFIP Parameters EffdtEffdt Record for SEFIP Parameters |
| SELECT DISTINCT A.ESTABID , A.DESCR FROM PS_ESTAB_TBL A WHERE A.COUNTRY = 'BRA' AND A.EFF_STATUS = 'A' AND A.EFFDT IN ( SELECT MAX(EFFDT) FROM PS_ESTAB_TBL WHERE ESTABID = A.ESTABID AND COUNTRY = A.COUNTRY AND EFF_STATUS =A.EFF_STATUS) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |