LM_PER_SRC_VW

(SQL View)
Index Back

Person Source View

Contains the source and source keys for a Person

SELECT LM_PERSON_ID , LM_HR_EMPLID , 0 , LM_SOURCE_IND FROM PS_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
2 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
3 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
4 LM_SOURCE_IND Character(4) VARCHAR2(4) NOT NULL Source Indicator
EXT=External
HR89=HRMS 89
HRMS=HRMS
LELM=Enterprise Learning