BAS_PAR_DPND_VW

(SQL View)
 Index Back

BAS Partic Inquiry- Dependent

BAS_PAR_DPND_VW is a view of dependents and beneficiaries. It is used with the Benefits Administration Inquiry.

SELECT SCHED_ID ,EMPLID ,BENEFIT_RCD_NBR ,EVENT_ID ,DISPLAY_PLN_SEQ ,DEPENDENT_BENEF ,ENROLL_ACTION ,BAS_ERROR ,BENEF_PCT ,FLAT_AMOUNT ,EXCESS ,CONTINGENT ,HLTH_PROVIDER_ID ,PREVIOUSLY_SEEN FROM PS_BAS_PARTIC_DPND

# 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 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

Prompt Table: DEPENDENT_VW

7 ENROLL_ACTION Character(1) VARCHAR2(1) NOT NULL Enroll Action
E=Enroll
N=None
T=Terminate
8 BAS_ERROR Character(1) VARCHAR2(1) NOT NULL BAS Error Type

Y/N Table Edit

9 BENEF_PCT Number(3,0) SMALLINT NOT NULL Percent Beneficiary Paid
10 FLAT_AMOUNT Signed Number(9,0) DECIMAL(8) NOT NULL Flat Amount
11 EXCESS Character(1) VARCHAR2(1) NOT NULL Excess
N=No
Y=Yes

Y/N Table Edit

12 CONTINGENT Character(1) VARCHAR2(1) NOT NULL Contingent

Y/N Table Edit

13 HLTH_PROVIDER_ID Character(30) VARCHAR2(30) NOT NULL Health Provider ID
14 PREVIOUSLY_SEEN Character(1) VARCHAR2(1) NOT NULL Previously Seen

Y/N Table Edit

Default Value: N