RD_PERSON

(SQL Table)
 Index Back

Person

The Fields SETID and CONTACT_ID have been added to maintain the cross reference with PS FDM.

  • Related Language Record: RD_PERSON_LNG

  • Parent Record Of NAMEGBL_NPC_SBR RA_CMP_ATTR_LNG RB_ATTRPERS_LNG RB_ATTR_PERS RB_EVALUATIONS RB_EVALUATIO_VW RB_EVALUAT_LNG RB_EVALUAT_VLNG RB_EVAL_CI_VW RB_WORKER RB_WORKER_ALL RB_WORKER_CI_VW RB_WORKER_NEW RC_WRKR_JOB RD_CMPY_ATR_LNG RD_PERS_ATR_LNG RD_POI RD_POI_CI_VW RD_SITE_ATR_LNG RD_WRKR_ASGN RD_W_ASGN_CI_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Default Value: NEXT

    2 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role.
    E=External Contact
    I=Internal Corporate Contact

    Default Value: E

    3 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    4 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    5 RB_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    ARA=Arabic
    CFR=Canadian French
    CZE=Czech
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FIN=Finnish
    FRA=French
    GER=German
    GRK=Greek
    HEB=Hebrew
    HUN=Hungarian
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    MAY=Bahasa Malay
    NOR=Norwegian
    POL=Polish
    POR=Portuguese
    RUS=Russian
    SVE=Swedish
    THA=Thai
    TUR=Turkish
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese

    Default Value: PSOPTIONS.LANGUAGE_CD

    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
    F=Female
    M=Male
    U=Unknown
    8 BIRTHDATE Date(10) DATE Birthdate of the person.
    9 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

    Default Value: C

    10 SALUTATION_CD Character(6) VARCHAR2(6) NOT NULL Salutation Code.

    Prompt Table: SALUTATION_TBL

    11 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

    12 AUTHORIZATION_ID Character(10) VARCHAR2(10) NOT NULL Identification used for authorization purposes.
    13 PREF_WF_ROUTE_MTHD Character(1) VARCHAR2(1) NOT NULL Preferred workflow notification method. E.g., Email, Worklist, or Both.
    B=Both
    E=Email
    W=Worklist

    Default Value: B

    14 SOURCE_IND Character(4) VARCHAR2(4) NOT NULL EIP Source Indicator
    CRM=CRM
    EBS=EBIZ Suite
    EXT=External
    HRMS=HCM
    SCM=SCM

    Default Value: CRM

    15 PIM_ACCT_NAME Character(30) VARCHAR2(30) NOT NULL PIM Account Name
    16 DRIVER_LICENCE Character(40) VARCHAR2(40) NOT NULL drivers license
    17 DRIVER_L_STATE Character(6) VARCHAR2(6) NOT NULL Driver State

    Prompt Table: RD_DL_STATE_VW

    18 DRIVER_L_EXP_DATE Date(10) DATE DL Expiry Date
    19 RD_EMPLOYER Character(50) VARCHAR2(50) NOT NULL Defines the Employer of the Customer, Consumer or Employee
    20 DO_NOT_CONTACT Character(1) VARCHAR2(1) NOT NULL DO_NOT_CONTACT is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994.
    N=Contact Permitted
    Y=Do not contact

    Default Value: N

    21 DO_NOT_SMS Character(1) VARCHAR2(1) NOT NULL DO_NOT_SMS is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994.
    N=SMS Permitted
    Y=Do not SMS

    Default Value: N

    22 DO_NOT_EMAIL Character(1) VARCHAR2(1) NOT NULL Do Not Email
    N=No
    Y=Yes

    Default Value: N

    23 DO_NOT_MAIL Character(1) VARCHAR2(1) NOT NULL Do Not Mail
    N=No
    Y=Yes

    Default Value: N

    24 DO_NOT_CALL Character(1) VARCHAR2(1) NOT NULL channel flag of privacy preference
    N=No
    Y=Yes

    Default Value: N

    25 TEMPLATE_FLAG Character(1) VARCHAR2(1) NOT NULL Use as Template Worker

    Y/N Table Edit

    26 INSAGNT_LICENSE_ID Character(20) VARCHAR2(20) NOT NULL insurance agent licence id
    27 DATE_DECEASED Date(10) DATE Date Deceased
    28 MARITAL_STATUS Character(2) VARCHAR2(2) NOT NULL Marital Status
    1=Single
    2=Married
    3=Married but Separated
    4=Divorced
    5=Widow
    29 OCCUPATION Character(50) VARCHAR2(50) NOT NULL Occupation
    30 INCOME Number(15,2) DECIMAL(14,2) NOT NULL Income
    31 INCOME_CURRENCY Character(3) VARCHAR2(3) NOT NULL Income Currency

    Prompt Table: CURRENCY_CD_TBL

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