GTAS_EXCEP_AET

(SQL Table)
 Index Back

GTAS Attribute Exceptions

Used in GTAS Attribute Exceptions page

  • Parent record: GTAS_CF_EXCEP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL
    Set Control Field: BUSINESS_UNIT

    4 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
    5 CF_ATTRIBUTE Character(15) VARCHAR2(15) NOT NULL ChartField Attribute
    6 CF_ATTRIB_VALUE Character(20) VARCHAR2(20) NOT NULL ChartField Attribute Value
    7 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    8 PRIORITY_ORDER Number(5,0) INTEGER NOT NULL Priority Order for Schedules
    9 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

    Prompt Table: OPER_UNIT_TBL

    10 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

    Prompt Table: PRODUCT_TBL

    11 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

    Prompt Table: FUND_TBL

    12 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

    Prompt Table: CLASS_CF_TBL

    13 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

    Prompt Table: PROGRAM_TBL

    14 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

    Prompt Table: BUD_REF_TBL

    15 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

    Prompt Table: AFFILIATE_VW

    16 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

    Prompt Table: %EDIT_INTRA01

    17 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

    Prompt Table: %EDIT_INTRA02

    18 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

    Prompt Table: CHARTFIELD1_TBL

    19 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

    Prompt Table: CHARTFIELD2_TBL

    20 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

    Prompt Table: CHARTFIELD3_TBL

    21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_ALL_VW

    22 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: PROJECT_ALL_VW

    23 GTAS_BEGIN_END Character(1) VARCHAR2(1) NOT NULL Beginning/Ending Bal Indicator
    B=Beginning Balances
    E=Ending Balances
    24 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause
    25 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
    26 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
    27 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    28 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).