RS_RR_RQ_AT_VW

(SQL View)
 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.

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.RS_ATTRIBUTE_ID , A.REQUIRED_FLAG FROM %Table(RS_SO_LN_RQ_AT) A WHERE EXISTS ( SELECT 'X' FROM %Table(RS_ATTRIBUTES) AA WHERE AA.RS_ATTRIBUTE_ID = A.RS_ATTRIBUTE_ID AND AA.RR_REQ_ATTR_FLG = 'Y')

  • Audit Record: RS_SO_AUDIT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
    4 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.

    Prompt Table: RS_RQ_AT_VW

    5 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N