INTERUNIT_BUCATEGORYIU_CATEGORY_VW(SQL View) |
Index Back |
|---|---|
Category InterUnit Viewselect %substring(b.setcntrlvalue,1,5), a.category, a.descr from ps_category_tbl a, ps_set_cntrl_rec b where a.effdt = (select max(effdt) from ps_category_tbl where a.setid = setid and a.category = category and effdt <= %currentdatein) and a.eff_status = 'A' and a.setid = b.setid and b.recname = 'CATEGORY_TBL' |
| select %substring(b.setcntrlvalue,1,5), a.category, a.descr from PS_CATEGORY_TBL a, ps_set_cntrl_rec b where a.effdt = (select max(effdt) from PS_CATEGORY_TBL where a.setid = setid and a.category = category and effdt <= %currentdatein) and a.eff_status = 'A' and a.setid = b.setid and b.recname = 'CATEGORY_TBL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTERUNIT_BU |
Character(5) | VARCHAR2(5) NOT NULL | InterUnit Business Unit |
| 2 | CATEGORY |
Character(5) | VARCHAR2(5) NOT NULL | Asset Category |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |