LM_CERT_RSN

(SQL Table)
 Index Back

Reason Code Table

Reason Code Table

  • Parent record: LM_RSNCD_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 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

    3 LM_RSN_STTS Character(1) VARCHAR2(1) NOT NULL Reason Status
    A=Active
    I=Inactive
    4 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    5 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    6 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    7 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid