LM_NEW_ACT_VW

(SQL View)
 Index Back

Activity Security Table

Activity Security Table to include learner, delivery method, and timestamp

SELECT DISTINCT PER.OPRID , PER.LM_PERSON_ID , A.LM_ACT_ID , A.LM_CI_ID , A.LM_ACT_CD , CI.LM_CS_LONG_NM , A.LM_DMTHD_TYPE_ID , D.LM_DM_LONG_NM , A.LM_RESTRICT_TO_PRG ,%subrec(LM_ROWAUDIT_SBR, A) FROM PS_LM_OPRID_GRP_VW PER , PS_LM_ACT_SEC S , PS_LM_ACT A , PS_LM_DMTH_TYP_TBL D , PS_LM_CI_TBL CI WHERE 1 = 1 AND S.LM_ACT_ID = A.LM_ACT_ID AND S.LM_LRNR_GROUP_ID = PER.LM_LRNR_GROUP_ID AND A.LM_DMTHD_TYPE_ID = D.LM_DMTHD_TYPE_ID AND CI.LM_CI_ID = A.LM_CI_ID AND %CurrentDateIn BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND A.LM_ACT_STATUS = '1'

  • Parent record: LM_ACT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    3 LM_ACT_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Holds the Activity or Program ID.
    4 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    5 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    6 LM_ACT_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Holds activity or program long name.
    7 LM_DMTHD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method Type ID - This is a unique identifier for each delivery method type
    8 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    9 LM_RESTRICT_TO_PRG Character(1) VARCHAR2(1) NOT NULL Restrict to Programs
    10 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    11 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    12 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    13 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid