SSR_RC_MLSTN

(SQL Table)
Index Back

Batch Milestone Run Control

This record is used to store values to be used by the batch milestone process.

  • Parent record: PRCSRUNCNTL
  • # 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 SCCPS_POP_SEL Character(1) VARCHAR2(1) NOT NULL Population Selection checkbox - used to incidate on run controls that pop selection was selected for use.

    Y/N Table Edit

    Default Value: Y

    4 SCCPS_TOOL_ID Number(15,0) DECIMAL(15) NOT NULL Tool ID - the unique key for a pop select tool

    Prompt Table: SCCPS_TOOL_VW

    5 SCCPS_QUERY_NAME Character(50) VARCHAR2(50) NOT NULL Query / Section name used by population selection

    Prompt Table: %EDITTABLE

    6 SCCPS_CNTXT_ID Number(15,0) DECIMAL(15) NOT NULL Context ID - the unique key that identifies the pop selection context

    Prompt Table: SCCPS_CNTXT_VW

    7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    9 SCCPS_FILE_PATH Character(254) VARCHAR2(254) NOT NULL Pop Select File Path and Name
    10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    11 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine

    Prompt Table: ACAD_CAR_TBL

    12 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    13 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBLVW

    14 ASOF_DATE Date(10) DATE NOT NULL This field is used all over campus solutions to hold the value of an as of date to be used in different processing.
    15 SSR_MLSTN_PRCS_ACT Character(1) VARCHAR2(1) NOT NULL This field contains the process actions available when processing milestones in batch.
    B=Insert/Update Milestones
    D=Delete Milestones
    I=Insert Milestones
    U=Update Milestones

    Default Value: I

    16 SSR_DUP_MLSTN_OPT Character(1) VARCHAR2(1) NOT NULL This field is used in processing batch milestones to designate which algorythm is used to determine a duplicate milestone.
    1=Milestone
    2=Milestone/Level

    Default Value: 1

    17 SSR_DUP_MLSTN_PRCS Character(1) VARCHAR2(1) NOT NULL This field is a Y/N field used in processing milestones in batch that identified if duplicate milestones should be processed or ignored.

    Y/N Table Edit

    Default Value: N

    18 SSR_USE_STDNT_SEL Character(1) VARCHAR2(1) NOT NULL Use Student Select

    Y/N Table Edit

    Default Value: N