LM_LPLN_ASGN_VW

(SQL View)
 Index Back

Learning Plan Assigned By

This is the same view as PS_LM_PERS_NAME_VW. The field LM_PERSON_ID is replaced with LM_ASSIGNED_BY. This view is used on Learning Plans.

SELECT A.LM_PERSON_ID , B.LM_NAME_TYPE , B.NAME , B.NAME_PREFIX , B.NAME_SUFFIX , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.LAST_NAME , B.FIRST_NAME , B.MIDDLE_NAME , A.LM_EXT_PERSON_FLG , A.LM_HR_EMPLID , C.LM_LE_ID , B.COUNTRY_NM_FORMAT , B.NAME_AC , B.LM_NAME_DISPLAY , B.NAME_INITIALS , B.NAME_ROYAL_PREFIX , B.NAME_ROYAL_SUFFIX , B.NAME_TITLE , B.SECOND_LAST_NAME , B.SECOND_LAST_SRCH , B.PREF_FIRST_NAME , B.PARTNER_LAST_NAME , B.PARTNER_ROY_PREFIX , B.LAST_NAME_PREF_NLD , B.LM_DISPLAY_FLAG FROM PS_LM_PERSON A , PS_LM_PERSON_NAME B , PS_LM_CURR_JOB_VW C WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND B.LM_DISPLAY_FLAG ='Y' AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND C.LM_PERSON_ID = A.LM_PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ASSIGNED_BY Number(15,0) DECIMAL(15) NOT NULL Assigned By
2 LM_NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Name Type
3 NAME Character(50) VARCHAR2(50) NOT NULL Name
4 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
5 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
7 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
10 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
11 LM_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag
12 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
13 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
14 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country

Prompt Table: COUNTRY_TBL

15 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name
16 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
17 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
18 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
19 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
20 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
21 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
22 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
23 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
24 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
25 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.
26 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
27 LM_DISPLAY_FLAG Character(1) VARCHAR2(1) NOT NULL Display the information flag.