RS_ATTRIBUTES

(SQL Table)
 Index Back

SRS Attributes

This record contains the attributes of an assignment for which the worker can specify preferences and/or which can be captured on the service order.

  • Related Language Record: RS_ATTRIBUTES_L

  • Parent Record Of RS_ATTRIB_VALS RS_ATTRIB_VAL_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RS_ATTRIBUTE_ID Character(10) VARCHAR2(10) NOT NULL This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Default Value: RS_ATTRIB_VALS

    Prompt Table: PSRECDEFNPVW

    5 ATTR_MULTIVALU_FLG Character(1) VARCHAR2(1) NOT NULL Multiple values allowed
    N=Only one value
    Y=Many values

    Default Value: N

    6 SO_ATTRIBUTE_FLAG Character(1) VARCHAR2(1) NOT NULL Service Order Attribute Flag

    Default Value: N

    7 WO_ATTRIBUTE_FLG Character(1) VARCHAR2(1) NOT NULL This is a worker attribute.

    Default Value: N

    8 RR_REQ_ATTR_FLG Character(1) VARCHAR2(1) NOT NULL Requestable attribute

    Y/N Table Edit

    Default Value: N

    9 WORKER_PREF_FLAG Character(1) VARCHAR2(1) NOT NULL Worker preference flag

    Y/N Table Edit

    Default Value: N

    10 FACTOR_FWA_FLG Character(1) VARCHAR2(1) NOT NULL Worker attribute factor

    Y/N Table Edit

    Default Value: N

    11 FACTOR_ID_FWA Character(3) VARCHAR2(3) NOT NULL Worker attribute factor ID
    ACC=Accomplishments
    AVA=Availability
    PRO=Competency Proficiency
    YRS=Competency Years Of Experience

    Prompt Table: RS_FACTOR_VW

    12 FACTOR_FWP_FLG Character(1) VARCHAR2(1) NOT NULL Worker preference factor

    Y/N Table Edit

    Default Value: N

    13 FACTOR_ID_FWP Character(3) VARCHAR2(3) NOT NULL Worker preference factor ID
    ACC=Accomplishments
    AVA=Availability
    PRO=Competency Proficiency
    YRS=Competency Years Of Experience

    Prompt Table: RS_FACTOR_VW

    14 FACTOR_PRL_FLG Character(1) VARCHAR2(1) NOT NULL PRL ATTRIBUTE FLAG

    Y/N Table Edit

    Default Value: N

    15 PRL_REQ_ATTR_FLG Character(1) VARCHAR2(1) NOT NULL PRL Requestable Attribute Flag

    Y/N Table Edit

    Default Value: N

    16 FACTOR_ID_PRL Character(3) VARCHAR2(3) NOT NULL Factor ID for PRL