EQTN_ID_AUTH_CLASSEQUATION_NAMESFA_ACG_EQ_VW(SQL View) |
Index Back |
|---|---|
ACG Equations ViewView of all ACG equations that can be used by Financial Aid ACG/SMART Eligibility Evaluation process. |
| 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 = 69 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 |