SPB_RLTY_DFALRT

(SQL Table)
 Index Back

Role Type Alert Defaults

Role Type Alert Defaults.

  • Related Language Record: SPB_RLTYAL_LANG

  • Parent record: SPB_ROLE_TYPE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    3 SP_ALERT_SEQ_NUM Number(3,0) SMALLINT NOT NULL Alert Sequence Number
    4 SP_WO_ALERT_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Alert Type
    A=Days After
    B=Days Before
    C=Percent Consumed
    5 SP_ALERT_NUM_DAYS Number(3,0) SMALLINT NOT NULL Number of Days/% Consumed

    Default Value: 0

    6 SP_ALERT_DESCR Character(30) VARCHAR2(30) NOT NULL Alert Description
    7 SP_ALRT_TRIG_EVENT Character(2) VARCHAR2(2) NOT NULL Alert Triggering Event
    AE=Actual End Date
    AP=Approval Date
    AS=Actual Start Date
    CL=Closed Date
    CN=Cancel Date
    EN=Entered Date
    PE=Projected End Date
    PS=Projected Start Date
    RE=Released Date
    TE=Terminated Date
    8 SP_DSTRLST_ID Character(18) VARCHAR2(18) NOT NULL Distribution List ID

    Prompt Table: SP_DSTRLST_ACTV