LM_PRG_REG_STTS

(SQL Table)
 Index Back

Registration status audit

Registration status audit

  • 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_REG_STTS_SEQ Number(4,0) SMALLINT NOT NULL Status Sequence Number
    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_CHNG_DT Date(10) DATE Status Change Date
    5 LM_PRG_NEWREQ_FLG Character(1) VARCHAR2(1) NOT NULL New Requirements change?
    6 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    7 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    8 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    9 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid