LM_PRG_SEC_VW

(SQL View)
 Index Back

Program Security View

Program Security View

SELECT A.LM_PRG_ID , A.EFFDT , A.LM_LRNR_GROUP_ID FROM PS_LM_PRG_SEC A

  • Parent record: LM_PRG_SEC

    • # 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 EFFDT Date(10) DATE Effective Date

    Default Value: LM_PRG.EFFDT

    3 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

    Prompt Table: %EDITTABLE