FE_JOB_CURR_EFF

(SQL View)
Index Back

SELECT EMPLID ,JB.EMPL_RCD ,JB.EFFDT ,JB.EFFSEQ ,JB.DEPTID ,JB.JOBCODE ,JB.POSITION_NBR ,JB.SETID_JOBCODE FROM PS_JOB JB WHERE %Sql(HRCURROW_WHERE,PS_JOB,JB)

# 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 Rcd Nbr
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
8 SETID Character(5) VARCHAR2(5) NOT NULL SetID