SSR_AM_UPD_PROC

(SQL Table)
Index Back

AM Update

This record is the run control header record for the AM Status Update process.

  • Parent Record Of SSR_AM_UPDP_DTL
  • # 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 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
    CRSE=Coursework

    Default Value: CRSE

    4 SSR_AM_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Run Type
    C=Create and Process Requests
    E=Process Existing Requests
    O=Create Requests

    Default Value: C

    5 SSR_AM_REQ_ACTION Character(3) VARCHAR2(3) NOT NULL Requested Action
    STA=Status Updates

    Default Value: STA

    6 SSR_AM_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL AM Request ID

    Prompt Table: SSR_AM_REQH_VW2

    7 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    8 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    9 SSR_PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Academic Period ID

    Prompt Table: SSR_EXAM_PRD_VW

    10 SSR_AM_SEL_TYPE Character(1) VARCHAR2(1) NOT NULL Activity Selection Type
    F=Use Filter
    M=Use Manual List

    Default Value: F

    11 SSR_AC_MAX_SRCH Number(3,0) SMALLINT NOT NULL Maximum Rows Returned

    Default Value: 100

    12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    13 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    14 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    15 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    16 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time