LM_PRG_ROST_VW1

(SQL View)
 Index Back

View For Program Roster

View containing person, program,and enrollment details

SELECT A.LM_PRG_ID ,A.LM_PRG_REG_ID ,B.FIRST_NAME_SRCH ,B.LAST_NAME_SRCH ,B.LM_HR_EMPLID ,B.LM_ACTIVE ,B.FIRST_NAME ,B.LAST_NAME ,B.NAME_AC ,B.LM_ORGANIZATION_ID ,B.LM_ORG_DESCR ,B.LM_ORG_SDESCR ,B.LM_ORG_TYPE ,B.LM_MANAGER_ID ,B.LM_MGR_FIRST_NAME ,B.LM_MGR_LAST_NAME ,B.LM_JOB_TITLE ,B.LM_HIRE_DT ,A.LM_PRG_STTS ,A.LM_PERSON_ID ,A.LM_ENRL_DT ,A.LM_COMPL_DT ,B.LM_NAME_DISPLAY , A.LM_CERT_EFFDT FROM PS_LM_PRG_REG_VW A ,PS_LM_PERS_DTL_VW B WHERE A.LM_PERSON_ID = B.LM_PERSON_ID

  • Related Language Record: LM_PRG_ROST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    2 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.
    3 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    5 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
    6 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    N=Inactive
    Y=Active
    7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    8 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    9 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name
    10 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    11 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
    12 LM_ORG_SDESCR Character(10) VARCHAR2(10) NOT NULL Organization Short Description
    13 LM_ORG_TYPE Character(15) VARCHAR2(15) NOT NULL Organization Type
    14 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    15 LM_MGR_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Manager First Name
    16 LM_MGR_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Manager Last Name
    17 LM_JOB_TITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    18 LM_HIRE_DT Date(10) DATE Hire Date
    19 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
    20 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    21 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    22 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    23 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    24 LM_CERT_EFFDT Date(10) DATE Current Certification Date