RDM_MOBILE_DFLT

(SQL Table)
 Index Back

Mobile Customer Options

This record is used for Mobile Customer Options

  • Related Language Record: RDM_MOBIL_LDFLT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MOBILE_DEFAULT_ID Character(5) VARCHAR2(5) NOT NULL MOBILE_DEFAULT_ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID2_NONVW

    4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: INSTALLATION.COUNTRY

    Prompt Table: COUNTRY_TBL

    5 RELATIONSHIP_VIEW Character(1) VARCHAR2(1) NOT NULL RELATIONSHIP_VIEW

    Y/N Table Edit

    Default Value: Y

    6 SPIDER_OUT_REL Character(1) VARCHAR2(1) NOT NULL Flag in setup for spider out relationship (mobile).

    Y/N Table Edit

    Default Value: N

    7 ALLOW_TRANSFER_REL Character(1) VARCHAR2(1) NOT NULL Allow Transfer From Rel. View

    Y/N Table Edit

    Default Value: Y

    8 THREE_SIXTY_VIEW Character(1) VARCHAR2(1) NOT NULL THREE_SIXTY_VIEW

    Y/N Table Edit

    Default Value: Y

    9 CM_PURP_TYPE_ADDR Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration

    Prompt Table: CM_PURP_ADR_VW

    10 ALLOW_TRANSFER_360 Character(1) VARCHAR2(1) NOT NULL Allow Transfer From 360 View

    Y/N Table Edit

    Default Value: Y

    11 CM_PURP_TYPE_MAIL Number(6,0) INTEGER NOT NULL CP Purp Type Mail

    Prompt Table: CM_PURP_EML_VW

    12 CM_PURP_TYPE_PAGE Number(6,0) INTEGER NOT NULL CP Purp Type Page

    Prompt Table: CM_PURP_PAG_VW

    13 CM_PURP_TYPE_PHON Number(6,0) INTEGER NOT NULL Used by PIM_PREFERENCE for PIM Configuration

    Prompt Table: CM_PURP_PHN_VW

    14 BILL_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Bill To customer.

    Y/N Table Edit

    Default Value: N

    15 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL A flag indicating that the customer or address is a valid Ship To customer or address.

    Y/N Table Edit

    Default Value: N

    16 SOLD_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Sold To customer.

    Y/N Table Edit

    Default Value: N

    17 ADD_ACTION Character(4) VARCHAR2(4) NOT NULL Default Action for Adding Person
    4=Go to New Worker Record
    8=Go to New Contact Record
    88=Go to New POI Record
    9=Go to New Consumer Record

    Default Value: 8

    18 VIEW_ACTION Character(4) VARCHAR2(4) NOT NULL Default action for viewing Person if the Person has multiple application roles, such as Contact, Consumer, or Worker.
    4=View worker details
    8=View contact details
    88=View POI details
    9=View consumer details

    Default Value: 8

    19 READONLY Character(1) VARCHAR2(1) NOT NULL Read Only

    Default Value: N

    20 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    21 SYSD_APPLICATION01 Character(1) VARCHAR2(1) NOT NULL PS CRM Core
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    22 SYSD_APPLICATION02 Character(1) VARCHAR2(1) NOT NULL Financial Services
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    23 SYSD_APPLICATION03 Character(1) VARCHAR2(1) NOT NULL Telecommunications
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    24 SYSD_APPLICATION04 Character(1) VARCHAR2(1) NOT NULL Government
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    25 SYSD_APPLICATION05 Character(1) VARCHAR2(1) NOT NULL Energy
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    26 SYSD_APPLICATION06 Character(1) VARCHAR2(1) NOT NULL Insurance
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    27 SYSD_APPLICATION07 Character(1) VARCHAR2(1) NOT NULL High Technology
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    28 SYSD_APPLICATION08 Character(1) VARCHAR2(1) NOT NULL HR HelpDesk
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    29 SYSD_APPLICATION09 Character(1) VARCHAR2(1) NOT NULL System Data Field for Application 9. Application 9 is used for Wealth Management.
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    30 SYSD_APPLICATION10 Character(1) VARCHAR2(1) NOT NULL Used in Application 10
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

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