EQTN_APPLID_TBL

(SQL Table)
 Index Back

Equation AE Application Table

Equation AE Application Table

  • Related Language Record: EQTN_APPLID_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQTN_OPERAND_APPL Character(8) VARCHAR2(8) NOT NULL Equation App Engine Applid
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 SCC_DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type code indicates whether a row of data is system data, demo data, or customer data.
    C=Customer Data
    D=Demonstration Data
    S=System Data

    Default Value: C

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 AE_PRODUCT Character(2) VARCHAR2(2) NOT NULL Product
    AE=PS/AE
    AM=PS/AM
    AP=PS/AP
    AR=PS/AR
    BI=PS/BI
    EO=PS/EO
    EX=PS/EX
    FS=PS/FS
    GL=PS/GL
    HR=PS/HR
    IN=PS/IN
    OM=PS/OM
    PC=PS/PC
    PO=PS/PO
    TR=PS/TR
    7 AE_APPL_ID Character(8) VARCHAR2(8) NOT NULL Application

    Prompt Table: AE_APPL_TBL