GTAS_CF_EXCEP

(SQL Table)
 Index Back

GTAS Attribute Exceptions

Used in GTAS Attribute Exceptions page

  • Parent Record Of GTAS_CF_EXCEP1 GTAS_EXCEP_AET

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

    2 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

    Prompt Table: GL_ACCOUNT_TBL
    Set Control Field: BUSINESS_UNIT

    3 CF_ATTRIBUTE Character(15) VARCHAR2(15) NOT NULL ChartField Attribute

    Prompt Table: GTAS_ATTR_VW

    4 CF_ATTRIB_VALUE Character(20) VARCHAR2(20) NOT NULL ChartField Attribute Value

    Prompt Table: GTAS_ATTR_VALUE

    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 PRIORITY_ORDER Number(5,0) INTEGER NOT NULL Priority Order for Schedules
    7 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive