JOB_BU_VW

(SQL View)
Index Back

Vw-JOB w/out PeopleCode

JOB_BU_VW is a view of the Job record, which screens out most PeopleCode. It is used to bring in an emplid's Business Unit for the most effective-dated row..

SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.BUSINESS_UNIT FROM PS_JOB A

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

Default Value: NEW

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: JOB.BUSINESS_UNIT

Prompt Table: BUS_UNIT_TBL_HR