EMPLIDEMPL_RCDEFFDTDefault Value: %date
EFFSEQN=Not Applicable
P=Primary Job
S=Secondary Job
GPHK_PRIMJOB_VW(SQL View) |
Index Back |
|---|---|
Retrieves data of primary jobThe view is used in global payroll rules to retrieve hire date, rehire date, termination date from the primary job. |
| SELECT B.EMPLID , B.EMPL_RCD , B.EFFDT , B.EFFSEQ , B.HIRE_DT , B.LAST_HIRE_DT , B.TERMINATION_DT , B.JOB_INDICATOR FROM PS_JOB B WHERE B.JOB_INDICATOR = 'P' |
| # | 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 | HIRE_DT | Date(10) | DATE | First Start Date |
| 6 | REHIRE_DT | Date(10) | DATE | Rehire Date |
| 7 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 8 | 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 |