BEN_EVENT_TYPED=Dependent
L=Life Event
O=Open Enrollment
EFFDTDefault Value: %date
N=No
Y=Yes
Default Value: N
A=Active
I=In Active
Default Value: N
Prompt Table:
BEN_ATT_DEFN_VW
Set Control Field: OBJECTOWNERID
Default Value: N
BEN_ATT_CFG_DFN(SQL Table) |
Index Back |
|---|---|
Benefit AttachmentBenefit Attachment : Attachmant transaction type and Attachment Defination mapping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BEN_EVENT_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Benefits event types for attachments
D=Dependent L=Life Event O=Open Enrollment |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | BEN_ATT_IS_FLDLVL | Character(1) | VARCHAR2(1) NOT NULL |
Field Level
N=No Y=Yes Default Value: N |
| 4 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 5 | BEN_ATT_CFG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
A=Active I=In Active Default Value: N |
| 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
Prompt Table:
BEN_ATT_DEFN_VW
|
| 8 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |