GP_NETDIST_VW (SQL View)	Index Back
Net Distribution View Global Payroll Self Service view of GP_NET_DIST Top level information of payee's net pay distribution.

GP_NETDIST_VW

(SQL View)

Net Distribution View

Global Payroll Self Service view of GP_NET_DIST Top level information of payee's net pay distribution.

SELECT EMPLID , EMPL_RCD , RUN_TYPE ,DEFAULT_IND FROM PS_GP_NET_DIST

# 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 Rcd Nbr

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

4 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.
Y/N Table Edit
Default Value: N

#	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 Rcd Nbr
3	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name Prompt Table: GP_RUN_TYPE
4	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. Y/N Table Edit Default Value: N