FO_ASGRTPRF2_VW

(SQL View)
Index Back

Assignment Rate Profile

Mass Assignment Rate Changes

SELECT ASSIGNMENT_ID , C.RATE_PROFILE_ID FROM PS_RS_ASSIGNMENT A , PS_RS_SO_HDR H , PS_PERSONAL_DATA P , PS_JOB J , PS_FO_RATE_PROFILE C , PS_SET_CNTRL_REC SC WHERE A.SYSTEM_SOURCE = 'STF' AND A.BUSINESS_UNIT = H.BUSINESS_UNIT AND A.SO_ID = H.SO_ID 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 ) AND C.SETID = SC.SETID AND SC.SETCNTRLVALUE = A.BUSINESS_UNIT AND SC.RECNAME = 'FO_RATE_PROFILE' AND ( (J.PAY_SYSTEM_FLG = 'GP' AND C.PROFILE_AVAIL_TO = 'G') OR (J.PAY_SYSTEM_FLG = 'NA' AND P.PER_STATUS = 'N' AND C.PROFILE_AVAIL_TO = 'N') OR (J.PAY_SYSTEM_FLG = 'NA' AND P.PER_STATUS = 'E' AND J.EMPL_TYPE = 'S' AND C.PROFILE_AVAIL_TO = 'S') OR (J.PAY_SYSTEM_FLG = 'NA' AND P.PER_STATUS = 'E' AND (J.EMPL_TYPE = 'H' OR J.EMPL_TYPE = 'E') AND C.PROFILE_AVAIL_TO = 'H') )

# 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