SELECT A.EMPLID 

 , A.EMPL_RCD 

 , A.CAL_RUN_ID 

 , A.GP_PAYGROUP 

 , A.CAL_ID 

 , A.ORIG_CAL_RUN_ID 

 , A.RSLT_SEG_NUM 

 , A.SEG_BGN_DT 

 , A.SEG_END_DT 

 ,SUM(b.Day_count_paid) 

 ,SUM(b.Day_count_unpaid) 

  FROM PS_GP_PYE_SEG_STAT A 

  , ps_gp_rslt_abs B 

 WHERE A.EMPLID = B.EMPLID 

   AND A.EMPL_RCD = B.EMPL_RCD 

   AND A.GP_PAYGROUP = B.GP_PAYGROUP 

   AND A.RSLT_SEG_NUM = b.RSLT_SEG_NUM 

  GROUP BY A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.SEG_BGN_DT , a.SEG_END_DT

Đọc tiếp...

Xem bài viết trên phiên bản di động

Bài viết với mục đích giúp cho những người mới tiếp cận module Global Payroll của phần mềm PS một cách nhanh nhất.

Yêu cầu kiến thức nền:

1.      Kiến thức căn bản về CNTT, khả năng xây dựng thuật giải, kiến thức về cơ sở dữ liệu.

2.      Kiến thức căn bản về phần mềm PS: Các khái niệm căn bản như  SetID, BU, Effdate,…

3.      Kiến thức căn bản về module Core HR: personal data, job data,…

4.      Kiến thức căn bản module Compensation: Thang bảng lương…

Đối tượng nghiên cứu:

Đối tượng nghiên cứu là các thiết lập trong module Global Payroll để có thể cấu hình công thức lương cho tổ chức. Bao gồm 3 phần chính:

1.      Cấu trúc tổ chức-Thiết lập đối tượng tính lương, thiết lập tính lương cho đối tượng nào. (Organization Structure)

2.      Cấu trúc tính toán- Thiết lập các công thức, phần này thiết lập tính lương như thế nào. (Process Structure )

3.      Lịch tính toán- Phần này thiết lập tính lương cho quãng thời gian nào.(Calendar Period ID)

Đọc tiếp...

Xem bài viết trên phiên bản di động

