GPNL_PRD_XML

(SQL Table)
Index Back

Period of Declaration

Wage Declaration: Period of Declaration

  • Parent record: GPNL_ADM_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 NOT NULL Pay Period End Date
    5 GPNL_WD_PER_IND Character(1) VARCHAR2(1) NOT NULL Wage Tax Declaration. Period Indicator.
    A=Annual
    C=Period Correction
    I=Initial Period
    6 GPNL_WD_ORIG_MSG Character(32) VARCHAR2(32) NOT NULL Reference to the original message id, used for corrections.