RS_ASSGN_AW

(SQL View)
Index Back

Header Record

Header Record for the Assignment Status change and the Date change AWE process.

SELECT A.ASSIGNMENT_ID , A.EMPLID , A.BUSINESS_UNIT , A.PROJECT_ID , A.CUST_ID , B.ASSIGN_STS , A.PROJ_ROLE , A.DESCR FROM PS_RS_ASSIGNMENT A , PS_RS_ASSGN_STS B WHERE A.SYSTEM_SOURCE = 'RS' AND A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND B.LASTUPDDTTM = ( SELECT MAX(B1.LASTUPDDTTM) FROM PS_RS_ASSGN_STS B1 WHERE B.ASSIGNMENT_ID = B1.ASSIGNMENT_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
5 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
6 ASSIGN_STS Character(2) VARCHAR2(2) NOT NULL Assignment Status
A=Assign
C=Complete
I=Interview
P=Propose
R=Reject
S=Reserve
V=Pending Approval
X=Cancel
7 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description