BAS_ELT_SCHEDVW (SQL View)	Index Back
BAS Election Ent: Sched Prompt BAS_ELT_SCHEDVW is a view used with Benefits Administration Election data entry and returns available Schedules.

BAS_ELT_SCHEDVW

(SQL View)

BAS Election Ent: Sched Prompt

BAS_ELT_SCHEDVW is a view used with Benefits Administration Election data entry and returns available Schedules.

SELECT SCHED_ID , DESCRSHORT , BAS_TYPE , COMPANY , BAS_GROUP_ID FROM PS_BAS_SCHED

Related Language Record: BAS_ELT_SH_LGVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID
Prompt Table: BAS_SCHED

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

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

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID Prompt Table: BAS_SCHED
2	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
3	BAS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Ben Admin Type E=Event Maintenance O=Open Enrollment S=Snapshot
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	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.