FO_MC_ART_SRES(SQL Table) |
Index Back |
---|---|
Asgn Rates VW for Mass ChangesMass 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 % |