EMPLIDPrompt Table: W3EB_EMPL_VW
BEN_EVENT_TYPED=Dependent
L=Life Event
O=Open Enrollment
BEN_EVENT_SEQBEN_ATT_IMG_VW(SQL View) |
Index Back |
|---|---|
Benefit Approval PhotoPhoto view for benefits approvals |
| SELECT A.EMPLID ,A.BEN_EVENT_TYPE ,A.BEN_EVENT_SEQ ,B.EMPLOYEE_PHOTO FROM PS_BEN_ATTACH_HDR A , %Table(USER_PH_LIST_FL) B WHERE A.EMPLID=B.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: W3EB_EMPL_VW |
| 2 | BEN_EVENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Benefits event types for attachments
D=Dependent L=Life Event O=Open Enrollment |
| 3 | BEN_EVENT_SEQ |
Number(3,0) | SMALLINT NOT NULL | Benefits attachment sequence |
| 4 | EMPLOYEE_PHOTO | Image / Attachment(256) | VARCHAR2(256) | Employee Photograph |