EQTXIDEXESECLN(SQL View) |
Index Back |
---|---|
Equation Id (name) Execute VwEquation Id (name) Execute Authority Security Search Vw |
SELECT A.EQTN_ID_AUTH_CLASS ,A.EQUATION_NAME ,B.LANGUAGE_CD ,B.DESCR FROM PS_EQTN_ID_NAMAUTH A , PS_EQTNNAMEVWLNG B WHERE A.EQTN_AUTH_LEVEL IN ('E', 'R', 'W') AND A.EQUATION_NAME = B.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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |