GP_MPSLP_STGMSG (SQL Table)	Index Back
Payslip Messages ePay Payslip Messages Staging record.

GP_MPSLP_STGMSG

(SQL Table)

Payslip Messages

ePay Payslip Messages Staging record.

# 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

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

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

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

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

8 GP_CNTRY_PSLP_MSG Character(3) VARCHAR2(3) NOT NULL Country

9 GP_PSLP_MSG_NBR Number(5,0) INTEGER NOT NULL This field will be used to identify the message number of the message that will be include on the on-line and hard-copy payslips,

10 GP_PSLP_MSG_PRIOTY Number(3,0) SMALLINT NOT NULL Payslip Message Priority
Default Value: 999

11 GP_PSLP_DTA_SRC Character(2) VARCHAR2(2) NOT NULL Mobile Payslip Data Source
CC=Core Payroll Calculation
CE=Country Extension Message
CP=Core Payslip Processing
OT=Other Message
Default Value: OT

12 GP_PSLP_MSG_TEXT Character(254) VARCHAR2(254) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

#	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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
5	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
6	ORIG_CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Original Calendar Group ID
7	RSLT_SEG_NUM	Number(4,0)	SMALLINT NOT NULL	Result Segment Number
8	GP_CNTRY_PSLP_MSG	Character(3)	VARCHAR2(3) NOT NULL	Country
9	GP_PSLP_MSG_NBR	Number(5,0)	INTEGER NOT NULL	This field will be used to identify the message number of the message that will be include on the on-line and hard-copy payslips,
10	GP_PSLP_MSG_PRIOTY	Number(3,0)	SMALLINT NOT NULL	Payslip Message Priority Default Value: 999
11	GP_PSLP_DTA_SRC	Character(2)	VARCHAR2(2) NOT NULL	Mobile Payslip Data Source CC=Core Payroll Calculation CE=Country Extension Message CP=Core Payslip Processing OT=Other Message Default Value: OT
12	GP_PSLP_MSG_TEXT	Character(254)	VARCHAR2(254) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.