SSR_RS_EXEC_RUL

(SQL Table)
Index Back

Execution Event Rule Types

  • Parent record: SSR_RS_EXEC_LOC
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_EXEC_LOC_ID Character(20) VARCHAR2(20) NOT NULL Execution Event

    Prompt Table: SSR_EXEC_LOC

    2 SSR_PE_RULE_TYPE Character(20) VARCHAR2(20) NOT NULL Rule Type
    CALC=Grade Calculation
    NAG=Enrollment Audit
    PGRS=Progression
    PREC=Pre-Condition
    RETK=Retake

    Prompt Table: SSR_RS_RULETYPE

    3 SSR_RULE_ERRHAND Character(2) VARCHAR2(2) NOT NULL How to handle errors from a rule execution
    00=Not Applicable
    10=Obey
    20=Treat as Warning

    Default Value: 10

    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: N

    6 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    7 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    8 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    9 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time