GP_NRP_PSMSG_AD (SQL Table)	Index Back
Payslip Messages Payslip messages

GP_NRP_PSMSG_AD

(SQL Table)

Payslip Messages

Payslip messages

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

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

3 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,

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

5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

6 GP_PSLP_MSG_AVAIL Character(1) VARCHAR2(1) NOT NULL Message Availability
A=Always Active
C=Calendar Group ID
D=Date Range

7 GP_PSLP_POPUL_SEL Character(1) VARCHAR2(1) NOT NULL Payslip Population Selection
A=All Payees
E=Payee
F=Formula Element
G=Human Resources Group
O=Other Criteria
P=Global Payroll Payee List

8 GP_PSLP_MSG_METHOD Character(1) VARCHAR2(1) NOT NULL Payslip Message Method
C=Payroll Calculation
P=Payslip Processing

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

10 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

11 GP_FROM_DT Date(10) DATE From Date

12 GP_TO_DT Date(10) DATE To Date

13 DEFN_ASOFDT_OPTN Character(1) VARCHAR2(1) NOT NULL DEFN_ASOFDT_OPTN
B=Calendar Period Begin Date
E=Calendar Period End Date
N=Not Applicable
P=Payment Date
R=Process Begin Date
S=Process End Date

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

15 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

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

17 PIN_FRML_NUM Number(8,0) INTEGER NOT NULL Element number field

18 GP_PSLP_MSG_PRIOTY Number(3,0) SMALLINT NOT NULL Payslip Message Priority

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

20 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

21 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	GP_CNTRY_PSLP_MSG	Character(3)	VARCHAR2(3) NOT NULL	Country
3	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,
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	GP_PSLP_MSG_AVAIL	Character(1)	VARCHAR2(1) NOT NULL	Message Availability A=Always Active C=Calendar Group ID D=Date Range
7	GP_PSLP_POPUL_SEL	Character(1)	VARCHAR2(1) NOT NULL	Payslip Population Selection A=All Payees E=Payee F=Formula Element G=Human Resources Group O=Other Criteria P=Global Payroll Payee List
8	GP_PSLP_MSG_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Payslip Message Method C=Payroll Calculation P=Payslip Processing
9	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
10	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
11	GP_FROM_DT	Date(10)	DATE	From Date
12	GP_TO_DT	Date(10)	DATE	To Date
13	DEFN_ASOFDT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	DEFN_ASOFDT_OPTN B=Calendar Period Begin Date E=Calendar Period End Date N=Not Applicable P=Payment Date R=Process Begin Date S=Process End Date
14	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
15	GB_GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Group Build ID.
16	GROUP_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	Group List
17	PIN_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
18	GP_PSLP_MSG_PRIOTY	Number(3,0)	SMALLINT NOT NULL	Payslip Message Priority
19	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.
20	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
21	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.