SCC_RUN_STD_GRP

(SQL Table)
Index Back

Batch Student Group Run Ctl

Record used to initial the Batch Student Group App Engine Program. This record also utilizes the Population Selection sub record.

  • 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).

    Default Value: OPR_DEF_TBL_CS.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: PRCSRUNCNTL.RUN_CNTL_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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTN_SCRTY

    11 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

    Prompt Table: INST_STGPU_SCTY

    12 ASOFDATE Date(10) DATE NOT NULL As of Date

    Default Value: %date

    13 SCC_EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    14 STDNT_OVRD Character(1) VARCHAR2(1) NOT NULL Student Override

    Default Value: N

    15 TUIT_CALC_REQ_LBL Character(1) VARCHAR2(1) NOT NULL Tuition Calc Required

    Y/N Table Edit

    Default Value: N

    16 COMMENTS Long Character CLOB Comment