FO_JOBOPENVW

(SQL View)
 Index Back

Staffing Job Opening view

Staffing Job Opening View

SELECT BUSINESS_UNIT , SO_ID , SO_LINE , FO_JOBOPEN_LINE , FO_JOBOPEN_STATUS , INDUSTRY_STANDARD , FO_JOBOPEN_ID , CUST_ID , ADDRESS_SEQ_NUM , POSITION_DESC , DESCRLONG , DESIRED_FULL_PART , ORDER_TYPE ,POST_DT , EXPIRATION_DT , START_DT FROM PS_FO_JOBOPEN_HDR WHERE FO_JOBOPEN_STATUS IN ('PUB','UPD')

  • Parent record: RS_SO_HDR

  • 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 FO_JOBOPEN_LINE Number(3,0) SMALLINT NOT NULL Job Opening Line
    5 FO_JOBOPEN_STATUS Character(3) VARCHAR2(3) NOT NULL Job Opening Status
    NEW=Draft
    PUB=Published
    REM=Removed
    UPD=Re-published
    6 INDUSTRY_STANDARD Character(30) VARCHAR2(30) NOT NULL Industry Standard field
    7 FO_JOBOPEN_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening ID
    8 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.
    9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
    10 POSITION_DESC Character(30) VARCHAR2(30) NOT NULL Template Position Description
    11 DESCRLONG Long Character CLOB Long Description
    12 DESIRED_FULL_PART Character(1) VARCHAR2(1) NOT NULL Full/Part-Time
    E=Either
    F=Full-Time
    P=Part-Time
    13 ORDER_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Order
    C=Career Order
    T=Temporary Order
    14 POST_DT Date(10) DATE The Date a transaction was Posted.
    15 EXPIRATION_DT Date(10) DATE Expiration Date
    16 START_DT Date(10) DATE Start Date