GP_KIB_ED_TBL (SQL Table)	Index Back
GP INS Pre-Process Staging GP Insights Pre-Process Staging Table

GP_KIB_ED_TBL

(SQL Table)

GP INS Pre-Process Staging

GP Insights Pre-Process Staging Table

Related Language Record: GP_KIB_ED_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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

6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

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

8 GP_PRVS_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

9 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

10 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

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

12 GP_CATEGORY_ID Character(3) VARCHAR2(3) NOT NULL Category ID for Chatbot category setup

13 GP_PRVS_CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

14 CURR_PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

15 PRVS_PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

17 GP_ED_LABEL Character(30) VARCHAR2(30) NOT NULL User Field 1-Label, this label will be displayed in the E/D Assignment Pages

18 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

19 SEG_CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result

20 CALC_CURR_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result

21 CALC_PRVS_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result

22 CALC_DIFF_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result

23 CALC_PDIFF_RSL_VAL Signed Number(16,2) DECIMAL(14,2) NOT NULL Calculation Numeric Result

24 SEG_UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation

25 UNIT_CURR_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation

26 UNIT_PRVS_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation

27 UNIT_DIFF_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation

28 UNIT_PDIFF_RSL_VAL Signed Number(16,2) DECIMAL(14,2) NOT NULL Number of units used in result calculation

29 GP_SEG_COUNT Number(3,0) SMALLINT NOT NULL Used in payroll analytics

30 PRD_BGN_DT Date(10) DATE Period Begin Date

31 PRD_END_DT Date(10) DATE Pay Period End Date

32 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date

33 SEG_END_DT Date(10) DATE Payee Process Segment's End Date

34 GP_CALC_VAL1 Signed Number(20,6) DECIMAL(18,6) NOT NULL GP Calculation value 1

35 GP_CALC_VAL2 Signed Number(20,6) DECIMAL(18,6) NOT NULL GP Calculation value 2

36 PYMT_DT Date(10) DATE Payment Date

37 SETID_EMPL_CLASS Character(5) VARCHAR2(5) NOT NULL Employee class Set ID

38 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

39 DESCR Character(30) VARCHAR2(30) NOT NULL Description

40 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

41 ASOF_DT_EXCHNG_RT Character(1) VARCHAR2(1) NOT NULL As of Date for Exchange Rate
B=Pay Period Begin Date
E=Pay Period End Date
P=Payment Date

42 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

43 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

44 EFFDT Date(10) DATE Effective Date

45 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result

46 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value

47 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation

48 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value

49 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value

50 CALC_RSLT_SUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Summary of calculations

51 UNIT_RSLT_SUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Summary of units used in result calculation

52 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

53 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

54 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

55 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

56 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

57 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

58 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

59 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

60 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence

61 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

62 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

63 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

64 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

65 GP_INCLUDE_RETRO Character(2) VARCHAR2(2) NOT NULL used in payroll analytics
N=No
Y=Yes

66 GP_MULT_INS_EXIST Character(2) VARCHAR2(2) NOT NULL Used in Payroll Analytics
N=No
Y=Yes

67 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

68 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

69 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

70 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

71 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

72 GP_PA_HIRE_DT Date(10) DATE used in payroll analytics

73 TERMINATION_DT Date(10) DATE Termination Date

74 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

75 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

76 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List

77 PYE_CALC_STAT Character(2) VARCHAR2(2) NOT NULL Calculation Status: field indicates the processing status of a segment (payment)
00=Identified
02=Calculation Error
03=Calculation Error - Bypassed
04=Calculation Error - By Rule
11=No Segment Created
50=Calculation Successful
55=Frozen For Further Calc
70=Finalized
75=Finalized - With Banking

78 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

79 GP_SEG_EXISTS Character(1) VARCHAR2(1) NOT NULL multiple segments exist
N=No
Y=Yes

80 GP_RPT_RETRO Character(1) VARCHAR2(1) NOT NULL Retroactivity Type
1=Original
2=Recalculation
3=Prior Calculation
4=Last Version/Revision
5=Result Delta - Corrective
6=Result Delta - Forwarded

81 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description

82 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description

83 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description

84 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description

85 ESTAB_DESCR Character(30) VARCHAR2(30) NOT NULL Description

86 GP_PA_COMP_DESCR Character(30) VARCHAR2(30) NOT NULL Used in payroll analytics

87 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date

88 SLICE_END_DT Date(10) DATE Element Slice End Date

89 GP_EMPL_COUNT Character(14) VARCHAR2(14) NOT NULL Employee count per segment

90 GP_LABEL_NAME Character(30) VARCHAR2(30) NOT NULL Label name.

91 GP_RPT_BGN_DT Date(10) DATE Payment begin date

92 GP_RPT_END_DT Date(10) DATE Payment end date

93 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.

94 PIN_GROSS_NUM Number(8,0) INTEGER NOT NULL Element number field

95 PIN_NET_NUM Number(8,0) INTEGER NOT NULL Element number field

96 SEG_PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

97 GP_C_PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

98 GP_P_PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

99 GP_DIFF_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

100 SEG_PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

101 GP_C_PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value

102 GP_P_PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value

