HRCD_NDE_JOB_VW(SQL View) |
Index Back |
|---|---|
Company Directory - Job VwView for selecting JOB data for org chart nodes |
| SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.JOB_INDICATOR , A.HR_STATUS , A.EMPL_STATUS , A.FULL_PART_TIME , A.BUSINESS_UNIT , A.COMPANY , A.SETID_DEPT , A.DEPTID , A.SETID_LOCATION , A.LOCATION , A.SETID_JOBCODE , A.JOBCODE , A.POSITION_NBR , A.POSITION_OVERRIDE , A.REPORTS_TO , A.SUPERVISOR_ID , A.REG_TEMP , A.EFFDT , A.EFFSEQ , A.STD_HOURS , A.STD_HRS_FREQUENCY FROM PS_JOB A WHERE A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT = A.EFFDT) |
| # | 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 | JOB_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee.
In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable P=Primary Job S=Secondary Job |
| 6 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive |
| 7 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 8 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 11 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 12 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 13 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 14 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 15 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 16 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 17 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 18 | POSITION_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL | Override Position Data |
| 19 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
| 20 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 21 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 22 | JOB_EFFDT | Date(10) | DATE | Job Effective Date |
| 23 | JOB_EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Job Effective Sequence |
| 24 | STD_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Standard Hours |
| 25 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL | Standard Work Period |