SCHED_IDPrompt Table: BAS_SCHED
EMPLIDBENEFIT_RCD_NBREVENT_IDOPTION_IDCOST_IDMSGIDMSGDATA1MSGDATA2MSGDATA3BAS_MESSAGE(SQL Table) |
Index Back |
|---|---|
BAS Error MessagesBAS_MESSAGE is a record that is used to store messages (usually errors that must be resolved) that are generated by the Cobol job of the Benefits Administration product. |
| # | 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 | 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 | OPTION_ID |
Number(4,0) | SMALLINT NOT NULL | Option ID |
| 6 | COST_ID |
Number(4,0) | SMALLINT NOT NULL | Cost Identification |
| 7 | MSGID |
Character(6) | VARCHAR2(6) NOT NULL | Message ID |
| 8 | MSGDATA1 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 9 | MSGDATA2 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 10 | MSGDATA3 |
Character(30) | VARCHAR2(30) NOT NULL | Message Data |
| 11 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |