JOB_HIR_ITA_VW(SQL View) |
Index Back |
|---|---|
Hire Employment View for HirinHire 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 Record |
| 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 Set ID |
| 8 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 11 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 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
|
| 14 | EMPL_CTG | Character(6) | VARCHAR2(6) NOT NULL |
Employee Category
Prompt Table:
EMPL_CTG_L1
|
| 15 | EMPL_CTG_L1 | Character(6) | VARCHAR2(6) NOT NULL |
Employee Subcategory
Prompt Table:
EMPL_CTG_L2
|
| 16 | EMPL_CTG_L2 | Character(6) | VARCHAR2(6) NOT NULL |
Employee Subcategory 2
Prompt Table:
EMPL_CTG_L3
|