EQTN_ID_AUTH_CLASSEQUATION_NAMESSF_TUTEQTNS_VW(SQL View) |
Index Back |
|---|---|
SF Tuit Calc Eqtn Select VwView of Equations that can be used by Student Admin Student Financials Tuition Calculation that return an A_SELECT value. |
| SELECT B.EQTN_ID_AUTH_CLASS ,A.EQUATION_NAME ,B.DESCR FROM PS_SCC_APPL_PRMPT A , PS_EQTX_ID_EXE_SEC B WHERE A.SCC_APPL_PROMPT_ID IN (9, 72) AND B.EQUATION_NAME = A.EQUATION_NAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EQTN_ID_AUTH_CLASS |
Character(30) | VARCHAR2(30) NOT NULL | Equation Id Auth Class |
| 2 | EQUATION_NAME |
Character(12) | VARCHAR2(12) NOT NULL | Equation Name |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |