Integration Tables between HCM and ADP PAISY

PeopleSoft HCM delivers the following integration records to support the GPS payroll interface between HCM and ADP PAISY:

GPS_INBOUND_DATA

This table lists the GPS_INBOUND_DATA record fields:

Field Name	Description
EMPLID	Employee ID
EMPL_RCD	Employee Record Number
BGN_DT	Begin Date
END_DT	End Date
GPS_CHILD_ALLOW_NR	Child Allowance Number
GPDE_AL_SEQCE_NBR	Number of Child
GPS_NOTIFIC_SRC	Notification Source
GPS_BASE_AMOUNT	Child Allowance Base Amount
BIRTHDATE	Date of Birth
BIRTHPLACE	Birth Location
GPDE_DV_TIME	Timestamp
GPS_CHECK_FLAG	Marked as Read

GPS_POST_NOTIFY

This table lists the GPS_POST_NOTIFY record fields:

Field Name	Description
EMPLID	Employee ID
EMPL_RCD	Employee Record Number
EFFDT	Effective Date
EFFSEQ	Effective Sequence
GPS_NOTIFIC_SRC	Notification Source
ACTION	Action
BEGIN_DT	Begin Date
ACTION_REASON	Reason Code
RETURN_DT	Return Date
GPS_EF23U2_RPT	Gross Amount
GPS_EF25_RPT	Capital formation Services
GPS_EF26_RPT	Allowances
PIN_NM	Absence Element
GPS_CHECK_FLAG	Marked as Read

GPS_SAL_PLAN

This table lists the GPS_SAL_PLAN record fields:

Field Name	Description
EMPLID	Employee ID
EMPL_RCD	Employee Record Number
EFFDT	Effective Date
EFFSEQ	Effective Sequence
GPS_NOTIFIC_SRC	Notification Source
SAL_ADMIN_PLAN	Salary Administration Plan
GRADE	Salary Grade
STEP	Salary Step

GPS_COST_CENTER

This table lists the GPS_COST_CENTER record fields:

Field Name	Description
EMPLID	Employee ID
EMPL_RCD	Employee Record Number
EFFDT	Effective Date
GPS_COST_CENTER_CD	Cost Center
EFF_STATUS	Status as of Effective Date
GPS_PRIMARY_FLAG	Primary Flag
GPS_COST_RANGE	Cost Center Range
GPS_COST_PCT	Cost Center Percentage

GPS_COST_SETUP

This table lists the GPS_COST_SETUP record fields:

Field Name	Description
GPS_COST_RANGE	Cost Center Range
GPS_COST_CENTER_CD	Cost Center
EFFDT	Effective Date
EFF_STATUS	Status as of Effective Date
DESCR	Description