EMPLOYMNTVW_LNG

(SQL View)
 Index Back

Vw-EMPLOYMENT data w/out PplCd

EMPLOYMENT_VW is a view of the Employment record, which screens out most PeopleCode for the Position Management application. This record is in a work scroll on the Position Data 1 panel, and is used to control the cross-update to Employment from Position_Data. One field, Business Title, is renamed to Descr in this record to support the Compare and CopyLikeFields functions. Please note: if you modify the Employment record to add columns, this view will need to be changed to include any new fields involved in the cross-update if Position Management is used. Audits: If you currently audit the Employment record, the same audit flags should be set on this record to trap changes from the position side.

SELECT EMPLID ,EMPL_RCD ,LANGUAGE_CD ,BUSINESS_TITLE FROM PS_PER_ORG_ASG_LNG

  • Related Language Record for EMPLOYMENT_VW

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

    Default Value: PERSON.EMPLID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description