FP_JOB_SETID_VW

(SQL View)
Index Back

View of Job Code/SetID


SELECT DISTINCT A.SETID FROM PS_JOBCODE_TBL A WHERE A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID