PENSION BENEFITS RECIPIENT Table
SAP HR Pension Benefits Recipients
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AGE |
*** In HR tables, this field contains the person's age in years as calculated by the HR System's Age Calculating Device. *** In STUDENT tables, this field contains the age of the person. |
NUMBER |
3 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
DEPENDENT_DOCS_REQUIRED_FLAG |
XXX |
VARCHAR2 |
1 |
FAMILY_RELATIONSHIP |
Relationship between employee and the recipient under the same health plan. E.g.: Child, Spouse, Self, Spousal Equivalent, Divorced spouse. |
VARCHAR2 |
40 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
GENDER_CODE |
Gender code. |
VARCHAR2 |
1 |
IS_DISABLED_DEPENDENT |
XXX |
VARCHAR2 |
1 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
8 |
LAST_UPDATE_USER |
Last person that changed this record. |
VARCHAR2 |
12 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
PENSION_BENEFITS_RECIPIENT_KEY |
XXX |
VARCHAR2 |
14 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
SOCIAL_SECURITY_NUMBER |
The person's Social Security Number |
VARCHAR2 |
15 |
SUFFIX |
Name suffix (e.g., "III", "Jr.", "Sr", etc. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |