BEN_EVENT_TYPED=Dependent
L=Life Event
O=Open Enrollment
Prompt Table: BEN_ATT_CFG_EVT
EFFDTDefault Value: %date
RECORDNAMEFIELDNAMEPrompt Table:
BEN_ATT_DEFN_VW
Set Control Field: OBJECTOWNERID
N=No
Y=Yes
N=No
Y=Yes
Default Value: N
BEN_ATT_CFG_FLD(SQL Table) |
Index Back |
|---|---|
Benefit Attachmentc : Attachment Defination and Component field 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 Prompt Table: BEN_ATT_CFG_EVT |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | RECORDNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record Name |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 5 | OBJECTOWNERID | Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 6 | HR_ATT_SUB_ID | Character(4) | VARCHAR2(4) NOT NULL |
Field to partition attachments keys entries
Prompt Table:
BEN_ATT_DEFN_VW
|
| 7 | BEN_ACTION_ADD | Character(1) | VARCHAR2(1) NOT NULL |
Add
N=No Y=Yes |
| 8 | BEN_ACTION_EDIT | Character(1) | VARCHAR2(1) NOT NULL |
Modify
N=No Y=Yes |
| 9 | 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 |