GPIN_PSLP_MSG (SQL Table)	Index Back
Payslip Messages Payslip messages

GPIN_PSLP_MSG

(SQL Table)

Payslip Messages

Payslip messages

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
Prompt Table: GP_CAL_RUN_SRCH

2 GPIN_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,

3 GPIN_MSG_LVL Character(2) VARCHAR2(2) NOT NULL This field will be used to identify the level of the message that will be used on the on-line and hard-copy payslips.
A=All
G=Group Build
P=Payee List
Default Value: A

4 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
Prompt Table: GPIN_GROUP_VW

5 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List
Prompt Table: GP_GRP_LIST_VW

6 GPIN_MESSAGE Character(254) VARCHAR2(254) NOT NULL This field will be used to store the message that will be included on the on-line and hard-copy payslip

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GP_CAL_RUN_SRCH
2	GPIN_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,
3	GPIN_MSG_LVL	Character(2)	VARCHAR2(2) NOT NULL	This field will be used to identify the level of the message that will be used on the on-line and hard-copy payslips. A=All G=Group Build P=Payee List Default Value: A
4	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID. Prompt Table: GPIN_GROUP_VW
5	GROUP_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Group List Prompt Table: GP_GRP_LIST_VW
6	GPIN_MESSAGE	Character(254)	VARCHAR2(254) NOT NULL	This field will be used to store the message that will be included on the on-line and hard-copy payslip