EMPLIDA=Adoption
B=Birth
D=Divorce
M=Marriage
BNE_LE_AG_VW(SQL View) |
Index Back |
|---|---|
Life Event AG expiration daysLife Evt expire data |
| SELECT A.EMPLID , A.LIFE_EVENT_TYPE , D.DESCR20 , C.PTAI_LIST_ID , CASE WHEN ((%DateDiff( %CurrentDateIn, %DateAdd(A.ACTION_DT_SS, D.DAYS_TO_NOTIFY)) + 1) < 6) THEN 'Y' ELSE 'N' END FROM PS_W3EB_LE_STATE92 A , PS_PTAI_LIST B , PS_PTAI_CONTEXT C , PS_W3EB_LE_RULES D WHERE C.PTAI_LIST_ID = B.PTAI_LIST_ID AND C.RECNAME = 'W3EB_LE_CONTEXT' AND C.FIELDNAME = 'EMPLID' AND C.PTAI_KEY_VALUE = A.EMPLID AND A.LIFE_EVENT_TYPE = D.LIFE_EVENT_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | 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 |
| 3 | LIFE_EVT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Life Event Descr |
| 4 | PTAI_LIST_ID | Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item List ID |
| 5 | BNE_LE_EXP_DESCR | Character(1) | VARCHAR2(1) NOT NULL | Benefits Expire description |