BAS_SCHED (SQL Table)	Index Back
BAS Schedule Table Use BAS_SCHED to define Benefits Administration Schedules. The Schedule defines 'Who' and 'What' will be processed. 'What' is defined by the BAS type, Event Maintenance or Open Enrollment. Additionally for Open Enrollment, an Open Enrollment Definition is identified. This definition lists the benefit programs and plan types to include in the Open Enrollment processing. 'Who' is defined by a combination of Company and Bas group ID.

BAS_SCHED

(SQL Table)

BAS Schedule Table

Use BAS_SCHED to define Benefits Administration Schedules. The Schedule defines 'Who' and 'What' will be processed. 'What' is defined by the BAS type, Event Maintenance or Open Enrollment. Additionally for Open Enrollment, an Open Enrollment Definition is identified. This definition lists the benefit programs and plan types to include in the Open Enrollment processing. 'Who' is defined by a combination of Company and Bas group ID.

Related Language Record: BAS_SCHED_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 BAS_TYPE Character(1) VARCHAR2(1) NOT NULL Ben Admin Type
E=Event Maintenance
O=Open Enrollment
S=Snapshot
Default Value: O

5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

6 BAS_GROUP_ID Character(3) VARCHAR2(3) NOT NULL Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program.
Prompt Table: BAS_GROUP_TBL

7 OE_DEFN_ID Character(4) VARCHAR2(4) NOT NULL Open Enrollment Definition ID
Prompt Table: BAS_OE_DEFN

8 OE_STATUS_IND Character(1) VARCHAR2(1) NOT NULL Open Enrollment Status Flag
S=Scheduled
U=Unprocessed
Default Value: U

9 SNAP_DEFN_ID Character(4) VARCHAR2(4) NOT NULL Snapshot Definition ID
Prompt Table: BAS_SNP_DFN

10 SNAP_STATUS_IND Character(1) VARCHAR2(1) NOT NULL Snapshot Status Flag
S=Scheduled
U=Unprocessed
Default Value: U

11 ALLOW_SELF_SERVICE Character(1) VARCHAR2(1) NOT NULL Available through Self Service
N=No Self Service
X=Event Created Prior to HRMS7.5
Y=Self Service Allowed
Y/N Table Edit
Default Value: N

12 NO_NEW_EVENTS Character(1) VARCHAR2(1) NOT NULL No New Events
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	BAS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Ben Admin Type E=Event Maintenance O=Open Enrollment S=Snapshot Default Value: O
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
6	BAS_GROUP_ID	Character(3)	VARCHAR2(3) NOT NULL	Identifies a user-defined Benefits Administration group used to facilitate benefits processing. A group can represent the entire participant population of the enterprise, or a specific group of participants. It enables you to control processing by, for example, setting up separate Open Enrollment schedules for each group. If used, a BAS Group ID is assigned to each participant in a benefit program. Prompt Table: BAS_GROUP_TBL
7	OE_DEFN_ID	Character(4)	VARCHAR2(4) NOT NULL	Open Enrollment Definition ID Prompt Table: BAS_OE_DEFN
8	OE_STATUS_IND	Character(1)	VARCHAR2(1) NOT NULL	Open Enrollment Status Flag S=Scheduled U=Unprocessed Default Value: U
9	SNAP_DEFN_ID	Character(4)	VARCHAR2(4) NOT NULL	Snapshot Definition ID Prompt Table: BAS_SNP_DFN
10	SNAP_STATUS_IND	Character(1)	VARCHAR2(1) NOT NULL	Snapshot Status Flag S=Scheduled U=Unprocessed Default Value: U
11	ALLOW_SELF_SERVICE	Character(1)	VARCHAR2(1) NOT NULL	Available through Self Service N=No Self Service X=Event Created Prior to HRMS7.5 Y=Self Service Allowed Y/N Table Edit Default Value: N
12	NO_NEW_EVENTS	Character(1)	VARCHAR2(1) NOT NULL	No New Events Y/N Table Edit Default Value: N