RBF_APPFORM_NAV

(SQL Table)
Index Back

Page Navigation Table

Page Navigation Table

  • Related Language Record: RBF_APP_PG_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 FORM_ID Character(15) VARCHAR2(15) NOT NULL The unique identifier of App form
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    5 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name

    Prompt Table: RC_PAGENAME_VW

    6 NAVIGATED_PAGE_FLG Character(1) VARCHAR2(1) NOT NULL Indicate whether page is navigated on

    Y/N Table Edit

    Default Value: Y

    7 PAGE_TITLE Character(50) VARCHAR2(50) NOT NULL This field is used for page title (50 characters).
    8 TOOLBAR_FLG Character(1) VARCHAR2(1) NOT NULL Used in Application Form Toolbar

    Y/N Table Edit

    Default Value: N

    9 TOOLBAR_ITEM_LABEL Character(20) VARCHAR2(20) NOT NULL Application form Toolabr item label
    10 PAGE_LOAD_EVENT Character(20) VARCHAR2(20) NOT NULL Page Load Event

    Prompt Table: RC_BS_ACTIONSET

    11 PAGE_UNLOAD_EVENT Character(20) VARCHAR2(20) NOT NULL Page exit event

    Prompt Table: RC_BS_ACTIONSET

    12 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    13 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    14 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    15 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    16 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    17 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time