FO_ASGN_RT_VW

(SQL View)
Index Back

Assignment Info

Assignment Info

SELECT RT.ASSIGNMENT_ID , DT.SEQNO , RT.EFFDT , RT.DETAIL_NO , %Substring(H.OWNERSHIP_ID, 1, 5) , A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , H.USER_ORDER_TYPE , A.CUST_ID , A.VENDOR_ID , A.ADDRESS_SEQ_NUM , A.EMPLID , A.EMPL_RCD_NUM , A.NAME , A.JOBCODE , DT.START_DT , DT.END_DT , RT.RATE_ELEMENT , H.CURRENCY_CD , RT.REG_PAY_RATE , RT.REG_BILL_RATE , H.PROJECT_ID , A.ACTIVITY_ID , H.BUSINESS_UNIT_CA , H.CONTRACT_NUM , A.CONTRACT_LINE_NUM , A.COMPANY , A.BUSINESS_UNIT_HR , A.DEPTID , A.PAYGROUP , A.GP_PAYGROUP , A.TASKGROUP , A.WORKGROUP , A.TAX_LOCATION_CD , A.TAX_CD FROM PS_RS_ASSGN_DETAIL DT , PS_FO_ASGN_RT_DTL RT , PS_RS_ASSIGNMENT A , PS_RS_SO_HDR H WHERE DT.ASSIGNMENT_ID = RT.ASSIGNMENT_ID AND DT.ASSIGNMENT_ID = A.ASSIGNMENT_ID AND A.BUSINESS_UNIT = H.BUSINESS_UNIT AND A.SO_ID = H.SO_ID AND A.SYSTEM_SOURCE = 'STF' AND ( (RT.EFFDT BETWEEN DT.START_DT AND DT.END_DT) OR (RT.EFFDT = ( SELECT MAX(RT2.EFFDT) FROM PS_FO_ASGN_RT_DTL RT2 WHERE RT2.ASSIGNMENT_ID = RT.ASSIGNMENT_ID AND RT2.DETAIL_NO = RT.DETAIL_NO AND RT2.EFFDT <= DT.START_DT ) ) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
2 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 DETAIL_NO Number(3,0) SMALLINT NOT NULL Detail Number
5 FO_BRANCH Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: FO_BRANCH_TBL

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

Prompt Table: SP_BU_PC_NONVW

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

Prompt Table: FO_ORD_SRCH_VW3

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

Prompt Table: RS_ASSGN_OSL_VW

9 USER_ORDER_TYPE Character(5) VARCHAR2(5) NOT NULL User Order Type
10 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

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

Prompt Table: VENDOR_VW

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

Prompt Table: FO_CST_ADDR_VW2

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

Prompt Table: PERSONAL_DATA

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

Prompt Table: FO_EMPL_NAME_VW

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

Prompt Table: JOBCODE_TBL

17 START_DT Date(10) DATE Start Date
18 END_DT Date(10) DATE End Date
19 RATE_ELEMENT Character(5) VARCHAR2(5) NOT NULL Rate Element

Prompt Table: FO_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 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_PROJP_NONVW

24 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
25 BUSINESS_UNIT_CA Character(5) VARCHAR2(5) NOT NULL Contracts Business Unit

Prompt Table: SP_BU_CA_NONVW

26 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
27 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
28 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

29 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR

Prompt Table: BUS_UNIT_TBL_HR

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

Prompt Table: DEPT_ALL_VW

31 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: FO_PAYGROUP_VW

32 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Pay Group

Prompt Table: GP_PYGRP

33 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

Prompt Table: TL_TASKGRP_TBL

34 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup

Prompt Table: TL_WRKGRP_TBL

35 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
36 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: CA_TAX_CD_VW