BAS_SCHED_LNG(SQL Table) |
Index Back |
---|---|
BAS Schedule TableBAS_SCHED_LNG is the language record related to BAS_SCHED. 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. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SCHED_ID | Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |