vietnamese Tiếng Việt english English Giới Thiệu
Hôm nay:
Tin mới đăng:
  • image01
  • image02
  • image03
  • image04

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

Global Payroll

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)


Global Payroll

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

Global Payroll