JOB_HIR_ITA_VW

(SQL View)
 Index Back

Hire Employment View for Hirin

Hire Employment View for Hiring Letters

SELECT EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,ACTION ,ACTION_REASON ,SETID_JOBCODE ,JOBCODE ,COMPANY ,SETID_LOCATION ,LOCATION ,REG_REGION ,LABOR_AGREEMENT ,EMPL_CTG ,EMPL_CTG_L1 ,EMPL_CTG_L2 FROM PS_JOB WHERE EMPL_STATUS NOT IN ('D' ,'T' ,'U' ,'V' ,'R' ,'Q' ,'X') AND ACTION IN ('HIR' ,'REH','ADD','ADL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
7 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: JOBCODE_TBL
Set Control Field: SETID_JOBCODE

9 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
10 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
11 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL
Set Control Field: SETID_LOCATION

12 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
13 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

Prompt Table: EMPL_CTG
Set Control Field: REG_REGION

14 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

Prompt Table: EMPL_CTG_L1
Set Control Field: REG_REGION

15 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory

Prompt Table: EMPL_CTG_L2
Set Control Field: REG_REGION

16 EMPL_CTG_L2 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory 2

Prompt Table: EMPL_CTG_L3
Set Control Field: REG_REGION