FO_ASGRTPRF2_VW(SQL View) |
Index Back |
---|---|
Assignment Rate ProfileMass 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 |