FO_CAND_ACT_ASS

(SQL View)

SELECT A.EMPLID , COUNT(*) FROM %Table(RS_ASSIGNMENT) A , %Table(RS_ASSGN_STS) B WHERE A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND A.SYSTEM_SOURCE ='STF' AND B.ASSIGN_STS = 'O' GROUP BY A.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CANDIDATE_ID Character(11) VARCHAR2(11) NOT NULL Used as a general ID for anything from Employee id to other types of ID like asset and material.

2 ACTIVE_ASSIGNMENTS Number(3,0) SMALLINT NOT NULL Active Assignments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CANDIDATE_ID	Character(11)	VARCHAR2(11) NOT NULL	Used as a general ID for anything from Employee id to other types of ID like asset and material.
2	ACTIVE_ASSIGNMENTS	Number(3,0)	SMALLINT NOT NULL	Active Assignments