OLM_WRKRJOB_VW(SQL View) |
Index Back |
|---|---|
Profile Worker JobSelected Workers Job information (tied to BO_ID) for Profile use |
| SELECT AA.BO_ID , AA.EFFDT , AA.EFFSEQ , AA.EMPL_STATUS , AA.HR_STATUS , AA.JOB_INDICATOR , AA.SOURCE_IND , AA.REG_TEMP , AA.FULL_PART_TIME , AA.SETID_JOBCODE , AA.JOBCODE , AA.SETID_DEPT , AA.DEPTID , AA.SETID_LOCATION , AA.LOCATION , AA.SUPERVISOR_ID FROM PS_RD_WRKR_JOB AA WHERE AA.EFFDT = ( SELECT MAX(B_AA.EFFDT) FROM PS_RD_WRKR_JOB B_AA WHERE AA.BO_ID = B_AA.BO_ID AND B_AA.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | SEQUENCE_NUMBER | Number(18,0) | DECIMAL(18) NOT NULL | Sequence Number |
| 4 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Employment Status. e.g., Active, Leave of Absence, Terminated, Retired, etc.
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 |
| 5 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
An indication whether a worker is still on payroll.
HR_STATUS = "A" if EMPL_STATUS in ("A", "L", "P", "S", "W");
HR_STATUS = "A" if EMPL_STATUS not in ("A", "L", "P", "S", "W");
A=Active I=Inactive |
| 6 | 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 |
| 7 | SOURCE_IND | Character(4) | VARCHAR2(4) NOT NULL |
EIP Source Indicator
CRM=CRM EBS=EBIZ Suite EXT=External HRMS=HCM SCM=SCM |
| 8 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Identifies whether the worker is a Regular employee or a Temporary employee.
R=Regular T=Temporary |
| 9 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Identifies whether the employee works Full Time or Part Time.
F=Full-Time P=Part-Time |
| 10 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | SETID_JOBCODE field used in the HCM/ CRM sync Application Messages. |
| 11 | JOBCODE | Character(15) | VARCHAR2(15) NOT NULL | Job Code or Job Title. |
| 12 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 13 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 14 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 15 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 16 | SUPERVISOR_ID | Character(15) | VARCHAR2(15) NOT NULL | ID of a worker's supervisor. |