ERE_ID_ESPCOMPANYESTABIDPrompt Table: ESTAB_TBL
ERE_ESTB_ESP_VW(SQL View) |
Index Back |
|---|---|
ERE EstablishmentCompany establishments affected by an ERE |
| SELECT B.ERE_ID_ESP , B.COMPANY , B.ESTABID , A.DESCR , A.STATE , C.AUTONOM_REG_ESP , MAX(C.DESCR50) , COUNT(DISTINCT B.EMPLID) FROM PS_ERE_EE_VW_ESP B , PS_ESTAB_TBL A , PS_AUTRG_ST_ESP_VW C WHERE A.ESTABID = B.ESTABID AND %EffdtCheck(ESTAB_TBL, A, %CurrentDateIn) AND A.STATE = C.STATE GROUP BY B.ERE_ID_ESP , B.COMPANY , B.ESTABID , A.DESCR, A.STATE, C.AUTONOM_REG_ESP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERE_ID_ESP |
Character(10) | VARCHAR2(10) NOT NULL | ERE ID |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 6 | AUTONOM_REG_ESP | Character(2) | VARCHAR2(2) NOT NULL | Autonomous community id |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 8 | EMPL_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Employee Count |