ESTABIDEFFDTDefault Value: %date
EST_RAIS_WV_BRA(SQL View) |
Index Back |
|---|---|
RAIS Centralizer Prompt ViewRAIS Centralizer Prompt View |
| SELECT E.ESTABID , E.EFFDT , E.DESCR FROM PS_ESTAB_TBL E , PS_ESTAB_TBL_BRA B WHERE E.COUNTRY = 'BRA' AND E.EFF_STATUS = 'A' AND B.ESTABID = E.ESTABID AND B.EFFDT = E.EFFDT AND B.RAIS_CENTR_IND_BRA = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |