FO_MC_ART_SRES

(SQL Table)
Index Back

Asgn Rates VW for Mass Changes

Mass Changes Mass Assignment Rates Changes Search Results record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FO_MC_USR_TYPE Character(10) VARCHAR2(10) NOT NULL User Mass Change Type
2 FO_MC_REQ_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Request ID.
3 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

Prompt Table: RS_ASSIGNMENT

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
5 FO_RATE_EFFDT Date(10) DATE NOT NULL Assignment Rate Effective Date
6 DETAIL_NO Number(3,0) SMALLINT NOT NULL Detail Number
7 FO_BRANCH Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: FO_BRANCH_TBL

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.

Prompt Table: RS_CUSTOMER_VW

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

Prompt Table: FO_CST_ADDR_VW2

10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_VW

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

12 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

Prompt Table: FO_ORD_SRCH_VW3

13 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

Prompt Table: RS_ASSGN_OSL_VW

14 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type

Prompt Table: FO_ORDER_TYPE

15 SERVICE_AREA Character(6) VARCHAR2(6) NOT NULL Line of Business
16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

17 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Project Employee Job Record #
18 NAME Character(50) VARCHAR2(50) NOT NULL Name

Prompt Table: FO_EMPL_NAME_VW

19 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL

20 RATE_ELEMENT Character(5) VARCHAR2(5) NOT NULL Rate Element
21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
22 REG_PAY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Pay Rate
23 REG_BILL_RATE Number(19,6) DECIMAL(18,6) NOT NULL Bill Rate
24 START_DT Date(10) DATE Start Date
25 END_DT Date(10) DATE End Date
26 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_PROJP_NONVW

27 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
28 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

Prompt Table: SP_BU_CA_NONVW

29 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
30 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
31 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR

Prompt Table: BUS_UNIT_TBL_HR

32 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

33 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_ALL_VW

34 FO_MARKUP_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Markup %