LM_GRP_SEL_LRNR

(SQL View)
 Index Back

Group Enrollment

Group Enrollment

SELECT A.LM_PERSON_ID , A.LM_HR_EMPLID , A.FIRST_NAME , A.LAST_NAME , A.LM_ORGANIZATION_ID , A.LM_MANAGER_ID , A.LM_ORG_DESCR , A.LM_ORG_SDESCR , A.LM_JOB_TITLE , A.LM_HIRE_DT , 0 , 'UNSU' , '' , 'UNSU' , A.LM_NAME_DISPLAY , 0 ,0 ,'N' ,'' ,'' FROM PS_LM_PERS_DTL_VW A

# 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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
5 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
6 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
7 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
8 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
9 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title
10 LM_HIRE_DT Date(10) DATE Hire Date
11 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
12 LM_STTS Character(4) VARCHAR2(4) NOT NULL Enrollment Status
CANC=Dropped
COMP=Completed
DECL=Denied
ENRL=Enrolled
INCO=Not Completed
INPO=In-Progress
MACT=Moved to New Activity
NOTS=Not Started
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
RQST=Learning Request
WAIV=Waived
WTLT=Waitlisted
13 LM_ERR_MSG Long Character(2000) VARCHAR2(2000) Error Message
14 LM_PRG_STTS Character(4) VARCHAR2(4) NOT NULL Program Reg Status
CANC=Dropped
COMP=Completed
DECL=Decline
ENRL=Registered
EXPR=Expired
INCO=Not Completed
INPO=In-Progress
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
REIS=Reissue
REVK=Revoked
WAIV=Waived
WARN=Warning
15 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
16 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
17 LM_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field

Prompt Table: %EDITTABLE3

18 LM_EXT_PERSON_FLG Character(1) VARCHAR2(1) NOT NULL External Person Flag

Y/N Table Edit

19 LM_ADHC_APRVL_EXT Character(4) VARCHAR2(4) NOT NULL Adhoc External Approval Types
10=None
40=Admin
50=Learner Selected
20 LM_ADHC_APRVL_INT Character(30) VARCHAR2(30) NOT NULL Adhoc internal approval types
10=None
20=Standard
50=Learner Selected