CNT_TYPE_VW_ESP

(SQL View)
 Index Back

Contract Type ESP VW

This view identifies types of Contracts for ESP region.

SELECT CONTRACT_TYPE , EFFDT , EFF_STATUS , DESCR , CONTRACT_TYPE %Concat ' - ' %Concat DESCR , CNT_DURTN_TYPE_ESP , CNT_SCHED_TYPE_ESP , CNT_REASON_ESP , ALLOWED_CNTR_EXT , XML_NODE_ID , CNT_TRANSFORMT_ESP , CONTRACT_RULE_ESP , CNT_PROMOTION_ESP , CNT_REDUCTION_ESP FROM PS_PERS_CNTRCT_TYP WHERE SETID = 'ESP'

  • Related Language Record: CNT_TYPEESP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

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

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 CNT_DURTN_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Contract Duration Type
    D=Fix Duration
    I=Permanent
    T=Temporary
    7 CNT_SCHED_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Schedule Type
    D=Permanent Intermitent
    F=Full Time
    P=Part Time
    8 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
    9 ALLOWED_CNTR_EXT Character(1) VARCHAR2(1) NOT NULL Allowed Extensions

    Y/N Table Edit

    Default Value: N

    10 XML_NODE_ID Character(6) VARCHAR2(6) NOT NULL Root node
    11 CNT_TRANSFORMT_ESP Character(1) VARCHAR2(1) NOT NULL Transformation flag

    Y/N Table Edit

    12 CONTRACT_RULE_ESP Character(20) VARCHAR2(20) NOT NULL Contract Rule
    13 CNT_PROMOTION_ESP Character(1) VARCHAR2(1) NOT NULL Tax Incentives
    14 CNT_REDUCTION_ESP Character(1) VARCHAR2(1) NOT NULL Permanent Intermitent flag
    1=By Contract
    2=By Employee
    3=By Employer