GPS_ACTION_TBL

(SQL Table)
 Index Back

GPS ACTION Setup Table

Contains all the ACTIONS that are possible to be applied to a post plan in planning or administration phase If the row is defined as SYSTEM_DATA then the user can only change the EFF_STATUS and the DESCR, DESCRSHORT. Customers can add their own Actions.

  • Related Language Record: GPS_ACTNTBL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPS_ACTION Character(8) VARCHAR2(8) NOT NULL Action as executed on GPS Post
    2 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 GPS_ACTION_STATUS Character(30) VARCHAR2(30) NOT NULL Action Status
    6 GPS_AVAILABILITY Character(1) VARCHAR2(1) NOT NULL defines availability in phases
    A=in Administration
    B=in Planning
    C=in All Phases
    D=in All Phases Show via Goto
    E=in Clean Up and Administration
    U=Not Used
    7 GPS_GOTO_DISPLAY Character(1) VARCHAR2(1) NOT NULL Indicates whether the action will be displayed in GoTo list
    M=On Main Transaction Page
    N=None
    R=On Post Request Page

    Default Value: N

    8 EOEC_CLASSPATH Character(254) VARCHAR2(254) NOT NULL The classpath of the application class
    9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %datetime

    10 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    11 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: Y