RS_ASSGN_AW(SQL View) |
Index Back |
---|---|
Header RecordHeader 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 |