SCHED_IDEMPLIDBENEFIT_RCD_NBREVENT_IDA=Adoption
B=Birth
D=Divorce
M=Marriage
W3EB_EMP_EVENT(SQL Table) |
Index Back |
|---|---|
Employee event dataused to gather the employee benefit options to created the review and confirm page, and the .pdf benefit summary report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCHED_ID |
Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
| 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 | LIFE_EVENT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Type of Life Event (e.g. Birth, Adoption, Marriage)
A=Adoption B=Birth D=Divorce M=Marriage |
| 6 | EVENT_CLASS | Character(3) | VARCHAR2(3) NOT NULL | Event Classification |
| 7 | EVENT_DT | Date(10) | DATE | Event Date |