GPSC_SSB_D_A_VW (SQL View)	Index Back
Global Payroll NetPayDist Vw This view provides an employee's all net pay distribution rows.

GPSC_SSB_D_A_VW

(SQL View)

Global Payroll NetPayDist Vw

This view provides an employee's all net pay distribution rows.

SELECT A.EMPLID ,A.EMPL_RCD ,A.RUN_TYPE ,A.EFFDT ,A.INSTANCE ,A.PAYMENT_MTHD ,A.ACCOUNT_ID ,A.PARTIAL_ALLOWED ,A.PRIMARY_ACCT_IND ,A.PERCENT_RATE ,A.DISTRIB_AMT ,A.CURRENCY_CD ,A.DEFAULT_IND ,A.GPSC_SSB_EFF_STA FROM PS_GPSC_SSB_DFL_VW A UNION SELECT B.EMPLID ,B.EMPL_RCD ,B.RUN_TYPE ,B.EFFDT ,B.INSTANCE ,B.PAYMENT_MTHD ,B.ACCOUNT_ID ,B.PARTIAL_ALLOWED ,B.PRIMARY_ACCT_IND ,B.PERCENT_RATE ,B.DISTRIB_AMT ,B.CURRENCY_CD ,B.DEFAULT_IND ,B.GPSC_SSB_EFF_STA B FROM PS_GPSC_SSB_D_F_VW B UNION SELECT C.EMPLID ,C.EMPL_RCD ,C.RUN_TYPE ,C.EFFDT ,C.INSTANCE ,C.PAYMENT_MTHD ,C.ACCOUNT_ID ,C.PARTIAL_ALLOWED ,C.PRIMARY_ACCT_IND ,C.PERCENT_RATE ,C.DISTRIB_AMT ,C.CURRENCY_CD ,C.DEFAULT_IND ,C.GPSC_SSB_EFF_STA B FROM PS_GPSC_SSB_D_H_VW C

# 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 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name

4 EFFDT Date(10) DATE NOT NULL Effective Date

5 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

6 PAYMENT_MTHD Character(1) VARCHAR2(1) NOT NULL Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer

7 ACCOUNT_ID Number(3,0) SMALLINT NOT NULL Account ID
Prompt Table: GP_PYE_ACCT1_VW

8 PARTIAL_ALLOWED Character(1) VARCHAR2(1) NOT NULL Partial amounts allowed to be distributed.
Y/N Table Edit

9 PRIMARY_ACCT_IND Character(1) VARCHAR2(1) NOT NULL Primary Account
Y/N Table Edit

10 PERCENT_RATE Number(6,2) DECIMAL(5,2) NOT NULL Percent

11 DISTRIB_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Distribution Amount

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

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

14 GPSC_SSB_EFF_STA Character(1) VARCHAR2(1) NOT NULL Status field
A=Active
I=Inactive

#	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	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
6	PAYMENT_MTHD	Character(1)	VARCHAR2(1) NOT NULL	Payment Method A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer
7	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID Prompt Table: GP_PYE_ACCT1_VW
8	PARTIAL_ALLOWED	Character(1)	VARCHAR2(1) NOT NULL	Partial amounts allowed to be distributed. Y/N Table Edit
9	PRIMARY_ACCT_IND	Character(1)	VARCHAR2(1) NOT NULL	Primary Account Y/N Table Edit
10	PERCENT_RATE	Number(6,2)	DECIMAL(5,2) NOT NULL	Percent
11	DISTRIB_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Distribution Amount
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
13	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.
14	GPSC_SSB_EFF_STA	Character(1)	VARCHAR2(1) NOT NULL	Status field A=Active I=Inactive