JOB_EMPLRCD_VW

(SQL View)
Index Back

VW- JOB data

JOB_EMPLRCD_VW is a view of the Job record, which gives information on emplid, company and employment record number.

SELECT DISTINCT EMPLID ,COMPANY ,EMPL_RCD FROM PS_JOB

# 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record