BN_FINTRM_VW (SQL View)	Index Back
Base Partic Terminated View View of Base Participant Record from Benefits Administration process with Event Status of Open for Processing, Event Class of Terminated, BAS Process Status of Prepared and Enroll not Finalized.

BN_FINTRM_VW

(SQL View)

Base Partic Terminated View

View of Base Participant Record from Benefits Administration process with Event Status of Open for Processing, Event Class of Terminated, BAS Process Status of Prepared and Enroll not Finalized.

SELECT A.SCHED_ID , A.EMPLID , A.BENEFIT_RCD_NBR , A.EVENT_ID , B.NAME FROM PS_BAS_PARTIC A , PS_PERSON_NAME B WHERE A.EVENT_STATUS = 'O' AND A.EVENT_CLASS = 'TER' AND A.BAS_PROCESS_STATUS = 'PR' AND A.FINALIZE_ENROLL = 'N' AND A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID

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

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

4 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	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.
4	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name