FSA_PAYMT_SRCH (SQL View)	Index Back
Search Vw-FSA Payments FSA_PAYMENT_SRCH is a view of FSA payments made to an employee. This can also be a historical record by calendar year which gives payment information (check no. and date) and payee.

FSA_PAYMT_SRCH

(SQL View)

Search Vw-FSA Payments

FSA_PAYMENT_SRCH is a view of FSA payments made to an employee. This can also be a historical record by calendar year which gives payment information (check no. and date) and payee.

SELECT %subrec(EMPLMT_BEN_SBR, SEC) ,FP.FORM_ID ,FP.PAYCHECK_NBR ,FP.CHECK_DT ,FP.FSA_PAYMENT_STATUS ,FP.CALENDAR_YEAR FROM PS_EMPL_BEN_SRCH SEC , PS_FSA_PAYMENT FP WHERE FP.EMPLID=SEC.EMPLID AND FP.EMPL_RCD=SEC.EMPL_RCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Benefit Record Number

5 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

6 NAME Character(50) VARCHAR2(50) NOT NULL Name

7 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

9 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
Prompt Table: SETID_TBL

10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: PERS_DEPT_VW

11 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

12 PRIMARY_ERN Number(4,0) SMALLINT NOT NULL Benefits Pre Upgrade Step primary_ern value set by client

13 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
Prompt Table: POI_TYPE_TBL

14 FORM_ID Character(6) VARCHAR2(6) NOT NULL Form Identification

15 PAYCHECK_NBR Number(15,0) DECIMAL(15) NOT NULL Paycheck number.

16 CHECK_DT Date(10) DATE Check date.

17 FSA_PAYMENT_STATUS Character(1) VARCHAR2(1) NOT NULL FSA Payment Status
P=Paid
R=Pay This Run
V=Void Check
X=Reversed Check

18 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Benefit Record Number
5	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Prompt Table: SETID_TBL
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: PERS_DEPT_VW
11	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
12	PRIMARY_ERN	Number(4,0)	SMALLINT NOT NULL	Benefits Pre Upgrade Step primary_ern value set by client
13	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS. Prompt Table: POI_TYPE_TBL
14	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
15	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
16	CHECK_DT	Date(10)	DATE	Check date.
17	FSA_PAYMENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	FSA Payment Status P=Paid R=Pay This Run V=Void Check X=Reversed Check
18	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year