EQUATION_NAMESF_EQTN_SRCH(SQL View) |
Index Back |
|---|---|
Equation Name search record |
| select a.equation_name ,a.descr from PS_SF_PKG_EQTN_TBL a where a.effdt = (select max(b.effdt) from PS_SF_PKG_EQTN_TBL b where b.equation_name = a.equation_name) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EQUATION_NAME |
Character(12) | VARCHAR2(12) NOT NULL | Equation Name |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |