BAS_PRNT_PAR_V3 (SQL View)	Index Back
BAS Prnt Partc-Sch Par EventID BAS_PRNT_PAR_V3 is a view used by the Benefits Administration Statement Print panel to return event IDs for the print list. The print list will be used in printing Enrollment or Confirmation statements.

BAS_PRNT_PAR_V3

(SQL View)

BAS Prnt Partc-Sch Par EventID

BAS_PRNT_PAR_V3 is a view used by the Benefits Administration Statement Print panel to return event IDs for the print list. The print list will be used in printing Enrollment or Confirmation statements.

SELECT SCHED_ID ,EMPLID ,BENEFIT_RCD_NBR ,EVENT_ID FROM PS_BAS_PARTIC WHERE BAS_PROCESS_STATUS IN ('PR','NT','EE','RE','ET','FE')

# 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

#	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