LM_RUNCTL_CR

(SQL Table)
Index Back

Run Control Curriculum Record

Run Control Curriculum Record - contains fields that are used as input parameters for the various Curriculum Reports. Input data is retrieved from this record when a report is requested from the Process Scheduler.

  • Related Language Record: LM_RNCTL_CR_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

    Prompt Table: %EDITTABLE2

    4 LM_PRG_CD Character(30) VARCHAR2(30) NOT NULL Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
    5 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    6 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

    Default Value: 0

    Prompt Table: %EDITTABLE

    7 FROMDATE Date(10) DATE From Date
    8 THRUDATE Date(10) DATE End Date
    9 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
    10 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
    CE=Certification
    CU=Curriculum
    11 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

    Prompt Table: %EDITTABLE3