RS_DF_STF_RR_VW

(SQL View)
 Index Back

View for staffing RR

View for staffing service orders.

SELECT C.BUSINESS_UNIT , C.SO_ID , C.SO_LINE , C.START_DT , C.END_DT , C.EST_DAYS , C.PERIOD_DAYS , C.PART_TIME_FLG , C.CUST_ID , C.ADDRESS_SEQ_NUM , C.DISTANCE , A.ASSIGNED_TO , C.LASTUPDDTTM , C.KEY_REQS , C.QTY_INTEGER , A.EXPRESS_SEARCH_FLG FROM %Table(RS_SO_HDR) A , %Table(RS_SO_LINE) C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.SO_ID = A.SO_ID AND A.SYSTEM_SOURCE = 'STF'

  • Parent record: RS_SO_HDR

    • # 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 START_DT Date(10) DATE Start Date
    5 END_DT Date(10) DATE End Date
    6 EST_DAYS Number(5,0) INTEGER NOT NULL Estimated number of days
    7 PERIOD_DAYS Number(5,0) INTEGER NOT NULL Number of Work Days
    8 PART_TIME_FLG Character(1) VARCHAR2(1) NOT NULL Part Time

    Y/N Table Edit

    9 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    10 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    11 DISTANCE Number(8,2) DECIMAL(7,2) NOT NULL Distance Traveled
    12 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To
    13 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    14 KEY_REQS Character(100) VARCHAR2(100) NOT NULL Key Requirements
    15 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals
    16 EXPRESS_SEARCH_FLG Character(1) VARCHAR2(1) NOT NULL Express Search