BAS_PAR_OPTN_V2

(SQL View)
 Index Back

BAS Partic OPTION_CD- Option

BAS_PAR_OPTN_V2 is a view used with the Benefits Administration data entry. It returns valid benefit options for election entry.

SELECT SCHED_ID ,EMPLID ,BENEFIT_RCD_NBR ,EVENT_ID ,DISPLAY_PLN_SEQ ,OPTION_CD ,OPTION_TYPE ,BENEFIT_PLAN ,COVRG_CD ,PROOF_REQ_IND ,OPTION_ID ,PAY_PERIOD1 ,PAY_PERIOD2 ,PAY_PERIOD3 ,PAY_PERIOD4 ,PAY_PERIOD5 FROM PS_BAS_PARTIC_OPTN WHERE OPTION_TYPE IN ('O', 'W') and HISTORY_ONLY = 'N'

# 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 DISPLAY_PLN_SEQ Character(2) VARCHAR2(2) NOT NULL Display Plan-type Sequence
6 OPTION_CD Character(3) VARCHAR2(3) NOT NULL Option Code
7 OPTION_TYPE Character(1) VARCHAR2(1) NOT NULL Option Type
D=General Deduction
G=General Credit
O=Option
P=Program
W=Waive Option
8 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan
9 COVRG_CD Character(2) VARCHAR2(2) NOT NULL Coverage Code

Prompt Table: COVRG_CD_TBL

10 PROOF_REQ_IND Character(1) VARCHAR2(1) NOT NULL Proof Required

Y/N Table Edit

11 OPTION_ID Number(4,0) SMALLINT NOT NULL Option ID
12 PAY_PERIOD1 Character(1) VARCHAR2(1) NOT NULL First Pay Period
13 PAY_PERIOD2 Character(1) VARCHAR2(1) NOT NULL Second Pay Period
14 PAY_PERIOD3 Character(1) VARCHAR2(1) NOT NULL Third Pay Period
15 PAY_PERIOD4 Character(1) VARCHAR2(1) NOT NULL Fourth Pay Period
16 PAY_PERIOD5 Character(1) VARCHAR2(1) NOT NULL Fifth Pay Period