FO_MC_ART_SEL (SQL Table)	Index Back
Asgn Rates VW for Mass Changes Mass Changes Mass Assignment Rates Changes Search Results record.

FO_MC_ART_SEL

(SQL Table)

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 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1

12 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

13 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
Prompt Table: FO_ORD_SRCH_VW3

14 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
Prompt Table: RS_ASSGN_OSL_VW

15 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type
Prompt Table: FO_ORDER_TYPE

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

17 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DATA

18 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Project Employee Job Record #

19 NAME Character(50) VARCHAR2(50) NOT NULL Name
Prompt Table: FO_EMPL_NAME_VW

20 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: JOBCODE_TBL

21 RATE_ELEMENT Character(5) VARCHAR2(5) NOT NULL Rate Element

22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

23 REG_PAY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Pay Rate

24 REG_BILL_RATE Number(19,6) DECIMAL(18,6) NOT NULL Bill Rate

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

26 START_DT Date(10) DATE Start Date

27 END_DT Date(10) DATE End Date

28 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: SP_PROJP_NONVW

29 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

30 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit
Prompt Table: SP_BU_CA_NONVW

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

32 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

33 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR
Prompt Table: BUS_UNIT_TBL_HR

34 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

35 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_ALL_VW

36 FO_BILL_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Customer Bill Rate

37 FO_PAY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Pay Rate

38 PB_MARKUP Signed Number(11,6) DECIMAL(9,6) NOT NULL Mark Up %

39 PB_MARGIN Signed Number(11,6) DECIMAL(9,6) NOT NULL Margin %

40 FO_MC_ORIG_ACTION Character(1) VARCHAR2(1) NOT NULL Determines which action to take in Mass Change. Used in Staffing Mass Changes. A - Add D - Delete N - None U - Update
A=Add
D=Delete
N=None
U=Update

41 FO_MC_ACTION Character(1) VARCHAR2(1) NOT NULL Determines which action to take in Mass Change. Used in Staffing Mass Changes. A - Add D - Delete N - None U - Update
A=Add
D=Delete
N=None
U=Update
Default Value: N

42 FO_MC_ART_STATUS Character(1) VARCHAR2(1) NOT NULL Staffing Mass Assignment Rate Line Status D - Done E - Error R - Ready W - Warning
D=Done
E=Error
R=Ready
W=Warning

43 SELECTED_FLAG Character(1) VARCHAR2(1) NOT NULL Selected Flag
N=Not Selected
Y=Seleted
Y/N Table Edit
Default Value: N

44 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

45 DTTM_STAMP 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.

#	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	VENDOR_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Vendor Name1
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
13	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID Prompt Table: FO_ORD_SRCH_VW3
14	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number Prompt Table: RS_ASSGN_OSL_VW
15	USER_ORDER_TYPE	Character(5)	VARCHAR2(5) NOT NULL	User Order Type Prompt Table: FO_ORDER_TYPE
16	SERVICE_AREA	Character(6)	VARCHAR2(6) NOT NULL	Line of Business
17	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
18	EMPL_RCD_NUM	Number(3,0)	SMALLINT NOT NULL	Project Employee Job Record #
19	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Prompt Table: FO_EMPL_NAME_VW
20	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
21	RATE_ELEMENT	Character(5)	VARCHAR2(5) NOT NULL	Rate Element
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	REG_PAY_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Pay Rate
24	REG_BILL_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Bill Rate
25	FO_MARKUP_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Markup %
26	START_DT	Date(10)	DATE	Start Date
27	END_DT	Date(10)	DATE	End Date
28	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SP_PROJP_NONVW
29	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
30	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit Prompt Table: SP_BU_CA_NONVW
31	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
32	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
33	BUSINESS_UNIT_HR	Character(5)	VARCHAR2(5) NOT NULL	Business Unit HR Prompt Table: BUS_UNIT_TBL_HR
34	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
35	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_ALL_VW
36	FO_BILL_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Customer Bill Rate
37	FO_PAY_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Pay Rate
38	PB_MARKUP	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Mark Up %
39	PB_MARGIN	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Margin %
40	FO_MC_ORIG_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Determines which action to take in Mass Change. Used in Staffing Mass Changes. A - Add D - Delete N - None U - Update A=Add D=Delete N=None U=Update
41	FO_MC_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Determines which action to take in Mass Change. Used in Staffing Mass Changes. A - Add D - Delete N - None U - Update A=Add D=Delete N=None U=Update Default Value: N
42	FO_MC_ART_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Staffing Mass Assignment Rate Line Status D - Done E - Error R - Ready W - Warning D=Done E=Error R=Ready W=Warning
43	SELECTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selected Flag N=Not Selected Y=Seleted Y/N Table Edit Default Value: N
44	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
45	DTTM_STAMP	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.