EMPL_MATR_ITA

(SQL Table)
Index Back

Employee Matricula Book ITA

Employee Matricula Book ITA

  • Parent Record Of MATRBKITA_TAO MATR_BK_ITA_TAO MATR_BOOK_ITA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_STANDARD_VW

    3 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

    Prompt Table: EMPL_CLASS_TBL

    4 MATRICULA_NBR_ITA Number(6,0) INTEGER NOT NULL Matricula Number ITA
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    7 HIRE_DT Date(10) DATE First Start Date