GP_SS_NPD_CNFVW (SQL View)	Index Back
Global Payroll Run Type View Global Payroll Self Service. View of run types (by employee) available for a self service user to specify a net pay distribution. This view is a consolidation of: 1) Net Pay configuration where the run-type is set-up as being available for use and where it can be locked or un-locked - by Country 2) The countries that are applicable for the paygroups of the jobs this employee does (provided by view GP_SSEEPGCTRYVW).

GP_SS_NPD_CNFVW

(SQL View)

Global Payroll Run Type View

Global Payroll Self Service. View of run types (by employee) available for a self service user to specify a net pay distribution. This view is a consolidation of: 1) Net Pay configuration where the run-type is set-up as being available for use and where it can be locked or un-locked - by Country 2) The countries that are applicable for the paygroups of the jobs this employee does (provided by view GP_SSEEPGCTRYVW).

SELECT C.EMPLID ,C.EMPL_RCD ,R.COUNTRY ,R.RUN_TYPE ,R1.DESCR ,R.GP_SS_NPD_LOCKED ,R.DEFAULT_IND FROM PS_GP_RUN_TYPE R1 , PS_GP_SSEEPGCTRYVW C , PS_GP_SS_NPD_CONF R WHERE R1.RUN_TYPE = R.RUN_TYPE AND C.COUNTRY = R.COUNTRY

Related Language Record: GP_NPDCNFVW_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 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

4 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
Prompt Table: GP_RUN_TYPE

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

6 GP_SS_NPD_LOCKED Character(1) VARCHAR2(1) NOT NULL Global Payroll Self Service Run Type Locked
Y/N Table Edit
Default Value: N

7 DEFAULT_IND Character(1) VARCHAR2(1) NOT NULL An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default.

#	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	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
4	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name Prompt Table: GP_RUN_TYPE
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	GP_SS_NPD_LOCKED	Character(1)	VARCHAR2(1) NOT NULL	Global Payroll Self Service Run Type Locked Y/N Table Edit Default Value: N
7	DEFAULT_IND	Character(1)	VARCHAR2(1) NOT NULL	An internal flag used by Benefits Administration to indicate whether a specific benefit option is the 'default' option - that is, if the employee fails to make a valid election, this option will be enrolled by default.