GPNL_PERS_XML

(SQL Table)
Index Back

Natural Person

Wage Declaration: Natural Person

  • Parent record: GPNL_EMPL_XML
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPNL_WD_MSG_ID Character(32) VARCHAR2(32) NOT NULL WALVIS
    2 GPNL_EMPLR_TAX_ID Character(12) VARCHAR2(12) NOT NULL Unique ID for the Employer assigned within the Wage Declaration, composed out of the Employer Tax Number + Suffix (e.g. "L01")
    3 PRD_BGN_DT Date(10) DATE NOT NULL Period Begin Date
    4 PRD_END_DT Date(10) DATE Pay Period End Date
    5 GPNL_WD_EMPL_ID Character(35) VARCHAR2(35) NOT NULL Wage Tax Declaration Employment ID.
    6 SEG_BGN_DT Date(10) DATE NOT NULL Payee Process Segment's Begin Date
    7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    8 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    9 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
    10 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
    11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    12 BIRTHDATE Date(10) DATE Date of Birth
    13 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    14 GPNL_NATIONALITY Character(4) VARCHAR2(4) NOT NULL Nationality code according to the NEN standards

    Default Value: 0001