WKF_CNT_TYP_ESP

(SQL Table)
 Index Back

Contract Info

Spanish details of the employment contract the employee is work

  • Parent record: CONTRACT_DATA

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

    Prompt Table: PERSON

    2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 CNT_ACTION_ESP Character(3) VARCHAR2(3) NOT NULL Contract Action
    001=New Contract
    002=Termination
    003=Extension
    004=Calling
    005=End Calling
    006=Calling
    007=Remote Working Agreement

    Default Value: 001

    6 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

    Default Value: 100

    Prompt Table: CNT_TYPE_VW_ESP

    7 CNT_TEMPLATE_ID Character(11) VARCHAR2(11) NOT NULL Contract Template ID

    Prompt Table: CNT_TMPL_ESP_VW

    8 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: ESP

    9 CNT_TEMPLT_ID_ESP Character(11) VARCHAR2(11) NOT NULL SPEE Template ID

    Prompt Table: CNT_BY_TMPL_VW

    10 CNT_BGN_DT_ESP Date(10) DATE Contract Begin Dt
    11 CNT_ORIG_BGNDT_ESP Date(10) DATE Contract Original Begin Date
    12 CNT_END_DT_ESP Date(10) DATE Contract End Date
    13 CNT_DURATION_ESP Character(5) VARCHAR2(5) NOT NULL Contract Duration
    14 CNT_DURTN_UNIT_ESP Character(1) VARCHAR2(1) NOT NULL Type of Duration
    D=Days
    M=Months
    Y=Years

    Default Value: M

    15 CNT_T_DURATION_ESP Character(30) VARCHAR2(30) NOT NULL Total Contract Duration
    16 EXT_BGN_DT_ESP Date(10) DATE Extension Begin Dt
    17 EXT_END_DT_ESP Date(10) DATE Extension End Date
    18 EXT_DURATION_ESP Character(3) VARCHAR2(3) NOT NULL Extension Duration
    19 EXT_T_DURATION_ESP Character(30) VARCHAR2(30) NOT NULL Extension Duration
    20 EXT_DURTN_UNIT_ESP Character(1) VARCHAR2(1) NOT NULL Type of Duration
    D=Days
    M=Months
    Y=Years

    Default Value: M

    21 EXT_NUMBER_ESP Character(2) VARCHAR2(2) NOT NULL Extension Number
    1=First Extension
    2=Second Extension
    3=Third Extension
    4=Fourth Extension
    5=Fifth Extension
    6=Sixth Extension
    7=Seventh Extension
    8=Eighth Extension
    9=Ninth Extension
    22 CONTRACT_ID_ESP Character(18) VARCHAR2(18) NOT NULL Contract ID assigned by the Employment Agency
    C=Company
    E=Employee
    N=None
    S=SS Contribution Center
    23 BC_MANAGEMNT_ESP Character(1) VARCHAR2(1) NOT NULL Manage Basic Copy

    Y/N Table Edit

    24 BC_SIGN_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Signature Type
    1=Signed by Legal Representative
    2=Not exist Legal Representative
    3=Sent without Copy
    4=Declined to Sign
    25 BC_TEXT_ESP Long Character CLOB Basic Copy Text
    26 CNT_INEM_DT_ESP Date(10) DATE SEPE Registration Date
    27 CTTA_CONTRACT_ESP Character(1) VARCHAR2(1) NOT NULL Report as Contract flag
    0=Not Communicated
    1=XML Generated
    2=XML Sent/Confirmated
    N=Not Available

    Default Value: N

    28 CTTA_EXTENSION_ESP Character(1) VARCHAR2(1) NOT NULL Report as Extension flag
    0=Not Communicated
    1=XML Generated
    2=XML Sent/Confirmated
    N=Not Available

    Default Value: N

    29 CTTA_BASICCOPY_ESP Character(1) VARCHAR2(1) NOT NULL Report as Basic Copy flag
    0=Not Communicated
    1=XML Generated
    2=XML Sent/Confirmated
    N=Not Available

    Default Value: N

    30 CTTA_TRANSFORM_ESP Character(1) VARCHAR2(1) NOT NULL Report as Transformation flag
    0=Not Communicated
    1=XML Generated
    2=XML Sent/Confirmated
    N=Not Available

    Default Value: N

    31 CTTA_GROUP_ESP Character(1) VARCHAR2(1) NOT NULL Report as Contract Group flag

    Y/N Table Edit

    32 CTTA_CALLING_ESP Character(1) VARCHAR2(1) NOT NULL Report as Calling flag
    0=Not Communicated
    1=XML Generated
    2=XML Sent/Confirmated
    N=Not Available

    Default Value: N

    33 XML_NODE_ID Character(6) VARCHAR2(6) NOT NULL Root node

    Prompt Table: XML_NODE_VW

    34 SERV_PRDTN_RSN_ESP Character(250) VARCHAR2(250) NOT NULL Service Reason
    35 BONIF_RSN_ESP Character(4) VARCHAR2(4) NOT NULL Bonificated Collective. Used for Bonificated Contracts

    Prompt Table: BONIF_RSN_ESPVW

    36 BONIF_GROUP_ESP Character(4) VARCHAR2(4) NOT NULL Bonificated Collective. Used for Bonificated Contracts

    Prompt Table: CNT_BNF_ESP_VW

    37 PRODCTN_RSN_ESP Character(250) VARCHAR2(250) NOT NULL Production Reason
    38 CNT_PROMOTION_ESP Character(1) VARCHAR2(1) NOT NULL Tax Incentives

    Y/N Table Edit

    Default Value: N

    39 SUBSTN_RSN_ESP Character(4) VARCHAR2(4) NOT NULL Replaced Reason

    Prompt Table: SUBST_RSN_ESPVW

    40 SUBSTN_EMPLID_ESP Character(11) VARCHAR2(11) NOT NULL Replaced Empl ID

    Prompt Table: SUBST_ID_ESP_VW

    41 SUBSTN_JOBCODE_ESP Character(40) VARCHAR2(40) NOT NULL Proposed Job Code
    42 RELV_CONTRCT_ESP Character(1) VARCHAR2(1) NOT NULL Relieve Contract Flag

    Y/N Table Edit

    Default Value: N

    43 RLV_WRK_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Relieve Work Type

    Prompt Table: PERS_CNTRCT_TYP

    44 COMPLMNTRY_HRS_ESP Character(1) VARCHAR2(1) NOT NULL Complementary Hours Agreed

    Y/N Table Edit

    45 LAB_AGRMNT_OK_ESP Character(1) VARCHAR2(1) NOT NULL Allowed by Labor Agreement

    Y/N Table Edit

    46 PART_TIME_PERC_ESP Number(3,0) SMALLINT NOT NULL Percentage of Part Time
    47 CNT_SCHED_BGN_ESP Character(5) VARCHAR2(5) NOT NULL Schedule Start Hour
    D=Permanent Intermitent
    F=Full Time
    P=Part Time
    48 CNT_SCHED_END_ESP Character(5) VARCHAR2(5) NOT NULL Schedule Start Hour
    49 CNT_SCHED_DIST_ESP Character(254) VARCHAR2(254) NOT NULL Schedule Distribution
    50 CNT_VACATION_ESP Character(30) VARCHAR2(30) NOT NULL Contract Vacation Period
    51 VAC_DURTN_ESP Number(3,0) SMALLINT NOT NULL Vacation Duration

    Default Value: 30

    52 VAC_DURTN_UNIT_ESP Character(1) VARCHAR2(1) NOT NULL Vacation period unit
    D=Days
    L=Labor Days
    M=Months
    N=Natural Days
    W=Weeks

    Default Value: N

    53 CNT_PROBATION_ESP Character(30) VARCHAR2(30) NOT NULL Contract Probation Period
    54 PRB_DURTN_ESP Number(3,0) SMALLINT NOT NULL Probation Duration
    55 PRB_DURTN_UNIT_ESP Character(1) VARCHAR2(1) NOT NULL Vacation period unit
    D=Days
    M=Months
    W=Weeks

    Default Value: D

    56 HIRE_CTR_CD_ESP Character(3) VARCHAR2(3) NOT NULL Hiring Center

    Prompt Table: HIRING_CTR_ESP

    57 COMP_RATE_DESCR Character(100) VARCHAR2(100) NOT NULL Compensation Rate Description
    58 SCHEME_ID_ESP Character(4) VARCHAR2(4) NOT NULL Scheme ID - ESP

    Default Value: 0111

    Prompt Table: SCHEME_ESP_VW

    59 CONTRIB_ID_ESP Character(5) VARCHAR2(5) NOT NULL Soc.Sec. Contribution ID - ESP

    Default Value: 001

    Prompt Table: CONTRIB_ESP_VW

    60 CNT_TRANSFORMT_ESP Character(1) VARCHAR2(1) NOT NULL Transformation flag

    Y/N Table Edit

    61 PART_TIME_HRS_ESP Character(4) VARCHAR2(4) NOT NULL Bonificated Collective. Used for Bonificated Contracts
    62 PART_TIME_MINS_ESP Character(2) VARCHAR2(2) NOT NULL Bonificated Collective. Used for Bonificated Contracts
    63 PART_TIME_FRQ_ESP Character(1) VARCHAR2(1) NOT NULL Hours Frequency for Part time employees. Values: Daily, Weekly, Monthly, Annualy.
    D=Daily
    M=Monthly
    W=Weekly
    Y=Yearly
    64 PT_MAX_HRS_ESP Signed Number(8,2) DECIMAL(6,2) NOT NULL Maximum Hours for Part Time Contracts
    65 PT_INTERMITTNT_ESP Character(1) VARCHAR2(1) NOT NULL Permanent Intermittent for Part Time Contracts

    Y/N Table Edit

    Default Value: N

    66 SCHD_HRS_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Compared Schedule for Part time employees. Values: Equivalent Full Time Worker, Maximum Schedule based on Labor Agreement, Official Maximum Schedule.
    F=Full Time Schedule
    L=Labor Agreement Max Schedule
    O=Official Max Schedule
    67 LINKED_TO_AFI_ESP Character(1) VARCHAR2(1) NOT NULL Node Status
    0=Action Not Applicable
    1=Action not linked to AFI
    2=Linked to AFI

    Default Value: 0

    68 REPRESNT_ID_ESP Character(11) VARCHAR2(11) NOT NULL Company Representative ID

    Prompt Table: REPRESNTATV_ESP

    69 LOCATN_CITY_CD_ESP Character(5) VARCHAR2(5) NOT NULL City Code
    70 COMPNY_CITY_CD_ESP Character(5) VARCHAR2(5) NOT NULL City Code
    71 CITY_CD_ESP Character(5) VARCHAR2(5) NOT NULL City Code
    72 TUTOR_ID_ESP Character(11) VARCHAR2(11) NOT NULL Tutor ID

    Prompt Table: PERS_POI_ESP_VW

    73 REPRESNT_ROLE_ESP Character(50) VARCHAR2(50) NOT NULL Tutor Role
    74 SIGNATURE_CITY Character(30) VARCHAR2(30) NOT NULL Signature City
    75 SIGNATURE_DT Date(10) DATE Signature Date
    76 CNT_LESS7DAYS_ESP Character(1) VARCHAR2(1) NOT NULL Permanent Intermitent flag
    C=Yes
    N=No
    77 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    78 CNT_CHANGE_FLG_ESP Character(1) VARCHAR2(1) NOT NULL Contract Change Flag

    Y/N Table Edit

    Default Value: N

    79 CNT_TUTOR_FLG_ESP Character(1) VARCHAR2(1) NOT NULL Employee with Tutor

    Y/N Table Edit

    Default Value: N

    80 LOCATN_ADDRESS_ESP Character(50) VARCHAR2(50) NOT NULL Location Address
    81 CNT_ADDTNL_CND_ESP Character(2) VARCHAR2(2) NOT NULL Reduction Collective

    Prompt Table: RD_COLETV_ESPVW

    82 ANEX_MANAGEMNT_ESP Character(1) VARCHAR2(1) NOT NULL Manage Contract Annex

    Y/N Table Edit

    Default Value: N

    83 EMPLMNT_OFF_CD_ESP Character(8) VARCHAR2(8) NOT NULL Employment Office Code.

    Prompt Table: SEPE_ESP_VW

    84 COMPLM_MAX_HRS_ESP Number(3,0) SMALLINT NOT NULL Maximum Complementary Hours per Year
    85 COMPLM_PCT_HRS_ESP Number(3,0) SMALLINT NOT NULL Complementary Hours Percent
    86 NOTIFCTN_DAYS_ESP Number(2,0) SMALLINT NOT NULL Notification Days before starting Complementary Hours
    87 EE_PREV_STATUS_ESP Character(1) VARCHAR2(1) NOT NULL Employee Previous Status. Values: D -> Unemployee C -> Current Employee.
    C=Current Employee
    D=Unemployee
    88 STAFF_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Company Staff Type based on Staff Number: P -> Small Company (<50 employees) M -> Medium Company (<250 employees) G -> Large Company (>=250 employees)
    G=Large Company
    M=Medium Company
    P=Small Company
    89 CNT_BONIF_FLG_ESP Character(1) VARCHAR2(1) NOT NULL Contract with Bonification

    Y/N Table Edit

    Default Value: N

    90 CNT_ADDTNL_FLG_ESP Character(1) VARCHAR2(1) NOT NULL Contract with Reduction

    Y/N Table Edit

    Default Value: N

    91 CNO_ESP Character(4) VARCHAR2(4) NOT NULL Occupational Code

    Prompt Table: CNO4_ESPVW

    92 CNT_ADTNL_INFO_ESP Character(250) VARCHAR2(250) NOT NULL Additional Information
    93 CNT_TEMPLT_CLS_ESP Character(3) VARCHAR2(3) NOT NULL SPEE Template Clause

    Prompt Table: CLS_TMPL_ESPVW

    94 RETIRED_EMPLID_ESP Character(11) VARCHAR2(11) NOT NULL Relieved Empl ID

    Prompt Table: RELEV_ID_ESP_VW

    95 YWS_REG_DT_ESP Date(10) DATE Warranty System Registratn Dt
    96 BONIF_AMOUNT_ESP Number(10,2) DECIMAL(9,2) NOT NULL Bonification Amount per Contract
    97 CNT_PT_PCT_ESP Number(6,2) DECIMAL(5,2) NOT NULL Percentage of Part Time
    98 CNT_ADTNL2_CND_ESP Character(1) VARCHAR2(1) NOT NULL This field has been added to manage the Plan for Employment Activation. In the future, if new special conditions will appear, it will be a xlat field.

    Y/N Table Edit

    Default Value: N

    99 CNT_ADTNL_TXT_ESP Character(100) VARCHAR2(100) NOT NULL This field has been added to manage the Plan for Employment Activation. In the future, if new special conditions will appear, it will be a xlat field.
    100 CNT_ADTNL_TXT2_ESP Character(100) VARCHAR2(100) NOT NULL This field has been added to manage the Plan for Employment Activation. In the future, if new special conditions will appear, it will be a xlat field.
    101 CNT_UNPREDICT_ESP Character(1) VARCHAR2(1) NOT NULL Transformation flag

    Y/N Table Edit