SUBST_ID_ESP_VW

(SQL View)
 Index Back

Substituted Emplid Name Prompt

Only Contracts checked as Partial Retirement ( CNT_REASON_ESP = 'JUB') are NOT elegibles to be Sustituted. They must use the view Relieved Emplid.

SELECT A.EMPLID ,B.NAME ,B.LAST_NAME ,B.SECOND_LAST_NAME ,B.FIRST_NAME ,B.BIRTHDATE ,B.NATIONAL_ID FROM PS_WKF_CNT_TYP_ESP A , PS_PERSDATA_ESP_VW B WHERE A.EMPLID = B.EMPLID

  • Parent record: PER_ORG_ASGN

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

    Prompt Table: PERSON_NAME

    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    4 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
    5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    6 BIRTHDATE Date(10) DATE Date of Birth
    7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID