LM_PRG_REG_RSN

(SQL Table)
 Index Back

Reason Code

Reason Code

  • Related Language Record: LM_REG_RSN_LNG

  • Parent record: LM_PRG_REG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.
    2 LM_STTS_RSNCD_ID Number(10,0) DECIMAL(10) NOT NULL Reason Code ID
    3 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
    4 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date
    5 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    6 LM_RSN_CD Character(10) VARCHAR2(10) NOT NULL Identifies the user defined reason code for program and activity status changes.

    Prompt Table: LM_RSNCD_VW

    7 LM_NOTES Long Character CLOB Notes - This field holds notes that are entered at the Catalog Item level.