LM_ACT_SRCH

(SQL View)
 Index Back

Activity Search

Activity Search View

SELECT PEROPR.OPRID , ACT.LM_ACT_ID , ACT.LM_ACT_CD , ACT.LM_ACT_STATUS , CI.LM_CS_LONG_NM , DMTYP.LM_DM_LONG_NM , ACT.LM_START_DT FROM PS_LM_ACT ACT , PS_LM_ACT_LE ACTLE , PS_LM_CI_TBL CI , PS_LM_DMTHD_TBL DM , PS_LM_DMTH_TYP_TBL DMTYP , PS_LM_PERSON_OPRID PEROPR , PS_LM_PERSON_ADMIN PERADM , PS_LM_PERSON_JOB PERJOB , PS_LM_PERSON PER WHERE ACT.LM_ACT_ID = ACTLE.LM_ACT_ID AND ACTLE.LM_LE_ID = PERADM.LM_LE_ID AND ACT.LM_CI_ID = CI.LM_CI_ID AND %CurrentDateIn BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND ACT.LM_DMTHD_TYPE_ID = DM.LM_DMTHD_TYPE_ID AND ACT.LM_CI_ID = DM.LM_CI_ID AND ACT.LM_DMTHD_ID = DM.LM_DMTHD_ID AND %CurrentDateIn BETWEEN DM.EFFDT AND DM.LM_END_EFFDT AND DMTYP.LM_DMTHD_TYPE_ID = DM.LM_DMTHD_TYPE_ID AND PERADM.LM_PERSON_ID = PEROPR.LM_PERSON_ID AND PERADM.LM_PRIMARY = 'Y' AND PERJOB.LM_PERSON_ID = PEROPR.LM_PERSON_ID AND PER.LM_PERSON_ID = PEROPR.LM_PERSON_ID AND %CurrentDateIn BETWEEN PERJOB.EFFDT AND PERJOB.LM_END_EFFDT AND PERJOB.LM_ACTIVE = 'Y'

  • Related Language Record: LM_ACT_SRCH_LVW

    • # 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_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    3 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    4 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
    1=Active
    2=Inactive
    3=Closed
    4=Pending
    5=Concluded
    5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    6 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    7 LM_START_DT Date(10) DATE Start Date