TL_SQL_TABLES

(SQL Table)
 Index Back

Tables included in a SQL Obj

  • Parent record: TL_SQL_OBJECT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SQL_ID Character(30) VARCHAR2(30) NOT NULL TL

    Prompt Table: TL_SQL_OBJECT

    2 CORR_ID Character(4) VARCHAR2(4) NOT NULL Table Alias - Correlation ID
    A=A
    B=B
    C=C
    D=D
    E=E
    F=F
    G=G
    H=H
    I=I
    J=J

    Default Value: A

    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: TL_WORK_SEL_VW

    4 EFFDT_OPTIONS Character(4) VARCHAR2(4) NOT NULL Effective Date Options
    0=None
    1=Join by Effdt
    2=First Effective Date
    3=Last Effective Date

    Default Value: 0

    5 EFFDT_COND_OPR Character(4) VARCHAR2(4) NOT NULL Conditional Operator
    <=<
    <==<=
    >=>
    >==>=
    6 TL_EFFDT_TYPE Character(1) VARCHAR2(1) NOT NULL Effective Date Type
    0=Current Date
    1=Expression
    7 EXPRESSION_TXT Character(254) VARCHAR2(254) NOT NULL Expression Text