BEN_ATTACH_HDR(SQL Table) |
Index Back |
|---|---|
Benefits Attachment HeaderHeader record for benefits attachments |
| # | 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 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
| 5 | ACTION_DT_SS | Date(10) | DATE | Termination Date |
| 6 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 7 | HR_ATT_SUB_ID | Character(4) | VARCHAR2(4) NOT NULL | Field to partition attachments keys entries |
| 8 | BEN_HEADER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status for header record
C=Complete D=Closed I=In Progress O=Complete - Admin override R=Attachment Missing Default Value: I |
| 9 | 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 |
| 10 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |