WKF_CNT_C_ESPVW

(SQL View)
 Index Back

Contract Info

Spanish details of the employment contract the employee is work

SELECT EMPLID , CONTRACT_NUM , EFFDT , EFFSEQ , CASE WHEN CNT_UNPREDICT_ESP = 'Y' THEN CNT_T_DURATION_ESP ELSE ' ' END , CASE WHEN CNT_UNPREDICT_ESP <> 'Y' AND CNT_TEMPLT_CLS_ESP = '202' THEN CONTRACT_TYPE ELSE ' ' END , CASE WHEN CNT_UNPREDICT_ESP = 'Y' OR CONTRACT_TYPE <> '402' THEN CNT_TEMPLT_CLS_ESP ELSE ' ' END , CASE WHEN CNT_UNPREDICT_ESP = 'Y' THEN SERV_PRDTN_RSN_ESP ELSE ' ' END , CASE WHEN CNT_UNPREDICT_ESP = 'Y' THEN PRODCTN_RSN_ESP ELSE ' ' END , CASE WHEN CNT_UNPREDICT_ESP = 'Y' THEN ' ' ELSE PRODCTN_RSN_ESP END , CNT_ADTNL_TXT_ESP , CNT_ADTNL_TXT2_ESP , CASE WHEN CNT_UNPREDICT_ESP = 'Y' THEN CNT_UNPREDICT_ESP ELSE 'N' END FROM PS_WKF_CNT_TYP_ESP

  • 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_T_DURATION_ESP Character(30) VARCHAR2(30) NOT NULL Total Contract Duration
    6 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

    Default Value: 100

    Prompt Table: CNT_TYPE_VW_ESP

    7 CNT_TEMPLT_CLS_ESP Character(3) VARCHAR2(3) NOT NULL SPEE Template Clause

    Prompt Table: CLS_TMPL_ESPVW

    8 SERV_PRDTN_RSN_ESP Character(250) VARCHAR2(250) NOT NULL Service Reason
    9 PRODCTN_RSN_ESP Character(250) VARCHAR2(250) NOT NULL Production Reason
    10 CNT_ADTNL_INFO_ESP Character(250) VARCHAR2(250) NOT NULL Additional Information
    11 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.
    12 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.
    13 CNT_UNPREDICT_ESP Character(1) VARCHAR2(1) NOT NULL Transformation flag

    Y/N Table Edit