SEQNUMLE_EVENTS_CATEGORYEFFDTDefault Value: %date
LE_TEMPLATE_IDPrompt Table: W3EB_LE_TMPL_VW
A=Adoption
B=Birth
D=Divorce
M=Marriage
W3EB_LE_EVT_ELE(SQL Table) |
Index Back |
|---|---|
Life Event Catagory elementsLife Event Catagory elements are the menu descriptions entered by the Admin i.e. I got Married, I had a Baby |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 2 | LE_EVENTS_CATEGORY |
Character(4) | VARCHAR2(4) NOT NULL | Life Events category i.e. Employee, Spouse/Domestic Partner, Child |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | LE_TEMPLATE_ID |
Character(31) | VARCHAR2(31) NOT NULL |
auto generated Template ID generated by Tools for the List
Prompt Table: W3EB_LE_TMPL_VW |
| 5 | LE_TEMPLATE_DESC | Character(30) | VARCHAR2(30) NOT NULL | Title for the Life Event pagelet |
| 6 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 7 | 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 |
| 8 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL | Text ID |
| 9 | TEXT_ID2 | Character(18) | VARCHAR2(18) NOT NULL | Text ID |