RS_SO_HDR

(SQL Table)
 Index Back

Service Order Header

This is the main table for a sevice order so it is called Service Order Header table.

  • Parent Record Of FO_ASSGN_OSL_VW FO_JOBOPENVW FO_JOBOPEN_HDR FO_JOBOPEN_VW1 FO_JOBOPEN_WRK FO_JOBOPN_AET FO_JOBSRCH_WRK FO_SO_LINE FO_SO_LINE_UPG RS_ASSGN_OSL_VW RS_ASSGN_RR_VW RS_DF_RR_AVA_VW RS_DF_RR_FAC RS_DF_RR_VW RS_DF_STF_RR_VW RS_SO_EXPLNE_VW RS_SO_LINE RS_SO_LN_SCH_VW RS_SRCH_SOLN_VW

  • 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

    Prompt Table: SP_BU_PC_NONVW

    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    3 SO_SOURCE Character(1) VARCHAR2(1) NOT NULL Service Order Source
    C=Contract
    P=Project
    S=SRS
    T=Template
    4 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

    Prompt Table: RS_OPR_NAME_VW1

    5 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

    Default Value: RS

    6 SO_DATE Date(10) DATE Service Order Date
    7 EXPRESS_SEARCH_FLG Character(1) VARCHAR2(1) NOT NULL Express Search

    Y/N Table Edit

    Default Value: N

    8 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
    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.

    Prompt Table: %EDITTABLE5

    10 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Default Value: NEXT

    11 CONTR_LN_NBR Number(3,0) SMALLINT NOT NULL Contract Line Number
    12 ALLOW_NONBILL_FLG Character(1) VARCHAR2(1) NOT NULL Nonbillable Assignment Allowed

    Y/N Table Edit

    Default Value: N

    13 BID_FLAG Character(1) VARCHAR2(1) NOT NULL Worker Bids Accepted

    Y/N Table Edit

    Default Value: N

    14 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

    Default Value: OPR_DEF_TBL_FS.OPRID

    Prompt Table: RS_OPR_NAME_VW

    15 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_PROJP_NONVW

    16 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    17 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 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.
    19 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR

    Prompt Table: BUS_UNIT_TBL_HR

    20 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID
    21 NODE_DETAIL Character(1) VARCHAR2(1) NOT NULL Tree Node or Tree detail Value
    D=Detail
    N=Node
    22 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    24 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type

    Prompt Table: FO_ORDER_TYPE

    25 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

    Prompt Table: SP_BU_CA_NONVW

    26 START_DATE Date(10) DATE Start Date for Gen Standing PO
    27 END_EST_DATE Date(10) DATE Estimated End Date
    28 END_ACTUAL_DATE Date(10) DATE Actual End Date
    29 END_ACTUAL_REASON Character(2) VARCHAR2(2) NOT NULL End Reason
    C1=Cancelled: Rate too High
    C2=Cancelled: Slow in Response
    C3=Cancelled: Job Delayed
    C4=Cancelled: Order Not Needed
    C5=Cancelled: Unknown or Other
    CF=Competitor Filled Position
    D1=Declined: Work Hazard
    D2=Declined: Credit Problem
    D3=Declined: Undesirable
    D4=Declined: Unknown or Other
    E1=Employee Dissatisfaction
    F1=Unable to Fill: Candidate N/A
    F2=Unable to Fill: Skills N/A
    F3=Unable to Fill: Undesirable
    FP=Filled Position
    IC=Inquiry Closed
    OC=Order Closed
    OT=Other Reason
    S1=Satisfactory: Work Completed
    U1=Unsatisfactory: Employee Perf
    U2=Unsatisfactory: Employ No Show
    30 END_ACTUAL_COMMENT Character(254) VARCHAR2(254) NOT NULL End Comment
    31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    32 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: FO_CUST_ADDR_VW

    33 BILL_TO_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Bill To Contact ID

    Prompt Table: FO_CUST_CONT_VW

    34 FO_CSF_ID Character(15) VARCHAR2(15) NOT NULL Definition ID

    Prompt Table: FO_CUS_CSF_DVW

    35 ORDER_REASON_CD Character(2) VARCHAR2(2) NOT NULL Order Reason
    IN=Interviewing for Permanent
    IP=Internal Replacement/Perm
    MC=Marketing Call
    ML=Medical/Maternity Leave
    NI=Not Investigated
    NP=New Position/Perm
    OS=Other Service Unable
    OT=Other
    PK=Peak Period
    R1=Replacement: Other Service
    R2=Replacement
    SP=Special Project
    VR=Vacation Replacement
    36 ORDER_EVENT_GROUP Character(10) VARCHAR2(10) NOT NULL Order Event Group

    Prompt Table: FO_ORDR_EVENT

    37 SVC_ORDER_SOURCE Character(3) VARCHAR2(3) NOT NULL Service Order Source
    ABL=Info USA
    DC=Direct Contact
    PC=Phone Call
    RME=Resume Manager: Email
    RMV=Resume Manager: Service
    RMW=Resume Manager: Web
    SS=Customer Self-Service
    38 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: FO_DEPTID_VW
    Set Control Field: BUSINESS_UNIT

    39 SERVICE_AREA Character(6) VARCHAR2(6) NOT NULL Line of Business

    Prompt Table: FO_LINE_BUS_VW

    40 INDUSTRY Character(4) VARCHAR2(4) NOT NULL Industry
    CORE=Core
    EDUC=Education
    FNSV=Financial Services
    GOVT=Government
    HLTH=Health Care
    RETL=Retail
    TRAN=Transportation
    UTIL=Utilities

    Prompt Table: FO_SIC_CODE_VW

    41 SERVICE_OPRID Character(30) VARCHAR2(30) NOT NULL Service Operator

    Prompt Table: FO_SVC_GRP_VW

    42 SALES_OPRID Character(30) VARCHAR2(30) NOT NULL Sales Operator

    Prompt Table: OPRID_VW

    43 MANAGER_CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Order Contact

    Prompt Table: FO_CUST_CONT_VW

    44 CALLER_NAME Character(40) VARCHAR2(40) NOT NULL Caller Name

    Prompt Table: FO_CUST_CNT_VW2

    45 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
    A=Approved
    D=Denied
    P=Pending

    Default Value: A

    46 FO_EVENT_LST Character(30) VARCHAR2(30) NOT NULL Staffing Front Office Recruiting Funnel Event List

    Prompt Table: FO_EVT_LST_VW2

    47 FO_FORCE_DEP Character(1) VARCHAR2(1) NOT NULL Force Dependency among Recruiting Funnel Events
    N=N
    Y=Y