PA_SP_EACCT_VW (SQL View)	Index Back
Plan Service Purchase Accounts This view selects all the Service Purchase Employee Accounts in a Benefit Plan

PA_SP_EACCT_VW

(SQL View)

Plan Service Purchase Accounts

This view selects all the Service Purchase Employee Accounts in a Benefit Plan

SELECT A.BENEFIT_PLAN , A.EFFDT , A.PROC_NAME , A.DESCR , A.FUNCTN_NAME FROM PS_PA_PROC_USE A , PS_PA_FNC_RSLT_TBL B WHERE A.BENEFIT_PLAN = B.BENEFIT_PLAN AND A.PROC_NAME=B.FUNCTN_RESULT_NM AND A.FUNCTN_NAME = B.FUNCTN_NAME AND B.EACCT_TYPE ='3'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name

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

5 FUNCTN_NAME Character(10) VARCHAR2(10) NOT NULL Function Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	FUNCTN_RESULT_NM	Character(10)	VARCHAR2(10) NOT NULL	Function Result Name
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	FUNCTN_NAME	Character(10)	VARCHAR2(10) NOT NULL	Function Name