BAS_ACTIVITY (SQL Table)	Index Back
BAS Activity Repository BAS_ACTIVITY serves as a repository of online activity that have been identified as Benefits Administration event triggers. These triggers serve as a mechanism to initiate an event to be processed by Benefits Administration Event Maintenance. This table is fed by online PeopleCode triggers, by manually entered events and by the passive event batch process.

BAS_ACTIVITY

(SQL Table)

BAS Activity Repository

BAS_ACTIVITY serves as a repository of online activity that have been identified as Benefits Administration event triggers. These triggers serve as a mechanism to initiate an event to be processed by Benefits Administration Event Maintenance. This table is fed by online PeopleCode triggers, by manually entered events and by the passive event batch process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: BAS_EVT_EMPLID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 BAS_ACTION_SOURCE Character(2) VARCHAR2(2) NOT NULL Source of Action
BP=Benefits Person
EX=Multijob Trigger Explosion
ME=Manual Event
MJ=MultiJob Indicator Change
OE=Open Enrollment
PB=Passive Event Birthdate
PS=Passive Event Service Date
SN=Snapshot
TJ=Job Data Change
TL=Union Change
TP=Address Change
Default Value: ME

4 EVENT_DT Date(10) DATE NOT NULL Event Date

5 EVENT_EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence of Event

6 BAS_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment.
Prompt Table: BAS_EVT_MANUAL

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

8 COBRA_ACTION Character(3) VARCHAR2(3) NOT NULL Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only.
Prompt Table: CBR_EVENT_RULES

9 BAS_ALL_JOBS Character(1) VARCHAR2(1) NOT NULL Trigger All Jobs
Y/N Table Edit
Default Value: Y

10 BAS_SUPPRESS_FORMS Character(1) VARCHAR2(1) NOT NULL This field indicates whether or not enrollment and/or confirmation forms should be printed or suppressed for an event. This flag can be set at the event rule level or at the employee/event level.
B=Print Both Forms
C=Print Confirmation Forms Only
E=Print Enrollment Forms Only
S=Suppress Print of Both Forms

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: BAS_EVT_EMPLID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	BAS_ACTION_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Source of Action BP=Benefits Person EX=Multijob Trigger Explosion ME=Manual Event MJ=MultiJob Indicator Change OE=Open Enrollment PB=Passive Event Birthdate PS=Passive Event Service Date SN=Snapshot TJ=Job Data Change TL=Union Change TP=Address Change Default Value: ME
4	EVENT_DT	Date(10)	DATE NOT NULL	Event Date
5	EVENT_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence of Event
6	BAS_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a benefits-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and benefits eligibility. A BAS (PeopleSoft Benefits Administration System) action may correspond to a BAS Event Class, which defines how a benefits-related event is recognized and handled. Some examples of BAS actions (and event classes) are Hire, Family Status Change, and Open Enrollment. Prompt Table: BAS_EVT_MANUAL
7	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.
8	COBRA_ACTION	Character(3)	VARCHAR2(3) NOT NULL	Identifies a COBRA-related process or event that is associated with a personnel action action reason combination. This provides the link between various personnel changes (both job-related and personal) and COBRA benefits eligibility. A COBRA action may correspond to a COBRA event classification, which defines how a qualifying event is recognized and handled. Some examples of COBRA actions (and qualifying events) are Death, Divorce, Medicare, and Military Leave. U.S. only. Prompt Table: CBR_EVENT_RULES
9	BAS_ALL_JOBS	Character(1)	VARCHAR2(1) NOT NULL	Trigger All Jobs Y/N Table Edit Default Value: Y
10	BAS_SUPPRESS_FORMS	Character(1)	VARCHAR2(1) NOT NULL	This field indicates whether or not enrollment and/or confirmation forms should be printed or suppressed for an event. This flag can be set at the event rule level or at the employee/event level. B=Print Both Forms C=Print Confirmation Forms Only E=Print Enrollment Forms Only S=Suppress Print of Both Forms