GPNZ_EE_IRD_NUM

(SQL Table)
 Index Back

Employee IRD Number Table

This table will be used to record the employee's IRD number.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 GPNZ_IRD_NUMBER Character(9) VARCHAR2(9) NOT NULL New Zealand IRD Number