RBF_APPFORM_TMP

(SQL Table)
Index Back

Application Form Templates

CRM Common Object Application Form Tamplate Table

# 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 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

Prompt Table: PSMSGNODEDEFN

5 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: RC_MENUNAME_VW

6 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

Prompt Table: RC_BARNAME_VW

7 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

Prompt Table: RC_ITEMNAME_VW

8 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name

Prompt Table: RC_PAGENAME_VW

9 FORM_LOAD_EVENT Character(20) VARCHAR2(20) NOT NULL Application Form Load Event

Prompt Table: RC_BS_ACTIONSET

10 FORM_UNLOAD_EVENT Character(20) VARCHAR2(20) NOT NULL Form Unload Event

Prompt Table: RC_BS_ACTIONSET

11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
15 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.
16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time