LM_PGRG_RSN_HST

(SQL Table)
Index Back

Reason Code

Reason Code

  • Related Language Record: LM_RGRSNLNG_HST
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 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.
    4 LM_STTS_RSNCD_ID Number(10,0) DECIMAL(10) NOT NULL Reason Code ID
    5 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
    6 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date
    7 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    8 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

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