BAS_PAR_SRCH_VW (SQL View)	Index Back
BAS Partic: Inquiry & Search This is a view of the BAS_PARTIC and EMPLMT_SRCH_GBL tables. EMPLMT_SRCH_GBL is an Employment Search record that takes row security into consideration. It is used in Inquiry and Search processes.

BAS_PAR_SRCH_VW

(SQL View)

BAS Partic: Inquiry & Search

This is a view of the BAS_PARTIC and EMPLMT_SRCH_GBL tables. EMPLMT_SRCH_GBL is an Employment Search record that takes row security into consideration. It is used in Inquiry and Search processes.

SELECT DISTINCT B.OPRID ,A.SCHED_ID ,A.EMPLID ,A.BENEFIT_RCD_NBR ,A.EVENT_ID ,A.BENEFIT_PROGRAM ,A.EVENT_CLASS ,A.EVENT_STATUS ,A.BAS_PROCESS_STATUS ,A.EVENT_DT FROM PS_BAS_PARTIC A , PS_EMPLMT_SRCH_GBL B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.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 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID
Prompt Table: BAS_SCHED

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

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

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

6 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
Prompt Table: BEN_DEFN_PGM

7 EVENT_CLASS Character(3) VARCHAR2(3) NOT NULL Event Classification
Prompt Table: BAS_EVT_CLASS

8 EVENT_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
C=Closed to Processing
D=Disconnected from Job Record
O=Open for Processing
V=Void

9 BAS_PROCESS_STATUS Character(2) VARCHAR2(2) NOT NULL Process Status
AE=Program Elig Assign Error
AN=Program Elig Assign None
AS=Program Elig Assigned
EE=Election Error
ET=Entered
FA=Finalized - Benefit Pgm None
FE=Finalized - Enrolled
FP=Finalized - Prepared None
NT=Notified
PE=Prepare Error
PR=Prepared
RE=Re-Enter

10 EVENT_DT Date(10) DATE NOT NULL Event Date

#	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	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID Prompt Table: BAS_SCHED
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
4	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.
5	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
6	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules. Prompt Table: BEN_DEFN_PGM
7	EVENT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Event Classification Prompt Table: BAS_EVT_CLASS
8	EVENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Event Status C=Closed to Processing D=Disconnected from Job Record O=Open for Processing V=Void
9	BAS_PROCESS_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Process Status AE=Program Elig Assign Error AN=Program Elig Assign None AS=Program Elig Assigned EE=Election Error ET=Entered FA=Finalized - Benefit Pgm None FE=Finalized - Enrolled FP=Finalized - Prepared None NT=Notified PE=Prepare Error PR=Prepared RE=Re-Enter
10	EVENT_DT	Date(10)	DATE NOT NULL	Event Date