T7UNPF_MI_PRTCI - UNJSPF Monthly Interface Participant Table
UNJSPF Monthly Interface Participant Table information is stored in SAP table T7UNPF_MI_PRTCI.
It is part of development package PBUN in software component PY-NPO. This development package consists of objects that can be grouped under "Master Data Non Profit Organizations".
It is part of development package PBUN in software component PY-NPO. This development package consists of objects that can be grouped under "Master Data Non Profit Organizations".
Fields for table T7UNPF_MI_PRTCI
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
.INCLUDE | X | PUNPF_MI_TBKEY | 0 | |||
.INCLUDE | X | PUNPF_MI_EXPKEY | 0 | |||
PENSION_NO | Pension Number | X | PUN_PENSION_NO | NUMC | 12 | |
DATA_KEY | Data Key | X | PUN_DATA_KEY | NUMC | 52 | |
DATA_KEY_2 | Data Key | X | PUN_DATA_KEY_2 | NUMC | 6 | |
.INCLUDE | PUNPF_MI_PRTCI | 0 | ||||
LAST_NM | Last name. Left justified. | PUN_LAST_NM | CHAR | 80 | ||
FIRST_NM | First name. Left justified. | PUN_FIRST_NM | CHAR | 80 | ||
ORG_CD | Organization | PUN_ORG_CD | CHAR | 4 | ||
FORMER_NO | Former participant Pension Number | PUN_FORMER_NO | NUMC | 12 | ||
BIRTH_DT | Date of birth. DD-MM-YYYY format | PUN_BIRTH_DT | CHAR | 20 | ||
DOB_VER | Date of birth verification indicator | PUN_DOB_VER | CHAR | 2 | ||
BEG_CS_DT | Beginning contributory service (BCS) data | PUN_BEG_CS_DT | CHAR | 20 | ||
BCS_VER | BCS date verification indicator | PUN_BCS_VER | CHAR | 2 | ||
LOCAL_ID | Staff member's Index Number | PUN_LOCAL_ID | CHAR | 16 | ||
DUTY_STATION_CD | Duty Station | PUN_DSTAT | CHAR | 8 | * | |
NATIONALITY_CD | Country of nationality | PUN_NATIONALITY_CD | CHAR | 6 | ||
GENDER_CD | Gender | PUN_GENDER_CD | CHAR | 2 | ||
LANGUAGE_CD | Communication Language | PUN_LANGUAGE_CD | CHAR | 2 | ||
LOCATION_CD | Location where the staff member physically works | PUN_LOCATION_CD | CHAR | 6 | ||
CATEGORY_CD | Employment category | PUN_CATEGORY_CD | NUMC | 2 | ||
MARITAL_STAT_CD | Marital status | PUN_MATIAL_STAT_CD | NUMC | 2 | ||
MAR_STAT_VER | Marital status verification indicator | PUN_MAR_STAT_VER | CHAR | 2 | ||
.INCLUDE | PUNPF_MI_STATS | 0 | ||||
ERROR_FLAG | Error flag | PUN_ERROR_FLAG | CHAR | 2 | ||
CRNAM | Created By | PUN_CRNAM | CHAR | 24 | ||
CRDAT | Creation Date | CDATE | DATS | 16 | ||
CRTIM | Created At | CREATETIME | TIMS | 12 | ||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
AETIM | Time of last change | PUTIM | TIMS | 12 | ||
DELETE_FLAG | Delete Flag | PUN_DELETE_FLAG | CHAR | 2 | ||
UPDT_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 |