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

GPSC_SSB_D_H_VW

(SQL View)

Global Payroll NetPayDist Vw

This view provides an employee's net pay distribution history 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 ,C.DEFAULT_IND ,'I' FROM PS_GP_NET_DIST_DTL A , PS_GP_NET_DIST_DT B , PS_GP_NET_DIST C WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.RUN_TYPE = A.RUN_TYPE AND B.EFFDT = A.EFFDT AND C.EMPLID = B.EMPLID AND C.EMPL_RCD = B.EMPL_RCD AND C.RUN_TYPE = B.RUN_TYPE AND (A.EFFDT < %CurrentDateIn AND (NOT EXISTS ( SELECT 'Y' FROM PS_GPSC_SSB_DFL_VW D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.RUN_TYPE = A.RUN_TYPE AND D.ACCOUNT_ID = A.ACCOUNT_ID AND D.INSTANCE = A.INSTANCE AND D.PAYMENT_MTHD= A.PAYMENT_MTHD AND D.PARTIAL_ALLOWED=A.PARTIAL_ALLOWED AND D.PRIMARY_ACCT_IND= A.PRIMARY_ACCT_IND AND D.CURRENCY_CD= A.CURRENCY_CD AND D.PERCENT_RATE= A.PERCENT_RATE AND D.DISTRIB_AMT = A.DISTRIB_AMT )))

# 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