FT_AS_SUM_IN_VW

(SQL View)
 Index Back

Assignment Audit Report Sum VW

Assignment Audit Report Summary View (Counts)

SELECT B.FT_RUN_ID , ( SELECT COUNT(DISTINCT A.EMPLID) FROM PS_FT_ASSIGNMNT_IN A WHERE (A.JOBCODE <> A.FT_JOBCODE OR A.GRADE <> A.FT_GRADE OR A.SAL_ADMIN_PLAN <> A.FT_SAL_ADMIN_PLAN OR A.POSITION_NBR <> A.FT_POSITION_NBR) AND A.FT_RUN_ID=B.FT_RUN_ID AND A.FT_ERROR_FLAG <> 'Y') , ( SELECT COUNT(1) FROM PS_FT_ASSIGNMNT_IN A WHERE A.FT_RUN_ID=B.FT_RUN_ID AND A.FT_ERROR_FLAG <> 'Y') , ( SELECT COUNT(1) FROM PS_FT_ASSIGNMNT_IN A WHERE A.JOBCODE <> A.FT_JOBCODE AND A.FT_RUN_ID=B.FT_RUN_ID AND A.FT_ERROR_FLAG <> 'Y') , ( SELECT COUNT(1) FROM PS_FT_ASSIGNMNT_IN A WHERE (A.GRADE <> A.FT_GRADE OR A.SAL_ADMIN_PLAN <> A.FT_SAL_ADMIN_PLAN) AND A.FT_RUN_ID=B.FT_RUN_ID AND A.FT_ERROR_FLAG <> 'Y') , ( SELECT COUNT(1) FROM PS_FT_ASSIGNMNT_IN A WHERE A.POSITION_NBR <> A.FT_POSITION_NBR AND A.FT_RUN_ID=B.FT_RUN_ID AND A.FT_ERROR_FLAG <> 'Y') , ( SELECT COUNT(1) FROM PS_FT_ASSIGNMNT_IN A WHERE A.FT_RUN_ID=B.FT_RUN_ID) , ( SELECT COUNT(1) FROM PS_FT_ASSIGNMNT_IN A WHERE FT_ERROR_FLAG = 'Y' AND A.FT_RUN_ID=B.FT_RUN_ID) FROM PS_FT_CWBOBJ_HDR B WHERE B.ft_object_ident = '1000'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID
2 FT_AS_EMPL_CNT Number(10,0) DECIMAL(10) NOT NULL Employees w/ Assignment Change
3 FT_ASSIGNMENT_CNT Number(10,0) DECIMAL(10) NOT NULL Assignments w/ Any Change
4 FT_AS_JOBCODE_CNT Number(10,0) DECIMAL(10) NOT NULL Assignments w/ Job Change
5 FT_AS_GRADE_CNT Number(10,0) DECIMAL(10) NOT NULL Assignments w/ Grade Change
6 FT_AS_POS_NBR_CNT Number(10,0) DECIMAL(10) NOT NULL Assignments w/ Position Change
7 FT_AS_TOT_CNT Number(10,0) DECIMAL(10) NOT NULL # of Assignments Processed
8 FT_AS_ERR_CNT Number(10,0) DECIMAL(10) NOT NULL # of Errors