FT_ASGN_JOB_VW2

(SQL View)
 Index Back

Assignment Audit Job Descr

Assignment Audit Report Job Descriptions (After)

SELECT DISTINCT STG.FT_SETID_JOBCODE , STG.FT_JOBCODE , JOB.DESCR FROM %Table(FT_ASSIGNMNT_IN) STG , %Table(JOBCODE_TBL) JOB WHERE STG.FT_SETID_JOBCODE = JOB.SETID AND STG.FT_JOBCODE = JOB.JOBCODE AND %EffdtCheck(JOBCODE_TBL JOB2, JOB, FT_EFF_START_DATE) AND JOB.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FT_SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description