SPB_FAM_TYPE_VW

(SQL View)
 Index Back

Role type table

Role type table

SELECT SETID , ROLE_TYPE , SERVICE_METHOD , CATEGORY_CD , MINIMUM , MAXIMUM , SP_SCORE , DESCRSHORT , DESCR , SP_TIME_REPORT_OPT , SPA_USE_EXPENSES , SP_MANDATORY_FLG , SP_AUTO_SUR_FLAG , SP_TRACK_RESRC , SP_USE_WO_ALERTS , WO_NOTIFY_BY FROM PS_SPB_ROLE_TYPE

  • Related Language Record: SPB_ROLETYP_LNG

    • # 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

    Prompt Table: %EDITTABLE16
    Set Control Field: SETID

    3 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource
    4 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code

    Prompt Table: SPB_CATEG_CD_VW
    Set Control Field: SETID

    5 MINIMUM Number(3,0) SMALLINT NOT NULL Minimum
    6 MAXIMUM Number(3,0) SMALLINT NOT NULL Maximum
    7 SP_SCORE Number(7,2) DECIMAL(6,2) NOT NULL Score
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 SP_TIME_REPORT_OPT Character(1) VARCHAR2(1) NOT NULL Time Reporting Option
    A=Actual Allocation
    D=Default from Business Unit
    P=Percent Allocation

    Default Value: D

    11 SPA_USE_EXPENSES Character(1) VARCHAR2(1) NOT NULL Field to indicate if the expenses is allowed in the transcation or not.
    D=Default from Business Unit
    N=No
    Y=Yes

    Default Value: D

    12 SP_MANDATORY_FLG Character(1) VARCHAR2(1) NOT NULL Survey is mandatory for work order flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 SP_AUTO_SUR_FLAG Character(1) VARCHAR2(1) NOT NULL Automatically send Survey to distribution list role actions
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    14 SP_TRACK_RESRC Character(1) VARCHAR2(1) NOT NULL Track Resource
    B=Default From Business Unit
    N=No
    Y=Yes
    15 SP_USE_WO_ALERTS Character(1) VARCHAR2(1) NOT NULL Using Work Order Alerts flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    16 WO_NOTIFY_BY Character(2) VARCHAR2(2) NOT NULL WorkOrder Alert Notification Method
    EM=Email and Worklist
    WL=Worklist Only