SPB_SC_DEF_ALRT

(SQL Table)
 Index Back

Service Coordinator Def Alerts

Service Coordinator Alert Defaults

  • Related Language Record: SPB_SCALRT_LANG

  • Parent record: SPB_SERVICE_COD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Prompt Table: SPB_PERSON_TBL

    2 SC_FUNCTION_TYPE Character(4) VARCHAR2(4) NOT NULL Function Type
    COOD=Coordinator

    Default Value: COOD

    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