COMPANYWPLACE_LOC_BRA1=Employer Establishment
2=Service Taker Establishment
3=Third Party Establishment
WPLACE_CODE_BRAEFFDTESTABIDPrompt Table: ESTAB_COMP_VW
WPL_EST2_VW_BRA(SQL View) |
Index Back |
|---|---|
Worplace Establishment Tbl BRAWorkplace establishments setup table BRA. |
| SELECT DISTINCT A.COMPANY ,A.WPLACE_LOC_BRA ,A.WPLACE_CODE_BRA ,A.EFFDT ,A.ESTABID ,B.DESCR FROM PS_WPL_SRV_TKR_BRA A , PS_ESTAB_TBL B WHERE A.ESTABID = B.ESTABID AND A.COMPANY = B.COMPANY AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_ESTAB_TBL B2 WHERE B2.ESTABID = B.ESTABID AND B2.EFFDT <= A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | WPLACE_LOC_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Worplace location.
1=Employer Establishment 2=Service Taker Establishment 3=Third Party Establishment |
| 3 | WPLACE_CODE_BRA |
Character(10) | VARCHAR2(10) NOT NULL | Workplace code. |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_COMP_VW |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |