PERS_CNTRCT_TYP

(SQL Table)
 Index Back

Contract Type

CONTRACT_TYPE identifies types of Contracts by REG_REGION. This table is used as an edit table when recording employee contracts. This data is part of theManage Labor Relations module.

  • Related Language Record: PERS_CNTTYP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: SET_VLD_HR_09

    2 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    9 CONTRACT_RULE_ESP Character(20) VARCHAR2(20) NOT NULL Contract Rule
    10 CONTR_MIN_DRTN Number(2,0) SMALLINT NOT NULL Minimum Duration
    11 DURATION_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Duration Unit

    Default Value: M

    Prompt Table: DT_COST_UNIT_VW

    12 CONTR_MAX_DRTN Number(2,0) SMALLINT NOT NULL Maximum Duration
    13 DURATION2_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Duration Unit

    Default Value: M

    Prompt Table: DT_COST_UNIT_VW

    14 ALLOWED_CNTR_EXT Character(1) VARCHAR2(1) NOT NULL Allowed Extensions

    Y/N Table Edit

    Default Value: N

    15 SSN_EMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Social Security Number Type
    1=Regular
    2=Apprenticeship
    3=Training

    Default Value: 1

    16 REDUCTION_ID_ESP Character(3) VARCHAR2(3) NOT NULL Reduction ID

    Prompt Table: %EDITTABLE

    17 CNT_DURTN_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Contract Duration Type
    D=Fix Duration
    I=Permanent
    T=Temporary
    18 CNT_SCHED_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Schedule Type
    D=Permanent Intermitent
    F=Full Time
    P=Part Time
    19 CNT_TRANSFORMT_ESP Character(1) VARCHAR2(1) NOT NULL Transformation flag

    Y/N Table Edit

    20 CNT_REASON_ESP Character(3) VARCHAR2(3) NOT NULL Contract Reason
    DIS=Disabled People
    FEU=European Funds
    FOM=Employment Promotion
    FOR=Training
    INS=Insertion
    INT=Interinity
    INT=Replacement
    JUB=Partial Retirement
    ORD=Regular
    PRO=Production
    REL=Relieve
    SER=Service
    21 CNT_PERM_INTER_ESP Character(1) VARCHAR2(1) NOT NULL Permanent Intermitent flag

    Y/N Table Edit

    22 CNT_REDUCTION_ESP Character(1) VARCHAR2(1) NOT NULL Permanent Intermitent flag
    1=By Contract
    2=By Employee
    3=By Employer

    Y/N Table Edit

    23 CNT_PROMOTION_ESP Character(1) VARCHAR2(1) NOT NULL Tax Incentives

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: CTTANODE1_ESPVW

    25 CNT_TYPE_APPL_ITA Character(1) VARCHAR2(1) NOT NULL Contract Type Applicability
    A=All
    E=Employee
    N=Non-Employee

    Default Value: A