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 PBM_ASGN_ID Character(15) VARCHAR2(15) NOT NULL Assigment ID

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 Staffing Branch

8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

9 ADDRESS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Address Sequence Number

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

11 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1

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

13 SO_ID Character(15) VARCHAR2(15) NOT NULL Order ID

14 SO_LINE Number(3,0) SMALLINT NOT NULL Order Line

15 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

16 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Employee Record Number

17 NAME Character(50) VARCHAR2(50) NOT NULL Name

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

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

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

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

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

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

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/Grant

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

28 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit for HCM

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

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

31 FO_BILL_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Determines Assignment Bill Rate

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

33 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

34 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

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

36 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	PBM_ASGN_ID	Character(15)	VARCHAR2(15) NOT NULL	Assigment ID
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	Staffing Branch
8	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
9	ADDRESS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Address Sequence Number
10	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
11	VENDOR_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Vendor Name1
12	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
13	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Order ID
14	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Order Line
15	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
16	EMPL_RCD_NUM	Number(3,0)	SMALLINT NOT NULL	Employee Record Number
17	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
18	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
19	RATE_ELEMENT	Character(5)	VARCHAR2(5) NOT NULL	Rate Element
20	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
21	REG_PAY_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Pay Rate
22	REG_BILL_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Bill Rate
23	FO_MARKUP_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Markup %
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/Grant
27	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
28	BUSINESS_UNIT_HR	Character(5)	VARCHAR2(5) NOT NULL	Business Unit for HCM
29	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
30	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
31	FO_BILL_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Determines Assignment Bill Rate
32	FO_PAY_RATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Pay Rate
33	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
34	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
35	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
36	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.