EMPLIDEMPL_RCDDefault Value: %date
A=Active
I=Inactive
N=Not Applicable
P=Primary Job
S=Secondary Job
HR_EERCD_VW(SQL View) |
Index Back |
|---|---|
ERN ViewView lists the Empl_Rcd for a person to be used as prompt record in ERN Delete Run Control HR_RUNCTL_ERN_D record. |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD , P.NAME , A.JOBCODE , A.EFFDT , A.HR_STATUS , A.JOB_INDICATOR FROM PS_JOB A , PS_PERSON_NAME P WHERE A.EMPLID = P.EMPLID AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | HR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
HR Status
A=Active I=Inactive |
| 7 | 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 |