SPB_ROLE_ATRB_V

(SQL View)
 Index Back

Service/Project RoleAttributes

Service/Project RoleAttributes

SELECT SETID , PROJ_ROLE ,SERVICE_METHOD , DESCR , DESCRLONG ,SPF_YRS_EXPERIENCE , EDUCATION_LVL , INTERVIEWREQUIRED , SP_BILL_METHOD , SP_SHOW_BID , SP_ADD_ACTIVITY FROM PS_SPB_ROLE_ATTRIB WHERE SP_BILL_METHOD NOT IN ('P') AND SERVICE_METHOD ='D'

  • Related Language Record: SPB_ROL_AT_LG_V

  • Parent record: PROJ_ROLE

    • # 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 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: PROJ_ROLE
    Set Control Field: SETID

    3 SERVICE_METHOD Character(1) VARCHAR2(1) NOT NULL Service Method
    D=Deliverable
    M=Multi Resource
    R=Resource
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRLONG Long Character CLOB Long Description
    6 SPF_YRS_EXPERIENCE Character(4) VARCHAR2(4) NOT NULL Years Experience

    Prompt Table: SP_EXPERIENCE
    Set Control Field: BUSINESS_UNIT

    7 EDUCATION_LVL Character(2) VARCHAR2(2) NOT NULL Education Level
    1=No Formal Education
    10=Associate Degree
    11=Three Years College
    12=Four Years College
    13=Bachelor Degree
    14=Post Bachelors
    15=First Professional
    16=Post-First Professional
    17=Masters Degree
    18=Post Masters
    19=Sixth Year Degree
    2=Elementary School Completed
    20=Post Sixth Year
    21=Doctorate Degree
    22=Post Doctorate
    3=Some High School
    4=High School Graduate
    5=Terminal Occupation Prog DNC
    6=Terminal Occupation Program
    7=Some College - Less than 1 Yr
    8=One Year College
    9=Two Years College
    A=University - Advanced
    T=Trade School
    U=University
    8 INTERVIEWREQUIRED Character(1) VARCHAR2(1) NOT NULL Interview Required
    N=No
    Y=Yes
    9 SP_BILL_METHOD Character(1) VARCHAR2(1) NOT NULL Used in Service Based Workorders to identify the billing method.
    F=Fixed Amount
    M=Milestone
    P=Percentage
    R=Rate Based
    10 SP_SHOW_BID Character(1) VARCHAR2(1) NOT NULL Show Bid
    N=Hide Rate
    Y=Display Rate
    11 SP_ADD_ACTIVITY Character(1) VARCHAR2(1) NOT NULL Allow add activities