GP_PSLP_PYE_OPT (SQL Table)	Index Back
Payslip payee delivery options This table will contain delivery options for a payee's payslip.

GP_PSLP_PYE_OPT

(SQL Table)

Payslip payee delivery options

This table will contain delivery options for a payee's payslip.

# 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 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 GP_PSLP_DLVRY_OPT Character(4) VARCHAR2(4) NOT NULL Payslip Delivery Option
ADDR=Address Type
DEPT=Department
DROP=Mail Drop
LOCN=Location
MAIL=Mailing Address
NONE=None
OTHL=Other Location
OTHM=Other Mail Drop
Default Value: NONE

6 GP_PSLP_PYE_ADRTYP Character(4) VARCHAR2(4) NOT NULL Payslip Payee Address Type
Prompt Table: ADDRESS_TYPE_VW

7 GP_PSLP_ALT_LOCADR Character(10) VARCHAR2(10) NOT NULL Payslip Alternate Location Address. This will tell the payslip process to use this location's address as the delivery address for the payee's payslip.
Prompt Table: LOCATION_TBL

8 GP_PSLP_ALT_DEPADR Character(10) VARCHAR2(10) NOT NULL Payslip Alternate Department Address. This will tell the payslip process to use this department's address as the delivery address for the payee's payslip.
Prompt Table: DEPT_TBL_ACCESS

9 GP_PSLP_MAIL_DROP Character(50) VARCHAR2(50) NOT NULL Payslip Mail Drop. This will tell the payslip process to use this mail drop as the delivery address for the payee's payslip.

10 GP_PSLP_OTHER_DROP Character(50) VARCHAR2(50) NOT NULL Other Mail Drop

11 GP_PSLP_PYE_NM_OPT Character(50) VARCHAR2(50) NOT NULL Payee Payslip Name Option

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

13 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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	GP_PSLP_DLVRY_OPT	Character(4)	VARCHAR2(4) NOT NULL	Payslip Delivery Option ADDR=Address Type DEPT=Department DROP=Mail Drop LOCN=Location MAIL=Mailing Address NONE=None OTHL=Other Location OTHM=Other Mail Drop Default Value: NONE
6	GP_PSLP_PYE_ADRTYP	Character(4)	VARCHAR2(4) NOT NULL	Payslip Payee Address Type Prompt Table: ADDRESS_TYPE_VW
7	GP_PSLP_ALT_LOCADR	Character(10)	VARCHAR2(10) NOT NULL	Payslip Alternate Location Address. This will tell the payslip process to use this location's address as the delivery address for the payee's payslip. Prompt Table: LOCATION_TBL
8	GP_PSLP_ALT_DEPADR	Character(10)	VARCHAR2(10) NOT NULL	Payslip Alternate Department Address. This will tell the payslip process to use this department's address as the delivery address for the payee's payslip. Prompt Table: DEPT_TBL_ACCESS
9	GP_PSLP_MAIL_DROP	Character(50)	VARCHAR2(50) NOT NULL	Payslip Mail Drop. This will tell the payslip process to use this mail drop as the delivery address for the payee's payslip.
10	GP_PSLP_OTHER_DROP	Character(50)	VARCHAR2(50) NOT NULL	Other Mail Drop
11	GP_PSLP_PYE_NM_OPT	Character(50)	VARCHAR2(50) NOT NULL	Payee Payslip Name Option
12	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.
13	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.