RT_RATE_TERM_VW(SQL View) | 
Index Back | 
|---|---|
View For Term In Rate Table | 
| select distinct term from ps_rt_rate_tbl a, ps_rt_index_tbl b where a.rt_rate_index =b.rt_rate_index and b.rt_category <> '10' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(5,0) | INTEGER NOT NULL | Term |