103 GP_DIFF_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value

104 GP_PARENT_SEQ Number(2,0) SMALLINT NOT NULL Sequence number for each parent row used while storing the Run data of Payment File Generation (SEPA/Financial Gateway)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
4	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
5	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
7	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
8	GP_PRVS_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
9	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
10	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
11	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
12	GP_CATEGORY_ID	Character(3)	VARCHAR2(3) NOT NULL	Category ID for Chatbot category setup
13	GP_PRVS_CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
14	CURR_PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
15	PRVS_PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
16	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
17	GP_ED_LABEL	Character(30)	VARCHAR2(30) NOT NULL	User Field 1-Label, this label will be displayed in the E/D Assignment Pages
18	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type
19	SEG_CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
20	CALC_CURR_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
21	CALC_PRVS_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
22	CALC_DIFF_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
23	CALC_PDIFF_RSL_VAL	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Calculation Numeric Result
24	SEG_UNIT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
25	UNIT_CURR_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
26	UNIT_PRVS_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
27	UNIT_DIFF_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
28	UNIT_PDIFF_RSL_VAL	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Number of units used in result calculation
29	GP_SEG_COUNT	Number(3,0)	SMALLINT NOT NULL	Used in payroll analytics
30	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
31	PRD_END_DT	Date(10)	DATE	Pay Period End Date
32	SEG_BGN_DT	Date(10)	DATE	Payee Process Segment's Begin Date
33	SEG_END_DT	Date(10)	DATE	Payee Process Segment's End Date
34	GP_CALC_VAL1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GP Calculation value 1
35	GP_CALC_VAL2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GP Calculation value 2
36	PYMT_DT	Date(10)	DATE	Payment Date
37	SETID_EMPL_CLASS	Character(5)	VARCHAR2(5) NOT NULL	Employee class Set ID
38	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
39	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
40	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
41	ASOF_DT_EXCHNG_RT	Character(1)	VARCHAR2(1) NOT NULL	As of Date for Exchange Rate B=Pay Period Begin Date E=Pay Period End Date P=Payment Date
42	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
43	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
44	EFFDT	Date(10)	DATE	Effective Date
45	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
46	BASE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculated Base Value
47	UNIT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Number of units used in result calculation
48	RATE_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
49	PCT_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Percent Result Value
50	CALC_RSLT_SUM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Summary of calculations
51	UNIT_RSLT_SUM	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Summary of units used in result calculation
52	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
53	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
54	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
55	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
56	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
57	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
58	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
59	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
60	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
61	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
62	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
63	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
64	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
65	GP_INCLUDE_RETRO	Character(2)	VARCHAR2(2) NOT NULL	used in payroll analytics N=No Y=Yes
66	GP_MULT_INS_EXIST	Character(2)	VARCHAR2(2) NOT NULL	Used in Payroll Analytics N=No Y=Yes
67	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
68	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
69	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
70	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
71	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
72	GP_PA_HIRE_DT	Date(10)	DATE	used in payroll analytics
73	TERMINATION_DT	Date(10)	DATE	Termination Date
74	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
75	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
76	GROUP_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Group List
77	PYE_CALC_STAT	Character(2)	VARCHAR2(2) NOT NULL	Calculation Status: field indicates the processing status of a segment (payment) 00=Identified 02=Calculation Error 03=Calculation Error - Bypassed 04=Calculation Error - By Rule 11=No Segment Created 50=Calculation Successful 55=Frozen For Further Calc 70=Finalized 75=Finalized - With Banking
78	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
79	GP_SEG_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	multiple segments exist N=No Y=Yes
80	GP_RPT_RETRO	Character(1)	VARCHAR2(1) NOT NULL	Retroactivity Type 1=Original 2=Recalculation 3=Prior Calculation 4=Last Version/Revision 5=Result Delta - Corrective 6=Result Delta - Forwarded
81	DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department Description
82	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description
83	LOCATION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Location Description
84	BUSINESS_DESCR	Character(60)	VARCHAR2(60) NOT NULL	Business Description
85	ESTAB_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
86	GP_PA_COMP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Used in payroll analytics
87	SLICE_BGN_DT	Date(10)	DATE	Element Slice Begin Date
88	SLICE_END_DT	Date(10)	DATE	Element Slice End Date
89	GP_EMPL_COUNT	Character(14)	VARCHAR2(14) NOT NULL	Employee count per segment
90	GP_LABEL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Label name.
91	GP_RPT_BGN_DT	Date(10)	DATE	Payment begin date
92	GP_RPT_END_DT	Date(10)	DATE	Payment end date
93	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
94	PIN_GROSS_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
95	PIN_NET_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
96	SEG_PIN_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
97	GP_C_PIN_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
98	GP_P_PIN_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
99	GP_DIFF_GROSS_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
100	SEG_PIN_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
101	GP_C_PIN_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Net Pay Value
102	GP_P_PIN_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Net Pay Value
103	GP_DIFF_NET_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Gross Pay Value
104	GP_PARENT_SEQ	Number(2,0)	SMALLINT NOT NULL	Sequence number for each parent row used while storing the Run data of Payment File Generation (SEPA/Financial Gateway)