IU_COST_TYPE_VW

(SQL View)
 Index Back

Cost Type InterUnit View

select %substring(b.setcntrlvalue,1,5), a.cost_type, a.descr from ps_cost_type_tbl a, ps_set_cntrl_rec b where a.effdt = (select max(effdt) from ps_cost_type_tbl where a.setid = setid and a.cost_type = cost_type and effdt <= %currentdatein) and a.eff_status = 'A' and a.setid = b.setid and b.recname = 'COST_TYPE_TBL'

select %substring(b.setcntrlvalue,1,5), a.cost_type, a.descr from PS_COST_TYPE_TBL a, ps_set_cntrl_rec b where a.effdt = (select max(effdt) from PS_COST_TYPE_TBL where a.setid = setid and a.cost_type = cost_type and effdt <= %currentdatein) and a.eff_status = 'A' and a.setid = b.setid and b.recname = 'COST_TYPE_TBL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTERUNIT_BU Character(5) VARCHAR2(5) NOT NULL InterUnit Business Unit
2 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description