EQTN_SQ_SQLAUTH

(SQL Table)
Index Back

Equation SQL Appl Auth

Matches SQL to Equation AE Auth Classes.

  • Parent record: EQTN_SQAUTH_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQTN_SQ_AUTH_CLASS Character(30) VARCHAR2(30) NOT NULL Equation SQL Authorization Class.

    Prompt Table: EQTN_SQAUTH_TBL

    2 EQTN_OPERAND_SQL Character(30) VARCHAR2(30) NOT NULL Equation Processor SQL that can be called. This sqlid will dovetail into potential merging with the sqlid field of tools 8.

    Prompt Table: EQTN_SQL_VW

    3 EQTN_AUTH_LEVEL Character(1) VARCHAR2(1) NOT NULL Equation Authorization Level
    E=Execute
    R=Read
    W=Write