FO_ASGRTPRFL_VW

(SQL View)
 Index Back

Assignment Rate Profile

Mass Assignment Rate Changes

SELECT ASSIGNMENT_ID , (CASE J.PAY_SYSTEM_FLG WHEN 'GP' THEN C.RATE_PROFILE_GP ELSE CASE P.PER_STATUS WHEN 'N' THEN C.RATE_PROFILE_NEE WHEN 'E' THEN CASE J.EMPL_TYPE WHEN 'S' THEN C.RATE_PROFILE_NAS ELSE C.RATE_PROFILE_NAH END END END) FROM PS_RS_ASSIGNMENT A , PS_RS_SO_HDR H , PS_PERSONAL_DATA P , PS_JOB J , PS_FO_CA_PROFILE C WHERE A.SYSTEM_SOURCE = 'STF' AND A.BUSINESS_UNIT = H.BUSINESS_UNIT AND A.SO_ID = H.SO_ID AND C.BUSINESS_UNIT = H.BUSINESS_UNIT_CA AND C.USER_ORDER_TYPE = H.USER_ORDER_TYPE AND P.EMPLID = A.EMPLID AND J.EMPLID = A.EMPLID AND J.EMPL_RCD = A.EMPL_RCD_NUM AND J.EFFDT = ( SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD ) AND J.EFFSEQ = ( SELECT MAX(J3.EFFSEQ) FROM PS_JOB J3 WHERE J3.EMPLID = J.EMPLID AND J3.EMPL_RCD = J.EMPL_RCD AND J3.EFFDT = J.EFFDT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

Prompt Table: RS_ASSIGNMENT

2 RATE_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Rate Profile ID

Prompt Table: FO_RATE_PROFILE