GP_KIB_OP_TBL (SQL Table)	Index Back
GP INS Trends Pre-Prcs Stg GP Insights Pre-Process Staging Table for Operation Trends.

GP_KIB_OP_TBL

(SQL Table)

GP INS Trends Pre-Prcs Stg

GP Insights Pre-Process Staging Table for Operation Trends.

Related Language Record: GP_KIB_OP_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 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

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

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

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

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

19 PRD_BGN_DT Date(10) DATE Period Begin Date

20 PRD_END_DT Date(10) DATE Pay Period End Date

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

22 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value

23 RSLT_NOT_TKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Not Taken

24 PYMT_DT Date(10) DATE Payment Date

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

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

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

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

29 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

30 GP_PA_HIRE_DT Date(10) DATE used in payroll analytics

31 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

32 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp

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

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

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

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

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

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

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

40 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.

41 GP_FREQUENCY Character(30) VARCHAR2(30) NOT NULL Calendar Frequency Insights

42 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

43 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer

44 GP_PAYMENT_MTHD Character(30) VARCHAR2(30) NOT NULL Payment Method Insights

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

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

47 GP_EMPL_STAT_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Status used for GP Insights Operation Insight

48 GP_PIN_DESCR Character(30) VARCHAR2(30) NOT NULL GP Element Description for Insights

49 GP_PER_YYYY_MM Character(7) VARCHAR2(7) NOT NULL Calendar Period in format YYYY MM (year and month) is used in GP Insights Payroll Operations dashboard functionality.

50 GP_KIB_GBL_DTTM DateTime(26) TIMESTAMP Datetime field for Insights GP Operations dashboard.

51 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	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
15	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
16	GP_ED_LABEL	Character(30)	VARCHAR2(30) NOT NULL	User Field 1-Label, this label will be displayed in the E/D Assignment Pages
17	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type
18	PIN_NET_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
19	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
20	PRD_END_DT	Date(10)	DATE	Pay Period End Date
21	GP_CALC_VAL1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	GP Calculation value 1
22	CALC_ADJ_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Adjustment Value
23	RSLT_NOT_TKN	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount Not Taken
24	PYMT_DT	Date(10)	DATE	Payment Date
25	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
26	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
27	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
28	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
29	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
30	GP_PA_HIRE_DT	Date(10)	DATE	used in payroll analytics
31	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
32	PRC_ORD_TS	DateTime(26)	TIMESTAMP	Process Order Timestamp
33	DEPT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Department Description
34	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description
35	LOCATION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Location Description
36	BUSINESS_DESCR	Character(60)	VARCHAR2(60) NOT NULL	Business Description
37	ESTAB_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
38	GP_PA_COMP_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Used in payroll analytics
39	GP_LABEL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Label name.
40	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.
41	GP_FREQUENCY	Character(30)	VARCHAR2(30) NOT NULL	Calendar Frequency Insights
42	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ?
43	PAYMENT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Payment Method A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer
44	GP_PAYMENT_MTHD	Character(30)	VARCHAR2(30) NOT NULL	Payment Method Insights
45	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
46	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
47	GP_EMPL_STAT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Employee Status used for GP Insights Operation Insight
48	GP_PIN_DESCR	Character(30)	VARCHAR2(30) NOT NULL	GP Element Description for Insights
49	GP_PER_YYYY_MM	Character(7)	VARCHAR2(7) NOT NULL	Calendar Period in format YYYY MM (year and month) is used in GP Insights Payroll Operations dashboard functionality.
50	GP_KIB_GBL_DTTM	DateTime(26)	TIMESTAMP	Datetime field for Insights GP Operations dashboard.
51	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)