Element Type	Element Name	Description	Comments
Array	GP AR PSLP GRP ID	Payslip message group ID.
Array	GP AR PSLP MSG PBD	Payslip message active.	Array to read PLSP_MSGs managed in GP that are active.
Array	GP AR PSLP PLIST	Payslip message HR group list.
Count	GP WORK DAY COUNT	Work day count.	Counts the number of workdays. Used with the standard proration element GP PRORATE WRK DAY. For this count element, a day is considered a workday if scheduled hours are greater than zero.
Count	GP WORK HRS COUNT	Work hours count.	Counts the number of workdays. Used with the standard proration element GP PRORATE WRK HRS. For this count element, count the number of scheduled hours.
Duration	GP YEARS OF SVC	Years of service.	Calculates the years of service based on the hire date through the calendar period end date.
Duration	GP MONTHS OF SVC	Months of service.	Calculates the months of service based on the hire date through the calendar period end date.
Duration	GP DAYS OF SVC	Days of service.	Calculates the days of service based on the hire date through the calendar period end date.
Duration	GP AGE IN YEARS	Age in years.	Calculates the age of person in years from the birth date through the calendar period end date.
Duration	GP AGE IN MONTHS	Age in months.	Calculates the age of person in months from the birth date through the calendar period end date.
Duration	GP AGE IN DAYS	Age in days.	Calculates the age of person in days from the birth date through the calendar period end date.
Duration	GP CAL DAYS SLICE	Calendar days in slice.	Calculates the number of calendar days in the slice. Used in the proration element GP PRORATE CAL DAYS.
Duration	GP CAL DAYS SEG	Calendar days in segment.	Calculates the number of calendar days in the segment.
Duration	GP CAL DAYS PERIOD	Calendar days in period.	Calculates the number of calendar days in the calendar period. Used in the proration element GP PRORATE CAL DAYS.
Date	GP ABS BGN DT - 1	Absence begin date - 1.
Date	GP PMNT DT EXTR	Payment date, date extract.	Returns three variable elements (GP PMNT DATE YR, GP PMNT DATE MO, GP PMNT DATE DY) that will resolve to the year, month, and day of the Calendar Payment Date.
Date	GP PRD BGN DT EXTR	Period begin date, date extract.	Returns three variable elements (GP PRD BGN DATE YR, GP PRD BGN DATE MO, GP PRD BGN DATE DY) that will resolve to the year, month, and day of the Calendar Period Begin Date.
Date	GP SLICE END DT +1	Slice end date, plus one day.	Returns the slice end date, plus one day. Used in a duration element GP CAL DAYS SLICE that calculates the number of calendar days in a slice.
Date	GP SEG END DT +1	Segment end date, plus one day.	Returns the segment end date, plus one day. Used in a duration element GP CAL DAYS SEG that calculates the number of calendar days in a segment.
Date	GP SEG END DT EXTR	Segment end date, date extract.
Date	GP SLI BGN DT EXTR	Slice begin date, date extract.
Date	GP SLI END DT EXTR	Slice end date, date extract.
Date	GP PRD END DT +1	Period end date, plus one day.	Returns the period end date, plus one day. Used in a duration element GP CAL DAYS PERIOD that calculates the number of calendar days in a calendar period.
Date	GP PRD END DT EXTR	Period end date, date extract.	Returns three variable elements (GP PRD END DATE YR, GP PRD END DATE MO, and GP PRD END DATE DY) that resolve to the year, month, and day of the calendar period end date.
Date	GP SEG BGN DT EXTR	Segment begin date, date extract.
Error message	MSG PIN	Call Error Message	Triggers the writing of a message, when entered in a Formula element. Before executing this element, the same formula must populate other system elements, such as MSG_NBR, MSG_SET_NBR, and MSG_PAYMENT_ERR.
Formula	GP JANUARY	January.	Returns True if the month of the calendar period is January; otherwise False.
Formula	GP FEBRUARY	February.	Returns True if the month of the calendar period is February; otherwise False.
Formula	GP MARCH	March.	Returns True if the month of the calendar period is March; otherwise False.
Formula	GP APRIL	April.	Returns True if the month of the calendar period is April; otherwise False.
Formula	GP MAY	May.	Returns True if the month of the calendar period is May; otherwise False.
Formula	GP JUNE	June.	Returns True if the month of the calendar period is June; otherwise False.
Formula	GP JULY	July.	Returns True if the month of the calendar period is July; otherwise False.
Formula	GP AUGUST	August.	Returns True if the month of the calendar period is August; otherwise False.
Formula	GP SEPTEMBER	September.	Returns True if the month of the calendar period is September; otherwise False.
Formula	GP OCTOBER	October.	Returns True if the month of the Calendar Period is October; otherwise False.
Formula	GP NOVEMBER	November.	Returns True if the month of the calendar period is November; otherwise False.
Formula	GP DECEMBER	December.	Returns True if the month of the calendar period is December; otherwise False.
Formula	GP COUNT WORK DAYS	Workday count.	Returns True if scheduled hours are greater than zero; otherwise False. Used in the count element GP WORK DAY COUNT to count the number of workdays.
Formula	GP COUNT WORK HRS	Work hour count.	Returns the number of work hours for a day. Used in the count element GP WORK HRS COUNT to count the number of work hours.
Formula	GP CHECK 1ST SEG	Check if first segment.	Returns True if you are in the first segment of a calendar for a payee; otherwise False. Determined by checking the value of the system element FIRST SEGMENT.
Formula	GP CHECK LST SEG	Check last segment.	Returns True if you are in the last segment of a calendar for a payee; otherwise False. This is determined by checking the value of the system element LAST SEGMENT.
Formula	GP CHK 1ST ACT SEG	Check first active segment.	Returns True if you are in the first active segment of a calendar for a payee; otherwise False. This is determined by checking the value of the system element FIRST ACT SEGMENT.
Formula	GP CHK LST ACT SEG	Check last active segment.	Returns True if you are in the last active segment of a calendar for a payee; otherwise False. This is determined by checking the value of the system element LAST ACT SEGMENT.
Formula	GP FM PSLP AR	Payslip messages duration.	(Duration formula). Calls GP FM PSLP SEL (population) when duration criteria is met.
Formula	GP FM PSLP SEL	Payslip messages duration.	(Population formula). Writes to the writable array If the EmplID meets the population criteria in the Message Definition. The message definition may have specified that a custom formula will be used to determine the criteria.
Formula	GP RETRO OVERRIDE	Retro process override formula.
Generation Control	GP QTR END ONLY	Quarter end only.	Checks generation control based on the quarter-end date. The quarter-end date is based on a predefined generation control frequency of QTR END (which references a frequency with a factor of 4). Note: For generation control frequency to be True, enter the matching generation control frequency on any calendar for which you want generation control to be True.
Generation Control	GP YEAR END ONLY	Year end only.	Checks generation control based on the year-end date. The year-end date is based on a predefined generation control frequency of YEAR END (which references a frequency with a factor of 1). Note: For generation control frequency to be True, you must enter the matching generation control frequency on any calendar for which you want generation control to be True.
Generation Control	GP APPLY 1ST SEG	Apply once - first segment.	Checks generation control based on whether the calculation is in the first segment (in a calendar). Generation control is True if you are in the first segment or False if you are not.
Generation Control	GP APPLY LST SEG	Apply once - last segment.	Checks generation control based on whether the calculation is in the last segment (in a calendar). Generation control is True if you are in the last segment or False if you are not.
Generation Control	GP APPLY LST A SEG	Apply once - last active segment.	Checks generation control based on whether the calculation is in the last active segment (in a calendar). Generation control is True if you are in the last active segment or False if you are not.
Generation Control	GP APPLY 1ST A SEG	Apply once - first active segment.	Checks generation control based on whether the calculation is in the first active segment (in a calendar). Generation control is True if you are in the first active segment or False if you are not.
Proration Rule	GP PRORATE CAL DAY	Proration based on calendar days.	Provides basic proration logic based on calendar days.
Proration Rule	GP PRORATE WRK DAY	Proration based on workdays.	Provides basic proration logic based on workdays.
Proration Rule	GP PRORATE WRK HRS	Proration based on work hours.	Provides basic proration logic based on work hours.
Rounding Rule	GP ROUND NEAR 0DEC	Round to nearest zero decimal places.	Rounds to nearest (up if greater than or equal to 5; otherwise down) zero decimal places.
Rounding Rule	GP ROUND NEAR 2DEC	Round to nearest two decimal places.	Rounds to nearest (up if greater than or equal to 5; otherwise down) two decimal places.
Rounding Rule	GP ROUND UP 0DEC	Round up to zero decimal places.	Rounds up to zero decimal places.
Rounding Rule	GP ROUND UP 2DEC	Round up to two decimal places.	Rounds up to two decimal places.
Rounding Rule	GP ROUND DOWN 0DEC	Round down to zero decimal places.	Rounds down (truncates) to zero decimal places.
Rounding Rule	GP ROUND DOWN 2DEC	Round down to two decimal places.	Rounds down (truncates) to two decimal places.
Variable	GP TEMP001 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP002 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP003 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP004 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP005 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP006 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP007 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP008 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP009 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP010 CHAR	Temporary variable - character.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP001 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP002 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP003 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP004 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP005 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP006 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP007 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP008 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP009 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP010 NUM	Temporary variable - number.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP001 DATE	Temporary variable - date.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP002 DATE	Temporary variable - date.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP003 DATE	Temporary variable - date.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP004 DATE	Temporary variable - date.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP TEMP005 DATE	Temporary variable - date.	For use in formulas as a temporary variable (to calculate intermediate results).
Variable	GP PRD END DATE YR	Period end date - year.	Stores the calendar period year if the date element GP PRD END DT EXTR is resolved. Note: The date element GP PRD END DT EXTR extracts the year from the calendar period and populates the variable GP PRD END DATE DY. For this date extract and corresponding variable to be resolved, either put this date element directly on the process list (include it in a section) or reference it in another element that is being resolved.
Variable	GP PRD END DATE MO	Period end date - month.	Stores the calendar period month if the date element GP PRD END DT EXTR is resolved. Note: The date element GP PRD END DT EXTR extracts the month from the calendar period and populates the variable GP PRD END DATE DY. For this date extract and corresponding variable to be resolved, either put this date element directly on the process list (include it in a section) or reference it in another element that is being resolved.
Variable	GP PRD END DATE DY	Period end date - day.	Stores the calendar period day, if the date element GP PRD END DT EXTR is resolved. Note: The date element GP PRD END DT EXTR extracts the day from the calendar period and populates the variable GP PRD END DATE DY. For this date extract and corresponding variable to be resolved, either put this date element directly on the process list (include it in a section) or reference it in another element that is being resolved.
Variable	GP TRUE	True.	Default is 1. Can be used in conjunction with formulas to set a value that is equal to True, which can then be used to validate against generation control or other checks.
Variable	GP FALSE	False.	Default is 0. Can be used in conjunction with formulas to set a value to False, which can then be used to validate against generation control or other checks.
Variable	GP ACTIVE	Active.	Default is A (active). Can be used in conjunction with formulas to check and compare with an active or inactive status that is retrieved from a different table.
Variable	GP GL AFF INTRA1	Affiliate Intra 1 - Chartfield
Variable	GP GL AFF INTRA2	Affiliate Intra 2 - Chartfield
Variable	GP GL AFFILIATE	Affiliate - Chartfield
Variable	GP GL ALT ACCOUNT	Alternate Account - Chartfield
Variable	GP GL BUDGET REF	Budget Reference - Chartfield
Variable	GP GL CHARTFIELD1	Chartfield 1 - Chartfield
Variable	GP GL CHARTFIELD2	Chartifeld2 - Chartfield
Variable	GP GL CHARTFIELD3	Chartfield 3 - Chartfield
Variable	GP GL CLASS	Class Field - Chartfield
Variable	GP GL DEPT	GL Department - Chartfield
Variable	GP GL FUND	Fund Code - Chartfield
Variable	GP GL OP UNIT	Operating Unit - Chartfield
Variable	GP GL PRODUCT	Product - Chartfield
Variable	GP GL PROGRAM	Program Code - Chartfield
Variable	GP GL PROJECT	Program Code - Chartfield
Variable	GP NULL DATE	Null Date	Used within rules when a reference to a 'null' date needs to be checked (or initialized).
Variable	GP PMNT DATE DY	Payment Date - Day	Stores the Calendar Payment Date 'Day' - if the Date GP PMNT DT EXTR is resolved. Note: The Date element GP PMNT DT EXTR will extract the 'day' from the Calendar Period and populate the variable GP PMNT DATE DY.
Variable	GP PMNT DATE MO	Payment Date - Month	Stores the Calendar Payment Date 'Month' - if the Date GP PMNT DT EXTR is resolved. Note: The Date Element GP PMNT DT EXTR will extract the 'month' from the Calendar Period and populate the Variable GP PMNT DATE MO.
Variable	GP PMNT DATE YR	Payment End Date - Year	Stores the Calendar Payment Date 'Year' - if the Date GP PMNT DT EXTR is resolved. Note: The Date Element GP PMNT DT EXTR will extract the 'year' from the Calendar Period and populate the Variable GP PMNT DATE YR.
Variable	GP PRD BGN DATE DY	Period Begin Date - Day	Stores the Calendar Period Begin Date 'Day' - if the Date GP PRD BGN DT EXTR is resolved. Note: The Date Element GP PRD BGN DT EXTR will extract the 'day' from the Calendar Period and populate the Variable GP PRD BGN DATE DY.
Variable	GP PRD BGN DATE MO	Period Begin Date - Month	Stores the Calendar Period Begin Date 'Month' - if the Date GP PRD BGN DT EXTR is resolved. Note: The Date Element GP PRD BGN DT EXTR will extract the 'month' from the Calendar Period and populate the Variable GP PRD BGN DATE DY.
Variable	GP PRD BGN DATE YR	Period Begin Date - Year	Stores the Calendar Period Begin Date 'Year' - if the Date GP PRD BGN DT EXTR is resolved. Note: The Date Element GP PRD BGN DT EXTR will extract the 'year' from the Calendar Period and populate the Variable GP PRD BGN DATE DY.
Variable	GP PSLP ASOF	Payslip Message Duration As Of	Message definition - if using date for duration- date is as of what?
Variable	GP PSLP CAL RUN	Payslip Message Calendar Run	Message definition calendar run only populated if Duration of message = Calendar
Variable	GP PSLP EMPLID	Payslip Message Employee ID	Message definition EmplID only populated if Population criteria is EmplID.
Variable	GP PSLP FM NUM	Payslip Message	Message definition FM NUM only populated if population criteria is 'custom formula'
Variable	GP PSLP FROM DT	Payslip Message From Date	Message definition From Date only populated if duration of message is as of a date
Variable	GP PSLP GP	Payslip Message Assign Method	Message definition - Assignment Method
Variable	GP PSLP GRP ID	Payslip Message Group ID	Message definition Group ID only populated if GP Group Build is Population criteria.
Variable	GP PSLP MSG CTRY	Payslip Message Country	Country of message definition (key to message definition)
Variable	GP PSLP MSG NBR	Payslip Message Number	Message number from payslip definition (key to message definition)
Variable	GP PSLP PLIST	Payslip Message HR Group List	Message definition HR Group List only populated if HR Group List is Population criteria.
Variable	GP PSLP SEL	Payslip Message Select	Message definition - population selection criteria
Variable	GP PSLP STATUS	Payslip Message Status	Status of message "active or inactive"
Variable	GP PSLP TO DT	Payslip Message To Date	Message definition To Date optionally populated if duration of message is as of a date
Variable	GP SEG BGN DATE DY	Segment Begin Date - Day
Variable	GP SEG BGN DATE MO	Segment Begin Date - Month
Variable	GP SEG BGN DATE YR	Segment Begin Date - Year
Variable	GP SEG END DATE DY	Segment End Date - Day
Variable	GP SEG END DATE MO	Segment End Date - Month
Variable	GP SEG END DATE YR	Segment End Date - Year
Variable	GP SLI BGN DATE DY	Slice Begin Date - Day
Variable	GP SLI BGN DATE MO	Slice Begin Date - Month
Variable	GP SLI BGN DATE YR	Slice Begin Date - Year
Variable	GP SLI END DATE DY	Slice End Date - Day
Variable	GP SLI END DATE MO	Slice End Date - Month
Variable	GP SLI END DATE YR	Slice End Date - Year
Writable Array	GP WA GUIDE	WA Segmentation Guide	Used for integration with EPM. To use it, just add the WA to any section. The writable array will not cause the resolution of the system elements defined in the Writable Array Fields grid.
Writable Array	GP WA PSLP MSG	Payslip Messages	Payslip Messages writable array

Đọc tiếp...

Xem bài viết trên phiên bản di động