EMPLOYMENT_VW (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.

EMPLOYMENT_VW

(SQL View)

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 ,BUSINESS_TITLE FROM PS_PER_ORG_ASGN

Related Language Record: EMPLOYMNTVW_LNG

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description