COMPANYESTABIDESTB_DSN_VW_FRA(SQL View) |
Index Back |
|---|---|
Etablishment View (Company)This view retrieves the establishments associated to a gien company |
| SELECT A.COMPANY , A.ESTABID FROM PS_ESTAB_COMP_VW A WHERE ( A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ESTAB_COMP_VW A_ED WHERE A.COMPANY = A_ED.COMPANY AND A.ESTABID = A_ED.ESTABID AND A_ED.EFFDT <= %CurrentDateIn)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |