LM_PERSON_EMAIL

(SQL Table)
Index Back

Person Email

Person Email

  • Parent record: LM_PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

    Prompt Table: LM_PERSON_NAME

    2 LM_CM_PURP_TYPE Character(4) VARCHAR2(4) NOT NULL Contact Method Purpose Type

    Prompt Table: LM_CM_PURP_TYPE

    3 LM_PRIMARY Character(1) VARCHAR2(1) NOT NULL Primary Contact Method
    N=No
    Y=Yes

    Y/N Table Edit

    4 LM_EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address
    5 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    6 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    7 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    8 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid