RSF_LEAD_VIV

(SQL Table)
 Index Back

Volume Import Verification

This record is a holding table for Leads being imported. This provides the user with an opportunity to verify the Leads moving to the real table RSF_LEAD. Added 4 new fields to import Educational Information

  • Related Language Record: RSF_LEAD_VIV_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 DTTM_IMPORTED DateTime(26) TIMESTAMP Imported Date Time
    3 ROW_NUMBER Number(10,0) DECIMAL(10) NOT NULL Row Number
    4 LEAD_IMP_STATUS Character(2) VARCHAR2(2) NOT NULL Status of the Lead Import
    CD=Not Imported -- Customer Data
    DP=Duplicate
    E1=Failed Edit Checks
    E2=Not Imported -- Errors Found
    IM=Imported
    5 LEAD_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation, this field uniquely identifies a Sales Lead.
    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RSF_NONVW

    7 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: RSF_OPR_TREE_VW

    8 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID

    Prompt Table: RSF_TER_NODE_VW

    9 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

    Prompt Table: RSF_REGION_VW

    10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    11 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer Setid
    12 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

    Default Value: 2

    Prompt Table: RSF_BO_ROLTY_VW

    13 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
    14 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
    15 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
    16 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.
    17 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
    18 LEAD_SOURCE_ID Character(15) VARCHAR2(15) NOT NULL Used by Sales Force Automation to identify the source of a Sales Lead.

    Prompt Table: RSF_LE_SRC_VW

    19 BUSINESS_UNIT_RA Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_RA_NONVW

    20 RA_CAMPAIGN_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.

    Prompt Table: RSF_CAMPAIGN_VW

    21 RA_CMPGN_WAVE_ID Character(15) VARCHAR2(15) NOT NULL Used to uniquely identify a Marketing - Campaign Activity (wave) ID

    Prompt Table: RSF_CMPGN_WA_VW

    22 LEAD_RATING Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to indicate the value (rating) of a lead, i.e. whether it's a Hot Lead or a Cold Lead.

    Prompt Table: RSF_LE_RATE_VW
    Set Control Field: BUSINESS_UNIT

    23 LEAD_TYPE Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to indicate what type of Lead,
    IN=Inquiry
    LE=Lead
    QU=Qualified Lead
    TQ=Turnback Qualified Lead
    TU=Turnback Lead
    24 LEAD_STATUS Character(2) VARCHAR2(2) NOT NULL Used by Sales Force Automation to keep the status of a Sales Lead.
    AC=Accepted
    CD=Closed - Duplicate
    CL=Closed - Won
    CO=Converted to Opportunity
    DE=Deferred
    IM=Imported
    LO=Closed - Lost
    NE=New
    OP=Open
    RE=Referred
    RJ=Rejected
    TB=Turnback
    WO=Working
    25 INDUSTRY_ID Character(30) VARCHAR2(30) NOT NULL Industry ID.

    Prompt Table: RSF_INDUSTRY_VW

    26 EST_REVENUE Signed Number(28,3) DECIMAL(26,3) NOT NULL The expected revenue (amount) associated with an Opportunity. This is particularly used for forecasting.
    27 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: RSF_USER_BU_VW

    28 SALES_USER_NAME Character(50) VARCHAR2(50) NOT NULL Sales User Name field
    29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    30 CHNL_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Unique identifier for a Channel Partner

    Prompt Table: RSF_CHNL_PRT_VW

    31 ALLIANC_PARTNER_ID Character(30) VARCHAR2(30) NOT NULL Alliance Partner

    Prompt Table: RSF_ALLNC_PRT_V

    32 REFERRED_DT Date(10) DATE Referred Date
    33 ACCEPTED_DT Date(10) DATE Accepted Date
    34 REFERRED_DT_STR Character(10) VARCHAR2(10) NOT NULL Invalid Input Date
    35 ACCEPTED_DT_STR Character(10) VARCHAR2(10) NOT NULL Invalid Input Date
    36 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    37 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    38 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    39 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    40 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    41 CITY Character(30) VARCHAR2(30) NOT NULL City
    42 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    43 NUM2 Character(4) VARCHAR2(4) NOT NULL Number 2
    44 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    45 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    46 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    47 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    48 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    49 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    50 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    51 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    52 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    Default Value: Y

    53 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS1_AC
    54 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS2_AC
    55 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL ADDRESS3_AC
    56 ADDRESS4_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 4.
    57 CITY_AC Character(30) VARCHAR2(30) NOT NULL CITY_AC
    58 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
    59 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.
    60 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    61 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    62 FIRST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL First Name Contact
    63 LAST_NAME_CNCT Character(30) VARCHAR2(30) NOT NULL Last Name
    64 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.
    65 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
    66 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.
    67 HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Phone
    68 CELL_PHONE Character(24) VARCHAR2(24) NOT NULL Cell Phone
    69 FAX Character(24) VARCHAR2(24) NOT NULL This is the fax number field.
    70 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    71 DESCRLONG Long Character CLOB Long Description
    72 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
    73 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL The person's preferred method of communication.
    C=Call
    E=Email Only
    F=Fax
    I=XML only
    M=Standard Mail
    P=Email & Print
    R=XML & Print
    S=SMS
    74 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

    Prompt Table: RSF_PRODGRP_VW2
    Set Control Field: BUSINESS_UNIT

    75 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    76 PRICE_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
    77 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    78 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    79 REVENUE_TYPE Character(15) VARCHAR2(15) NOT NULL This field is used to store revenue type related to a product sales and used within forecasting.

    Prompt Table: RSF_REV_TYPE_VW

    80 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    CS=Case
    EA=Each
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    81 WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Phone
    82 FIND_TERRITORY Character(1) VARCHAR2(1) NOT NULL Find Territory

    Y/N Table Edit

    83 CB_CONVERT_CONTACT Character(1) VARCHAR2(1) NOT NULL Convert to CUstomer
    N=No
    Y=Yes
    84 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    85 START_BPEL Character(1) VARCHAR2(1) NOT NULL Start Business Process
    N=No
    Y=Yes
    86 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.

    Prompt Table: RD_USR_INS_VW

    87 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic career field coming from campus solution system.
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: RD_USR_CAR_VW

    88 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL stores information about term attending.

    Prompt Table: RD_ACAD_ATE_VW

    89 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last school attended

    Prompt Table: EXT_ORG_TBL

    90 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    91 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    92 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    93 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    94 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.
    95 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    96 LAST_IMPORTED_DTTM DateTime(26) TIMESTAMP Last Import Attempt made on this date and time
    97 LAST_IMPORT_OPRID Character(30) VARCHAR2(30) NOT NULL used for import sales leads - shows the operator id of the last operartor to run the import.