CONTRACT_DATA

(SQL Table)
 Index Back

Contract Info

Detals of the employment contract the employee is work

  • Parent Record Of AFI_DATAWRK_ESP CNTRCT_DATA_ESP CNT_PREV_ESP_VW CNT_PROBATION CONTR_ENDS_BEL GPES_PP_INC_VW GP_DIAG_WCT_VW HR_EE_TASK_ORD UPG_CNT_LNG_TAO UPG_CNT_PRB_TAO UPG_WKF_CNT_TAO WKF_CNTCLS_ESPL WKF_CNTCLS_LNG WKF_CNT_AFI_ESP WKF_CNT_CLAUSE WKF_CNT_CLS_ESP WKF_CNT_C_ESPVW WKF_CNT_INC_ESP WKF_CNT_RDT_ESP WKF_CNT_TYPE WKF_CNT_TYP_ESP WKF_CNT_XML_ESP

    • # 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 CONTRACT_BEGIN_DT Date(10) DATE Contract Begin Date

    Default Value: %Date

    4 CONTRACT_END_DT Date(10) DATE Contract End Date
    5 SIGNATURE_DT Date(10) DATE Signature Date
    6 CONTRACT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status - The values 'N - N/A' and 'P - Pending' are suppressed from release 8.
    A=Active
    I=Inactive

    Default Value: A

    7 ADD_CONTRACT Character(1) VARCHAR2(1) NOT NULL Additional Contract

    Y/N Table Edit

    Default Value: N

    8 CNT_MIN_HRS Number(6,2) DECIMAL(5,2) NOT NULL Minimum Hours Per Contract
    9 CNT_MAX_HRS Number(6,2) DECIMAL(5,2) NOT NULL Maximum Hours Per Contract
    10 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Prompt Table: PERSON_NAME

    11 YEAR_SW Character(1) VARCHAR2(1) NOT NULL More than one year expected

    Y/N Table Edit

    Default Value: N

    12 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment
    13 CNT_TEMPLATE_ID Character(11) VARCHAR2(11) NOT NULL Contract Template ID

    Prompt Table: CNT_TEMPL_VW

    14 CNT_RSZ_SUBM_BEL Character(1) VARCHAR2(1) NOT NULL RSZ-Submitted

    Y/N Table Edit

    Default Value: Y

    15 CNT_RSZ_CAT_BEL Character(3) VARCHAR2(3) NOT NULL RSZ category Belgiums
    000=Not Applicable
    010=Former Entitled Man Worker
    020=Entitled Manual Worker
    030=Ent. appr. Retail Worker
    031=Entitled Industrial Apprentice
    032=Entitled Management Trainee
    040=Non-Entitled Self-Employed
    041=Non-Entitled Director
    042=Non-Ent Manager Non-Prof Sect
    043=Non-Entitled Active Partner
    050=Man Worker on Early Retirement
    051=Office Worker on Early Retirem
    052=Retired Man Worker (OAP)
    053=Retired Office Worker (OAP)
    054=Widow Office Worker (Wid Pens)
    055=Widow Man Worker (Wid Pens.)
    056=Orphan
    057=Disabled
    060=Employed Non-Entitled
    061=Non-Entitled Manual Worker
    062=Non-Entitled Office Worker
    070=Entitled Homeworker
    080=Entitled Domestic
    090=Entitled Office Worker
    091=Entitled Off Worker - Director
    092=Entitled Off Worker - Manager
    094=Ent Off Worker -Representative
    16 RED_CHRG_CAT_BEL Character(6) VARCHAR2(6) NOT NULL Reduced Charges Category

    Prompt Table: REDUCT_TBL_BEL

    17 REDCH_STARTDT_BEL Date(10) DATE Reduced Charges Start Date
    18 REDCH_ENDDT_BEL Date(10) DATE Reduce Charge End Date
    19 SOCIAL_BALANCE_BEL Character(3) VARCHAR2(3) NOT NULL The Social Balance Category is entered on the Belgian contracts and used for the Social Reporting.
    400=Company Plan
    403=Youth Employment
    404=Low Salaries
    405=Employment Agreement 1995-1996
    408=Longterm unemployed
    409=Maribel
    410=Re-employment (>50 years)
    500=1st Work experience
    501=Start up Agreement
    502=Youth internship
    503=Work/training agreement
    504=Apprenticeship
    505=Successive Defined Terms
    506=Conventional early retirement
    511=Conv.early retirem. part-time
    512=Career interruption full-time
    513=Career interruption part-time
    20 BEGIN_WEEKDAY Character(1) VARCHAR2(1) NOT NULL Begin/End Week
    1=Sunday
    2=Monday
    3=Tuesday
    4=Wednesday
    5=Thursday
    6=Friday
    7=Saturday

    Default Value: 2

    21 END_WEEKDAY Character(1) VARCHAR2(1) NOT NULL End Day of Week
    1=Sunday
    2=Monday
    3=Tuesday
    4=Wednesday
    5=Thursday
    6=Friday
    7=Saturday

    Default Value: 6

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

    Prompt Table: HIRING_CTR_ESP

    23 COMP_RATE_DESCR Character(100) VARCHAR2(100) NOT NULL Compensation Rate Description
    24 PROBATION_PERIOD Number(3,0) SMALLINT NOT NULL Probation Period
    25 DURATION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Duration
    D=Days
    M=Months
    Y=Years

    Default Value: M

    26 VACATION_PERIOD Number(3,0) SMALLINT NOT NULL Vacation period
    27 VACN_PERIOD_UNIT Character(1) VARCHAR2(1) NOT NULL Vacation period unit
    D=Work Days
    M=Months
    N=Natural Days
    W=Weeks

    Default Value: M

    28 SCHEME_ID_ESP Character(4) VARCHAR2(4) NOT NULL Scheme ID - ESP

    Prompt Table: SCHEME_ESP_VW

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

    Prompt Table: CONTRIB_ESP_VW

    30 CONTRCT_EXP_END_DT Date(10) DATE Contract Expected End Date
    31 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

    32 NEE_PROVIDER_ID Character(10) VARCHAR2(10) NOT NULL The ID for the Non Employee Provider, Agency, or Employer.

    Prompt Table: NEE_PROVIDR_TBL

    33 WAIVE_COMPLIANCE Character(1) VARCHAR2(1) NOT NULL Waive Working Time Compliance

    Y/N Table Edit

    34 COMMENTS Long Character CLOB Comment