TRN_T_EMP_ESP

(SQL Table)
 Index Back

Employee Tripartite Data

Additional information about employee for Tripartite Foundation

  • Related Language Record: TRN_T_EMP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 TRN_T_FNC_AREA_ESP Character(1) VARCHAR2(1) NOT NULL Functional Area
    1=Management
    2=Administration
    3=Commercial
    4=Maintenance
    5=Production
    5 CATEGORY_FORCEM Character(3) VARCHAR2(3) NOT NULL FORCEM Category
    1=Manager
    2=Middle Level Manager
    3=Technical
    4=Qualified Worker
    5=No Qualified Worker
    6 TRN_T_STDY_LVL_ESP Character(1) VARCHAR2(1) NOT NULL Education Level
    1=Without Studies
    2=Primary Studies,EGB or equival
    3=FPI,FPII or Equivalent
    4=Tech Archict/Enginr,Tech Schl
    5=Major Eng or Bachelor degree
    6=Others
    7 TRN_T_QLIFICTN_ESP Character(150) VARCHAR2(150) NOT NULL Others Qualifications
    8 TRN_T_CHK_MBR_ESP Character(1) VARCHAR2(1) NOT NULL Priority Member

    Y/N Table Edit

    Default Value: N

    9 TRN_T_VICTMGNR_ESP Character(1) VARCHAR2(1) NOT NULL Affected by Gender Violence

    Y/N Table Edit

    Default Value: N

    10 TRN_T_VICTMTRR_ESP Character(1) VARCHAR2(1) NOT NULL Affected by Terrorism

    Y/N Table Edit

    Default Value: N