LM_PERSON

(SQL Table)
 Index Back

ELM Learner

Contains all types of People

  • Parent Record Of LM_PERSON_ADDR LM_PERSON_EFFDT LM_PERSON_EMAIL LM_PERSON_NAME LM_PERSON_PHONE LM_PERSON_POI

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

    Default Value: 999999999999999

    2 LM_BIRTHDATE Date(10) DATE Birthdate
    3 LM_COMM_METHOD Character(4) VARCHAR2(4) NOT NULL Preferred Communication Method
    EMAL=Email
    MAIL=Postal Mail
    PHON=Telephone

    Default Value: EMAL

    4 LM_SOURCE_IND Character(4) VARCHAR2(4) NOT NULL Source Indicator
    EXT=External
    HR89=HRMS 89
    HRMS=HRMS
    LELM=Enterprise Learning
    5 LM_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag

    Y/N Table Edit

    6 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
    7 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    8 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    9 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    10 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid