GP_PYE_HIST_WRK (SQL Table)	Index Back
History Segment Pointer History Segment Pointer for the Global Absence and Payroll process. The table is populated during the Identify phase and then emptied during the Cancel or Finalize phase for entries for that Cal Run ID. The purpose is to give the calculation process a pointer back to the most up-to-date balances.

GP_PYE_HIST_WRK

(SQL Table)

History Segment Pointer

History Segment Pointer for the Global Absence and Payroll process. The table is populated during the Identify phase and then emptied during the Cancel or Finalize phase for entries for that Cal Run ID. The purpose is to give the calculation process a pointer back to the most up-to-date balances.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

8 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

9 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID

10 HIST_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL History Calendar Run Id. Identifies the Calendar Run (or Group) in which the calendar now being pointed to as a starting point for balances was originally processed in. Table containing these pointers also contains CAL RUN ID identifying the Calendar Run (or Group) that is using this pointer.

11 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

13 CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation
B=All Calculations
P=Payroll Calculation

14 HIST_TYPE Character(1) VARCHAR2(1) NOT NULL History Pointer Type. Indicates whether the row represents a pointer to the globally last set of results or to the last set of results for a given CALC_TYPE. Used in batch processing to load the correct balance accumulator values Contains XLAT values
C=Calculation Type Hist Pointer
G=Global History Pointer

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
8	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
9	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
10	HIST_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	History Calendar Run Id. Identifies the Calendar Run (or Group) in which the calendar now being pointed to as a starting point for balances was originally processed in. Table containing these pointers also contains CAL RUN ID identifying the Calendar Run (or Group) that is using this pointer.
11	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Calculation Process Type. Identifies a run as either absence run or payroll run A=Absence Calculation B=All Calculations P=Payroll Calculation
14	HIST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	History Pointer Type. Indicates whether the row represents a pointer to the globally last set of results or to the last set of results for a given CALC_TYPE. Used in batch processing to load the correct balance accumulator values Contains XLAT values C=Calculation Type Hist Pointer G=Global History Pointer